📄 showquestion.jsp
字号:
<%@page contentType="text/html;charset=GB2312"%>
<%@page import="java.sql.*"%>
<jsp:useBean id="MyBean" scope="session" class="myjsp.MyBean"/>
<jsp:setProperty name="MyBean" property="*"/>
<html>
<head>
<title>
在线答题
</title>
<LINK href="style.css" rel=stylesheet>
</head>
<body>
<% Connection con = MyBean.getConnection();
Statement smt = con.createStatement();
ResultSet rs;
%>
<form action = thanks.jsp method="post">
<%
String sql = "SELECT Question,QuestionID from questions where IsVisable = 1 ";
rs = smt.executeQuery(sql);
ResultSet _rs;
String question = null,item = null,_sql;
Statement _smt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
int questionid = 0,itemid = 0;
int i=0,j; //题目及选项标号
while(rs.next())
{
i++;
question = rs.getString(1);
questionid= rs.getInt(2);
out.print("<TABLE borderColor=#999999 cellSpacing=0 cellPadding=0 width=100% border=0><tr bgcolor=#999999><td>"+" "+i+"."+" "+question+"</td></tr>");
_sql = "SELECT Item,ItemID From Items Where QuestionID ="+questionid;
_rs = _smt.executeQuery(_sql);
j = 0;
while(_rs.next())
{
j++;
item = _rs.getString(1);
itemid = _rs.getInt(2);
//out.print("<tr>"+item);%>
<td > <%=j%><input type=radio value="<%=itemid%>" name="<%=questionid%>" <%if(j<2) {out.print(" checked "+j);}%>><%=item%></td></tr>
}
out.print(" </table><p>");
}
<%
smt.close(); //关闭Statement对象
MyBean.close(); //关闭Connection对象
%>
<hr>
<DIV align=center><INPUT class=buttonface type=submit value=提交 name=Submit>
<INPUT class=buttonface type=reset value=重选 name=Submit2>
</div>
</form>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -