newpaper.jsp

来自「这是用jsp技术编写的一个网上测试系统。」· JSP 代码 · 共 46 行

JSP
46
字号
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<body>
<form name="fm" action="newPaper2.jsp" method="post">
  <div align="center">试卷名称:
    <input type=text name=paperName />
    <br />
所有的试题:<br />
<%
	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	Connection conn=DriverManager.getConnection("jdbc:odbc:myAccess");
	Statement stmt=conn.createStatement();
	String sql="select * from subject order by sid";
	ResultSet rs=stmt.executeQuery(sql);
%>

<table width="100%" border="1">
	<tr><td width="15%" align="center"><strong>试题编号</strong></td>
		<td width="55%" align="center"><strong>提干</strong></td>
		<td width="10%" align="center"><strong>标准答案</strong></td>
		<td width="20%" align="center"><strong>操作</strong></td>
	</tr>
<%	while(rs.next()){
	String sid=rs.getString("sid");
%>
	<tr><td><%=sid%></td>
		<td><%=rs.getString("headline")%></td>
		<td><%=rs.getString("answer")%></td>
		<td><div align="center">
		  <input type="checkbox" name="subjects" value="<%=sid%>">
		  </div></td>
	</tr>
<%	}	%>

</table>
<center><input type="submit" value="提交"></center>
  </div>
</form>
</body>
</html>

<script language="javascript">
function validate(){
	document.fm.submit();
}
</script>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?