From da2a873cceac0df9bb4944754d3c1f34ec554047 Mon Sep 17 00:00:00 2001
From: huangzhen <867217663@qq.com>
Date: Tue, 19 Sep 2023 11:08:04 +0800
Subject: [PATCH] 解决Cause: java.sql.SQLSyntaxErrorException: Unknown column ‘search_value’ in ‘field list’报错问题
---
ruoyi-system/src/main/java/com/ruoyi/system/service/impl/SysOperateTypeServiceImpl.java | 23 +++++++++++++++++++----
1 files changed, 19 insertions(+), 4 deletions(-)
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/SysOperateTypeServiceImpl.java b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/SysOperateTypeServiceImpl.java
index d1de2a7..e04cd77 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/SysOperateTypeServiceImpl.java
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/SysOperateTypeServiceImpl.java
@@ -20,12 +20,14 @@
import com.ruoyi.system.mapper.SysOperateTypeMapper;
import com.ruoyi.system.mapper.SysRoleMapper;
import com.ruoyi.system.service.SysOperateTypeService;
+import org.apache.ibatis.logging.Log;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.util.CollectionUtils;
import javax.annotation.PostConstruct;
+import javax.annotation.Resource;
import java.time.LocalDateTime;
import java.util.ArrayList;
import java.util.HashMap;
@@ -45,21 +47,26 @@
@Autowired
private SysRoleMapper roleMapper;
+ @Resource
+ private RedisCache redisCache;
+
+
@PostConstruct
public void init()
{
loadingOperateTypeCache();
+
}
@Override
public void loadingOperateTypeCache() {
LambdaQueryWrapper<SysOperateType> wrapper = new LambdaQueryWrapper<>();
- wrapper.eq(SysOperateType::getDelFlag, DeleteStatusEnum.YES.getStatus());
+ wrapper.eq(SysOperateType::getDelFlag, DeleteStatusEnum.NO.getStatus());
List<SysOperateType> sysOperateTypes = operateTypeMapper.selectList(wrapper);
if (!CollectionUtils.isEmpty(sysOperateTypes)){
Map<Long, SysOperateTypeWholeNameBO> map = new HashMap<>();
for (SysOperateType sysOperateType : sysOperateTypes) {
- SysOperateTypeWholeNameBO nameBO = this.getOperateTypeWholeNameById(sysOperateType.getId());
+ SysOperateTypeWholeNameBO nameBO = this.operateTypeWholeNameCacheById(sysOperateType.getId());
map.put(sysOperateType.getId(),nameBO);
}
SpringUtils.getBean(RedisCache.class).setCacheObject(CacheConstants.SYS_OPERATE_TYPE_NAME_KEY, map);
@@ -302,8 +309,7 @@
return this.operateTypeMapper.updateById(sysOperateType);
}
- @Override
- public SysOperateTypeWholeNameBO getOperateTypeWholeNameById(Long id) {
+ private SysOperateTypeWholeNameBO operateTypeWholeNameCacheById(Long id){
SysOperateType sysOperateType = operateTypeMapper.selectOperateTypeById(id);
if (sysOperateType == null)
return null;
@@ -333,6 +339,15 @@
}
return bo;
}
+
+ @Override
+ public SysOperateTypeWholeNameBO getOperateTypeWholeNameById(Long id) {
+ Map<Long, SysOperateTypeWholeNameBO> map = redisCache.getCacheObject(CacheConstants.SYS_OPERATE_TYPE_NAME_KEY);
+ if (map != null){
+ return map.get(id);
+ }
+ return null;
+ }
//
///**
// * 递归列表
--
Gitblit v1.9.2