工具类使用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;
}
}
Talk is cheap. Show me the code.