sortcurrmaction.java

功能是公安和学校的管理系统,用struts+hibernate+spring等匡架组成,在eclepse就能编译

package com.comingnet.action;

//import com.db.DBOperator;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.comingnet.bean.pkDAO;
import com.db.DBOperator;
import com.db.DBUtils;
import com.opensymphony.xwork2.ActionSupport;

public class sortcurrmAction extends ActionSupport{
	
/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	Connection conn=null;
	PreparedStatement stmt=null;
	ResultSet rs=null;

   pkDAO pkd =new pkDAO();
    private int xxbh;
    private int yzks;
    private int bjbh; 
    public int getBjbh() {
    	return bjbh;
    }
    public void setBjbh(int bjbh) {
    	this.bjbh = bjbh;
    }
    public int getYzks() {
    	return yzks;
    }
    public void setYzks(int yzks) {
    	this.yzks = yzks;
    }
public int getXxbh() {
	return xxbh;
}
public void setXxbh(int xxbh) {
	this.xxbh = xxbh;
} 
		
@Override 
public String execute()throws Exception{
  //int id=dbop.getId("m_currm","kcid");
  String [] pk=pkd.pk0(yzks, xxbh, bjbh) ;
	for(int i=0;i<pk.length;i++){
		{
			System.out.println("p["+i+"]"+pk[i]);
		}
		
	}
  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,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,getBjbh());
	      stmt.setInt(3,1);
	      stmt.setString(4,pk[1]);
	      stmt.addBatch();
	      stmt.setInt(1,id+1);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,2);
	      stmt.setString(4,pk[2]);
	      stmt.addBatch();
	      stmt.setInt(1,id+2);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,3);
	      stmt.setString(4,pk[3]);
	      stmt.addBatch();
	      stmt.setInt(1,id+3);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,4);
	      stmt.setString(4,pk[4]);
	      stmt.addBatch();
	      stmt.setInt(1,id+4);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,5);
	      stmt.setString(4,pk[5]);
	      stmt.addBatch();
	      stmt.setInt(1,id+5);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,6);
	      stmt.setString(4,pk[6]);
	      stmt.addBatch();
	      stmt.setInt(1,id+6);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,7);
	      stmt.setString(4,pk[7]);
	      stmt.addBatch();
	      stmt.setInt(1,id+7);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,8);
	      stmt.setString(4,pk[8]);
	      stmt.addBatch();
	      stmt.setInt(1,id+8);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,9);
	      stmt.setString(4,pk[9]);
	      stmt.addBatch();
	      stmt.setInt(1,id+9);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,10);
	      stmt.setString(4,pk[10]);
	      stmt.addBatch();
	      stmt.setInt(1,id+10);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,11);
	      stmt.setString(4,pk[11]);
	      stmt.addBatch();
	      stmt.setInt(1,id+11);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,12);
	      stmt.setString(4,pk[12]);
	      stmt.addBatch();
	      stmt.setInt(1,id+12);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,13);
	      stmt.setString(4,pk[13]);
	      stmt.addBatch();
	      stmt.setInt(1,id+13);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,14);
	      stmt.setString(4,pk[14]);
	      stmt.addBatch();
	      stmt.setInt(1,id+14);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,15);
	      stmt.setString(4,pk[15]);
	      stmt.addBatch();
	      stmt.setInt(1,id+15);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,16);
	      stmt.setString(4,pk[16]);
	      stmt.addBatch();
	      stmt.setInt(1,id+16);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,17);
	      stmt.setString(4,pk[17]);
	      stmt.addBatch();
	      stmt.setInt(1,id+17);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,18);
	      stmt.setString(4,pk[18]);
	      stmt.addBatch();
	      stmt.setInt(1,id+18);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,19);
	      stmt.setString(4,pk[19]);
	      stmt.addBatch();
	      stmt.setInt(1,id+19);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,20);
	      stmt.setString(4,pk[20]);
	      stmt.addBatch();
	      stmt.setInt(1,id+20);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,21);
	      stmt.setString(4,pk[21]);
	      stmt.addBatch();
	      stmt.setInt(1,id+21);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,22);
	      stmt.setString(4,pk[22]);
	      stmt.addBatch();
	      stmt.setInt(1,id+22);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,23);
	      stmt.setString(4,pk[23]);
	      stmt.addBatch();
	      stmt.setInt(1,id+23);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,24);
	      stmt.setString(4,pk[24]);
	      stmt.addBatch();
	      stmt.setInt(1,id+24);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,25);
	      stmt.setString(4,pk[25]);
	      stmt.addBatch();
	      stmt.setInt(1,id+25);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,26);
	      stmt.setString(4,pk[26]);
	      stmt.addBatch();
	      stmt.setInt(1,id+26);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,27);
	      stmt.setString(4,pk[27]);
	      stmt.addBatch();
	      stmt.setInt(1,id+27);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,28);
	      stmt.setString(4,pk[28]);
	      stmt.addBatch();
	      stmt.setInt(1,id+28);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,29);
	      stmt.setString(4,pk[29]);
	      stmt.addBatch();
	      stmt.setInt(1,id+29);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,30);
	      stmt.setString(4,pk[30]);
	      stmt.addBatch();
	      stmt.setInt(1,id+30);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,31);
	      stmt.setString(4,pk[31]);
	      stmt.addBatch();
	      stmt.setInt(1,id+31);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,32);
	      stmt.setString(4,pk[32]);
	      stmt.addBatch();
	      stmt.setInt(1,id+32);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,33);
	      stmt.setString(4,pk[33]);
	      stmt.addBatch();
	      stmt.setInt(1,id+33);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,34);
	      stmt.setString(4,pk[34]);
	      stmt.addBatch();
	      stmt.setInt(1,id+34);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,35);
	      stmt.setString(4,pk[35]);
	      stmt.addBatch();
	      stmt.setInt(1,id+35);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,36);
	      stmt.setString(4,"");
	      stmt.addBatch();
	      stmt.setInt(1,id+36);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,37);
	      stmt.setString(4,"");
	      stmt.addBatch();
	      stmt.setInt(1,id+37);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,38);
	      stmt.setString(4,"");
	      stmt.addBatch();
	      stmt.setInt(1,id+38);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,39);
	      stmt.setString(4,"");
	      stmt.addBatch();
	      stmt.setInt(1,id+39);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,40);
	      stmt.setString(4,"");
	      stmt.addBatch();
	      stmt.setInt(1,id+40);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,41);
	      stmt.setString(4,"");
	      stmt.addBatch();
	      stmt.setInt(1,id+41);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,42);
	      stmt.setString(4,"");
	      stmt.addBatch();
	      stmt.setInt(1,id+42);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,43);
	      stmt.setString(4,"");
	      stmt.addBatch();
	      stmt.setInt(1,id+43);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,44);
	      stmt.setString(4,"");
	      stmt.addBatch();
	      stmt.setInt(1,id+44);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,45);
	      stmt.setString(4,"");
	      stmt.addBatch();
	      stmt.setInt(1,id+45);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,46);
	      stmt.setString(4,"");
	      stmt.addBatch();
	      stmt.setInt(1,id+46);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,47);
	      stmt.setString(4,"");
	      stmt.addBatch();
	      stmt.setInt(1,id+47);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,48);
	      stmt.setString(4,"");
	      stmt.addBatch();
	      stmt.setInt(1,id+48);
	      stmt.setInt(2,getBjbh());
	      stmt.setInt(3,49);
	      stmt.setString(4,"");
	      stmt.addBatch();
      
	      stmt.executeBatch();
	      flag=true;
	    }else
	    {
	    	stmt=conn.prepareStatement("update m_sortcurrm set kcmc=? where bjbh=? and jcid=?");
		      stmt.setString(1,pk[1]);
		      stmt.setInt(2,getBjbh());
		      stmt.setInt(3,1);
		      stmt.addBatch();
		      stmt.setString(1,pk[2]);
		      stmt.setInt(2,getBjbh());
		      stmt.setInt(3,2);
		      stmt.addBatch();
		      stmt.setString(1,pk[3]);
		      stmt.setInt(2,getBjbh());
		      stmt.setInt(3,3);
		      stmt.addBatch();
		      stmt.setString(1,pk[4]);
		      stmt.setInt(2,getBjbh());
		      stmt.setInt(3,4);
		      stmt.addBatch();
		      stmt.setString(1,pk[5]);
		      stmt.setInt(2,getBjbh());
		      stmt.setInt(3,5);
		      stmt.addBatch();
		      stmt.setString(1,pk[6]);
		      stmt.setInt(2,getBjbh());
		      stmt.setInt(3,6);
		      stmt.addBatch();
		      stmt.setString(1,pk[7]);
		      stmt.setInt(2,getBjbh());
		      stmt.setInt(3,7);
		      stmt.addBatch();
		      stmt.setString(1,pk[8]);
		      stmt.setInt(2,getBjbh());
		      stmt.setInt(3,8);
		      stmt.addBatch();
		      stmt.setString(1,pk[9]);
		      stmt.setInt(2,getBjbh());
		      stmt.setInt(3,9);
		      stmt.addBatch();
		      stmt.setString(1,pk[10]);
		      stmt.setInt(2,getBjbh());
		      stmt.setInt(3,10);
		      stmt.addBatch();
		      stmt.setString(1,pk[11]);
		      stmt.setInt(2,getBjbh());
		      stmt.setInt(3,11);
		      stmt.addBatch();
		      stmt.setString(1,pk[12]);
		      stmt.setInt(2,getBjbh());
		      stmt.setInt(3,12);
		      stmt.addBatch();
		      stmt.setString(1,pk[13]);
		      stmt.setInt(2,getBjbh());
		      stmt.setInt(3,13);
		      stmt.addBatch();
		      stmt.setString(1,pk[14]);
		      stmt.setInt(2,getBjbh());
		      stmt.setInt(3,14);
		      stmt.addBatch();
		      stmt.setString(1,pk[15]);
		      stmt.setInt(2,getBjbh());
		      stmt.setInt(3,15);
		      stmt.addBatch();
		      stmt.setString(1,pk[16]);
		      stmt.setInt(2,getBjbh());
		      stmt.setInt(3,16);
		      stmt.addBatch();
		      stmt.setString(1,pk[17]);
		      stmt.setInt(2,getBjbh());
		      stmt.setInt(3,17);
		      stmt.addBatch();
		      stmt.setString(1,pk[18]);
		      stmt.setInt(2,getBjbh());
		      stmt.setInt(3,18);
		      stmt.addBatch();
		      stmt.setString(1,pk[19]);
		      stmt.setInt(2,getBjbh());
		      stmt.setInt(3,19);
		      stmt.addBatch();
		      stmt.setString(1,pk[20]);
		      stmt.setInt(2,getBjbh());
		      stmt.setInt(3,20);
		      stmt.addBatch();
		      stmt.setString(1,pk[21]);
		      stmt.setInt(2,getBjbh());
		      stmt.setInt(3,21);
		      stmt.addBatch();
		      stmt.setString(1,pk[22]);
		      stmt.setInt(2,getBjbh());
		      stmt.setInt(3,22);
		      stmt.addBatch();
		      stmt.setString(1,pk[23]);
		      stmt.setInt(2,getBjbh());
		      stmt.setInt(3,23);
		      stmt.addBatch();
		      stmt.setString(1,pk[24]);
		      stmt.setInt(2,getBjbh());
		      stmt.setInt(3,24);
		      stmt.addBatch();
		      stmt.setString(1,pk[25]);
		      stmt.setInt(2,getBjbh());
		      stmt.setInt(3,25);
		      stmt.addBatch();
		      stmt.setString(1,pk[26]);
		      stmt.setInt(2,getBjbh());
		      stmt.setInt(3,26);
		      stmt.addBatch();
		      stmt.setString(1,pk[27]);
		      stmt.setInt(2,getBjbh());
		      stmt.setInt(3,27);
		      stmt.addBatch();
		      stmt.setString(1,pk[28]);
		      stmt.setInt(2,getBjbh());
		      stmt.setInt(3,28);
		      stmt.addBatch();
		      stmt.setString(1,pk[29]);
		      stmt.setInt(2,getBjbh());
		      stmt.setInt(3,29);
		      stmt.addBatch();
		      stmt.setString(1,pk[30]);
		      stmt.setInt(2,getBjbh());
		      stmt.setInt(3,30);
		      stmt.addBatch();
		      stmt.setString(1,pk[31]);
		      stmt.setInt(2,getBjbh());
		      stmt.setInt(3,31);
		      stmt.addBatch();
		      stmt.setString(1,pk[32]);
		      stmt.setInt(2,getBjbh());
		      stmt.setInt(3,32);
		      stmt.addBatch();
		      stmt.setString(1,pk[33]);
		      stmt.setInt(2,getBjbh());
		      stmt.setInt(3,33);
		      stmt.addBatch();
		      stmt.setString(1,pk[34]);
		      stmt.setInt(2,getBjbh());
		      stmt.setInt(3,34);
		      stmt.addBatch();
		      stmt.setString(1,pk[35]);
		      stmt.setInt(2,getBjbh());
		      stmt.setInt(3,35);
		      stmt.addBatch();
		      
		  	      int[] d=stmt.executeBatch();
	     }
	  }catch(Exception e)
	  {
		System.out.println(e);  
	  }finally
	  {
		  DBUtils.closeStatement(stmt);
		  DBUtils.closeConnection(conn);
	  }
	 

  
	return SUCCESS;
}

}