📄 simpleoutsave.jsp
字号:
<%@ page language="java" import="java.util.*" pageEncoding="GB18030"%>
<%@ page import="com.study.database.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.sql.*"%>
<%@ page import="com.study.vo.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>在线考试系统</title>
</head>
<%
String choice="";
String opinion="";
String discuss="";
String papertitle = new String(request.getParameter("papertitle").getBytes("ISO-8859-1"),"GB18030");
DBConnectionManage db = new DBConnectionManage();
int count= 1;
Connection conn = db.getFreeConnection();
String query = "select * from paper p,exam e where e.paperid = p.paperid and p.papertitle = ?";
PreparedStatement psmt = null;
ResultSet rs = null;
try{
psmt = conn.prepareStatement(query);
psmt.setString(1,papertitle);
rs = psmt.executeQuery();
while(rs.next()){
choice = rs.getString("choiceid");
opinion = rs.getString("opinionid");
discuss = rs.getString("discussid");
}
}catch(Exception ex){
out.println();
}finally{
psmt.close();
rs.close();
db.closeConnection(conn);
}
%>
<body>
<br>
<form action="checkpaper.jsp" method="post">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="2" align="center"><h2>考 试 试 题</h2></td>
</tr>
<tr>
<td colspan="2" align="center"><input type='hidden' name='papertitle' id='papertitle' value='<%=papertitle %>'/><h3></h3></td>
</tr>
<tr>
<td colspan="2"><b>选择题：</b></td>
</tr>
<%
conn = db.getFreeConnection();
query = "select * from subject where subjectid in ("+choice+")";
psmt = null;
rs = null;
try{
psmt = conn.prepareStatement(query);
rs = psmt.executeQuery();
while(rs.next()){
out.println("<tr>");
out.println("<td> "+rs.getString("subjectquestion")+"</td>");
out.println("<td><input type='' value='' id='subject_"+rs.getString("subjectid")+"' name='subject_"+rs.getString("subjectid")+"' size='10'/></td>");
out.println("</tr>");
}
}catch(Exception ex){
}finally{
psmt.close();
rs.close();
db.closeConnection(conn);
}
%>
<tr>
<td colspan="2"><HR></HR></td>
</tr>
<tr>
<td colspan="2"><b>判断题：</b></td>
</tr>
<%
conn = db.getFreeConnection();
query = "select * from subject where subjectid in ("+opinion+")";
psmt = null;
rs = null;
try{
psmt = conn.prepareStatement(query);
rs = psmt.executeQuery();
while(rs.next()){
out.println("<tr>");
out.println("<td> "+rs.getString("subjectquestion")+"</td>");
out.println("<td><input type='' value='' id='subject_"+rs.getString("subjectid")+"' name='subject_"+rs.getString("subjectid")+ "' size='10'/></td>");
out.println("</tr>");
out.println();
count++;
}
}catch(Exception ex){
}finally{
psmt.close();
rs.close();
db.closeConnection(conn);
}
%>
<tr>
<td colspan="2"><HR></HR></td>
</tr>
<tr>
<td colspan="2"><b>论述题：
</b></td>
</tr>
<%
conn = db.getFreeConnection();
query = "select * from subject where subjectid in ("+discuss+")";
psmt = null;
rs = null;
try{
psmt = conn.prepareStatement(query);
rs = psmt.executeQuery();
while(rs.next()){
out.println("<tr>");
out.println("<td colspan='2'>"+rs.getString("subjectquestion")+"</td>");
out.println("</tr>");
out.println("<tr>");
out.println("<td colspan='2'><textarea name='subject_"+rs.getString("subjectid")+"' cols='50' rows='10'></textarea></td>");
out.println("</tr>");
count++;
}
}catch(Exception ex){
}finally{
psmt.close();
rs.close();
db.closeConnection(conn);
}
%>
<tr>
<td colspan="2"><HR></HR></td>
</tr>
<tr>
<td colspan="2" align="center"><input name="" type="submit" value="提交">
<input name="" type="reset" value="重置"></td>
</tr>
</table>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -