JDBC连接数据库

Connection con = null;

PreparedStatement pst = null ;

ResultSet rs = null;

try {

Class.forName("oracle.jdbc.driver.OracleDriver");//加载驱动

String url = "oracle:jdbc:thin:@localhost:1521:orcl";

String user = "Book";

String password ="123456";

con = DriverManager.getConnection(url, user, password);//创建连接

String sql = "select * from Book";

pst = con.prepareStatement(sql);//创建statementpst.setString(1,"admin");

pst.setString(2, "123");

rs = pst.executeQuery();//执行sql语句，返回结果集resultset,并处理结果集

while(rs.next()){

String c1 = rs.getString(1);

String c2 = rs.getString(2);

}

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch blocke.printStackTrace();

} catch (SQLException e) {

// TODO Auto-generated catch blocke.printStackTrace();

}

finally{

try {

rs.close();//关闭连接

pst.close();

con.close();

} catch (SQLException e) {

// TODO Auto-generated catch blocke.printStackTrace();}

}