pkinfordao.java
来自「功能是公安和学校的管理系统,用struts+hibernate+spring等匡」· Java 代码 · 共 570 行 · 第 1/2 页
JAVA
570 行
package com.comingnet.bean;
import com.db.*;
import com.comingnet.bean.*;
import java.sql.*;
import java.util.ArrayList;
public class pkInforDAO {
Connection conn=null;
PreparedStatement stmt=null;
ResultSet rs=null;
public pkInforDAO() throws Exception
{
}
public bjpk[] getPkinfor(int bjbh)
{
ArrayList list0= null;
ArrayList list=null;
DBOperator dbop=new DBOperator();
try {
list0=dbop.ExecuteSelect(false, "select b.jsxm,a.jcid,a.kcmc,a.bjbh from m_sortcurrm a, m_teacher b ,m_class_cur c where a.kcmc=c.kcmc and c.bjbh=a.bjbh and b.jsid =c.jsbh and a.bjbh="+bjbh+" order by a.jcid");
System.out.println("select b.jsxm,a.jcid,a.kcmc,a.bjbh from m_sortcurrm a, m_teacher b ,m_class_cur c where a.kcmc=c.kcmc and c.bjbh=a.bjbh and b.jsid =c.jsbh and a.bjbh="+bjbh+" order by a.jcid");
} catch (NullPointerException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
bjpk[] pklist=new bjpk[50];
// System.out.println("list.size-->"+list0.size());
for(int i=0;i<list0.size();i++){
list=(ArrayList)list0.get(i);
bjpk pk=new bjpk();
pk.setBjmc(list.get(3).toString());
pk.setJcid(list.get(1).toString());
pk.setKcmc(list.get(2).toString());
pk.setJsmc(list.get(0).toString());
//System.out.println("list.get(1).toString()-->"+list.get(1).toString());
pklist[Integer.parseInt(list.get(1).toString())]=pk;
}
return pklist;
}
public bjpk[] getPkinfor0(int jsbh)
{
ArrayList list0= null;
ArrayList list=null;
DBOperator dbop=new DBOperator();
try {
list0=dbop.ExecuteSelect(false, "select distinct b.jsxm,a.jcid,a.kcmc,d.bjmc from m_sortcurrm a, m_teacher b ,m_class_cur c ,m_class d where a.bjbh=d.bjid and b.jsid =c.jsbh and c.kcmc=a.kcmc and c.bjbh=a.bjbh and b.jsid="+jsbh+" order by a.jcid");
System.out.println("select distinct b.jsxm,a.jcid,a.kcmc,d.bjmc from m_sortcurrm a, m_teacher b ,m_class_cur c ,m_class d where a.bjbh=d.bjid and b.jsid =c.jsbh and c.kcmc=a.kcmc and c.bjbh=a.bjbh and b.jsid="+jsbh+" order by a.jcid");
} catch (NullPointerException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
bjpk[] pklist=new bjpk[50];
// System.out.println("list.size-->"+list0.size());
for(int i=0;i<list0.size();i++){
list=(ArrayList)list0.get(i);
bjpk pk=new bjpk();
pk.setBjmc(list.get(3).toString());
pk.setJcid(list.get(1).toString());
pk.setKcmc(list.get(2).toString());
pk.setJsmc(list.get(0).toString());
//System.out.println("list.get(1).toString()-->"+list.get(1).toString());
pklist[Integer.parseInt(list.get(1).toString())]=pk;
}
return pklist;
}
public boolean pkInforAdd(pkInfor pkinfor)
{
try {
conn=DBUtils.getConnection();
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
DBOperator dbop=new DBOperator();
boolean flag=false;
int bjbh=0;
try
{
stmt=conn.prepareStatement("select * from m_sortcurrm where bjbh=?");
stmt.setInt(1,pkinfor.getBjbh());
rs=stmt.executeQuery();
if(rs.next())
{
bjbh=rs.getInt("bjbh");
}
DBUtils.closeResultSet(rs);
DBUtils.closeStatement(stmt);
if(bjbh==0)
{
int id=dbop.getId("m_sortcurrm", "pkid");
stmt=conn.prepareStatement("insert into m_sortcurrm(pkid,bjbh,jcid,kcmc)values(?,?,?,?)");
stmt.setInt(1,id);
stmt.setInt(2,pkinfor.getBjbh());
stmt.setInt(3,1);
stmt.setString(4,pkinfor.getKcmc1());
stmt.addBatch();
stmt.setInt(1,id+1);
stmt.setInt(2,pkinfor.getBjbh());
stmt.setInt(3,2);
stmt.setString(4,pkinfor.getKcmc2());
stmt.addBatch();
stmt.setInt(1,id+2);
stmt.setInt(2,pkinfor.getBjbh());
stmt.setInt(3,3);
stmt.setString(4,pkinfor.getKcmc3());
stmt.addBatch();
stmt.setInt(1,id+3);
stmt.setInt(2,pkinfor.getBjbh());
stmt.setInt(3,4);
stmt.setString(4,pkinfor.getKcmc4());
stmt.addBatch();
stmt.setInt(1,id+4);
stmt.setInt(2,pkinfor.getBjbh());
stmt.setInt(3,5);
stmt.setString(4,pkinfor.getKcmc5());
stmt.addBatch();
stmt.setInt(1,id+5);
stmt.setInt(2,pkinfor.getBjbh());
stmt.setInt(3,6);
stmt.setString(4,pkinfor.getKcmc6());
stmt.addBatch();
stmt.setInt(1,id+6);
stmt.setInt(2,pkinfor.getBjbh());
stmt.setInt(3,7);
stmt.setString(4,pkinfor.getKcmc7());
stmt.addBatch();
stmt.setInt(1,id+7);
stmt.setInt(2,pkinfor.getBjbh());
stmt.setInt(3,8);
stmt.setString(4,pkinfor.getKcmc8());
stmt.addBatch();
stmt.setInt(1,id+8);
stmt.setInt(2,pkinfor.getBjbh());
stmt.setInt(3,9);
stmt.setString(4,pkinfor.getKcmc9());
stmt.addBatch();
stmt.setInt(1,id+9);
stmt.setInt(2,pkinfor.getBjbh());
stmt.setInt(3,10);
stmt.setString(4,pkinfor.getKcmc10());
stmt.addBatch();
stmt.setInt(1,id+10);
stmt.setInt(2,pkinfor.getBjbh());
stmt.setInt(3,11);
stmt.setString(4,pkinfor.getKcmc11());
stmt.addBatch();
stmt.setInt(1,id+11);
stmt.setInt(2,pkinfor.getBjbh());
stmt.setInt(3,12);
stmt.setString(4,pkinfor.getKcmc12());
stmt.addBatch();
stmt.setInt(1,id+12);
stmt.setInt(2,pkinfor.getBjbh());
stmt.setInt(3,13);
stmt.setString(4,pkinfor.getKcmc13());
stmt.addBatch();
stmt.setInt(1,id+13);
stmt.setInt(2,pkinfor.getBjbh());
stmt.setInt(3,14);
stmt.setString(4,pkinfor.getKcmc14());
stmt.addBatch();
stmt.setInt(1,id+14);
stmt.setInt(2,pkinfor.getBjbh());
stmt.setInt(3,15);
stmt.setString(4,pkinfor.getKcmc15());
stmt.addBatch();
stmt.setInt(1,id+15);
stmt.setInt(2,pkinfor.getBjbh());
stmt.setInt(3,16);
stmt.setString(4,pkinfor.getKcmc16());
stmt.addBatch();
stmt.setInt(1,id+16);
stmt.setInt(2,pkinfor.getBjbh());
stmt.setInt(3,17);
stmt.setString(4,pkinfor.getKcmc17());
stmt.addBatch();
stmt.setInt(1,id+17);
stmt.setInt(2,pkinfor.getBjbh());
stmt.setInt(3,18);
stmt.setString(4,pkinfor.getKcmc18());
stmt.addBatch();
stmt.setInt(1,id+18);
stmt.setInt(2,pkinfor.getBjbh());
stmt.setInt(3,19);
stmt.setString(4,pkinfor.getKcmc19());
stmt.addBatch();
stmt.setInt(1,id+19);
stmt.setInt(2,pkinfor.getBjbh());
stmt.setInt(3,20);
stmt.setString(4,pkinfor.getKcmc20());
stmt.addBatch();
stmt.setInt(1,id+20);
stmt.setInt(2,pkinfor.getBjbh());
stmt.setInt(3,21);
stmt.setString(4,pkinfor.getKcmc21());
stmt.addBatch();
stmt.setInt(1,id+21);
stmt.setInt(2,pkinfor.getBjbh());
stmt.setInt(3,22);
stmt.setString(4,pkinfor.getKcmc22());
stmt.addBatch();
stmt.setInt(1,id+22);
stmt.setInt(2,pkinfor.getBjbh());
stmt.setInt(3,23);
stmt.setString(4,pkinfor.getKcmc23());
stmt.addBatch();
stmt.setInt(1,id+23);
stmt.setInt(2,pkinfor.getBjbh());
stmt.setInt(3,24);
stmt.setString(4,pkinfor.getKcmc24());
stmt.addBatch();
stmt.setInt(1,id+24);
stmt.setInt(2,pkinfor.getBjbh());
stmt.setInt(3,25);
stmt.setString(4,pkinfor.getKcmc25());
stmt.addBatch();
stmt.setInt(1,id+25);
stmt.setInt(2,pkinfor.getBjbh());
stmt.setInt(3,26);
stmt.setString(4,pkinfor.getKcmc26());
stmt.addBatch();
stmt.setInt(1,id+26);
stmt.setInt(2,pkinfor.getBjbh());
stmt.setInt(3,27);
stmt.setString(4,pkinfor.getKcmc27());
stmt.addBatch();
stmt.setInt(1,id+27);
stmt.setInt(2,pkinfor.getBjbh());
stmt.setInt(3,28);
stmt.setString(4,pkinfor.getKcmc28());
stmt.addBatch();
stmt.setInt(1,id+28);
stmt.setInt(2,pkinfor.getBjbh());
stmt.setInt(3,29);
stmt.setString(4,pkinfor.getKcmc29());
stmt.addBatch();
stmt.setInt(1,id+29);
stmt.setInt(2,pkinfor.getBjbh());
stmt.setInt(3,30);
stmt.setString(4,pkinfor.getKcmc30());
stmt.addBatch();
stmt.setInt(1,id+30);
stmt.setInt(2,pkinfor.getBjbh());
stmt.setInt(3,31);
stmt.setString(4,pkinfor.getKcmc31());
stmt.addBatch();
stmt.setInt(1,id+31);
stmt.setInt(2,pkinfor.getBjbh());
stmt.setInt(3,32);
stmt.setString(4,pkinfor.getKcmc32());
stmt.addBatch();
stmt.setInt(1,id+32);
stmt.setInt(2,pkinfor.getBjbh());
stmt.setInt(3,33);
stmt.setString(4,pkinfor.getKcmc33());
stmt.addBatch();
stmt.setInt(1,id+33);
stmt.setInt(2,pkinfor.getBjbh());
stmt.setInt(3,34);
stmt.setString(4,pkinfor.getKcmc34());
stmt.addBatch();
stmt.setInt(1,id+34);
stmt.setInt(2,pkinfor.getBjbh());
stmt.setInt(3,35);
stmt.setString(4,pkinfor.getKcmc35());
stmt.addBatch();
stmt.setInt(1,id+35);
stmt.setInt(2,pkinfor.getBjbh());
stmt.setInt(3,36);
stmt.setString(4,pkinfor.getKcmc36());
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?