表模型（tableModel）信息

说明

数据库表的富声明，包含:

  • tableDefine: 表定义；
  • orderColumns: 排序字段；
  • bizFieldsMap: 业务key识别，如：createTime，updateTime，queryList, searchKey, allColumn 等信息；
  • dicts: 数据字典项等信息；
  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <tableModel>
  3.   <tableDefine id='AcCommonExtInfo' cnname='扩展信息' dbTableName='ac_common_ext_info'>
  4.     <column dataName='id' columnName='id' cnname='id' columnType='INT' canBeNull='false' readonly='false' isPK='true' length='10' jspTag='TEXT' dictName='' comment='id' />
  5.     <column dataName='ownerType' columnName='owner_type' cnname='归属类型' columnType='INT' canBeNull='false' readonly='false' isPK='false' length='10' jspTag='SELECT' dictName='acCommonExtInfo_ownerType_DICT' comment='归属类型：1.系统，2.项目' />
  6.        <!-- 省略部分信息 -->
  7.     </tableDefine>
  8.   <orderColumns>
  9.     <orderColumn orderType='desc'>id</orderColumn>
  10.   </orderColumns>
  11.   <bizFieldsMap>
  12.     <bizFields key='createTime'>created</bizFields>
  13.     <bizFields key='updateTime'>modified</bizFields>
  14.     <bizFields key='queryList'>id,owner_type,owner_code,ext_key,ext_value,type,creator,operator,concurrent_version,data_version,status,modified</bizFields>
  15.     <bizFields key='addList'>id,owner_type,owner_code,ext_key,ext_value,type,creator,operator,concurrent_version,data_version,status</bizFields>
  16.     <bizFields key='updateList'>id,owner_type,owner_code,ext_key,ext_value,type,creator,operator,concurrent_version,data_version,status</bizFields>
  17.     <bizFields key='viewList'>id,owner_type,owner_code,ext_key,ext_value,type,creator,operator,concurrent_version,data_version,status,created,modified</bizFields>
  18.     <bizFields key='searchKey'>id,owner_type,type,status</bizFields>
  19.     <bizFields key='allColumn'>id,owner_type,owner_code,ext_key,ext_value,type,creator,operator,concurrent_version,data_version,status,created,modified</bizFields>
  20.   </bizFieldsMap>
  21.   <dicts>
  22.     <dict id='acCommonExtInfo_type_DICT' name='type字段的字典项'>
  23.       <option value='1' cssClass=''>文本</option>
  24.       <option value='2' cssClass=''>json</option>
  25.       <option value='3' cssClass=''>xml</option>
  26.       <option value='4' cssClass=''>properties</option>
  27.       <option value='5' cssClass=''>开关</option>
  28.     </dict>
  29.     <dict id='acCommonExtInfo_ownerType_DICT' name='owner_type字段的字典项'>
  30.       <option value='1' cssClass=''>系统</option>
  31.       <option value='2' cssClass=''>项目</option>
  32.     </dict>
  33.     <dict id='acCommonExtInfo_status_DICT' name='status字段的字典项'>
  34.       <option value='1' cssClass=''>有效</option>
  35.       <option value='-1' cssClass=''>无效</option>
  36.     </dict>
  37.   </dicts>
  38. </tableModel>
  41.     ...更多未展示...

主要的方法和功能请参看源码。

源码

  1. /**
  2.  * 表模型结构
  3.  * @author david
  4.  * @since 2018/12/12
  5.  */
  6. class TableModelVo {
  8.     /**
  9.      * table的表定义信息
  10.      */
  11.     TableDefineVo tableDefine;
  12.     /**
  13.      * 排序字段
  14.      */
  15.     List<OrderColumnVo> orderColumns;
  16.     /**
  17.      * 业务字段列表，以逗号分隔
  18.      */
  19.     Map<String, String> bizFieldsMap = new LinkedHashMap<String, String>();
  21.     /**
  22.      * 字段List, 转换为List，方便获取
  23.      */
  24.     Map<String, List<String>> fieldListMap = new HashMap<String, List<String>>();
  26.     /**
  27.      * 字典项map
  28.      */
  29.     Map<String, DictVo> dictMap;
  31.     /**
  32.      * 是否不在List中
  33.      * @param listName
  34.      * @param columnName
  35.      * @return
  36.      */
  37.     boolean isNotInList(String listName, String columnName) {
  38.         return !isInList(listName, columnName);
  39.     }
  41.     /**
  42.      * 是否在List中
  43.      * @param listName
  44.      * @param columnName
  45.      * @return
  46.      */
  47.     boolean isInList(String listName, String columnName) {
  48.         List<String> columnNameList = this.getColumnNameList(listName);
  49.         //如果为空，默认为TRUE
  50.         if (CollectionUtils.isEmpty(columnNameList)) {
  51.             return true;
  52.         }
  53.         return columnNameList.contains(columnName);
  54.     }
  56.     /**
  57.      * 根据listName获取list列表
  58.      * @param listName
  59.      * @return
  60.      */
  61.     List<String> getColumnNameList(String listName) {
  62.         if (fieldListMap.containsKey(listName)) {
  63.             return fieldListMap.get(listName);
  64.         } else {
  65.             return this.parseListStrAndPutIntoMap(listName);
  66.         }
  67.     }
  69.     /**
  70.      * 将字符串转换为List<String>便于之后contains校验，也可以转为Set
  71.      * @param listName
  72.      */
  73.     private List<String> parseListStrAndPutIntoMap(String listName) {
  74.         String listStr = bizFieldsMap.get(listName);
  75.         if (StringUtils.isEmpty(listStr)) {
  76.             listStr = bizFieldsMap.get(MoliCodeConstant.BIZ_FIELDS_KEY_ALLCOLUMN)
  77.         }
  78.         if (StringUtils.isEmpty(listStr)) {
  79.             return null;
  80.         }
  81.         String[] columnNameArr = listStr.split(",");
  82.         List<String> columnNameList = Arrays.asList(columnNameArr);
  83.         fieldListMap.put(listName, columnNameList);
  84.         return columnNameList;
  85.     }
  87.     /**
  88.      * 将字符串转换为List<String>便于之后contains校验，也可以转为Set
  89.      * @param listName
  90.      */
  91.     int listSize(String listName) {
  92.         List<String> columnNameList = this.getColumnNameList(listName)
  93.         //如果为空，默认为全部
  94.         if (CollectionUtils.isEmpty(columnNameList)) {
  95.             return 0;
  96.         }
  97.         return columnNameList.size();
  98.     }
  100.     /**
  101.      * 所有列表中是否包含tag
  102.      * @param tagName
  103.      * @return
  104.      */
  105.     boolean listContainsTag(String tagName) {
  106.         for (ColumnVo column : tableDefine.getColumns()) {
  107.             if (column.getJspTag().equalsIgnoreCase(tagName)) {
  108.                 return true;
  109.             }
  110.         }
  111.         return false;
  112.     }
  114.     /**
  115.      * 列表中是否包含tag
  116.      * @param listName
  117.      * @param tagName
  118.      * @return
  119.      */
  120.     boolean listContainsTag(String listName, String tagName) {
  121.         List<String> list = getColumnNameList(listName);
  122.         if (CollectionUtils.isEmpty(list)) {
  123.             return false;
  124.         }
  126.         for (ColumnVo column : tableDefine.getColumns()) {
  127.             if (list.contains(column.getColumnName()) && column.getJspTag().equalsIgnoreCase(tagName)) {
  128.                 return true;
  129.             }
  130.         }
  131.         return false;
  132.     }
  134.     /**
  135.      * 取消，直接通过key获取
  136.      * @return
  137.      */
  138.     @Deprecated
  139.     List<String> getSearchKeyList() {
  140.         return getColumnNameList(MoliCodeConstant.BIZ_FIELDS_KEY_SEARCHKEY);
  141.     }
  143.     /**
  144.      * 设置bizFields
  145.      * @param key
  146.      * @param bizFields
  147.      */
  148.     void putBizFields(String key, String bizFields) {
  149.         bizFieldsMap.put(key, bizFields);
  150.     }
  152.     /**
  153.      * 通过key 获取 bizFields
  154.      * @param key
  155.      */
  156.     String getBizFields(String key) {
  157.         return bizFieldsMap.get(key);
  158.     }
  160.     /**
  161.      * 获取创建时间字段
  162.      */
  163.     String getCreateTime() {
  164.         return bizFieldsMap.get(MoliCodeConstant.BIZ_FIELDS_KEY_CREATETIME)
  165.     }
  166.     /**
  167.      * 获取更新时间字段
  168.      */
  169.     String getUpdateTime() {
  170.         return bizFieldsMap.get(MoliCodeConstant.BIZ_FIELDS_KEY_UPDATETIME)
  171.     }
  172. }