docasefactory.java

一套完整的工商12315的源程序jsp部分在12315里,后台JAVA部分在gs12315src里,没有打包数据库.

package com.gs.doCase;

import java.util.*;
import java.io.*;
import com.gs.db.*;
import com.gs.db.dbimp.*;
import com.gs.util.*;

import java.util.*;
import java.sql.*;
import com.gs.doCase.*;



public class DoCaseFactory {
  public static String dateFormat = "yyyy-MM-dd";
  private static Object initLock = new Object();
  private static DoCaseFactory factory = null;

  public DoCaseFactory() {

  }
  public static DoCaseFactory getInstance() {
    if (factory == null) {
      synchronized (initLock) {
        if (factory == null) {
         factory = new DoCaseFactory();
        }
      }
    }
    return factory;
  }
  private final static String Q_U_xztjaj_add =
     "INSERT INTO u_xztjaj   ( djbh,ajbh,tjrq,badw,bar,t_tssplb,t_ssnrb,t_ssrfl,t_jzfl,b_mc,b_zch,b_qylx,sssjje,whjjss,jspcje,jbpcje,sfcf,sfyjbmcl,sfqq,sfcg,tjjg) VALUES ( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
  private final static String Q_U_xztjaj_edit =
      "update u_xztjaj set ajbh=?,tjrq=?,badw=?,bar=?,t_tssplb=?,t_ssnrb=?,t_ssrfl=?,t_jzfl=?,b_mc=?,b_zch=?,b_qylx=?,sssjje=?,whjjss=?,jspcje=?,jbpcje=?,sfcf=?,sfyjbmcl=?,sfqq=?,sfcg=?,tjjg=? where djbh=?";
  private final static String Q_U_xztjaj_delete = "delete from  u_xztjaj where  djbh=?";
  //Q_U_xztjaj_getByKey
  private final static String Q_U_xztjaj_getByKey = "select  djbh,ajbh,tjrq,badw,bar,t_tssplb,t_ssnrb,t_ssrfl,t_jzfl,b_mc,b_zch,b_qylx,sssjje,whjjss,jspcje,jbpcje,sfcf,sfyjbmcl,sfqq,sfcg,tjjg from u_xztjaj where djbh=? ";

  private final static String Q_U_qhxfzqyaj_add =
      "INSERT INTO u_qhxfzqyaj   ( djbh,ajbh,tjrq,badw,bar,t_tssplb,t_qqxwfl,t_ssrfl,t_jzfl,b_mc,b_zch,b_qylx,ajje,msje,fkje,sfla,sfyssf,sftjzd,sfdxzz,dyzfry,dyzfcl,jcsc,jcqy,blkf,shoushang,siwang,tjjg,sfyjbmcl) VALUES ( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
  private final static String Q_U_qhxfzqyaj_edit =
      "update u_qhxfzqyaj set ajbh=?,tjrq=CONVERT(datetime, ?, 120),badw=?,bar=?,t_tssplb=?,t_qqxwfl=?,t_ssrfl=?,t_jzfl=?,b_mc=?,b_zch=?,b_qylx=?,ajje=?,msje=?,fkje=?,sfla=?,sfyssf=?,sftjzd=?,sfdxzz=?,dyzfry=?,dyzfcl=?,jcsc=?,jcqy=?,blkf=?,shoushang=?,siwang=?,tjjg=?,sfyjbmcl=? where djbh=? ";
  private final static String Q_U_qhxfzqyaj_delete = "delete from  u_qhxfzqyaj where  djbh=?";
  private final static String Q_U_qhxfzqyaj_getByKey = "select  djbh,ajbh,tjrq,badw,bar,t_tssplb,t_qqxwfl,t_ssrfl,t_jzfl,b_mc,b_zch,b_qylx,ajje,msje,fkje,sfla,sfyssf,sftjzd,sfdxzz,dyzfry,dyzfcl,jcsc,jcqy,blkf,shoushang,siwang,tjjg,sfyjbmcl from u_qhxfzqyaj where djbh=? ";

