newsubject2.jsp

这是用jsp技术编写的一个网上测试系统。

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%
	String headline=request.getParameter("headline")+"";
	String A=request.getParameter("A")+"";
	String B=request.getParameter("B")+"";	
	String C=request.getParameter("C")+"";
	String D=request.getParameter("D")+"";
	String answer=request.getParameter("answer")+"";
	
	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	Connection conn=DriverManager.getConnection("jdbc:odbc:myAccess");
	Statement stmt=conn.createStatement();
	String sql="insert into subject (headline,answer) values('"+headline+"','"+answer+"')";
	stmt.execute(sql);
	sql="select max(sid) as sid1 from subject";
	ResultSet rs=stmt.executeQuery(sql);
	String maxSid="";
	if(rs.next()) maxSid=rs.getString("sid1");
	sql="insert into options (sid,oname,content) values("+maxSid+",'A','"+A+"') ";
	stmt.execute(sql);
	sql="insert into options (sid,oname,content) values("+maxSid+",'B','"+B+"') ";
	stmt.execute(sql);
	sql="insert into options (sid,oname,content) values("+maxSid+",'C','"+C+"') ";
	stmt.execute(sql);
	sql="insert into options (sid,oname,content) values("+maxSid+",'D','"+D+"')";
	stmt.execute(sql);
%>
<script language="javascript">
	alert("纪录已经插入");
	window.close();
	window.opener.location.href="subject.jsp";
</script>