dbwlwz.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 Dbwlwz {
  private final static String Insert_DB =
      "INSERT INTO u_wlwz values(?,?,?,?,?,?,?) ";
  private final static String Update_DB =
      "UPDATE u_wlwz set dw=?,sl=?,jz=? where ajbh=? and djjg=? and rq=? and pm=?";
  private final static String Delete_DB =
      "delete from u_wlwz where ajbh=? and djjg=? and rq=? and pm=?";
  private final static String Load_DB =
      "select dw,sl,jz  from u_wlwz where ajbh=? and djjg=? and rq=? and pm=?";
  public String ajbh;
  public String djjg;
  public String rq;
  public String pm;
  public String dw;
  public String sl;
  public String jz;
  public Dbwlwz(String bh, String jg, String dt, String mc,String v1,String v2,String v3) {
   ajbh = bh;
   djjg = jg;
   rq = dt;
   pm = mc;
   dw = v1;
   sl = v2;
   jz = v3;

 }
  public Dbwlwz(String bh, String jg, String dt, String mc) {
    ajbh = bh;
    djjg = jg;
    rq = dt;
    pm = mc;
    dw = null;
    sl = null;
    jz = null;
    load();
  }
  public Dbwlwz(String bh, String jg, String dt, String mc,boolean bInsert) {
    ajbh = bh;
    djjg = jg;
    rq = dt;
    pm = mc;
    dw = null;
    sl = null;
    jz = null;
    if (bInsert)
      insert();
  }


  private void insert() {
    Connection con = null;
    PreparedStatement pstmt = null;
    try {
      con = DbConnectionManager.getConnection();
      pstmt = con.prepareStatement(Insert_DB);
      pstmt.setString(1, ajbh);
      pstmt.setString(2, djjg);
      pstmt.setString(3, rq);
      pstmt.setString(4, pm);
      pstmt.setString(5, dw);
      pstmt.setString(6, sl);
      pstmt.setString(7, jz);
      pstmt.executeUpdate();
    }
    catch (Exception e) {}
    finally {
      try {
        pstmt.close();
      }
      catch (Exception e) {
        e.printStackTrace();
      }
      try {
        con.close();
      }
      catch (Exception e) {
        e.printStackTrace();
      }
    }

  }

  public void save() {
    Connection con = null;
    PreparedStatement pstmt = null;
    try {
      con = DbConnectionManager.getConnection();
      pstmt = con.prepareStatement(Update_DB);

      pstmt.setString(1, dw);
      pstmt.setString(2, sl);
      pstmt.setString(3, jz);
      pstmt.setString(4, ajbh);
      pstmt.setString(5, djjg);
      pstmt.setString(6, rq);
      pstmt.setString(7, pm);
      pstmt.executeUpdate();
    }
    catch (Exception e) {}
    finally {
      try {
        pstmt.close();
      }
      catch (Exception e) {
        e.printStackTrace();
      }
      try {
        con.close();
      }
      catch (Exception e) {
        e.printStackTrace();
      }
    }

  }
  private void load() {
    Connection con = null;
    PreparedStatement pstmt = null;
    try {
      con = DbConnectionManager.getConnection();
      pstmt = con.prepareStatement(Load_DB);
      pstmt.setString(1, ajbh);
      pstmt.setString(2, djjg);
      pstmt.setString(3, rq);
      pstmt.setString(4, pm);
      ResultSet rs = pstmt.executeQuery();
      if (rs.next()) {
        dw = rs.getString("dw");
        sl = rs.getString("sl");
        jz = rs.getString("jz");
      }
    }
    catch (Exception e) {}
    finally {
      try {
        pstmt.close();
      }
      catch (Exception e) {
        e.printStackTrace();
      }
      try {
        con.close();
      }
      catch (Exception e) {
        e.printStackTrace();
      }
    }

  }


  public void setajbh(String v) {
    ajbh = v;
  }

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

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

  public void setpm(String v) {
    pm = v;
  }

  public void setdw(String v) {
    dw = v;
  }

  public void setsl(String v) {
    sl = v;
  }

  public void setjz(String v) {
    jz = v;
  }

  public String getajbh() {
    return ajbh;
  }

  public String getdjjg() {
    return djjg;
  }

  public String getrq() {
    return rq;
  }

  public String getpm() {
    return pm;
  }

  public String getdw() {
    return dw;
  }

  public String getsl() {
    return sl;
  }

  public String getjz() {
    return jz;
  }

}