 private final static String Q_U_jmwlspaj_add =
      "INSERT INTO u_jmwlspaj   ( djbh,ajbh,tjrq,badw,bar,t_tssplb,t_qqxwfl,t_ssrfl,t_jzfl,b_mc,b_zch,b_qylx,ajje,msje,fkje,sfla,sfyssf,sftjzd,sfdxzz,sfsc,sfjmsc,dhwd,sfdxzdaj,ksaj,qgaj,swaj,thaj,lfaj,kfaj,zlaj,shoushang,siwang,tjjg) "
      +"VALUES ( ?,?,CONVERT(datetime, ?, 120),?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
 private final static String Q_U_jmwlspaj_edit =
      "update u_jmwlspaj set ajbh=?,tjrq=CONVERT(datetime, ?, 120),badw=?,bar=?,t_tssplb=?,t_qqxwfl=?,t_ssrfl=?,t_jzfl=?,b_mc=?,b_zch=?,b_qylx=?,ajje=?,msje=?,fkje=?,sfla=?,sfyssf=?,sftjzd=?,sfdxzz=?,sfsc=?,sfjmsc=?,dhwd=?,sfdxzdaj=?,ksaj=?,qgaj=?,swaj=?,thaj=?,lfaj=?,kfaj=?,zlaj=?,shoushang=?,siwang=?,tjjg=? where djbh=?";
  private final static String Q_U_jmwlspaj_delete = "delete from  u_jmwlspaj where  djbh=?";
  private final static String Q_U_jmwlspaj_getByKey = "select  djbh,ajbh,tjrq,badw,bar,t_tssplb,t_qqxwfl,t_ssrfl,t_jzfl,b_mc,b_zch,b_qylx,ajje,msje,fkje,sfla,sfyssf,sftjzd,sfdxzz,sfsc,sfjmsc,dhwd,sfdxzdaj,ksaj,qgaj,swaj,thaj,lfaj,kfaj,zlaj,shoushang,siwang from u_jmwlspaj,tjjg where djbh=?";

  public U_xztjajImp getXztjaj(String djbh) {
    U_xztjajImp obj = null;
    Connection con = null;
    PreparedStatement pstmt = null;
    try {
      con = DbConnectionManager.getConnection();
      pstmt = con.prepareStatement(Q_U_xztjaj_getByKey);

      pstmt.setString(1, djbh);

      ResultSet rs = pstmt.executeQuery();
      if (rs.next()) {
        obj = setObjct(obj, rs);
      }
    }
    catch (Exception e) {
    }
    finally {
      try {
        pstmt.close();
      }
      catch (Exception e) {
        e.printStackTrace();
      }
      try {
        con.close();
      }
      catch (Exception e) {
        e.printStackTrace();
      }
    }
    return obj;

  }
  public U_qhxfzqyajImp getQhxfzqyaj(String djbh) {
    U_qhxfzqyajImp obj = null;
    Connection con = null;
    PreparedStatement pstmt = null;
    try {
      con = DbConnectionManager.getConnection();
      pstmt = con.prepareStatement(Q_U_qhxfzqyaj_getByKey);

      pstmt.setString(1, djbh);

      ResultSet rs = pstmt.executeQuery();
      if (rs.next()) {
        obj = setObjct(obj, rs);
      }
    }
    catch (Exception e) {
    }
    finally {
      try {
        pstmt.close();
      }
      catch (Exception e) {
        e.printStackTrace();
      }
      try {
        con.close();
      }
      catch (Exception e) {
        e.printStackTrace();
      }
    }
    return obj;

  }
  public U_jmwlspajImp getJmwlspaj(String djbh) {
    U_jmwlspajImp obj = null;
    Connection con = null;
    PreparedStatement pstmt = null;
    try {
      con = DbConnectionManager.getConnection();
      pstmt = con.prepareStatement(Q_U_jmwlspaj_getByKey);

      pstmt.setString(1, djbh);

      ResultSet rs = pstmt.executeQuery();
      if (rs.next()) {
        obj = setObjct(obj, rs);
      }
    }
    catch (Exception e) {
    }
    finally {
      try {
        pstmt.close();
      }
      catch (Exception e) {
        e.printStackTrace();
      }
      try {
        con.close();
      }
      catch (Exception e) {
        e.printStackTrace();
      }
    }
    return obj;

  }



