newpaper2.jsp

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

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%
	String paperName=request.getParameter("paperName")+"";
	String[] subjects=request.getParameterValues("subjects");
		
	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	Connection conn=DriverManager.getConnection("jdbc:odbc:myAccess");
	Statement stmt=conn.createStatement();
	String sql="insert into paper (pid,pname) select max(pid)+1,'"+paperName + "' from paper";
	stmt.execute(sql);
	
	sql="select max(pid) as pid1 from paper";
	ResultSet rs=stmt.executeQuery(sql);
	String maxPid="";
	if(rs.next()) maxPid=rs.getString("pid1");
	for(int i=0;i<subjects.length;i++){
		sql="insert into paper_subject (pid,sid) values("+maxPid+","+subjects[i]+") ";
		stmt.execute(sql);
	}
	conn.close();
%>
<script language="javascript">
	alert("试卷已经生成");
	window.close();
	window.opener.location.href="paper.jsp";
</script>