WebRoot/admin/login.jsp

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ page contentType="text/html; charset=GB2312" %>
<%@ page import="java.sql.*" %>
<%@ page language="java" %>
<%@ page import="java.util.*" %>
<%@ page import=" proj112.ISOtoGb2312  "%>
<jsp:useBean id="conn" scope="page" class="proj112.dbconn"/>
<html>
<head>
<title>
身份验证
</title>
</head>
<body bgcolor="#ffffff">
<%
String user=ISOtoGb2312.convert(request.getParameter("username"));
String pwd=ISOtoGb2312.convert(request.getParameter("password"));
String select=request.getParameter("select");
String URL="";
String sql="";
  if(select.equals("Student")){
			sql = "SELECT * FROM student where stu_id='"+user+"'and stu_password='"+pwd+"'";
                        URL="../student/admin.jsp";
                        ResultSet rs = conn.executeQuery(sql);
                        if(rs.next()){
                          String a=rs.getString("stu_name");
                          String zhuanye=rs.getString("zhuanye");
                          request.getSession(true);
                          session.setAttribute("zhuanye",zhuanye);
                          session.setAttribute("stu_name",a);
                          session.setAttribute("id",user);
                          response.sendRedirect(URL) ;}
                          else
                        out.print("<script>alert('用户名或者密码错误!');window.history.go(-1);</script>");
  }

 else
 {
                         sql = "SELECT * FROM admin where name='"+user+"'and ad_password='"+pwd+"'";
                         URL="admin.jsp";
                         ResultSet rs = conn.executeQuery(sql);
                       if(rs.next()){
                          request.getSession(true);
                          session.setAttribute("id",user);
                          response.sendRedirect(URL) ;}
                        else
                         out.print("<script>alert('用户名或者密码错误!');window.history.go(-1);</script>");
}

                         //使用executeQuery执行SQL查询语句


%>

</body>
</html>