  public void delXztjaj(String djbh){
    Connection con = null;
   PreparedStatement pstmt = null;
   try {
     con = DbConnectionManager.getConnection();
     pstmt = con.prepareStatement(Q_U_xztjaj_delete);
     pstmt.setString(1, djbh);
     pstmt.executeUpdate();
   }
   catch (Exception e) {
     e.printStackTrace();
   }
   finally {
     try {
       pstmt.close();
     }
     catch (Exception e) {
       e.printStackTrace();
     }
     try {
       con.close();
     }
     catch (Exception e) {
       e.printStackTrace();
     }
   }

  }
  public void delJmwlspaj(String djbh){
    Connection con = null;
   PreparedStatement pstmt = null;
   try {
     con = DbConnectionManager.getConnection();
     pstmt = con.prepareStatement(Q_U_jmwlspaj_delete);
     pstmt.setString(1, djbh);
     pstmt.executeUpdate();
   }
   catch (Exception e) {
     e.printStackTrace();
   }
   finally {
     try {
       pstmt.close();
     }
     catch (Exception e) {
       e.printStackTrace();
     }
     try {
       con.close();
     }
     catch (Exception e) {
       e.printStackTrace();
     }
   }

  }
  public void delQhxfzqyaj(String djbh){
    Connection con = null;
   PreparedStatement pstmt = null;
   try {
     con = DbConnectionManager.getConnection();
     pstmt = con.prepareStatement(Q_U_qhxfzqyaj_delete);
     pstmt.setString(1, djbh);
     pstmt.executeUpdate();
   }
   catch (Exception e) {
     e.printStackTrace();
   }
   finally {
     try {
       pstmt.close();
     }
     catch (Exception e) {
       e.printStackTrace();
     }
     try {
       con.close();
     }
     catch (Exception e) {
       e.printStackTrace();
     }
   }

  }

