QueryRunner-2-优快云博客

本文展示了一个使用Java进行Oracle数据库登录验证的例子。通过传递用户名和密码参数，该示例演示了如何查询数据库以验证用户的登录信息，并根据结果重定向到相应的页面。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

String param[] = {username,password};
   OracleUtil db = new OracleUtil("java:/comp/env/jdbc/oracleds");
   db.init();

   //List result = (List) db.queryU("select * from admin where username='"+param[0]+"' and upassword='"+param[1]+"' ", new BeanHandler(Users.class));
   //List result = (List) db.queryU("select * from admin", new BeanHandler(Users.class));
   List result = (List)db.queryU("select * from admin where username='"+param[0]+"' and upassword='"+param[1]+"' ", new BeanListHandler(Users.class));
   if(result.size()==0 ){
    message = "对不起，密码不能为空，请重新输入！";
    request.setAttribute("guestbook.admin.login.message", message);
    request.getRequestDispatcher("/admin/loginFail.jsp").forward(request, response);
   }else{
    HttpSession session = request.getSession();
    session.setAttribute("guestbook.admin.username",username);
    response.sendRedirect("/liuyanban/servlet/getMessages?username="+param[0]);
    //response.sendRedirect(request.getContextPath() + "/admin/secure/manage?q=list");
   }