📄 loginlogic.jsp
字号:
<%@page import="java.sql.*"%>
<%@page import="javax.servlet.*"%>
<html>
<head>
<title></title>
</head>
<body>
<%@ page contentType="text/html; charset=GBK" %>
<%request.setCharacterEncoding("GBK");%>
<%
String driver= "sun.jdbc.odbc.JdbcOdbcDriver";
Class.forName(driver).newInstance();
String ConURL = "jdbc:odbc:login";
Connection con = null;
con = DriverManager.getConnection(ConURL,"sa","453558337");
Statement stmt = con.createStatement();
String username=request.getParameter("Username");
String password=request.getParameter("Password");
String userkinds=request.getParameter("userkinds");
if(username.equals("")||password.length()==0){
String redirctURL="login.jsp";
response.sendRedirect(response.encodeURL(redirctURL));
}
else if(userkinds.trim().equals(""))out.print("<script>alert('请选择用户类型!');window.location.href='login.jsp'</script>");
else{
String sqlstring="SELECT Username,Password userkinds FROM logstu";
sqlstring+=" ";
sqlstring+="WHERE Username LIKE'"+username+"'";
ResultSet rs=null;
rs=stmt.executeQuery(sqlstring);
if(rs.next()){
if((rs.getString(2).trim().equals(password.trim()))&&(rs.getString(3).equals(userkinds))){
rs.close();
stmt.close();
con.close();
if(userkinds.trim().equals(user)) String redirctURL="success.jsp";
else String redirctURL="welcome.jsp";
response.sendRedirect(response.encodeURL(redirctURL));
}
else if(!(rs.getString(3).equals(userkinds))){
out.print("<script>alert('用户类型不正确!');window.location.href='login.jsp'</script>");
}
else{
rs.close();
stmt.close();
con.close();
String redirctURL="login.jsp";
out.print("<script>alert('密码错误！');window.location.href='login.html'</script>");
/*response.sendRedirect(response.encodeURL(redirctURL)); */
}
}
else{
rs.close();
stmt.close();
con.close();
out.print("<script>alert('用户名不存在，请先注册');window.location.href='register.html'</script>");
/*String redirctURL="login.jsp";
response.sendRedirect(response.encodeURL(redirctURL));*/
}
}
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -