WebRoot/ceping/ceping_do.jsp

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

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

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="com.util.*"%>
<%
DBO db=new DBO();
request.setCharacterEncoding("gb2312");
ResultSet rs=null;
String sql="";
int row=0;
String dy[]=null;
String ty[]=null;
String xs=(String)request.getParameter("xs");
String js=(String)request.getParameter("js");
String sj=(String)request.getParameter("sj");
 dy=request.getParameterValues("dy");
String zy=(String)request.getParameter("zy");
 ty=request.getParameterValues("ty");
String jc=(String)request.getParameter("jc");
int fzdy=0;
int fzty=0;
for(int i=0;i<dy.length;i++){
fzdy=fzdy+Integer.parseInt(dy[i]);
}
for(int j=0;j<ty.length;j++){
fzty=fzty+Integer.parseInt(ty[j]);
}
//String sq="select sum()";
sql="select sum(jf) as jf from shenqing where xs='"+xs+"'";
rs=db.query(sql);
int jf=0;
if(rs.next()){
jf=rs.getInt("jf");
}
sql="select avg(cj) as cj from chengji where yh='"+xs+"'";
rs=db.query(sql);
int cj=0;
if(rs.next()){
cj=rs.getInt("cj");
}
int total=0;
total=fzdy+fzty+jf;//+cj*0.6
float a =Float.valueOf(total);
float b=Float.valueOf(cj)*Float.valueOf("0.6");
float all=0;
if(a+b>100){
all=100;
}else{
all=a+b;
}
sql="insert into ceping(xs,js,sj,dy,zy,ty,jc,zf) values('"+xs+"','"+js+"','"+sj+"','"+fzdy+"','"+b+"','"+fzty+"','"+jf+"','"+all+"')";
try{
row=db.executeUpdate(sql);
}catch(Exception e){
System.out.println(e.toString());}
if(row==1){
out.println("<script>");
out.println("alert('测评添加成功');");
out.println("window.location='cepinglist.jsp'");
out.println("</script>");
}else{
out.println("<script>");