pkaddaction.java

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

package com.comingnet.action;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.comingnet.bean.*;
import com.comingnet.intercepter.UserSessionAware;
import com.db.DBOperator;
import com.db.DBUtils;
import com.opensymphony.xwork2.ActionSupport;

public class pkAddAction extends ActionSupport implements UserSessionAware{
	Connection conn=null;
	PreparedStatement stmt=null;
	ResultSet rs=null;

	private pkInfor pkinfor;
	private UserInfor userSession=null;
	private String auid_test="9";
	private int bjbh;
	private int pk_id;
	private String kcmc1;
	private String kcmc2;
	private String kcmc3;
	private String kcmc4;
	private String kcmc5;
	private String kcmc6;
	private String kcmc7;
	private String kcmc8;
	private String kcmc9;
	private String kcmc10;
	private String kcmc11;
	private String kcmc12;
	private String kcmc13;
	private String kcmc14;
	private String kcmc15;
	private String kcmc16;
	private String kcmc17;
	private String kcmc18;
	private String kcmc19;
	private String kcmc20;
	private String kcmc21;
	private String kcmc22;
	private String kcmc23;
	private String kcmc24;
	private String kcmc25;
	private String kcmc26;
	private String kcmc27;
	private String kcmc28;
	private String kcmc29;
	private String kcmc30;
	private String kcmc31;
	private String kcmc32;
	private String kcmc33;
	private String kcmc34;
	private String kcmc35;
	private String kcmc36;
	private String kcmc37;
	private String kcmc38;
	private String kcmc39;
	private String kcmc40;
	private String kcmc41;
	private String kcmc42;
	private String kcmc43;
	private String kcmc44;
	private String kcmc45;
	private String kcmc46;
	private String kcmc47;
	private String kcmc48;
	private String kcmc49;
	public int getBjbh() {
		return bjbh;
	}
	public void setBjbh(int bjbh) {
		this.bjbh = bjbh;
	}
	public String getKcmc1() {
		return kcmc1;
	}
	public void setKcmc1(String kcmc1) {
		this.kcmc1 = kcmc1;
	}
	public String getKcmc10() {
		return kcmc10;
	}
	public void setKcmc10(String kcmc10) {
		this.kcmc10 = kcmc10;
	}
	public String getKcmc11() {
		return kcmc11;
	}
	public void setKcmc11(String kcmc11) {
		this.kcmc11 = kcmc11;
	}
	public String getKcmc12() {
		return kcmc12;
	}
	public void setKcmc12(String kcmc12) {
		this.kcmc12 = kcmc12;
	}
	public String getKcmc13() {
		return kcmc13;
	}
	public void setKcmc13(String kcmc13) {
		this.kcmc13 = kcmc13;
	}
	public String getKcmc14() {
		return kcmc14;
	}
	public void setKcmc14(String kcmc14) {
		this.kcmc14 = kcmc14;
	}
	public String getKcmc15() {
		return kcmc15;
	}
	public void setKcmc15(String kcmc15) {
		this.kcmc15 = kcmc15;
	}
	public String getKcmc16() {
		return kcmc16;
	}
	public void setKcmc16(String kcmc16) {
		this.kcmc16 = kcmc16;
	}
	public String getKcmc17() {
		return kcmc17;
	}
	public void setKcmc17(String kcmc17) {
		this.kcmc17 = kcmc17;
	}
	public String getKcmc18() {
		return kcmc18;
	}
	public void setKcmc18(String kcmc18) {
		this.kcmc18 = kcmc18;
	}
	public String getKcmc19() {
		return kcmc19;
	}
	public void setKcmc19(String kcmc19) {
		this.kcmc19 = kcmc19;
	}
	public String getKcmc2() {
		return kcmc2;
	}
	public void setKcmc2(String kcmc2) {
		this.kcmc2 = kcmc2;
	}
	public String getKcmc20() {
		return kcmc20;
	}
	public void setKcmc20(String kcmc20) {
		this.kcmc20 = kcmc20;
	}
	public String getKcmc21() {
		return kcmc21;
	}
	public void setKcmc21(String kcmc21) {
		this.kcmc21 = kcmc21;
	}
	public String getKcmc22() {
		return kcmc22;
	}
	public void setKcmc22(String kcmc22) {
		this.kcmc22 = kcmc22;
	}
	public String getKcmc23() {
		return kcmc23;
	}
	public void setKcmc23(String kcmc23) {
		this.kcmc23 = kcmc23;
	}
	public String getKcmc24() {
		return kcmc24;
	}
	public void setKcmc24(String kcmc24) {
		this.kcmc24 = kcmc24;
	}
	public String getKcmc25() {
		return kcmc25;
	}
	public void setKcmc25(String kcmc25) {
		this.kcmc25 = kcmc25;
	}
	public String getKcmc26() {
		return kcmc26;
	}
	public void setKcmc26(String kcmc26) {
		this.kcmc26 = kcmc26;
	}
	public String getKcmc27() {
		return kcmc27;
	}
	public void setKcmc27(String kcmc27) {
		this.kcmc27 = kcmc27;
	}
	public String getKcmc28() {
		return kcmc28;
	}
	public void setKcmc28(String kcmc28) {
		this.kcmc28 = kcmc28;
	}
	public String getKcmc29() {
		return kcmc29;
	}
	public void setKcmc29(String kcmc29) {
		this.kcmc29 = kcmc29;
	}
	public String getKcmc3() {
		return kcmc3;
	}
	public void setKcmc3(String kcmc3) {
		this.kcmc3 = kcmc3;
	}
	public String getKcmc30() {
		return kcmc30;
	}
	public void setKcmc30(String kcmc30) {
		this.kcmc30 = kcmc30;
	}
	public String getKcmc31() {
		return kcmc31;
	}
	public void setKcmc31(String kcmc31) {
		this.kcmc31 = kcmc31;
	}
	public String getKcmc32() {
		return kcmc32;
	}
	public void setKcmc32(String kcmc32) {
		this.kcmc32 = kcmc32;
	}
	public String getKcmc33() {
		return kcmc33;
	}
	public void setKcmc33(String kcmc33) {
		this.kcmc33 = kcmc33;
	}
	public String getKcmc34() {
		return kcmc34;
	}
	public void setKcmc34(String kcmc34) {
		this.kcmc34 = kcmc34;
	}
	public String getKcmc35() {
		return kcmc35;
	}
	public void setKcmc35(String kcmc35) {
		this.kcmc35 = kcmc35;
	}
	public String getKcmc36() {
		return kcmc36;
	}
	public void setKcmc36(String kcmc36) {
		this.kcmc36 = kcmc36;
	}
	public String getKcmc37() {
		return kcmc37;
	}
	public void setKcmc37(String kcmc37) {
		this.kcmc37 = kcmc37;
	}
	public String getKcmc38() {
		return kcmc38;
	}
	public void setKcmc38(String kcmc38) {
		this.kcmc38 = kcmc38;
	}
	public String getKcmc39() {
		return kcmc39;
	}
	public void setKcmc39(String kcmc39) {
		this.kcmc39 = kcmc39;
	}
	public String getKcmc4() {
		return kcmc4;
	}
	public void setKcmc4(String kcmc4) {
		this.kcmc4 = kcmc4;
	}
	public String getKcmc40() {
		return kcmc40;
	}
	public void setKcmc40(String kcmc40) {
		this.kcmc40 = kcmc40;
	}
	public String getKcmc41() {
		return kcmc41;
	}
	public void setKcmc41(String kcmc41) {
		this.kcmc41 = kcmc41;
	}
	public String getKcmc42() {
		return kcmc42;
	}
	public void setKcmc42(String kcmc42) {
		this.kcmc42 = kcmc42;
	}
	public String getKcmc43() {
		return kcmc43;
	}
	public void setKcmc43(String kcmc43) {
		this.kcmc43 = kcmc43;
	}
	public String getKcmc44() {
		return kcmc44;
	}
	public void setKcmc44(String kcmc44) {
		this.kcmc44 = kcmc44;
	}
	public String getKcmc45() {
		return kcmc45;
	}
	public void setKcmc45(String kcmc45) {
		this.kcmc45 = kcmc45;
	}
	public String getKcmc46() {
		return kcmc46;
	}
	public void setKcmc46(String kcmc46) {
		this.kcmc46 = kcmc46;
	}
	public String getKcmc47() {
		return kcmc47;
	}
	public void setKcmc47(String kcmc47) {
		this.kcmc47 = kcmc47;
	}
	public String getKcmc48() {
		return kcmc48;
	}
	public void setKcmc48(String kcmc48) {
		this.kcmc48 = kcmc48;
	}
	public String getKcmc49() {
		return kcmc49;
	}
	public void setKcmc49(String kcmc49) {
		this.kcmc49 = kcmc49;
	}
	public String getKcmc5() {
		return kcmc5;
	}
	public void setKcmc5(String kcmc5) {
		this.kcmc5 = kcmc5;
	}
	public String getKcmc6() {
		return kcmc6;
	}
	public void setKcmc6(String kcmc6) {
		this.kcmc6 = kcmc6;
	}
	public String getKcmc7() {
		return kcmc7;
	}
	public void setKcmc7(String kcmc7) {
		this.kcmc7 = kcmc7;
	}
	public String getKcmc8() {
		return kcmc8;
	}
	public void setKcmc8(String kcmc8) {
		this.kcmc8 = kcmc8;
	}
	public String getKcmc9() {
		return kcmc9;
	}
	public void setKcmc9(String kcmc9) {
		this.kcmc9 = kcmc9;
	}
	public int getPk_id() {
		return pk_id;
	}
	public void setPk_id(int pk_id) {
		this.pk_id = pk_id;
	}
	
    	
	
	public String getAuid_test() {
		return auid_test;
	}
	public void setAuid_test(String auid_test) {
		this.auid_test = auid_test;
	}

	public pkInfor getPkinfor() {
		return pkinfor;
	}
	public void setPkinfor(pkInfor pkinfor) {
		this.pkinfor = pkinfor;
	}
	public UserInfor getUserSession() {
		return userSession;
	}
	public void setUserSession(UserInfor userSession) {
		this.userSession = userSession;
	}
	
	public String execute() throws Exception 
	{ 
		
        pkInforDAO pkdao=new pkInforDAO();
        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,getKcmc1());
    	      stmt.addBatch();
    	      stmt.setInt(1,id+1);
    	      stmt.setInt(2,getBjbh());
    	      stmt.setInt(3,2);
    	      stmt.setString(4,getKcmc2());
    	      stmt.addBatch();
    	      stmt.setInt(1,id+2);
    	      stmt.setInt(2,getBjbh());
    	      stmt.setInt(3,3);
    	      stmt.setString(4,getKcmc3());
    	      stmt.addBatch();
    	      stmt.setInt(1,id+3);
    	      stmt.setInt(2,getBjbh());
    	      stmt.setInt(3,4);
    	      stmt.setString(4,getKcmc4());