 public void addXztjaj(U_xztjajImp obj){
   Connection con = null;
   PreparedStatement pstmt = null;
   try {
     con = DbConnectionManager.getConnection();
     pstmt = con.prepareStatement(Q_U_xztjaj_add);
     pstmt.setString(1, obj.getdjbh());
       pstmt.setString(2, obj.getajbh());
       pstmt.setString(3, StringUtils.SimpleDateFormat(obj.gettjrq()));
       pstmt.setString(4, obj.getbadw());
       pstmt.setString(5, obj.getbar());
       pstmt.setString(6, obj.gett_tssplb());
       pstmt.setString(7, obj.gett_ssnrb());
       pstmt.setString(8, obj.gett_ssrfl());
       pstmt.setString(9, obj.gett_jzfl());
       pstmt.setString(10, obj.getb_mc());
       pstmt.setString(11, obj.getb_zch());
       pstmt.setString(12, obj.getb_qylx());
       pstmt.setString(13, obj.getsssjje());
     //  System.out.println("sssjje="+obj.getsssjje());
       pstmt.setString(14, obj.getwhjjss());
       pstmt.setString(15, obj.getjspcje());
       pstmt.setString(16, obj.getjbpcje());
       pstmt.setString(17, obj.getsfcf());
       pstmt.setString(18, obj.getsfyjbmcl());
       pstmt.setString(19, obj.getsfqq());
       pstmt.setString(20, obj.getsfcg());
       pstmt.setString(21, obj.gettjjg());
       pstmt.executeUpdate();
   }
   catch (Exception e) {
     e.printStackTrace();
   }
   finally {
     try {
       pstmt.close();
     }
     catch (Exception e) {
       e.printStackTrace();
     }
     try {
       con.close();
     }
     catch (Exception e) {
       e.printStackTrace();
     }
   }

 }
 public void addJmwlspaj(U_jmwlspajImp obj){
   Connection con = null;
   PreparedStatement pstmt = null;
   try {
     con = DbConnectionManager.getConnection();
     pstmt = con.prepareStatement(Q_U_jmwlspaj_add);
     pstmt.setString(1, obj.getdjbh());
     pstmt.setString(2, obj.getajbh());
     pstmt.setString(3, StringUtils.SimpleDateFormat(obj.gettjrq()));
     pstmt.setString(4, obj.getbadw());
     pstmt.setString(5, obj.getbar());
     pstmt.setString(6, obj.gett_tssplb());
     pstmt.setString(7, obj.gett_qqxwfl());
     pstmt.setString(8, obj.gett_ssrfl());
     pstmt.setString(9, obj.gett_jzfl());
     pstmt.setString(10, obj.getb_mc());
     pstmt.setString(11, obj.getb_zch());
     pstmt.setString(12, obj.getb_qylx());
     pstmt.setString(13, obj.getajje());

     pstmt.setString(14, obj.getmsje());
     pstmt.setString(15, obj.getfkje());
     pstmt.setString(16, obj.getsfla());
     pstmt.setString(17, obj.getsfyssf());
     pstmt.setString(18, obj.getsftjzd());
     pstmt.setString(19, obj.getsfdxzz());
     pstmt.setString(20, obj.getsfsc());
     pstmt.setString(21, obj.getsfjmsc());
     pstmt.setInt(22, obj.getdhwd());
     pstmt.setString(23, obj.getsfdxzdaj());
     pstmt.setString(24, obj.getksaj());
     pstmt.setString(25, obj.getqgaj());
     pstmt.setString(26, obj.getswaj());
     pstmt.setString(27, obj.getthaj());
     pstmt.setString(28, obj.getlfaj());
     pstmt.setString(29, obj.getkfaj());
     pstmt.setString(30, obj.getzlaj());
     pstmt.setInt(31, obj.getshoushang());
     pstmt.setInt(32, obj.getsiwang());
     pstmt.setString(33, obj.gettjjg());

     pstmt.executeUpdate();
   }
   catch (Exception e) {
     e.printStackTrace();
   }
   finally {
     try {
       pstmt.close();
     }
     catch (Exception e) {
       e.printStackTrace();
     }
     try {
       con.close();
     }
     catch (Exception e) {
       e.printStackTrace();
     }
   }

 }
 public void addQhxfzqyaj(U_qhxfzqyajImp obj){
   Connection con = null;
   PreparedStatement pstmt = null;
   try {
     con = DbConnectionManager.getConnection();
     pstmt = con.prepareStatement(Q_U_qhxfzqyaj_add);
     pstmt.setString(1, obj.getdjbh());
     pstmt.setString(2, obj.getajbh());
     pstmt.setString(3, StringUtils.SimpleDateFormat(obj.gettjrq()));
     pstmt.setString(4, obj.getbadw());
     pstmt.setString(5, obj.getbar());
     pstmt.setString(6, obj.gett_tssplb());
     pstmt.setString(7, obj.gett_qqxwfl());
     pstmt.setString(8, obj.gett_ssrfl());
     pstmt.setString(9, obj.gett_jzfl());
     pstmt.setString(10, obj.getb_mc());
     pstmt.setString(11, obj.getb_zch());
     pstmt.setString(12, obj.getb_qylx());
     pstmt.setString(13, obj.getajje());
     pstmt.setString(14, obj.getmsje());
     pstmt.setString(15, obj.getfkje());
     pstmt.setString(16, obj.getsfla());
     pstmt.setString(17, obj.getsfyssf());
     pstmt.setString(18, obj.getsftjzd());
     pstmt.setString(19, obj.getsfdxzz());
     pstmt.setInt(20, obj.getdyzfry());
     pstmt.setInt(21, obj.getdyzfcl());
     pstmt.setInt(22, obj.getjcsc());
     pstmt.setInt(23, obj.getjcqy());
     pstmt.setInt(24, obj.getblkf());
     pstmt.setInt(25, obj.getshoushang());
     pstmt.setInt(26, obj.getsiwang());
     pstmt.setString(27, obj.gettjjg());
     pstmt.setString(28, obj.getsfyjbmcl());
     pstmt.executeUpdate();
   }
   catch (Exception e) {
     e.printStackTrace();
   }
   finally {
     try {
       pstmt.close();
     }
     catch (Exception e) {
       e.printStackTrace();
     }
     try {
       con.close();
     }
     catch (Exception e) {
       e.printStackTrace();
     }
   }
 }
 public void editXztjaj(U_xztjajImp obj){
   Connection con = null;
   PreparedStatement pstmt = null;
   try {
     con = DbConnectionManager.getConnection();
     pstmt = con.prepareStatement(Q_U_xztjaj_edit);
     String djbh = obj.getdjbh();
     String ajbh = obj.getajbh();
     java.util.Date tjrq = obj.gettjrq();
     String badw = obj.getbadw();
     String bar = obj.getbar();
     String t_tssplb = obj.gett_tssplb();
     String t_ssnrb = obj.gett_ssnrb();
     String t_ssrfl = obj.gett_ssrfl();
     String t_jzfl = obj.gett_jzfl();
     String b_mc = obj.getb_mc();
     String b_zch = obj.getb_zch();
     String b_qylx = obj.getb_qylx();
     String sssjje = obj.getsssjje();
     String whjjss = obj.getwhjjss();
     String jspcje = obj.getjspcje();
     String jbpcje = obj.getjbpcje();
     String sfcf = obj.getsfcf();
     String sfyjbmcl = obj.getsfyjbmcl();
     String sfqq = obj.getsfqq();
     String sfcg = obj.getsfcg();

     pstmt.setString(1, ajbh);
     pstmt.setString(2, StringUtils.SimpleDateFormat(tjrq, dateFormat));
     pstmt.setString(3, badw);
     pstmt.setString(4, bar);
     pstmt.setString(5, t_tssplb);
     pstmt.setString(6, t_ssnrb);