WebRoot/shixi/zidongdo.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 rs1=(String)request.getParameter("rs");// 变量 名 :备注

String sql="";//声明sql
sql="select * from qiye";
String qy="";
String qynum="";
ResultSet r=null,s=null;
rs=db.query(sql);
int a=0;
while(rs.next()){
sql="select count(1) as num from shixi where qy='"+rs.getString("qy")+"'";
db.open();
r=db.query(sql);
if(r.next()){
qynum=r.getString("num");
}
 a=Integer.parseInt(rs1)-Integer.parseInt(qynum);
if(a>0){
sql="select count(1) as num from xuesheng where yhm not in (select xs from shixi )";
db.open();
s=db.query(sql);
if(s.next()){
if(s.getInt("num")==0){
break;
}
}

sql="select * from xuesheng where yhm not in (select xs from shixi ) limit 0,"+a+"";
db.open();
s=db.query(sql);
while(s.next()){
sql="insert into shixi(xs,qy,sj,zt,bz) values('"+s.getString("yhm")+"','"+rs.getString("qy")+"','"+StaticMethod.getStringDate()+"','正常','自动分配')";
db.open();
db.update(sql);
}

}


}


out.println("<script>");
out.println("alert('分配完成');");
out.println("window.location='shixiadd.jsp'");
out.println("</script>");

db.close();
%>