u_djnrbimp.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.Cacheable;
import com.gs.util.CacheSizes;
import java.sql.*;
import com.gs.util.*;
import java.util.ArrayList;
import java.lang.*;
import java.util.*;
import java.text.SimpleDateFormat;


public class U_djnrbImp {
  public static String dateFormat = "yyyy-MM-dd";
  private String djbh;
  private String djjg;
  private String gxdw;
  private String cldw;
  private String clr;
  private String tslx;
  private String lrr;
  private String lrrid;
  private String clbz;
  private String tsly;
  private String tslybm;
  private String tslylxr;
  private String tslylxdh;
  private String tsrmc;
  private java.util.Date tsrq;
  private String tssj;
  private String tsfs;
  private String tsrdh;
  private String tsrdz;
  private String tsrem;
  private String tsyzbm;
  private String tslxr;
  private String btsdw;
  private String btsdwdz;
  private String btsdwdh;
  private String btsdwlxr;
  private String btsdwlxrdh;
  private String btsdwyzbm;
  private String btspart;
  private String btsbrand;
  private String btsstyle;
  private String btsxflxdl;
  private String btsxflxzl;
  private String btsxflxxl;
  private String tsnr;
  private String slqk;
  private String bz;
  private String ktwhmc;
  private String lrryj;
  private String djjgjdyyj;
  private String djjghzryj;
  private String djjgjzyj;
  private String zbdwjdyyj;
  private String zbdwhzryj;
  private String zbdwjzyj;
  private String cl_result;
  private String anly;
  private String return_reason;
  private String zb_path;
  private String final_clbz;
  private String hfr;
  private java.util.Date hfsj;
  private String hfjg;

  boolean bSet = false;
  public U_djnrbImp() {
    bSet = false;
  }

  public boolean getBSet() {
    return bSet;
  }

  public void setBSet(boolean b) {
    bSet = b;
  }

  /**
   *
   * put,get
   */
  public void setdjbh(String param) {
    djbh = param;
  }

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

  public void setgxdw(String param) {
    gxdw = param;
  }

  public void setcldw(String param) {
    cldw = param;
  }

  public void setclr(String param) {
    clr = param;
  }

  public void settslx(String param) {
    tslx = param;
  }

  public void setlrr(String param) {
    lrr = param;
  }

  public void setlrrid(String param) {
    lrrid = param;
  }

  public void setclbz(String param) {
    clbz = param;
  }

  public void settsly(String param) {
    tsly = param;
  }

  public void settslybm(String param) {
    tslybm = param;
  }

  public void settslylxr(String param) {
    tslylxr = param;
  }

  public void settslylxdh(String param) {
    tslylxdh = param;
  }

  public void settsrmc(String param) {
    tsrmc = param;
  }

  public void settsrq(java.util.Date param) {
    tsrq = param;
  }

  public void settssj(String param) {
    tssj = param;
  }

  public void settsfs(String param) {
    tsfs = param;
  }

  public void settsrdh(String param) {
    tsrdh = param;
  }

  public void settsrdz(String param) {
    tsrdz = param;
  }

  public void settsrem(String param) {
    tsrem = param;
  }

  public void settsyzbm(String param) {
    tsyzbm = param;
  }

  public void settslxr(String param) {
    tslxr = param;
  }

  public void setbtsdw(String param) {
    btsdw = param;
  }

  public void setbtsdwdz(String param) {
    btsdwdz = param;
  }

  public void setbtsdwdh(String param) {
    btsdwdh = param;
  }

  public void setbtsdwlxr(String param) {
    btsdwlxr = param;
  }

  public void setbtsdwlxrdh(String param) {
    btsdwlxrdh = param;
  }

  public void setbtsdwyzbm(String param) {
    btsdwyzbm = param;
  }

  public void setbtspart(String param) {
    btspart = param;
  }

  public void setbtsbrand(String param) {
    btsbrand = param;
  }

  public void setbtsstyle(String param) {
    btsstyle = param;
  }

  public void setbtsxflxdl(String param) {
    btsxflxdl = param;
  }

  public void setbtsxflxzl(String param) {
    btsxflxzl = param;
  }

  public void setbtsxflxxl(String param) {
    btsxflxxl = param;
  }

  public void settsnr(String param) {
    tsnr = param;
  }

  public void setslqk(String param) {
    slqk = param;
  }

  public void setbz(String param) {
    bz = param;
  }

  public void setktwhmc(String param) {
    ktwhmc = param;
  }

  public void setlrryj(String param) {
    lrryj = param;
  }

  public void setdjjgjdyyj(String param) {
    djjgjdyyj = param;
  }

  public void setdjjghzryj(String param) {
    djjghzryj = param;
  }

  public void setdjjgjzyj(String param) {
    djjgjzyj = param;
  }

  public void setzbdwjdyyj(String param) {
    zbdwjdyyj = param;
  }

  public void setzbdwhzryj(String param) {
    zbdwhzryj = param;
  }

