?? result.jsp
字號(hào):
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%request.setCharacterEncoding("gb2312");%>
<html>
<head>
<title>考試結(jié)果</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<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");
String S_name=request.getParameter("s_name");
Connection conn = linejdbc.getopenConnection();
PreparedStatement ps=null;
ResultSet rs=null;
int i;
int score=0;//總分
String selectvalue;
String id;
for (i=1;i<=50;i++)
{
selectvalue=request.getParameter("select"+i);
id=request.getParameter("h"+i);
ps=conn.prepareStatement("select * from tiku 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=?");
ps.setInt(1,Integer.parseInt(S_id));
rs=ps.executeQuery();
if (rs.next())
{
//out.println("<center><p class='banquan'>錯(cuò)誤:成績(jī)已經(jīng)存在!</p></center>");
ps=conn.prepareStatement("update score set score=? where s_id=?");
ps.setInt(1,score);
ps.setInt(2,Integer.parseInt(S_id));
ps.executeUpdate();
}
else
{
ps=conn.prepareStatement("insert into score (s_id,score) values (?,?)");
ps.setInt(1,Integer.parseInt(S_id));
ps.setInt(2,score);
ps.executeUpdate();
}
%>
<body>
<table width="56%" border="0" align="center" class="table">
<tr align="center" class="unnamed2">
<td colspan="2" class="table">本次考試結(jié)果</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">成績(jī):</td>
<td class="table"><%= score %> </td>
</tr>
</table>
<div align="center"><br>
<a href="login.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>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -