67,513
社区成员
发帖
与我相关
我的任务
分享
//连接oracle
Class.forName("oracle.jdbc.driver.OracleDriver");
//DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
String url = "jdbc:oracle:thin:@172.16.16.37:1521:chenjie";
String users = "system";
String password = "chenjie";
ct = DriverManager.getConnection(url, users, password);
//查询数据库,看看用户名存不存在,若存在则将返回的密码与用户输入的密码进行比较
smt = ct.createStatement(); //创建Statement对象
rs = smt.executeQuery("select password from users where name =" + uname);
if(rs.next()){
String pwd = rs.getString("password");
if(upwd.equals(pwd)){
hsRes.sendRedirect("welcome?u="+ uname +"&p=" + upwd);
}else{
hsRes.sendRedirect("login");
}
}else{
hsRes.sendRedirect("login");
}
//关闭
if(rs != null){
rs.close();
}
if(smt != null){
smt.close();
}
if(ct != null){
ct.close();
}