JDBC编程的六个步骤

1 导入jdbc驱动包/ 注册驱动
Class.forName(“oracle.jdbc.OracleDriver”);
2 创建数据库连接对象/ 获取连接
String url = “jdbc:oracle:thin:@localhost:1521:xe”;//其中xe为sid 1521端口号
String user = “XXX”;
String password = “XXX”;
Connection conn = DriverManager.getConnection(url,name,password);
3 创建statement对象/ 获取数据库操作对象
Statement state = conn.createStatement();
4 填充结果集/ 执行SQL语句
String sql = “select id,name from s_emp”;//sql语句
5 遍历结果集/ 处理查询结果集
while(rs.next()){
int id = rs.getInt(“id”);
String name = rs.getString(2);
System.out.println(id+" "+name);
}
6 关闭连接/ 释放资源
rs.close();
state.close();
conn.close();