  public void setzbdwjzyj(String param) {
    zbdwjzyj = param;
  }

  public void setcl_result(String param) {
    cl_result = param;
  }

  public void setanly(String param) {
    anly = param;
  }

  public void setreturn_reason(String param) {
    return_reason = param;
  }

  public void setzb_path(String param) {
    zb_path = param;
  }

  public void setfinal_clbz(String param) {
    final_clbz = param;
  }

  public void sethfr(String param) {
    hfr = param;
  }

  public void sethfsj(java.util.Date param) {
    hfsj = param;
  }

  public void sethfjg(String param) {
    hfjg = param;
  }

  public String getdjbh() {
    return djbh;
  }

  public String getdjjg() {
    return djjg;
  }

  public String getgxdw() {
    return gxdw;
  }

  public String getcldw() {
    return cldw;
  }

  public String getclr() {
    return clr;
  }

  public String gettslx() {
    return tslx;
  }

  public String getlrr() {
    return lrr;
  }

  public String getlrrid() {
    return lrrid;
  }

  public String getclbz() {
    return clbz;
  }

  public String gettsly() {
    return tsly;
  }

  public String gettslybm() {
    return tslybm;
  }

  public String gettslylxr() {
    return tslylxr;
  }

  public String gettslylxdh() {
    return tslylxdh;
  }

  public String gettsrmc() {
    return tsrmc;
  }

  public java.util.Date gettsrq() {
    return tsrq;
  }

  public String gettssj() {
    return tssj;
  }

  public String gettsfs() {
    return tsfs;
  }

  public String gettsrdh() {
    return tsrdh;
  }

  public String gettsrdz() {
    return tsrdz;
  }

  public String gettsrem() {
    return tsrem;
  }

  public String gettsyzbm() {
    return tsyzbm;
  }

  public String gettslxr() {
    return tslxr;
  }

  public String getbtsdw() {
    return btsdw;
  }

  public String getbtsdwdz() {
    return btsdwdz;
  }

  public String getbtsdwdh() {
    return btsdwdh;
  }

  public String getbtsdwlxr() {
    return btsdwlxr;
  }

  public String getbtsdwlxrdh() {
    return btsdwlxrdh;
  }

  public String getbtsdwyzbm() {
    return btsdwyzbm;
  }

  public String getbtspart() {
    return btspart;
  }

  public String getbtsbrand() {
    return btsbrand;
  }

  public String getbtsstyle() {
    return btsstyle;
  }

  public String getbtsxflxdl() {
    return btsxflxdl;
  }

  public String getbtsxflxzl() {
    return btsxflxzl;
  }

  public String getbtsxflxxl() {
    return btsxflxxl;
  }

  public String gettsnr() {
    return tsnr;
  }

  public String getslqk() {
    return slqk;
  }

  public String getbz() {
    return bz;
  }

  public String getktwhmc() {
    return ktwhmc;
  }

  public String getlrryj() {
    return lrryj;
  }

  public String getdjjgjdyyj() {
    return djjgjdyyj;
  }

  public String getdjjghzryj() {
    return djjghzryj;
  }

  public String getdjjgjzyj() {
    return djjgjzyj;
  }

  public String getzbdwjdyyj() {
    return zbdwjdyyj;
  }

  public String getzbdwhzryj() {
    return zbdwhzryj;
  }

  public String getzbdwjzyj() {
    return zbdwjzyj;
  }

  public String getcl_result() {
    return cl_result;
  }

  public String getanly() {
    return anly;
  }

  public String getreturn_reason() {
    return return_reason;
  }

  public String getzb_path() {
    return zb_path;
  }

  public String getfinal_clbz() {
    return final_clbz;
  }

  public String gethfr() {
    return hfr;
  }

  public java.util.Date gethfsj() {
    return hfsj;
  }

  public String gethfjg() {
    return hfjg;
  }


  public ArrayList getUnFinishedList(String sql){
    ArrayList list = new ArrayList();
    Connection con = null;
    PreparedStatement pstmt = null;
    try {
      con = DbConnectionManager.getConnection();
      pstmt = con.prepareStatement(sql);
      ResultSet rs = pstmt.executeQuery();
      while (rs.next()) {
        U_djnrbImp obj = new U_djnrbImp();
        String djbh = rs.getString("djbh");
        String lrr = rs.getString("lrr");
        String tslx = rs.getString("tslx");
        String tsrmc = rs.getString("tsrmc");
        String btsdw = rs.getString("btsdw");
        String tsrq = rs.getString("tsrq");
        obj.setdjbh(djbh);
        obj.setlrr(lrr);
        obj.settslx(tslx);
        obj.settsrmc(tsrmc);
        obj.setbtsdw(btsdw);
        obj.settsrq(StringUtils.handleDate(tsrq,dateFormat));
        try{
          obj.setzb_path(rs.getString("zb_path"));
        }catch(Exception e){}
        try{
          obj.setclbz(rs.getString("clbz"));
        }catch(Exception e){}

        list.add(obj);
      }

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

    return list;
  }



}