import java.sql.*;

public class HelloJDBC {

        public static void main(String[] args) throws ClassNotFoundException, SQLException {
                //第一步，建立驱动程序实例
                Class.forName("oracle.jdbc.driver.OracleDriver");
                
                //第二步，获得连接
                Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:oracle", "system", "pqx3318");
                
                //第三步，获得Statement
                Statement stmt =  con.createStatement();
                
                String sql = "select id,name from HelloJDBC";
                
                //第四步，执行SQL语句
                ResultSet rs = stmt.executeQuery(sql);
                
                //处理结果集
                while(rs.next()) {
                        int id = rs.getInt("id");        
                        String name = rs.getString("name");        
                                
                        
                        System.out.println("id: " + id + ", name: " + name);
                }
                
                //第六步s
                rs.close();
                stmt.close();
                con.close();
        }

}