validate.jsp
来自「help desk for hospitals/health care syst」· JSP 代码 · 共 54 行
JSP
54 行
<html>
<body>
<%@ page errorPage="ErrorPage.jsp" language="java" import="java.sql.*" %>
<%
Connection conn;
conn=null;
ResultSet rs;
rs=null;
try
{
String name=request.getParameter("UserName");
String pass=request.getParameter("Password");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection("jdbc:odbc:tis","tis","tis");
PreparedStatement pst= conn.prepareStatement("SELECT edesig FROM master where lname=? and pword =?");
pst.setString(1,name);
pst.setString(2,pass);
rs = pst.executeQuery();
if(rs.next())
{
String str1;
str1=rs.getString(1);
if(str1.equals("administrator"))
{
response.sendRedirect("Admin.htm");
}
else if(str1.equals("trainer"))
{
response.sendRedirect("Trainer.htm");
}
else
response.sendRedirect("Employ.htm");
}
else
{
response.sendRedirect("InvalidUser.htm");
}
}
catch(Exception E)
{
out.println("Error "+E);
}
finally
{
rs.close();
conn.close();
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?