tablenameutil.java

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

package com.gs.util;

public class TableNameUtil{
    //内外关系表
    public static final String GSGSJINOUT_RELATION = "gsgsjinout_relation";

    //内网主表
    public static final String GSGSJIN_BASIS02 = "gsgsjin_basis02";

    //内网子表
    public static final String GSGSJIN_SUB02 = "gsgsjin_sub02";

    //注销内网主表
    public static final String GSGSJIN_ZHUXIAO = "GSGSJIN_ZHUXIAO";

    //注销内网子表
    public static final String GSGSJIN_ZHUXIAO_SUB = "GSGSJIN_ZHUXIAO_SUB";

    //补照内网主表
    public static final String GSGSJIN_BUZHAO = "GSGSJIN_BUZHAO";

    //补照内网子表
    public static final String GSGSJIN_BUZHAO_SUB = "GSGSJIN_BUZHAO_SUB";

    //内网子表增加删除记录信息表
    public static final String IN_SUB_INSDEL = "in_sub_insdel";

    //外网主表
    public static final String GSGSJOUT_BASIS01 = "gsgsjout_basis01";

    //外网子表
    public static final String GSGSJOUT_SUB01 = "gsgsjout_sub01";

    //内网年检主表lxh2003-11-14
    public static final String IN_YEARVALI = "in_yearvali";

    //内网年检子表lxh2003-11-14
    public static final String IN_YEARVALI_SUB = "in_yearvali_sub";

    //外网年检主表lxh2003-11-14
    public static final String OUT_YEARVALI = "out_yearvali";

    //外网年检子表lxh2003-11-14
    public static final String OUT_YEARVALI_SUB = "out_yearvali_sub";

    //快速年检表lxh2004-1-7
    public static final String FAST_YEARVALI = "fast_yearvali";

    //变更字段
    public static final String CHANGE_ITEM = "change_item";

    //参数表
    public static final String GS_DICT_PARAMETER = "gs_dict_parameter";

    public static final String GSGSJOUT_COMMUNION = "gsgsjout_communion";

    //外网页面定义
    public static final String GSGSJOUT_CODING_PAGE = "gsgsjout_coding_page";

    //外网每个申请所需要控制显示的页面
    public static final String GSGSJOUT_CODING_PAGE_USING = "gsgsjout_coding_page_using";

    //存储外网变化记录
    public static final String OUT_CHANGE = "out_change";

    //存储内网变化记录
    public static final String IN_CHANGE = "in_change";

    //申请业务填写记录
    public static String GSGSJOUT_INUPFLAG = "gsgsjout_inupflag";

    //业务表
    public static final String GSGSJOUT_BUSINESS = "gsgsjout_business";

    //业务表
    public static final String GS_APPROVE_CONTENT = "gs_approve_content";

    //注册号说明表
    public static final String GS_REGISTER = "GS_REGISTER";

    //注册号顺序号表
    public static final String GS_REGISTER_SN = "GS_REGISTER_SN_";

    //预查重名称库
    public static final String PRE_CHECKNAME = "PRE_CHECKNAME";

    //预查重名称库
    public static final String GS_PINYIN = "GS_PINYIN";

    //查重驰名商标库
    public static final String GS_TRADEMARK = "GS_TRADEMARK";
    //查重著名商标库
    public static final String GS_AREARIGHT = "GS_AREARIGHT";

    //业务附件表
    public static final String GS_BUSINESS_ACCESSORIES = "GS_BUSINESS_ACCESSORIES";

    //allen 最新数据库表名，以后程序的引用都要使用这个文件的定义 2003-07-23

    /*********************************功能点，角色，属性相关*****************************************/

    //功能点链接表
    public static final String UNIVERSAL_OPERATION_PAGELINK = "universal_operation_pagelink";

    //工作模式表
    public static final String UNIVERSAL_OPERATING = "universal_operating";

    //功能点表
    public static final String UNIVERSAL_OPERATION = "universal_operation";

    //角色表
    public static final String UNIVERSAL_ROLE = "universal_role";

    //属性表
    public static final String UNIVERSAL_PROPERTY = "universal_property";

    //属性表
    public static final String UNIVERSAL_ROLE_PROPERTY = "universal_role_property";

    //功能点，角色，属性对应表(业务定义表)
    public static final String UNIVERSAL_OPERATE_FLOW = "universal_operate_flow";

    //流程节点的下一步节点
    public static final String UNIVERSAL_PRIVI_NEXT = "universal_privi_next";

    /****************************************用户相关**********************************************/

    //用户表
    public static final String UNIVERSAL_USER = "universal_user";

    //组表
    public static final String UNIVERSAL_GROUP = "universal_group";

    //组和用户对应表
    public static final String UNIVERSAL_GROUP_USER = "universal_group_user";

    //组拥有的权限表对应表
    public static final String UNIVERSAL_GROUP_PRIVILLEGE = "universal_group_privilege";

    /**************************************业务流程相关相关*********************************************/

    //审批进程表
    public static final String UNIVERSAL_APPROVE_PROCESS = "universal_approve_process";

    //审批动作表
    public static final String UNIVERSAL_APPROVE_ACTION = "universal_approve_action";

    //审批流程分支表
    public static final String UNIVERSAL_FLOW_BRANCH = "universal_flow_branch";

    /*******************************************视图**********************************************/

    //当前审批步骤
    public static final String V_CURRENT_PROCESS = "v_current_process";

    //当前审批步骤
    public static final String V_OPERATE_FLOW = "v_operate_flow";

    //用户和组
    public static final String V_GROUP_USER = "v_group_user";

    //用户的操作权限
    public static final String V_USER_OPERATE_PRIVI = "v_user_operate_privi";

    //用户拥有的流程权限
    public static final String V_USER_PRIVI = "v_user_privi";

    //审批流程中的下一步审批权限
    public static final String V_NEXT_PROCESS = "v_next_process";

    //流程状态
    public static final String V_PROPERTY_STATE = "v_property_state";

    /***************************************编码表**********************************************/
    //业务状态表
    public static final String UNIVERSAL_BUSINESS_STATE = "universal_business_state";

    //地域编码
    public static final String GS_REGISTERORG = "gsshare_coding_registerorg";

    //登记机关编码表
    public static final String DICT_DJJG = "a_bm_djjg";

    //性别编码
    public static final String UNIVERSAL_SEX = "universal_sex";

    //企业类型
    public static final String GSGSJOUT_CODING_ECONOMY = "gsgsjout_coding_economy";

    //山东登记机关表
    public static final String GSSHARE_CODING_REGISTERORG = "gsshare_coding_registerorg";

    /***************************************预警相关**********************************************/

    //预警数据表
    public static final String UNIVERSAL_WARN = "universal_warn";

    //预警定义表
    public static final String UNIVERSAL_WARN_DEFINE = "universal_warn_define";

    //预警BID-warnID对应表
    public static final String UNIVERSAL_WARN_BID = "universal_warn_bid";

    /***************************************页面生成相关**********************************************/

    //页面定义表
    public static final String UNIVERSAL_PAGE_DEFINE = "universal_page_define";

    //页面数据表
    public static final String UNIVERSAL_PAGEELEMENT_DEFINE = "universal_pageelement_define";

    //报表页记录表
    public static final String UNIVERSAL_REPORT = "universal_report";

    //报表数据表
    public static final String UNIVERSAL_REPORT_DATA = "universal_report_data";

    //报表公式表
    public static final String UNIVERSAL_REPORT_EXPRESSION = "universal_report_expression";

    /*************************************** 查询 **********************************************/
    //页面定义表
    //
    public static final String UNIVERSAL_QUERY_PAGEDEFINE = "UNIVERSAL_QUERY_PAGEDEFINE";
    //页面数据表
    public static final String UNIVERSAL_QUERY_DATA = "UNIVERSAL_QUERY_DATA";
    //页面字段表
    public static final String UNIVERSAL_QUERY_FIELD_DEFINE = "UNIVERSAL_QUERY_FIELD_DEFINE";

    /*************************************** 执照 **********************************************/
    //执照打印设置表
    public static final String UNIVERSAL_PRINTSET = "UNIVERSAL_PRINTSET";
    /*************************************** 序 列 **********************************************/
    //限期整改通知书编号
    public static final String XIANQIZHENGGAI_SEQ = "XIANQIZHENGGAI_SEQ";

    //限期整改通知书编号
    public static final String DANGCHANGCHUFA_SEQ = "DANGCHANGCHUFA_SEQ";

    //受理通知书编号
    public static final String ACCEPTNO_SEQ = "ACCEPTNO_SEQ";

    /*增加 glt 2004-04-06*/
    //注销通知书编号
    public static final String ZHUXIAO_SEQ = "ZHUXIAO_SEQ";
    /*增加 glt 2004-04-06*/

    //年检通知书编号
    public static final String NIANJIANSHOULI_SEQ = "NIANJIANSHOULI_SEQ";

    //名称核准受理顺序号
    public static final String MINGCHENGHEZHUN_SEQ = "MINGCHENGHEZHUN_SEQ";
    //注销期限表
    public static final String GSGSJ_DICT_PARAMETER = "GSGSJ_DICT_PARAMETER";
    //变更字段表111
    public static final String SUB_FIELD_CHANGE = "SUB_FIELD_CHANGE";
    //重复企业信息表BY LXH 2004-03-26
    public static final String DT_CHACHONG = "DT_CHACHONG";

    /*************************************** 网 员 **********************************************/

    public static final String NETACTOR_INFO = "NETACTOR_INFO";
    //end new 以下是暂用的表，没有迁移，暂不删除

    /*************************************** 编码表 **********************************************/

    public static final String A_BM_GBDQ = "A_BM_GBDQ"; //国家

    public static final String HK_BM_BFXZ = "HK_BM_BFXZ"; //帮扶组编码表

    //数据删除备份用字表
    public static final  String BACK_GSGSJOUT_BASIS01= "BACK_GSGSJOUT_BASIS01";
    public static final  String BACK_GSGSJOUT_SUB01= "BACK_GSGSJOUT_SUB01";
    public static final  String BACK_GSGSJIN_BASIS02= "BACK_GSGSJIN_BASIS02";
    public static final  String BACK_GSGSJIN_SUB02= "BACK_GSGSJIN_SUB02";
    public static final  String BACK_GSGSJOUT_INUPFLAG= "BACK_GSGSJOUT_INUPFLAG";
    public static final  String BACK_UNIVERSAL_APPROVE_PROCESS= "BACK_UNIVERSAL_APPROVE_PROCESS";
    public static final  String UNIVERSAL_DELETE_RECORD= "UNIVERSAL_DELETE_RECORD";

}