dbdjnr.java

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

package com.gs.db.dbimp;

import com.gs.db.*;
import com.gs.util.Cacheable;
import com.gs.util.CacheSizes;
import java.sql.*;
import java.util.Iterator;
import java.util.ArrayList;
import java.lang.*;
import java.util.*;
import java.text.SimpleDateFormat;

public class Dbdjnr {
  private static final String LOAD_NR_BY_BH =
      "SELECT djbh,djjg,gxdw,cldw, clr,tslx,lrr,clbz,tsly,tslybm,tslylxr,"
      +
      "tslylxdh,tsrmc,tsrq,tssj,tsfs,tsrdh,tsrdz,tsrem,tsyzbm,tslxr,btsdw,btsdwdz,"
      + "btsdwdh,btsdwlxr,btsdwlxrdh,btsdwyzbm,btspart,btsbrand,btsstyle,btsxflxdl,btsxflxzl,btsxflxxl,"
      + "tsnr,slqk,bz,ktwhmc,lrrID,lrryj,djjgjdyyj,djjghzryj,djjgjzyj,zbdwjdyyj,zbdwhzryj,zbdwjzyj,cl_result,anly,return_reason,zb_path,final_clbz,hfr,hfsj,hfjg"
      +""
      + " FROM u_djnrb WHERE djbh=?";
  private static final String Create_NR_ID =
      "SELECT max(djbh) FROM u_djnrb WHERE djbh like ''+?+'%'";
  private static final String INSERT_NR =
      "INSERT INTO u_djnrb(djbh,djjg,gxdw,cldw, clr,tslx,lrr,clbz,tsly,tslybm,tslylxr,"
      +
      "tslylxdh,tsrmc,tsrq,tssj,tsfs,tsrdh,tsrdz,tsrem,tsyzbm,tslxr,btsdw,btsdwdz,"
      + "btsdwdh,btsdwlxr,btsdwlxrdh,btsdwyzbm,btspart,btsbrand,btsstyle,btsxflxdl,btsxflxzl,btsxflxxl,"
      + "tsnr,slqk,bz,ktwhmc,lrrID,lrryj,djjgjdyyj,djjghzryj,djjgjzyj,zbdwjdyyj,zbdwhzryj,zbdwjzyj,cl_result,anly,return_reason,zb_path,final_clbz,hfr,hfsj,hfjg"
      + ") " +
      "VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
  private static final String SAVE_NR =
      "UPDATE u_djnrb SET djjg=?,gxdw=?,cldw=?, clr=?,tslx=?,lrr=?,clbz=?,tsly=?,tslybm=?,tslylxr=?,"
      + "tslylxdh=?,tsrmc=?,tsrq=?,tssj=?,tsfs=?,tsrdh=?,tsrdz=?,tsrem=?,tsyzbm=?,tslxr=?,btsdw=?,btsdwdz=?,"
      + "btsdwdh=?,btsdwlxr=?,btsdwlxrdh=?,btsdwyzbm=?,btspart=?,btsbrand=?,btsstyle=?,btsxflxdl=?,"
      + "btsxflxzl=?,btsxflxxl=?,tsnr=?,slqk=?,bz=?,ktwhmc=?,lrrID=?,"
      +"lrryj=?,djjgjdyyj=?,djjghzryj=?,djjgjzyj=?,zbdwjdyyj=?,zbdwhzryj=?,zbdwjzyj=?,cl_result=?,anly=?,return_reason=?,zb_path=?,final_clbz=?,hfr=?,hfsj=?,hfjg=?"
      + " WHERE djbh=?";
  private final SimpleDateFormat dateFormatter =
      new SimpleDateFormat("yyyy-MM-d");
  public String djbh = null;
  public String djjg = null;
  public String gxdw = null;
  public String cldw = null;
  public String clr = null;
  public String tslx = null;
  public String lrr = null;
  public String clbz = null;
  public String tsly = null;
  public String tslybm = null;
  public String tslylxr = null;
  public String tslylxdh = null;
  public String tsrmc = null;
  public String tsrq = null;
  public String tssj = null;
  public String tsfs = null;
  public String tsrdh = null;
  public String tsrdz = null;
  public String tsrem = null;
  public String tsyzbm = null;
  public String tslxr = null;
  public String btsdw = null;
  public String btsdwdz = null;
  public String btsdwdh = null;
  public String btsdwlxr = null;
  public String btsdwlxrdh = null;
  public String btsdwyzbm = null;
  public String btspart = null;
  public String btsbrand = null;
  public String btsstyle = null;
  public String btsxflxdl = null;
  public String btsxflxzl = null;
  public String btsxflxxl = null;
  public String tsnr = null;
  public String slqk = null;
  public String bz = null;
  public String ktwhmc = null;
  public String lrrID = null;
  public String lrryj = null; /*登记机关的经办人意见*/
  public String djjgjdyyj = null; /*登记机关的监督员人意见*/
  public String djjghzryj = null; /*登记机关的负责人意见*/
  public String djjgjzyj = null; /*登记机关的局长意见*/
  public String zbdwjdyyj = null; /*转办单位的监督员意见*/
  public String zbdwhzryj = null; /*转办单位的负责人意见*/
  public String zbdwjzyj = null; /*转办单位的局长意见*/
  public String cl_result = null;/*处理结果*/
  public String anly = null;/*案件来源 0:上级交办;1:转办;2:其它*/
  public String return_reason = null;/*退回意见*/
  public String zb_path = null;/*转办路径*/

  public String hfr = null;/*回访人*/
  public String hfsj = null;/*回访时间*/
  public String hfjg = null;/*回访结果:1:满意2：不满意*/


  public String final_clbz = null;

  private boolean bInserted = false;
  private String s_IDPrex = null;
  private static Object propertyLock = new Object();

  public Dbdjnr(String s_djbh) {
    djbh = s_djbh;
    loadDb();
  }

  public Dbdjnr(String s_djjg, String s_djsj) {
    djjg = s_djjg;
    tsrq = s_djsj;
    s_IDPrex = s_djjg + s_djsj.replaceAll("-", "");
    System.out.println("s_IDPrex=" + s_IDPrex);
  }

  public static String createID(String prex) {
    String s_id = null;
    String s_maxDjbh = null;
    String s_pex = "0000000";
    synchronized (propertyLock) {
      Connection con = null;
      PreparedStatement pstmt = null;
      try {
        con = DbConnectionManager.getConnection();
        pstmt = con.prepareStatement(Create_NR_ID);
        pstmt.setString(1, prex);

        ResultSet rs = pstmt.executeQuery();
        if (rs.next()) {
          s_maxDjbh = rs.getString(1);
        }
        if (s_maxDjbh == null) {
          s_maxDjbh = prex + s_pex;
        }
        if (s_maxDjbh != null) {
          s_maxDjbh = s_maxDjbh.trim();
          String s_sub = s_maxDjbh.substring(prex.length(), s_maxDjbh.length());
          int i_sub = Integer.parseInt(s_sub);
          i_sub = i_sub + 1;
          s_sub = i_sub + "";
          s_sub = s_pex.substring(0, s_pex.length() - s_sub.length()) + s_sub;
          s_id = prex + s_sub;
        }
      }
      catch (Exception sqle) {}
      finally {
        try {
          pstmt.close();
        }
        catch (Exception e) {
          e.printStackTrace();
        }
        try {
          con.close();
        }
        catch (Exception e) {
          e.printStackTrace();
        }
      }
    }

    return s_id;
  }

  public void inserDB() throws Exception {
    if (djbh == null && s_IDPrex != null) {
      djbh = createID(s_IDPrex);
    }
    else if (djbh == null && s_IDPrex == null) {
      throw new Exception("创建编号失败");
    }
    System.out.println("djbh=" + djbh);
    Connection con = null;
    PreparedStatement pstmt = null;
    try {
      con = DbConnectionManager.getConnection();
      pstmt = con.prepareStatement(INSERT_NR);
      pstmt.setString(1, djbh);
      pstmt.setString(2, djjg);
      pstmt.setString(3, gxdw);
      pstmt.setString(4, cldw);
      pstmt.setString(5, clr);
      pstmt.setString(6, tslx);
      pstmt.setString(7, lrr);
      pstmt.setString(8, clbz);
      pstmt.setString(9, tsly);
      pstmt.setString(10, tslybm);
      pstmt.setString(11, tslylxr);
      pstmt.setString(12, tslylxdh);
      pstmt.setString(13, tsrmc);
      pstmt.setString(14, tsrq);
      pstmt.setString(15, tssj);
      pstmt.setString(16, tsfs);
      pstmt.setString(17, tsrdh);
      pstmt.setString(18, tsrdz);
      pstmt.setString(19, tsrem);
      pstmt.setString(20, tsyzbm);
      pstmt.setString(21, tslxr);
      pstmt.setString(22, btsdw);
      pstmt.setString(23, btsdwdz);
      pstmt.setString(24, btsdwdh);
      pstmt.setString(25, btsdwlxr);
      pstmt.setString(26, btsdwlxrdh);
      pstmt.setString(27, btsdwyzbm);
      pstmt.setString(28, btspart);
      pstmt.setString(29, btsbrand);
      pstmt.setString(30, btsstyle);
      pstmt.setString(31, btsxflxdl);
      pstmt.setString(32, btsxflxzl);
      pstmt.setString(33, btsxflxxl);
      pstmt.setString(34, tsnr);
      pstmt.setString(35, slqk);
      pstmt.setString(36, bz);
      pstmt.setString(37, ktwhmc);
      pstmt.setString(38, lrrID);

      pstmt.setString(39, lrryj);
      pstmt.setString(40, djjgjdyyj);
      pstmt.setString(41, djjghzryj);
      pstmt.setString(42, djjgjzyj);
      pstmt.setString(43, zbdwjdyyj);
      pstmt.setString(44, zbdwhzryj);
      pstmt.setString(45, zbdwjzyj);
      pstmt.setString(46, cl_result);
      pstmt.setString(47, anly);
      pstmt.setString(48, return_reason);
      pstmt.setString(49, zb_path);
      pstmt.setString(50, final_clbz);

      pstmt.setString(51, hfr);
      pstmt.setString(52, hfsj);
      pstmt.setString(53, hfjg);


      pstmt.executeUpdate();
    }
    catch (Exception sqle) {
      sqle.printStackTrace();
      throw new Exception("创建内容失败");
    }
    finally {
      try {
        pstmt.close();
      }
      catch (Exception e) {
        e.printStackTrace();
      }
      try {
        con.close();
      }
      catch (Exception e) {
        e.printStackTrace();
      }
    }

  }

  public void saveDb() throws Exception {
    if (djbh == null) {
      inserDB();
      return;
    }
    if (!bInserted) {
      inserDB();
      return;
    }
    Connection con = null;
    PreparedStatement pstmt = null;
    try {
      con = DbConnectionManager.getConnection();
      pstmt = con.prepareStatement(SAVE_NR);
      pstmt.setString(1, djjg);
      pstmt.setString(2, gxdw);
      pstmt.setString(3, cldw);
      pstmt.setString(4, clr);
      pstmt.setString(5, tslx);
      pstmt.setString(6, lrr);
      pstmt.setString(7, clbz);
      pstmt.setString(8, tsly);
      pstmt.setString(9, tslybm);
      pstmt.setString(10, tslylxr);
      pstmt.setString(11, tslylxdh);
      pstmt.setString(12, tsrmc);
      pstmt.setString(13, tsrq);
      pstmt.setString(14, tssj);
      pstmt.setString(15, tsfs);
      pstmt.setString(16, tsrdh);
      pstmt.setString(17, tsrdz);
      pstmt.setString(18, tsrem);
      pstmt.setString(19, tsyzbm);
      pstmt.setString(20, tslxr);
      pstmt.setString(21, btsdw);
      pstmt.setString(22, btsdwdz);
      pstmt.setString(23, btsdwdh);
      pstmt.setString(24, btsdwlxr);
      pstmt.setString(25, btsdwlxrdh);
      pstmt.setString(26, btsdwyzbm);
      pstmt.setString(27, btspart);
      pstmt.setString(28, btsbrand);
      pstmt.setString(29, btsstyle);
      pstmt.setString(30, btsxflxdl);
      pstmt.setString(31, btsxflxzl);
      pstmt.setString(32, btsxflxxl);
      pstmt.setString(33, tsnr);
      pstmt.setString(34, slqk);
      pstmt.setString(35, bz);
      pstmt.setString(36, ktwhmc);
      pstmt.setString(37, lrrID);

      pstmt.setString(38, lrryj);
      pstmt.setString(39, djjgjdyyj);
      pstmt.setString(40, djjghzryj);
      pstmt.setString(41, djjgjzyj);
      pstmt.setString(42, zbdwjdyyj);
      pstmt.setString(43, zbdwhzryj);
      pstmt.setString(44, zbdwjzyj);
      pstmt.setString(45, cl_result);
      pstmt.setString(46, anly);
      pstmt.setString(47, return_reason);
      pstmt.setString(48, zb_path);
      pstmt.setString(49, final_clbz);

      pstmt.setString(50, hfr);
      pstmt.setString(51, hfsj);
      pstmt.setString(52, hfjg);

      pstmt.setString(53, djbh);

      pstmt.executeUpdate();
    }
    catch (SQLException sqle) {
      throw new Exception("编辑内容失败");
    }
    finally {
      try {
        pstmt.close();
      }
      catch (Exception e) {
        e.printStackTrace();
      }
      try {
        con.close();
      }
      catch (Exception e) {
        e.printStackTrace();
      }
    }
  }

