📄 index1.jsp
字号:
<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<%@ page import="DataBase.DBConn"%>
<%@ page import="java.sql.ResultSet"%>
<html>
<head>
<title>网上考试系统</title>
<link rel="stylesheet" type="text/css" href="css.css">
</head>
<body topmargin="0" leftmargin="0">
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="778" id="AutoNumber1" height="45">
<tr>
<td align="center" valign="top">
<div align="center">
<center>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="778" id="AutoNumber2" bgcolor="#CBEFDC" height="40">
<tr>
<td align="center"><a href=index.jsp>回到学生登陆系统</a></td>
</tr>
</table>
</center>
</div>
</td>
</tr>
</table>
</center>
</div>
<div align="center">
<center>
<table border="1" cellpadding="4" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="760" height="100">
<tr>
<td align="center">
<div align="center">
<center>
<table border="0" cellpadding="4" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="400">
<%
request.setCharacterEncoding("GBK");
response.setCharacterEncoding("GBK");
DBConn db=new DBConn();
int id=Integer.parseInt(request.getParameter("id"));
String sql="select * from student where id='"+id+"'";
ResultSet rs=db.Query(sql);
rs.next();
String name=rs.getString("name");
String sql2="select * from test";
ResultSet rs1=db.Query(sql2);
rs1.last();
int rowcount=rs1.getRow();
int id1=rs1.getInt("id1");
int id2=rs1.getInt("id2");
int id3=rs1.getInt("id3");
int fenshu1=rs1.getInt("fenshu1");
int fenshu2=rs1.getInt("fenshu2");
int fenshu3=rs1.getInt("fenshu3");
%>
<tr>
<td><%=name%>，你好！以下你将要参加的第 <font color=red><%=rowcount %></font> 期考试情况：</td>
</tr>
<%if(rowcount==0){%>
<tr>目前还没有出考试的试卷</tr>
<%}else{ %>
<tr>
<td> 本期考试 <font color=red><%=id1 %></font> 道判断题，<font color=red><%=id2 %></font> 道选择题，<font color=red><%=id3%></font> 道填空题，总分 <font color=red><%=(id1*fenshu1+id2*fenshu2+id3*fenshu3)%></font> 分</td>
</tr>
<tr>
<td align="right"><a href=my_test.jsp?id=<%=id%>>进入考试===></a></td>
</tr>
<%}%>
<tr>
<td><a href=my_report.jsp?id=<%=id%>>查询你以往考试成绩：</a></td>
</tr>
<tr>
<td align="center">
</td>
</tr>
</table>
</center>
</div>
</td>
</tr>
</table>
</center>
</div>
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="778" id="AutoNumber1" height="45">
<tr>
<td align="center" valign="bottom">
<div align="center">
<center>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="778" id="AutoNumber2" bgcolor="#CBEFDC" height="40">
<tr>
<td align="center"> <a href="admin.jsp">后台管理入口</a></td>
</tr>
</table>
</center>
</div>
</td>
</tr>
</table>
</center>
</div>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -