📄 validate.jsp

📁 help desk for hospitals/health care systems

💻 JSP

字号:

<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 + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -