JAVA 连接oracle数据库 实现简单的查询

package renxiaomei; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import javax.sql.StatementEvent; public class Test1 { //连接数据库 private Connection conn; //执行SQL返回结果 private Statement stmt; //存放返回的结果 private ResultSet res; //驱动程序包 private String driver="oracle.jdbc.driver.OracleDriver"; //连接路径 private String url="jdbc:oracle:thin:@localhost:1521:orcl"; //数据库登陆的用户以及密码 private String user="renxiaomei"; private String password="123"; //查询全部的语句 private String sql="select * from student"; //查询全部 public void queryAllStudent(){ try { //加载驱动 Class.forName(driver); //建立连接 conn=DriverManager.getConnection(url, user, password); //创建Statement对象 stmt=conn.createStatement(); //stmt调用查询的方法返回查询结果给rs res=stmt.executeQuery(sql); //打印输出到控制台 while(res.next()){ System.out.print(res.getString("id")+" "); System.out.print(res.getString("name")+" "); System.out.print(res.getInt("age")+" "); System.out.print(res.getDate("birth")+" "); System.out.print(res.getString("class")+" "); System.out.println(res.getInt("score")+" "); } } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); }finally{ try { if (res!=null){ res.close(); } if(stmt!=null){ stmt.close(); } if(conn!=null){ conn.close(); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } }