📄 login.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 成绩单 ";
SQL = SQL + "Where 学号=" + "'" + No + "'" +
" And 姓名='" + 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>
<BODY BGCOLOR="BEIGE">
<H1 ALIGN="CENTER">在线考试系统</H1>
<HR>
<FORM ACTION="login.jsp" METHOD="GET">
<P>考试科目：<SELECT NAME="Lesson" SIZE="1">
<OPTION VALUE="JSP">JSP</OPTION>
<OPTION VALUE="XML">XML</OPTION>
</SELECT></P>
<P>姓名：<INPUT TYPE="TEXT" SIZE="20" NAME="Name" VALUE="<%=Name%>"></P>
<P>学号：<INPUT TYPE="TEXT" SIZE="20" NAME="No" VALUE="<%=No%>"></P>
<P><INPUT TYPE="SUBMIT" NAME="SEND" VALUE=" 开始考试"> </P>
</FORM>
<HR>
<FONT Color="red"><%=Msg%></FONT>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -