dbspzl.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 Dbspzl {
  String djbh;
  String djjg;
  String rq;
  String splb;
  String cczs;
  String zlhg;
  String bsbhg1;
  String zlbhg;
  String bsbhg2;
  String jmfm;
  String xjzc;
  String jxdwzs;
  String jxdwshc;
  String jxdwcs;
  String jxdwsc;
  String jxdwjxdw;
  String jxdwsfgt;
  String jxdwgth;
  String jxdwqt;
  String jxdwhg;
  String sjscqyzs;
  String sjscqyhg;

  public Dbspzl() {
  }

  public Dbspzl(String djbh, String djjg, String rq, String splb, String cczs,
                String zlhg, String bsbhg1, String zlbhg, String bsbhg2,
                String jmfm, String xjzc, String jxdwzs, String jxdwshc,
                String jxdwcs, String jxdwsc, String jxdwjxdw, String jxdwsfgt,
                String jxdwgth, String jxdwqt, String jxdwhg, String sjscqyzs,
                String sjscqyhg) {
    this.djbh = djbh;
    this.djjg = djjg;
    this.rq = rq;
    this.splb = splb;
    this.cczs = cczs;
    this.zlhg = zlhg;
    this.bsbhg1 = bsbhg1;
    this.zlbhg = zlbhg;
    this.bsbhg2 = bsbhg2;
    this.jmfm = jmfm;
    this.xjzc = xjzc;
    this.jxdwzs = jxdwzs;
    this.jxdwshc = jxdwshc;
    this.jxdwcs = jxdwcs;
    this.jxdwsc = jxdwsc;
    this.jxdwjxdw = jxdwjxdw;
    this.jxdwsfgt = jxdwsfgt;
    this.jxdwgth = jxdwgth;
    this.jxdwqt = jxdwqt;
    this.jxdwhg = jxdwhg;
    this.sjscqyzs = sjscqyzs;
    this.sjscqyhg = sjscqyhg;

  }

  public String getdjbh() {
    return djbh;
  }

  public String getdjjg() {
    return djjg;
  }

  public String getrq() {
    return rq;
  }

  public String getsplb() {
    return splb;
  }

  public String getcczs() {
    return cczs;
  }

  public String getzlhg() {
    return zlhg;
  }

  public String getbsbhg1() {
    return bsbhg1;
  }

  public String getzlbhg() {
    return zlbhg;
  }

  public String getbsbhg2() {
    return bsbhg2;
  }

  public String getjmfm() {
    return jmfm;
  }

  public String getxjzc() {
    return xjzc;
  }

  public String getjxdwzs() {
    return jxdwzs;
  }

  public String getjxdwshc() {
    return jxdwshc;
  }

  public String getjxdwcs() {
    return jxdwcs;
  }

  public String getjxdwsc() {
    return jxdwsc;
  }

  public String getjxdwjxdw() {
    return jxdwjxdw;
  }

  public String getjxdwsfgt() {
    return jxdwsfgt;
  }

  public String getjxdwgth() {
    return jxdwgth;
  }

  public String getjxdwqt() {
    return jxdwqt;
  }

  public String getjxdwhg() {
    return jxdwhg;
  }

  public String getsjscqyzs() {
    return sjscqyzs;
  }

  public String getsjscqyhg() {
    return sjscqyhg;
  }

  public void setdjbh(String v) {
    djbh = v;
  }

  public void setdjjg(String v) {
    djjg = v;
  }

  public void setrq(String v) {
    rq = v;
  }

  public void setsplb(String v) {
    splb = v;
  }

  public void setcczs(String v) {
    cczs = v;
  }

  public void setzlhg(String v) {
    zlhg = v;
  }

  public void setbsbhg1(String v) {
    bsbhg1 = v;
  }

  public void setzlbhg(String v) {
    zlbhg = v;
  }

  public void setbsbhg2(String v) {
    bsbhg2 = v;
  }

  public void setjmfm(String v) {
    jmfm = v;
  }

  public void setxjzc(String v) {
    xjzc = v;
  }

  public void setjxdwzs(String v) {
    jxdwzs = v;
  }

  public void setjxdwshc(String v) {
    jxdwshc = v;
  }

  public void setjxdwcs(String v) {
    jxdwcs = v;
  }

  public void setjxdwsc(String v) {
    jxdwsc = v;
  }

  public void setjxdwjxdw(String v) {
    jxdwjxdw = v;
  }

  public void setjxdwsfgt(String v) {
    jxdwsfgt = v;
  }

  public void setjxdwgth(String v) {
    jxdwgth = v;
  }

  public void setjxdwqt(String v) {
    jxdwqt = v;
  }

  public void setjxdwhg(String v) {
    jxdwhg = v;
  }

  public void setsjscqyzs(String v) {
    sjscqyzs = v;
  }

  public void setsjscqyhg(String v) {
    sjscqyhg = v;
  }

  private final static String update_spzl =
      "update u_spzlsccc set cczs=?,zlhg=?,bsbhg1=?,zlbhg=?,bsbhg2=?,jmfm=?,xjzc=?,"
      +
      "jxdwzs=?,jxdwshc=?,jxdwcs=?,jxdwsc=?,jxdwjxdw=?,jxdwsfgt=?,jxdwgth=?,jxdwqt=?,"
      + "jxdwhg=?,sjscqyzs=?,sjscqyhg=?  where djbh=? and djjg=? and rq=? and splb=?";

  public void save() {
    Connection con = null;
    PreparedStatement pstmt = null;
    try {
      con = DbConnectionManager.getConnection();
      pstmt = con.prepareStatement(update_spzl);
      pstmt.setString(1, splb);
      pstmt.setString(2, cczs);
      pstmt.setString(3, zlhg);
      pstmt.setString(4, bsbhg1);
      pstmt.setString(5, zlbhg);
      pstmt.setString(6, bsbhg2);
      pstmt.setString(7, jmfm);
      pstmt.setString(8, xjzc);
      pstmt.setString(9, jxdwzs);
      pstmt.setString(10, jxdwshc);
      pstmt.setString(11, jxdwcs);
      pstmt.setString(12, jxdwsc);
      pstmt.setString(13, jxdwjxdw);
      pstmt.setString(14, jxdwsfgt);
      pstmt.setString(15, jxdwgth);
      pstmt.setString(16, jxdwqt);
      pstmt.setString(17, jxdwhg);
      pstmt.setString(18, sjscqyzs);
      pstmt.setString(19, sjscqyhg);
      pstmt.setString(20, djbh);
      pstmt.setString(21, djjg);
      pstmt.setString(22, rq);
      pstmt.executeUpdate();
    }
    catch (Exception e) {}
    finally {
      try {
        pstmt.close();
      }
      catch (Exception e) {
        e.printStackTrace();
      }
      try {
        con.close();
      }
      catch (Exception e) {
        e.printStackTrace();
      }
    }

  }

}