📄 login.jsp

📁 可在线考试JSP等课程
💻 JSP
字号:
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*" %>
<% 
   String No="";
   String Name="";
   String Lesson="";
   String Msg="";
   if(request.getParameter("Name")!=null)
   {
	   No=request.getParameter("No");
	   Name=request.getParameter("Name");
	   Lesson=request.getParameter("Lesson");
	   String SQL ="SELECT * From chjb ";
	   SQL=SQL+"Where xh="+"'"+No+"'"+
	       " And xm='"+Name+"'";
	   Connection conn=null;
	   Statement stmt=null;
	   ResultSet rsScore=null;
	   try{
		    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	   }
	   catch(ClassNotFoundException ce){
		   out.println(ce.getMessage());
	   }
	   try{
		   conn=DriverManager.getConnection("jdbc:odbc:test");
		   stmt=conn.createStatement();
		   rsScore=stmt.executeQuery(SQL);
	   }
	   catch(SQLException e){
		   System.out.println(e.getMessage());
	   }
	   if(!rsScore.next())
	   {
		   Msg="您不是合法考生！";
	   }
	   else
	   {
		   if(rsScore.getInt(Lesson)!=-1)
		   {
			   Msg="您已经考过本科目了！";
		   }
		   else
		   {
			   response.sendRedirect("test.jsp?Lesson="+Lesson+"&Name="+Name+"&No="+No+"");
		    }
	    }
    }
   %>
<HTML>
<title>考试界面</title>
 <head><BODY background="login.jpg">
 <meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
 <style type="text/css">
<!--
body {
	background-color: #339944;
}
-->
</style>
</head>
   <BODY>
   <p align="center">&nbsp;</p>
   <p align="center">&nbsp;</p>
   <p align="center">&nbsp;</p>
     <center><font color="#FFFFFF" face="楷体_GB2312" size="+4">在线考试系统</font></center>
	 <center>
	 <HR>
	     <FORM ACTION="login.jsp" METHOD="GET">
		   <P>考试科目:<SELECT NAME="Lesson" SIZE="1">
		      <OPTION VALUE="JSP">JSP</OPTION>
			 <OPTION VALUE="XML">XML</OPTION>
			 <OPTION VALUE="ASP">ASP</OPTION>
		    </SELECT></P>
   <P>姓名:<INPUT TYPE="TEXT" NAME="Name"   VALUE="<%=Name%>"></p>
   <p>学号:<INPUT TYPE="password" NAME="No"   VALUE="<%=No%>">
   </p>
     <p><INPUT TYPE="SUBMIT" NAME="SEND" VALUE="开始考试"></p>
	 </FORM>
	 </center>
	 <HR>
	 <center><FONT Color="red" size="+2"><%=Msg%></FONT></center>
  </BODY>
</HTML>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -