?? validate.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 + -