📄 chiresult.jsp
字号:
<%@ page language="java" import="java.sql.*" errorPage="" %>
<%//request.setCharacterEncoding("gb2312");%>
<html>
<head>
<title>考试结果</title>
<link href="../img/cssexamin.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.unnamed1 { font-size: 12px;
font-weight: lighter;
color: #FF0000;
text-decoration: none;
}
.unnamed2 {
border: 1px solid #CCCCCC;
font-size: 14px;
color: #000000;
}
.unnamed3 {
font-size: 14px;
color: #000000;
}
-->
</style>
<link href="img/cssexamin.css" rel="stylesheet" type="text/css">
</head>
<jsp:useBean id="linejdbc" scope="page" class="examinline.DBConnectionBean" />
<%linejdbc.setdrivername();%>
<%
String S_id=(request.getParameter("S_id")).trim();
//String Subject=(String)session.getValue("Subject");System.out.print(Subject);
//String S_name=(String)session.getValue("S_name");
String S_name=(request.getParameter("S_name")).trim();
System.out.print(S_id+S_name);
Connection conn = linejdbc.getopenConnection();
PreparedStatement ps=null;
ResultSet rs=null;
int i;
int score=0;//总分
String selectvalue;
//String Subject;
String id;
String Subject="语文";
//111111111
for (i=1;i<=4;i++)
{
selectvalue=request.getParameter("select"+i);
id=request.getParameter("h"+i);
//System.out.print(selectvalue+id+"yyy");
ps=conn.prepareStatement("select * from chi_choose where id=? and answer=?");
ps.setInt(1,Integer.parseInt(id));
ps.setString(2,selectvalue);
rs=ps.executeQuery();
if (rs.next())
{
score=score+1;
}
System.out.println(id+":"+selectvalue+":"+score);
}
//222222222
for (i=5;i<=8;i++)
{
selectvalue=request.getParameter("select"+i);
id=request.getParameter("h"+i);
//System.out.print(selectvalue+id+"yyy");
ps=conn.prepareStatement("select * from chi_cloze where id=? and answer=?");
ps.setInt(1,Integer.parseInt(id));
ps.setString(2,selectvalue);
rs=ps.executeQuery();
if (rs.next())
{
score=score+1;
}
System.out.println(id+":"+selectvalue+":"+score);
}
//333333333333333
for (i=9;i<=10;i++)
{
selectvalue=request.getParameter("select"+i);
id=request.getParameter("h"+i);
ps=conn.prepareStatement("select * from chi_read_choose where id=? and answer=?");
ps.setInt(1,Integer.parseInt(id));
ps.setString(2,selectvalue);
rs=ps.executeQuery();
if (rs.next())
{
score=score+1;
}
System.out.println(id+":"+selectvalue+":"+score);
}
score=score*2;
ps=conn.prepareStatement("select * from score where s_id=? and subject=?");
ps.setString(1,S_id);
ps.setString(2,Subject);
rs=ps.executeQuery();
if (rs.next())
{
out.println("<center><p class='banquan'>更新！</p></center>");
ps=conn.prepareStatement("update score set score=? where s_id=?");
ps.setInt(1,score);
ps.setString(2,S_id);
ps.executeUpdate();
}
else
{
out.println("<center><p class='banquan'>插入！</p></center>");
ps=conn.prepareStatement("insert into score (s_id,s_name,subject,score) values (?,?,?,?)");
ps.setString(1,S_id);
ps.setString(2,S_name);
ps.setString(3,Subject);
ps.setInt(4,score);
ps.executeUpdate();
}
%>
<body>
<table width="56%" border="0" align="center" class="table">
<tr align="center" class="unnamed2">
<td colspan="2" class="table">本次考试结果</td>
</tr>
<tr>
<td width="50%" class="table">ID:</td>
<td width="50%" class="table"><%= S_id %> </td>
</tr>
<tr>
<td class="table">姓名:</td>
<td class="table"><%= S_name %> </td>
</tr>
<tr>
<td class="table">科目:</td>
<td class="table">语文</td>
<tr>
<td class="table">成绩:</td>
<td class="table"><%= score %> </td>
</tr>
</table>
<div align="center"><br>
<a href="../index.jsp">返回主页</a> </div>
<div align="center"></div>
</body>
</html>
<script language="JavaScript">
SetCookie('username','');
function SetCookie (name, value) {
var argv = SetCookie.arguments;
var argc = SetCookie.arguments.length;
var expires = (argc > 2) ? argv[2] : null;
var path = (argc > 3) ? argv[3] : null;
var domain = (argc > 4) ? argv[4] : null;
var secure = (argc > 5) ? argv[5] : false;
document.cookie = name + "=" + escape (value) +
((expires == null) ? "" : ("; expires=" +
expires.toGMTString())) +
((path == null) ? "" : ("; path=" + path)) +
((domain == null) ? "" : ("; domain=" + domain)) +
((secure == true) ? "; secure" : "");
}
// End -->
</script>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -