📄 validate.jsp

📁 在线考试能够让用户在线就能考试本软件有20多个页面

💻 JSP

字号:

<%@ page contentType="text/html;charset=GBK"  language="java" import="java.sql.*"%>
<%!
 String username=new String();
 String password=new String();
 String name=new String();
 String classes=new String();
 String competence=new String();
 String sta=new String();
 String com=new String();
 String s=new String();
%>
<%
sta=request.getParameter("radiobutton");
if(sta.equals("student"))
{com="student";}
else if(sta.equals("teacher"))
{com="teacher";}
else if(sta.equals("admin"))
{com="admin";}
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection("jdbc:odbc:exam");
Statement stmt = conn.createStatement();
if(com=="student")
{
s ="select *from Student_tb where username='"+request.getParameter("username")+"'";
}
else if(com=="teacher")
{
s ="select *from Teacher_tb where username='"+request.getParameter("username")+"'";
}
else if(com=="admin")
{
s ="select *from Admin_tb where username='"+request.getParameter("username")+"'";
}
ResultSet zs = stmt.executeQuery(s);
while(zs.next())
{
username=zs.getString("username");
password=zs.getString("password");
name=zs.getString("name");
classes=zs.getString("classes");
competence=zs.getString("competence");
}
}
catch(Exception e)
{
}
if(password.equals(request.getParameter("password")))
{
session.setAttribute("username",username);
session.setAttribute("password",password);
session.setAttribute("name",name);
session.setAttribute("class",classes);
session.setAttribute("competence",competence);
if(competence.equals("student"))
{
response.sendRedirect("a.jsp");}
else if(competence.equals("teacher"))
{response.sendRedirect("teacherMain.jsp");}
else if(competence.equals("admin"))
{}
else
{
%>
<html><body>
<%= competence %>
</body></html>
<%
}
}
else
{response.sendRedirect("b.jsp");}
%>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -