getcodingtable.java

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

/**
 * GetCodingTable.java       07/01/2002,
 * Author:
 *
 * Copyright (c) 2002 Censoft Corp.
 * Beijing China
 * All rights reserved.
 *
 * Modifier:
 * Time:
 ***/

package com.gs.util;

import java.sql.*;
import java.util.*;
import com.gs.component.enterprise.model.*;

public class GetCodingTable{
    /**
     * 获取个体开业类别
     * @ ArrayList 类型编码表
     * add by chen danyu 2004-03-24
     */
    public static ArrayList getCodingGtkylb(){
        String sql = "select * from a_bm_gtkylb order by bm";
        return getCoding(sql);
    }
    /**
     * 冠名省市
     * @ArrayList 类型编码表
     * add by Jamie 2004-06-24
     */
    public static ArrayList getCodingGmss(){
        String sql = "select coding,mcjc from GSSHARE_CODING_REGISTERORG where coding like '%00' and coding not like '%0000' order by coding";
        return getCoding(sql);
    }
    /**
     * 冠名市县
     * @ArrayList 类型编码表
     * add by Jamie 2004-06-24
     */
    public static ArrayList getCodingGmsx(){
       String sql="select coding,mcjc from GSSHARE_CODING_REGISTERORG where not coding like '%00' order by coding";
       return getCoding(sql);
   }

   /**
    * 冠名机关
    * @ArrayList 类型编码表
    * add by Jamie 2004-06-25
    */
   public static String getCodingGmjg(String coding){
       String sql = "select coding,mcjc from GSSHARE_CODING_REGISTERORG where coding = '" + coding + "' order by coding";
       String resultStr = null;
       EnterpriseCoding eCode = null;
       ArrayList al = getCoding(sql);
       if(al.size()>0){
           eCode = (EnterpriseCoding) al.get(0);
           resultStr = eCode.getContent();
       }
       return resultStr;
   }


    /**
     * 获取个体开业类别
     * @ ArrayList 类型编码表
     * add by 谢德金 2004-05-13
     */
    public static ArrayList getCodingGmlx(){
        String sql = "select * from a_bm_gmlx order by bm";
        return getCoding(sql);
    }

    public static String getCodingGmlx(String bm){
        String sql = "select * from a_bm_gmlx where bm='" + bm + "'";
        String resultStr = null;
        EnterpriseCoding eCode = null;
        ArrayList al = getCoding(sql);
        if(0 < al.size()){
            eCode = (EnterpriseCoding) al.get(0);
            resultStr = eCode.getContent();
        }
        return resultStr;
    }

    /**
     *
     * @ ArrayList 获取个体开业类别
     *  add by chen danyu 2004-03-24
     */
    public static String getCodingGtkylb(String bm){
        String sql = "select * from a_bm_gtkylb where bm='" + bm + "' order by bm";
        String resultStr = null;
        EnterpriseCoding eCode = null;
        ArrayList al = getCoding(sql);
        if(0 < al.size()){
            eCode = (EnterpriseCoding) al.get(0);
            resultStr = eCode.getContent();
        }
        return resultStr;
    }

    //add usercbg 2004-02-20
    /**
     * 主体分类
     * @ ArrayList主体分类
     */
    public static String getCodingZTFL(String bm){
        String sql = "select * from a_bm_ztfl where bm='" + bm + "' order by bm";
        String resultStr = null;
        EnterpriseCoding eCode = null;
        ArrayList al = getCoding(sql);
        if(0 < al.size()){
            eCode = (EnterpriseCoding) al.get(0);
            resultStr = eCode.getContent();
        }
        return resultStr;
    }

    /**
     * 主体分类
     * @ ArrayList 主体分类
     */
    public static ArrayList getCodingZTFL(){
        String sql = "select * from a_bm_ZTFL order by bm";
        return getCoding(sql);
    }

    /**
     * 注销原因
     * @ ArrayList注销原因
     */
    public static String getCodingZXYY(String bm){
        String sql = "select * from a_bm_zxyy where bm='" + bm + "' order by bm";
        String resultStr = null;
        EnterpriseCoding eCode = null;
        ArrayList al = getCoding(sql);
        if(0 < al.size()){
            eCode = (EnterpriseCoding) al.get(0);
            resultStr = eCode.getContent();
        }
        return resultStr;
    }

    /**
     * 注销原因
     * @ ArrayList 注销原因
     */
    public static ArrayList getCodingZXYY(){
        String sql = "select * from a_bm_zxyy order by bm";
        return getCoding(sql);
    }

    /**
     * 注销原因
     * @ ArrayList注销原因
     */
    public static String getCodingGTZXYY(String bm){
        String sql = "select * from a_bm_gtzxyy where bm='" + bm + "' order by bm";
        String resultStr = null;
        EnterpriseCoding eCode = null;
        ArrayList al = getCoding(sql);
        if(0 < al.size()){
            eCode = (EnterpriseCoding) al.get(0);
            resultStr = eCode.getContent();
        }
        return resultStr;
    }

    /**
     * 注销原因
     * @ ArrayList 注销原因
     */
    public static ArrayList getCodingGTZXYY(){
        String sql = "select * from a_bm_gtzxyy order by bm";
        return getCoding(sql);
    }


    /**
    * 吊销原因
    * @ ArrayList吊销原因
    */
   public static String getCodingDXYY(String bm){
       String sql = "select * from a_bm_dxyy where bm='" + bm + "' order by bm";
       String resultStr = null;
       EnterpriseCoding eCode = null;
       ArrayList al = getCoding(sql);
       if(0 < al.size()){
           eCode = (EnterpriseCoding) al.get(0);
           resultStr = eCode.getContent();
       }
       return resultStr;
   }

   /**
    * 吊销原因
    * @ ArrayList 吊销原因
    */
   public static ArrayList getCodingDXYY(){
       String sql = "select * from a_bm_dxyy order by bm";
       return getCoding(sql);
   }


    /**
     * 地域编码
     * @ ArrayList地域编码
     */
    public static ArrayList getAreaCode(){
        String sql = "select * from " + TableNameUtil.GS_REGISTERORG + " order by coding";
        return getCoding(sql);
    }

    /**
     * 地域编码
     * @ string 地域编码
     */
    public static String getAreaCode(String coding){
        String sql = "select * from " + TableNameUtil.GS_REGISTERORG + " where coding like'" + coding + "' order by coding";
        String resultStr = null;
        EnterpriseCoding eCode = null;
        ArrayList al = getCoding(sql);
        if(0 < al.size()){
            eCode = (EnterpriseCoding) al.get(0);
            resultStr = eCode.getContent();
        }
        return resultStr;
    }

    /**
     * 经营范围规范
     * @param ArrayList 职务
     */
    public static HashMap getCodingJyfwgf(String bm){
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
        HashMap hm = new HashMap();
        ArrayList al;
        try{
            ArrayList sm = new ArrayList();
            ArrayList bh = new ArrayList();
            ArrayList bbh = new ArrayList();

            String sql = "select * from a_bm_jyfwgf where bm='" + bm + "' order by bm,fl,xh";
            conn = Common.getConnection();
            stmt = conn.createStatement();
            rs = stmt.executeQuery(sql);

            while(rs.next()){
                al = new ArrayList();
                al.add(rs.getString(1));
                al.add(rs.getString(2));
                al.add(rs.getString(3));
                al.add(rs.getString(4));

                if("0".equals(rs.getString(2))){
                    sm.add(al);
                }
                if("1".equals(rs.getString(2))){
                    bh.add(al);
                }
                if("2".equals(rs.getString(2))){
                    bbh.add(al);
                }
            }
            hm.put("0",sm);
            hm.put("1",bh);
            hm.put("2",bbh);
        } catch(Exception e){
            Debug.println("[GetCodingTable-->getCodingZhiwu]Error--" + e.getMessage());
        } finally{
            cleanup(rs,stmt,conn);
        }
        return hm;
    }

    /**
     * 职务
     * @ ArrayList 职务
     */
    public static ArrayList getCodingZhiwu(){
        String sql = "select * from dict_zw order by bm";
        return getCoding(sql);
    }

    /**
     * 职务
     * @ ArrayList 职务Msg
     */
    public static String getCodingZhiwu(String bm){
        String sql = "select * from dict_zw where bm='" + bm + "' order by bm";
        String resultStr = null;
        EnterpriseCoding eCode = null;
        ArrayList al = getCoding(sql);
        if(0 < al.size()){
            eCode = (EnterpriseCoding) al.get(0);
            resultStr = eCode.getContent();
        }
        return resultStr;
    }

    /**
     * 获取股东发起人名录备注编码
     * @ ArrayList 备注编码
     */
    public static ArrayList getCodingFrgdbz(){
        String sql = "select * from dict_frgdbz order by bm";
        return getCoding(sql);
    }

    /**
     * 获取股东发起人名录备注编码
     * @ ArrayList 备注编码Str
     */
    public static String getCodingFrgdbz(String bm){
        String sql = "select * from dict_frgdbz where bm='" + bm + "' order by bm";
        String resultStr = null;
        EnterpriseCoding eCode = null;
        ArrayList al = getCoding(sql);
        if(0 < al.size()){
            eCode = (EnterpriseCoding) al.get(0);
            resultStr = eCode.getContent();
        }
        return resultStr;
    }

    /**
   * 获取表达式查询字段编码
   * @ ArrayList 备注编码
   */
  public static ArrayList getCodingQueryFieldList(){
      String sql = "select tablename_sub||fieldname,explain from A_BM_QUERYFIELDLIST order by tablename";
      return getCoding(sql);
  }

  /**
   * 获取表达式查询字段编码
   * @ ArrayList
   */
  public static String getCodingQueryFieldList(String fieldname){
      String sql = "select tableneme_sub||fieldname,explain from A_BM_QUERYFIELDLIST where explain = '"+fieldname+"'  order by tablename";
      String resultStr = null;
      EnterpriseCoding eCode = null;
      ArrayList al = getCoding(sql);
      if(0 < al.size()){
          eCode = (EnterpriseCoding) al.get(0);
          resultStr = eCode.getContent();
      }
      return resultStr;
  }

  /**
  * 获取表达式查询字段编码
  * @ ArrayList 备注编码
  */
  public static ArrayList getCodingOrerator(){
   String sql = "select * from DICT_ORERATOR order by coding";
   return getCoding(sql);
  }

  /**
  * 获取表达式查询字段编码
  * @ ArrayList
  */
  public static String getCodingOrerator(String bm){
   String sql = "select * from DICT_ORERATOR where coding = '"+bm+"' order by bm";
   String resultStr = null;
   EnterpriseCoding eCode = null;
   ArrayList al = getCoding(sql);
   if(0 < al.size()){
       eCode = (EnterpriseCoding) al.get(0);
       resultStr = eCode.getContent();
   }
   return resultStr;
  }

    /**
     * 获取性别编码值
     * @ ArrayList 性别编码表
     */
    public static ArrayList getCodingSex(){
        String sql = "select * from dict_sex order by code";
        return getCoding(sql);
    }

    /**
     *
     * @ ArrayList 性别编码表
     */
    public static String getCodingSex(String bm){
        String sql = "select * from dict_sex where code='" + bm + "' order by code";
        String resultStr = null;
        EnterpriseCoding eCode = null;
        ArrayList al = getCoding(sql);
        if(0 < al.size()){
            eCode = (EnterpriseCoding) al.get(0);
            resultStr = eCode.getContent();
        }
        return resultStr;
    }

    /**
     * 获取年检发现问题备注事项类型编码表的值
     * @ ArrayList 类型编码表
     */
    public static ArrayList getCodingBgsx(){
        String sql = "select * from a_bm_bgsx order by bm";
        return getCoding(sql);
    }