dbajdjmanager.java

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

package com.gs.db.dbimp;

import com.gs.db.*;
import com.gs.util.*;

import java.util.*;
import java.sql.*;


public class DbajdjManager {
  private final static String Insert_DB =
      "INSERT INTO u_wlwz values(?,?,?,?,?,?,?) ";
  private final static String get_wlwz_all =
      "select ajbh,djjg,rq,pm,dw,sl,jz from u_wlwz";
  private final static String get_wlwz_1 =
      "select pm,dw,sl,jz  from u_wlwz where ajbh=? and djjg=? and rq=?";
  private final static String get_wlwz_2 =
      "select pm,dw,sl,jz  from u_wlwz where ajbh=? and djjg=? and rq=? and pm=?";
  private final static String Delete_DB_1 =
      "delete from u_wlwz where ajbh=? and djjg=? and rq=? and pm=?";
  private final static String Delete_DB_2 =
      "delete from u_wlwz where ajbh=? and djjg=? and rq=? ";



  public DbajdjManager() {
  }
  public void deleteWlwz(String bh,String jg,String rq){
    Connection con = null;
    PreparedStatement pstmt = null;
    try{
      con = DbConnectionManager.getConnection();
      pstmt = con.prepareStatement(Delete_DB_2);
      pstmt.setString(1, bh);
      pstmt.setString(2, jg);
      pstmt.setString(3, rq);
      pstmt.executeUpdate();
    }catch(Exception e){}
    finally {
      try {
        pstmt.close();
      }
      catch (Exception e) {
        e.printStackTrace();
      }
      try {
        con.close();
      }
      catch (Exception e) {
        e.printStackTrace();
      }
    }
  }
  public void deleteWlwz(String bh,String jg,String rq,String pm){
    Connection con = null;
    PreparedStatement pstmt = null;
    try{
      con = DbConnectionManager.getConnection();
      pstmt = con.prepareStatement(Delete_DB_1);
      pstmt.setString(1, bh);
      pstmt.setString(2, jg);
      pstmt.setString(3, rq);
      pstmt.setString(4, pm);
      pstmt.executeUpdate();
    }catch(Exception e){}
    finally {
      try {
        pstmt.close();
      }
      catch (Exception e) {
        e.printStackTrace();
      }
      try {
        con.close();
      }
      catch (Exception e) {
        e.printStackTrace();
      }
    }
  }
  public Dbwlwz createWlwz(String bh,String jg,String rq,String pm){
    return new Dbwlwz(bh,jg,rq,pm,true);
  }
  public Dbwlwz createWlwz(String bh,String jg,String rq,String pm,String dw,String sl,String jz){
    Connection con = null;
    PreparedStatement pstmt = null;
    try {
      con = DbConnectionManager.getConnection();
      pstmt = con.prepareStatement(Insert_DB);
      pstmt.setString(1, bh);
      pstmt.setString(2, jg);
      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) {
      return null;
    }
    finally {
      try {
        pstmt.close();
      }
      catch (Exception e) {
        e.printStackTrace();
      }
      try {
        con.close();
      }
      catch (Exception e) {
        e.printStackTrace();
      }
    }

    return new Dbwlwz(bh,jg,rq,pm,dw,sl,jz);
  }



  public Dbwlwz getWlwz(String bh,String jg,String rq,String pm){
    Connection con = null;
    PreparedStatement pstmt = null;
    try{
      con = DbConnectionManager.getConnection();
      pstmt = con.prepareStatement(get_wlwz_2);
      pstmt.setString(1, bh);
      pstmt.setString(2, jg);
      pstmt.setString(3, rq);
      pstmt.setString(4, pm);
      ResultSet rs = pstmt.executeQuery();
      if(rs.next()){
        String dw = rs.getString("dw");
        String sl = rs.getString("sl");
        String jz = rs.getString("jz");
        return new Dbwlwz(bh,jg,rq,pm,dw,sl,jz);
      }

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

  }
  public ArrayList getWlwzList(String bh,String jg,String rq){
    ArrayList list = new ArrayList();
    Connection con = null;
    PreparedStatement pstmt = null;
    try{
      con = DbConnectionManager.getConnection();
      pstmt = con.prepareStatement(get_wlwz_1);
      pstmt.setString(1, bh);
      pstmt.setString(2, jg);
      pstmt.setString(3, rq);
      ResultSet rs = pstmt.executeQuery();
      while(rs.next()){
        String pm = rs.getString("pm");
        String dw = rs.getString("dw");
        String sl = rs.getString("sl");
        String jz = rs.getString("jz");
        list.add(new Dbwlwz(bh,jg,rq,pm,dw,sl,jz));
      }

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

    return list;
  }
  public ArrayList geAlltWlwzList(){
    ArrayList list = new ArrayList();
    Connection con = null;
    PreparedStatement pstmt = null;
    try{
      con = DbConnectionManager.getConnection();
      pstmt = con.prepareStatement(get_wlwz_all);
      ResultSet rs = pstmt.executeQuery();
      while(rs.next()){
        String bh = rs.getString("ajbh");
        String jg = rs.getString("djjg");
        String rq = rs.getString("rq");
        String pm = rs.getString("pm");
        String dw = rs.getString("dw");
        String sl = rs.getString("sl");
        String jz = rs.getString("jz");
        list.add(new Dbwlwz(bh,jg,rq,pm,dw,sl,jz));
      }

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

    return list;
  }


  private final static String get_spzl_all =
      "select djbh,djjg,rq,splb,cczs,zlhg,bsbhg1,zlbhg,bsbhg2,jmfm,xjzc,jxdwzs,jxdwshc,"
      +"jxdwcs,jxdwsc,jxdwjxdw,jxdwsfgt,jxdwgth,jxdwqt,jxdwhg,sjscqyzs,sjscqyhg  "
      +"from u_spzlsccc";
  private final static String Insert_spzl_DB =
      "INSERT INTO .u_spzlsccc values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ";
  private final static String get_spzl =
      "select djbh,djjg,rq,splb,cczs,zlhg,bsbhg1,zlbhg,bsbhg2,jmfm,xjzc,jxdwzs,jxdwshc,"
      +"jxdwcs,jxdwsc,jxdwjxdw,jxdwsfgt,jxdwgth,jxdwqt,jxdwhg,sjscqyzs,sjscqyhg  "
      +" from u_spzlsccc where djbh=? and djjg=? and rq=? and splb=?";
  private final static String Deletespzl =
      "delete from u_spzlsccc where ajbh=? and djjg=? and rq=? and splb=?";

  public Dbspzl createspzl(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){
    Connection con = null;
    PreparedStatement pstmt = null;
    try {
      con = DbConnectionManager.getConnection();
      pstmt = con.prepareStatement(Insert_spzl_DB);
      pstmt.setString(1,   djbh    );
      pstmt.setString(2, djjg);
      pstmt.setString(3, rq);
      pstmt.setString(4, splb);
      pstmt.setString(5, cczs);
      pstmt.setString(6, zlhg);
      pstmt.setString(7, bsbhg1);
      pstmt.setString(8, zlbhg);
      pstmt.setString(9, bsbhg2);
      pstmt.setString(10, jmfm);
      pstmt.setString(11, xjzc);
      pstmt.setString(12, jxdwzs);
      pstmt.setString(13, jxdwshc);
      pstmt.setString(14, jxdwcs);
      pstmt.setString(15, jxdwsc);
      pstmt.setString(16, jxdwjxdw);
      pstmt.setString(17, jxdwsfgt);
      pstmt.setString(18, jxdwgth);
      pstmt.setString(19, jxdwqt);
      pstmt.setString(20, jxdwhg);
      pstmt.setString(21, sjscqyzs);
      pstmt.setString(22, sjscqyhg);

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

    return new Dbspzl(djbh,djjg,rq,splb,cczs,zlhg,bsbhg1,zlbhg,bsbhg2,jmfm,xjzc,jxdwzs,jxdwshc,jxdwcs,jxdwsc,jxdwjxdw,jxdwsfgt,jxdwgth,jxdwqt,jxdwhg,sjscqyzs,sjscqyhg);
  }
  public Dbspzl getspzl(String bh,String jg,String rq,String lb){
    Connection con = null;
    PreparedStatement pstmt = null;
    try{
      con = DbConnectionManager.getConnection();
      pstmt = con.prepareStatement(get_spzl);
      pstmt.setString(1, bh);
      pstmt.setString(2, jg);
      pstmt.setString(3, rq);
      pstmt.setString(4, lb);
      ResultSet rs = pstmt.executeQuery();
      if(rs.next()){
        String splb = rs.getString("splb");
        String cczs = rs.getString("cczs");
        String zlhg = rs.getString("zlhg");
        String bsbhg1 = rs.getString("bsbhg1");
        String zlbhg = rs.getString("zlbhg");
        String bsbhg2 = rs.getString("bsbhg2");
        String jmfm = rs.getString("jmfm");
        String xjzc = rs.getString("xjzc");
        String jxdwzs = rs.getString("jxdwzs");
        String jxdwshc = rs.getString("jxdwshc");
        String jxdwcs = rs.getString("jxdwcs");
        String jxdwsc = rs.getString("jxdwsc");
        String jxdwjxdw = rs.getString("jxdwjxdw");
        String jxdwsfgt = rs.getString("jxdwsfgt");
        String jxdwgth = rs.getString("jxdwgth");
        String jxdwqt = rs.getString("jxdwqt");
        String jxdwhg = rs.getString("jxdwhg");
        String sjscqyzs = rs.getString("sjscqyzs");
        String sjscqyhg = rs.getString("sjscqyhg");
        return new Dbspzl(bh,jg,rq,splb,cczs,zlhg,bsbhg1,zlbhg,bsbhg2,jmfm,xjzc,jxdwzs,jxdwshc,jxdwcs,jxdwsc,jxdwjxdw,jxdwsfgt,jxdwgth,jxdwqt,jxdwhg,sjscqyzs,sjscqyhg);
     //   return new Dbwlwz(bh,jg,rq,pm,dw,sl,jz);
      }

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

  }
  public ArrayList geAlltSpzlList(){
    ArrayList list = new ArrayList();
    Connection con = null;
    PreparedStatement pstmt = null;
    try{
      con = DbConnectionManager.getConnection();
      pstmt = con.prepareStatement(get_spzl_all);
      ResultSet rs = pstmt.executeQuery();
      while(rs.next()){
        String bh = rs.getString("ajbh");
        String jg = rs.getString("djjg");
        String rq = rs.getString("rq");
        String splb = rs.getString("splb");
        String cczs = rs.getString("cczs");
        String zlhg = rs.getString("zlhg");
        String bsbhg1 = rs.getString("bsbhg1");
        String zlbhg = rs.getString("zlbhg");
        String bsbhg2 = rs.getString("bsbhg2");
        String jmfm = rs.getString("jmfm");
        String xjzc = rs.getString("xjzc");
        String jxdwzs = rs.getString("jxdwzs");
        String jxdwshc = rs.getString("jxdwshc");
        String jxdwcs = rs.getString("jxdwcs");
        String jxdwsc = rs.getString("jxdwsc");
        String jxdwjxdw = rs.getString("jxdwjxdw");
        String jxdwsfgt = rs.getString("jxdwsfgt");
        String jxdwgth = rs.getString("jxdwgth");
        String jxdwqt = rs.getString("jxdwqt");
        String jxdwhg = rs.getString("jxdwhg");
        String sjscqyzs = rs.getString("sjscqyzs");
        String sjscqyhg = rs.getString("sjscqyhg");
        list.add(new Dbspzl(bh,jg,rq,splb,cczs,zlhg,bsbhg1,zlbhg,bsbhg2,jmfm,xjzc,jxdwzs,jxdwshc,jxdwcs,jxdwsc,jxdwjxdw,jxdwsfgt,jxdwgth,jxdwqt,jxdwhg,sjscqyzs,sjscqyhg));
      }

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

    return list;
  }

  public void deleteSpzl(String bh,String jg,String rq,String lb){
    Connection con = null;
    PreparedStatement pstmt = null;
    try{
      con = DbConnectionManager.getConnection();
      pstmt = con.prepareStatement(Deletespzl);
      pstmt.setString(1, bh);
      pstmt.setString(2, jg);
      pstmt.setString(3, rq);
      pstmt.setString(4, lb);
      pstmt.executeUpdate();
    }catch(Exception e){}
    finally {
      try {
        pstmt.close();
      }
      catch (Exception e) {
        e.printStackTrace();
      }
      try {
        con.close();
      }
      catch (Exception e) {
        e.printStackTrace();
      }
    }
  }





}