  public void loadDb() {

    Connection con = null;
    PreparedStatement pstmt = null;
    try {
      con = DbConnectionManager.getConnection();
      pstmt = con.prepareStatement(LOAD_NR_BY_BH);
      pstmt.setString(1, djbh);
      ResultSet rs = pstmt.executeQuery();
      if (rs.next()) {
        bInserted = true;
        djbh = rs.getString("djbh");
        djjg = rs.getString("djjg");
        if(djjg!=null)
          djjg = djjg.trim();
        gxdw = rs.getString("gxdw");
        if(gxdw!=null)
          gxdw = gxdw.trim();
        cldw = rs.getString("cldw");
        if(cldw!=null)
          cldw = cldw.trim();
        clr = rs.getString("clr");
        tslx = rs.getString("tslx");
        lrr = rs.getString("lrr");

        clbz = rs.getString("clbz");
        tsly = rs.getString("tsly");
        tslybm = rs.getString("tslybm");
        tslylxr = rs.getString("tslylxr");
        tslylxdh = rs.getString("tslylxdh");
        tsrmc = rs.getString("tsrmc");
        tsrq = rs.getString("tsrq");
        tssj = rs.getString("tssj");
        tsfs = rs.getString("tsfs");
        tsrdh = rs.getString("tsrdh");
        tsrdz = rs.getString("tsrdz");
        tsrem = rs.getString("tsrem");
        tsyzbm = rs.getString("tsyzbm");
        tslxr = rs.getString("tslxr");
        btsdw = rs.getString("btsdw");
        btsdwdz = rs.getString("btsdwdz");
        btsdwdh = rs.getString("btsdwdh");
        btsdwlxr = rs.getString("btsdwlxr");
        btsdwlxrdh = rs.getString("btsdwlxrdh");
        btsdwyzbm = rs.getString("btsdwyzbm");
        btspart = rs.getString("btspart");
        btsbrand = rs.getString("btsbrand");
        btsstyle = rs.getString("btsstyle");
        btsxflxdl = rs.getString("btsxflxdl");
        btsxflxzl = rs.getString("btsxflxzl");
        btsxflxxl = rs.getString("btsxflxxl");
        tsnr = rs.getString("tsnr");
        slqk = rs.getString("slqk");
        bz = rs.getString("bz");
        ktwhmc = rs.getString("ktwhmc");

        lrrID = rs.getString("lrrID");
        if(lrrID!=null)
          lrrID = lrrID.trim();
        lrryj = rs.getString("lrryj");
        djjgjdyyj = rs.getString("djjgjdyyj");
        djjghzryj = rs.getString("djjghzryj");
        djjgjzyj = rs.getString("djjgjzyj");
        zbdwjdyyj = rs.getString("zbdwjdyyj");
        zbdwhzryj = rs.getString("zbdwhzryj");
        zbdwjzyj = rs.getString("zbdwjzyj");
        cl_result = rs.getString("cl_result");

        anly = rs.getString("anly");
        return_reason = rs.getString("return_reason");
        zb_path = rs.getString("zb_path");
        final_clbz = rs.getString("final_clbz");


        hfr = rs.getString("hfr");
        hfsj = rs.getString("hfsj");
        hfjg = rs.getString("hfjg");

   //     System.out.println("lrr="+lrr+";lrrID="+lrrID);
      }
      else {
        bInserted = false;
      }

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

  }

  public void isInserted() {
    if (djbh == null)