工具类使用Mapper

package com.sptit.isv.utils;

import com.sptit.isv.mapper.db1.TreeNameTableMapper;
import com.sptit.isv.pojo.db1.TreeNameTable;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;

import javax.annotation.PostConstruct;
import java.util.HashMap;
import java.util.Map;

@Component
public class TableInfoUtils {

    public static final String STRUCT = "struct";
    public static final String ASSET = "asset";

    @Autowired
    private TreeNameTableMapper tableMapper;

    private static TableInfoUtils tableInfoUtils;

    @PostConstruct
    public void init() {
        tableInfoUtils = this;
        tableInfoUtils.mapper = this.mapper;
    }

    /**
     * 获取表名前缀
     * @param id
     * @return
     */
    public static String getTableNameById(Integer id){
        TreeNameTable table = tableInfoUtils.tableMapper.getTableNameById(id);
        return table.getTableName();
    }

    /**
     * 获取表详情(版本号、展示表表名、展示评分表表名)
     * @param id
     * @param type
     * @return
     */
    public static Map<String, String>getTableInfo(Integer id, String type){
        Map<String, String> map = new HashMap<>();
        TreeNameTable table = tableInfoUtils.tableMapper.getTableNameById(id);
        // 业务系统的版本号
        map.put("treeVersionId", table.getTreeVersionId() + "");
        if (STRUCT.equals(type)){
            // 结构展示表表名
            map.put("tableName", table.getTableName() + StateParameter.GRADE_SUFFIX);
            // 结构展示评分表表名
            map.put("scoreTableName", table.getTableName() + StateParameter.GRADE_SCORE_SUFFIX);
        }
        if (ASSET.equals(type)){
            // 资产展示表表名
            map.put("tableName", table.getTableName() + StateParameter.ASSET_SUFFIX);
            // 资产展示评分表表名
            map.put("scoreTableName", table.getTableName() + StateParameter.ASSET_SCORE_SUFFIX);
        }
        return map;
    }

}
posted @ 2020-07-08 16:46  柒月廿三  阅读(59)  评论(0)    收藏  举报  来源