/*
JDBC工作过程:
1.加载驱动,建立连接(加载驱动是靠DriverManager,并且通过DriverManager获取连接Connection)
2.创建语句对象(通过Connection创建Statement用于执行sql语句)
3.执行SQL语句
4.处理结果集(若执行的是select语句,会产生结果集RsultSet)
5.关闭连接(调用Connection的close()方法来释放资源)
*/
try {
//加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//通过DriverManager获取数据库连接 scott为用户名,tiger为密码,实际情况看自己的数据库中的用户名和密码,orcl为数据库的sid
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","scott","tiger");
System.out.println("数据库连接成功!");
//通过Connection创建Statement执行sql语句
Statement stmt = conn.createStatement();
String sql = "select * from emp";
System.out.println(sql);
//使用executeQuery()方法老执行DQL语句并且查询后会得到一个查询结果集
ResultSet rs =
stmt.executeQuery(sql);
while (rs.next()) {
int empno = rs.getInt("empno");
String ename = rs.getString("ename");
int sal = rs.getInt("sal");
Date hiredate = rs.getDate("hiredate");
System.out.println(empno+","+ename+","+sal+","+hiredate);
}
} catch (Exception e) {
e.printStackTrace();
}