java程序连接oracle数据库方法实例。
//定义数据库变量
Connection ct=null;
PreparedStatement ps=null;
ResultSet rs=null;
//下面使用数据库验证登录用户
try {
//1.加载驱动
Class.forName(“oracle.jdbc.driver.OracleDriver”);
//2连接数据库
ct=DriverManager.getConnection(“jdbc:oracle:thin:@127.0.0.1:1521:orcl”,”userm”,”123456″);
//3预编译sql语句
ps=ct.prepareStatement(“select * from users where id=? and password=?”);
ps.setObject(1, idnum);
ps.setObject(2, password);
//4执行操作
rs=ps.executeQuery();
//5.操作
if(rs.next()){
request.setAttribute(“id”, idnum);
request.setAttribute(“password”, password);
request.getRequestDispatcher(“/mainframe”).forward(request, response);//转发
}else{
request.getRequestDispatcher(“/login”).forward(request,response);
}
} catch (Exception e) {
// TODO: handle exception
}finally{
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
ps.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
ct.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}