目前該函數(shù)取多個(gè)值需要多次和數(shù)據(jù)庫(kù)交互,并且代碼相對(duì)冗余,特地將改進(jìn)后的代碼貢獻(xiàn)出來(lái)
/**
* 根據(jù)對(duì)象獲取配置(getValueByKey)
* @param merId 商戶id
* @param clazz 對(duì)象類
* @return Object
*/
@Override
public <T> T getConfigObj(Integer merId, Class<T> clazz) {
return getConfigObj(merId, 0, clazz);
}
/**
* 根據(jù)對(duì)象獲取配置(getValueByKey)
* @param merId 商戶id
* @param adminId 管理員id
* @param clazz 對(duì)象類
* @return Object
*/
@Override
public <T> T getConfigObj(Integer merId, Integer adminId, Class<T> clazz) {
//獲取對(duì)象屬性名稱
List<String> fieldNames = Arrays.stream(clazz.getDeclaredFields())
.filter(e->!e.getName().equals(serialVersionUID))
.map(Field::getName).collect(Collectors.toList());
//從數(shù)據(jù)庫(kù)查詢集合
LambdaQueryWrapper<SystemConfig> lqw = Wrappers.lambdaQuery();
lqw.select(SystemConfig::getName, SystemConfig::getValue);
lqw.eq(SystemConfig::getMerId, merId);
lqw.eq(SystemConfig::getAdminId, adminId);
lqw.eq(SystemConfig::getStatus, 0);
lqw.in(SystemConfig::getName, fieldNames);
List<SystemConfig> list = dao.selectList(lqw);
//將集合轉(zhuǎn)換成對(duì)象實(shí)體類
HashMap<String, Object> map = new HashMap<>();
list.forEach(e-> map.put(e.getName(), e.getValue()));
Object bean = BeanUtil.mapToBean(map, clazz, false, new CopyOptions());
return (T) bean;
}
/**
* 根據(jù)對(duì)象保存配置(updateOrSaveValueByName)
* @param merId 商戶id
* @param obj 對(duì)象
* @return Object
*/
@SneakyThrows
@Override
public Boolean setConfigObj(Integer merId, Object obj) {
return setConfigObj(merId, 0, obj);
}
/**
* 根據(jù)對(duì)象保存配置(updateOrSaveValueByName)
* @param merId 商戶id
* @param adminId 管理員id
* @param obj 對(duì)象
* @return Object
*/
@SneakyThrows
@Override
public Boolean setConfigObj(Integer merId, Integer adminId, Object obj) {
//獲取對(duì)象屬性名稱
List<String> fieldNames = Arrays.stream(obj.getClass().getDeclaredFields())
.filter(e->!e.getName().equals(serialVersionUID))
.map(Field::getName).collect(Collectors.toList());
//將對(duì)象屬性值轉(zhuǎn)換成Map
List<SystemConfig> configList = new ArrayList<>();
for (String fieldName : fieldNames) {
String firstLetter = fieldName.substring(0, 1).toUpperCase();
String getter = "get" + firstLetter + fieldName.substring(1);
Method method = obj.getClass().getMethod(getter, new Class[] {});
Object value = method.invoke(obj, new Object[] {});
SystemConfig systemConfig = getByName(merId, adminId, fieldName);
systemConfig.setValue(value.toString());
configList.add(systemConfig);
}
//批量保存和更新
return saveOrUpdateBatch(configList);
}
/**
* 獲取配置對(duì)象
* @param merId 商戶id
* @param adminId 管理員id
* @param name 配置名稱
*/
private SystemConfig getByName(Integer merId, Integer adminId, String name){
LambdaQueryWrapper<SystemConfig> lqw = Wrappers.lambdaQuery();
lqw.eq(SystemConfig::getName, name);
lqw.eq(SystemConfig::getMerId, merId);
lqw.eq(SystemConfig::getAdminId, adminId);
SystemConfig systemConfig = dao.selectOne(lqw);
return Optional.ofNullable(systemConfig).orElse(new SystemConfig().setName(name).setMerId(merId).setAdminId(adminId));
}
調(diào)用方法(SystemConfig表需新增adminId字段來(lái)區(qū)分不同商戶下管理員配置)
//直接從數(shù)據(jù)庫(kù)拉取字段映射到對(duì)象
ConfigInfoVo configInfoVo = systemConfigService.getConfigObj(admin.getMerId(), ConfigInfoVo.class);
ConfigInfoVo configInfoVo = systemConfigService.getConfigObj(admin.getMerId(), admin.getId(), ConfigInfoVo.class);
//直接將對(duì)象屬性保存到數(shù)據(jù)庫(kù)
systemConfigService.setConfigObj(admin.getMerId(), request);
systemConfigService.setConfigObj(admin.getMerId(), admin.getId(), request);