📄 login.jsp
字号:
<%@ page contentType="text/html;charset=GB2312"%>
<%@ page import="java.lang.*" %>
<%@ page import="java.sql.*" %>
<html>
<body background="2.jpg">
<center>
<br>
<%
String name=request.getParameter("name");
if(name==null)
{
name="";
}
byte b[]=name.getBytes("ISO-8859-1");
name=new String(b);
String password=request.getParameter("password");
String role=request.getParameter("role");
if(role.equals("1"))
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{
out.print("加载驱动失败！");
}
try
{
Connection con=DriverManager.getConnection("jdbc:odbc:LogIn","sa","");
Statement sql=con.createStatement();
String condition="SELECT * FROM CheckIn WHERE 姓名='"+name+"' AND 密码='"+password+"'";
ResultSet rs=null;
rs=sql.executeQuery(condition);
if(rs.next()&&!name.equals(""))
{
response.sendRedirect("success.jsp");
}
else
{
response.sendRedirect("error.jsp");
}
con.close();
}
catch(SQLException e)
{
out.print(e);
}
}
if(role.equals("2"))
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{
out.print("加载驱动失败！");
}
try
{
Connection con=DriverManager.getConnection("jdbc:odbc:LogIn","sa","");
Statement sql=con.createStatement();
String condition="SELECT * FROM TCheckIn WHERE 姓名='"+name+"' AND 密码='"+password+"'";
ResultSet rs=null;
rs=sql.executeQuery(condition);
if(rs.next()&&!name.equals(""))
{
response.sendRedirect("teacher.jsp");
}
else
{
response.sendRedirect("error.jsp");
}
con.close();
}
catch(SQLException e)
{
out.print(e);
}
}
else
{
out.print(role);
}
%>
</center>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -