getcodingtable.java

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

    /**
     *
     * @ ArrayList 获取年检发现问题备注事项类型编码表的值
     */
    public static String getCodingBgsx(String bm){
        String sql = "select * from a_bm_bgsx 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 getCodingCfjg(){
        String sql = "select * from a_bm_cfjg order by bm";
        return getCoding(sql,true);
    }

    /**
     *
     * @ ArrayList 获取年检处罚结果类型编码表的值
     */
    public static String getCodingCfjg(String bm){
        String sql = "select * from a_bm_cfjg 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 getCodingCfyy(){
        String sql = "select * from a_bm_cfyy order by bm";
        return getCoding(sql);
    }

    /**
     *
     * @ ArrayList 获取年检处罚原因类型编码表的值
     */
    public static String getCodingCfyy(String bm){
        String sql = "select * from a_bm_cfyy 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 getCodingMz(){
        String sql = "select * from b_bm_mz order by bm";
        return getCoding(sql);
    }

    /**
     *
     * @ ArrayList 获取民族类型编码表的值
     */
    public static String getCodingMz(String bm){
        String sql = "select * from b_bm_mz 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 getCodingGJ(){
        String sql = "select * from a_bm_gbdq order by bm";
        return getCoding(sql);
    }

    /**
     *
     * @ ArrayList 获取国家类型编码表的值
     */
    public static String getCodingGJ(String bm){
        String sql = "select * from a_bm_gbdq 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 getCodingZjbm(){
        String sql = "select * from a_bm_zjbm order by bm";
        return getCoding(sql);
    }

    /**
     *
     * @ ArrayList 获取证件类型编码表的值
     */
    public static String getCodingZjbm(String bm){
        String sql = "select * from a_bm_zjbm 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 getCodingCsfs(){
        String sql = "select * from a_bm_csfs order by bm";
        return getCoding(sql);
    }

    /**
     *
     * @ ArrayList 获取产生方式编码表的值
     */
    public static String getCodingCsfs(String bm){
        String sql = "select * from a_bm_csfs 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 getCodingRylx(){
        String sql = "select * from a_bm_rylx order by bm";
        return getCoding(sql);
    }

    /**
     *
     * @ ArrayList 获取人员类型编码表的值
     */
    public static String getCodingRylx(String bm){
        String sql = "select * from a_bm_rylx 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 getCodingWhcd(){
        String sql = "select * from a_bm_whcd order by bm";
        return getCoding(sql);
    }

    /**
     *
     * @ ArrayList 获取文化程度编码表的值
     */
    public static String getCodingWhcd(String bm){
        String sql = "select * from a_bm_whcd 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 getCodingShzw(){
        String sql = "select * from a_bm_shzw order by bm";
        return getCoding(sql);
    }

    /**
     *
     * @ ArrayList 获取社会职务编码表的值
     */
    public static String getCodingShzw(String bm){
        String sql = "select * from a_bm_shzw 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 getCodingQyzw(){
        String sql = "select * from a_bm_zqyzw order by bm";
        return getCoding(sql);
    }

    /**
     *
     * @ ArrayList 获取企业职务编码表的值
     */
    public static String getCodingQyzw(String bm){
        String sql = "select * from a_bm_zqyzw 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 getCodingJszc(){
        String sql = "select * from a_bm_jszc order by bm";
        return getCoding(sql);
    }

    /**
     *
     * @ ArrayList 获取职称职务编码表的值
     */
    public static String getCodingJszc(String bm){
        String sql = "select * from a_bm_jszc 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 getCodingZzmm(){
        String sql = "select * from b_bm_zzmm order by bm";
        return getCoding(sql);
    }

    /**
     *
     * @ ArrayList 获取政治面貌编码表的值
     */
    public static String getCodingZzmm(String bm){
        String sql = "select * from b_bm_zzmm 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 getCodingTzfxz(){
        String sql = "select * from dict_investor order by bm";
        return getCoding(sql);
    }

    /**
     * 获取企业类型编码表的值
     * @ ArrayList
     */
    public static String getCodingQYLX(String bm){
        String sql = "select * from gsgsjout_coding_economy where coding='" + bm + "' 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;
    }

    /**
     * 获取企业类型编码表的值
     * @return ArrayList
     * @author glt 2004-05-25
     */
    public static ArrayList getCodingQYLX(){
        return getCodingEconomy();
    }

    /**
     * 获取企业类型内容
     * @ ArrayList
     * edite usercbg 2004-02-05 22:54
     */
    public static ArrayList getCodingQYLXInfo(String bm) throws Exception{

        String sql = "select * from gsgsjout_coding_economy where coding='" + bm + "' order by coding";
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;

        ArrayList map = new ArrayList();
        try{
            conn = Common.getConnection();
            stmt = conn.createStatement();
            rs = stmt.executeQuery(sql);
            if(rs.next()){
                map.add(0,rs.getString(1));
                map.add(1,rs.getString(2));
                map.add(2,rs.getString(3));
                map.add(3,rs.getString(4));
                map.add(4,rs.getString(5));
                map.add(5,rs.getString(6));
            }
        } catch(Exception e){
            throw new Exception("访问编码表失败：" + e.getMessage());
        } finally{
            cleanup(rs,stmt,conn);
        }
        return map;
    }

    /**
     * 获取投资方性质编码表的值
     * @ ArrayList
     */
    public static String getCodingTzfxz(String bm){
        String sql = "select * from dict_investor 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 getCodingCzfs(){
        String sql = "select * from dict_czfs order by bm";
        return getCoding(sql);
    }

    /**
     * 获取出资方式编码表的值
     * @ ArrayList
     */
    public static String getCodingCzfs(String bm){
        String sql = "select * from dict_czfs where bm='" + bm + "' order by bm";