📄 validate.jsp
字号:
<html>
<body>
<%@ page errorPage="errorpage.jsp" language="java" import="java.sql.*" %>
<%
Connection conn;
conn=null;
ResultSet rs;
rs=null;
try
{
String strName=request.getParameter("UserName");
String strPass=request.getParameter("Password");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection("jdbc:odbc:Data","scott","tiger");
PreparedStatement stat= conn.prepareStatement("SELECT * FROM user_auth where username=? and password =?");
stat.setString(1,strName);
stat.setString(2,strPass);
rs = stat.executeQuery();
if(rs.next())
{
String str1,str2;
str1=rs.getString(1);
str2=rs.getString(2);
out.println(str1+str2);
session.putValue("user",strName);
if(str1.equals("Administrator"))
{
response.sendRedirect("Admin.htm");
}
else
{
out.println("Logged IN");
response.sendRedirect("SearchCriteria.jsp");
}
}
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 + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -