adminpass.jsp

JSP+ORACLE网站开发实例（下）.rar

<%@ include file="conn.jsp"%>
<%request.setCharacterEncoding("GB2312");
String admin_name=request.getParameter("admin_name");
String admin_password=request.getParameter("admin_password");
String sql="select * from scott.admin where admin_name like '" + admin_name + "' and admin_password like '" + admin_password + "'"; 
ResultSet rs_admin=stmt.executeQuery(sql); 
   if(!rs_admin.next()){
   out.print("<script language='javascript'>");
   out.print("alert('账号或密码错误！');");
  out.print("history.go(-1);");
   out.print("</script>");
   }else{
rs_admin.close();
session.putValue("admin_pass","ok"); 
  response.sendRedirect("admin.jsp"); 

   }
%>