WebRoot/chengji/pigaicheck.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 keyid=(String)request.getParameter("keyid");
String xs=(String)request.getParameter("xs");
String sjbh=(String)request.getParameter("sjbh");
String cj=(String)request.getParameter("cj");
String sql="";
ResultSet rs=null;


 sql="select b.*,a.jlid from jl a,shiti b where a.st=b.stid and a.sj='"+sjbh+"' and a.yh='"+xs+"' and b.fl='主观' 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("dc"+rs.getString("stid"));//获得前台答案
flag="错";
System.out.println(a);
b=rs.getString("da");
c=rs.getString("fz");
System.out.println(b);

if(a!=null){
if(a.equals("对")){
d=Integer.parseInt(c);
all=all+d;
flag="对";
}
}


sql="update jl set pf='"+d+"',dc='"+a+"' where jlid='"+rs.getString("jlid")+"'";

//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();
String ys="0";
//sql="insert into chengji(sj,xs,kssj,jssj,cj,zg,kg,zt,ys) values('"+sj+"','"+xs+"','"+kssj+"','"+jssj+"','"+all+"','0','"+all+"','未完成','"+ys+"')";
int cc=Integer.parseInt(cj)+all;
sql="update chengji set cj='"+cc+"' ,zg='"+all+"',zt='完成' where cjid='"+keyid+"'";
System.out.println(sql);
db.open();
db.update(sql);
db.close();
//out.println("all="+all);
out.println("<script>");
out.println("alert('提交成功,主观得分,"+all+" !');");