- 通过反射的形式加载驱动
-
Class.forname("oracle.jdbc.driver.OracleDriver")
- 建立连接
-
Connection conn = DriverManager.getConnection( "url", "用户名" "密码" )
- 定义sql语句
-
String sql = select * from 表名
- 创建处理块
-
PreparedStatement state = conn.PerpareStatement(sql)
- 执行sql语句
-
ResultSet rs = state.executeQurey()
- 处理sql语句
-
while(rs.next()){ String username = rs.getString("字段名"); int password = rs.getInt("字段名"); System.out.println(username,password) }
- 关闭连接
-
conn.close();
03-08
665
05-16
636