WebRoot/shijuan/jiaojuan.jsp

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%>
<%@ page import="com.util.*"%>
<%
DBO db=new DBO();
request.setCharacterEncoding("gb2312");
String sj=(String)request.getParameter("sj");
String xs=(String)request.getParameter("xs");
String kssj=(String)request.getParameter("kssj");
String sql="";
ResultSet rs=null;
sql="select * from chengji where sj='"+sj+"' and xs='"+xs+"'";
rs=db.query(sql);
if(rs.next()){
out.println("<script>");
out.println("alert('你已经考过此卷，不能再考 !');");
out.println("window.location='shijuanquery.jsp?keyid="+sj+"'");
out.println("</script>");

return;
}


 sql="select b.* from zuti a,shiti b where a.st=b.stid and a.sjid='"+sj+"' order by b.lx";

db.open();
rs=db.query(sql);
String a="";
String b="";
String c="";//每题得分
int d=0;
int all=0;
String flag="";
String time=StaticMethod.getStringDate();
while(rs.next()){
a=(String)request.getParameter("hd"+rs.getString("stid"));//获得前台答案
flag="错";
System.out.println(a);
b=rs.getString("da");
c=rs.getString("fz");
System.out.println(b);
if(rs.getString("fl").equals("客观")){
if(a!=null){
if(a.equals(b)){
d=Integer.parseInt(c);
all=all+d;
flag="对";
}
}else {
d=0;
a="";
flag="";
}
}
sql=" insert into jl(sj,st,hd,dc,yh,pf) values('"+sj+"','"+rs.getString("stid")+"','"+a+"','"+flag+"','"+xs+"','"+d+"')";
db.open();
db.update(sql);
}

String jssj=StaticMethod.getStringDate();
int ys=StaticMethod.gethour(kssj, jssj);