springboot智慧社区管理系统(源码+数据库）04191

package com.project.demo.service.base; import com.alibaba.fastjson.JSON; import com.alibaba.fastjson.JSONArray; import com.alibaba.fastjson.JSONObject; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.project.demo.constant.FindConfig; import com.project.demo.dao.base.BaseMapper; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.transaction.annotation.Transactional; import javax.servlet.http.HttpServletRequest; import java.io.BufferedReader; import java.io.IOException; import java.io.UnsupportedEncodingException; import java.lang.reflect.ParameterizedType; import java.net.URLDecoder; import java.security.MessageDigest; import java.util.*; /** */ @Slf4j public class BaseService{ @Autowired private BaseMapper baseMapper; Class eClass = (Class)((ParameterizedType)getClass().getGenericSuperclass()).getActualTypeArguments()[0]; private final String table = humpToLine(eClass.getSimpleName()); public List selectBaseList(String select) { List> mapList = baseMapper.selectBaseList(select); List list = new ArrayList<>(); for (Map map:mapList) { list.add(JSON.parseObject(JSON.toJSONString(map),eClass)); } return list; } public List> selectMapBaseList(String select) { return baseMapper.selectBaseList(select); } public int selectBaseCount(String sql) { return baseMapper.selectBaseCount(sql); } public int deleteBaseSql(String sql) { return baseMapper.deleteBaseSql(sql); } public int updateBaseSql(String sql) { return baseMapper.updateBaseSql(sql); } public void insert(Map body){ E entity = JSON.parseObject(JSON.toJSONString(body),eClass); baseMapper.insert(entity); log.info("[{}] - 插入操作：{}",entity); } @Transactional public void update(Map query,Map config,Map body){ QueryWrapper wrapper = new QueryWrapper(); toWhereWrapper(query,"0".equals(config.get(FindConfig.LIKE)),wrapper); E entity = JSON.parseObject(JSON.toJSONString(body),eClass); baseMapper.update(entity,wrapper); log.info("[{}] - 更新操作：{}",entity); } public Map selectToPage(Map query,Map config){ Map map = new HashMap<>(); List list = baseMapper.selectBaseList(select(query, config)); map.put("list",list); map.put("count",baseMapper.selectBaseCount(count(query,config))); return map; } public Map selectToList(Map query,Map config){ Map map = new HashMap<>(); List> resultList = baseMapper.selectBaseList(selectGroupCount(query, config)); for (Map sub:resultList) { sub.put("0",sub.get("count")); sub.put("1",sub.get(config.get(FindConfig.GROUP_BY))); } map.put("list",resultList); return map; } public Integer selectSqlToInteger(String sql){ Integer value = baseMapper.selectBaseCount(sql); return value; } public Map selectBarGroup(Map query,Map config){ Map map = new HashMap<>(); List> resultList = baseMapper.selectBaseList(barGroup(query, config)); List list = new ArrayList(); for (Map resultMap:resultList) { List subList = new ArrayList(); for(String key:resultMap.keySet()){//keySet获取map集合key的集合 然后在遍历key即可 subList.add(resultMap.get(key)); } list.add(subList); } map.put("list",list); return map; } // public void barGroup(Map query,Map config,QueryWrapper wrapper){ // if (config.get(FindConfig.GROUP_BY) != null && !"".equals(config.get(FindConfig.GROUP_BY))){ // wrapper.select(config.get(FindConfig.GROUP_BY)); // if (config.get(FindConfig.FIELD) != null && !"".equals(config.get(FindConfig.FIELD))){ // String[] fieldList = config.get(FindConfig.FIELD).split(","); // for (int i=0;i query,Map config){ StringBuffer sql = new StringBuffer(" SELECT "); if (config.get(FindConfig.GROUP_BY) != null && !"".equals(config.get(FindConfig.GROUP_BY))){ sql.append(config.get(FindConfig.GROUP_BY)); if (config.get(FindConfig.FIELD) != null && !"".equals(config.get(FindConfig.FIELD))){ String[] fieldList = config.get(FindConfig.FIELD).split(","); for (int i=0;i query,Map config,QueryWrapper wrapper){ // wrapper.select("count(*) AS count_value",config.get(FindConfig.GROUP_BY)); // toWhereSql(query, "0".equals(config.get(FindConfig.LIKE)),wrapper); // if (config.get(FindConfig.GROUP_BY) != null && !"".equals(config.get(FindConfig.GROUP_BY))){ // wrapper.groupBy(config.get(FindConfig.GROUP_BY)); // } // log.info("[{}] - 查询操作，sql: {}",wrapper.getSqlSelect()); // } public String selectGroupCount(Map query,Map config){ StringBuffer sql = new StringBuffer("select COUNT(*) AS count, "); sql.append(config.get(FindConfig.GROUP_BY)).append(" "); sql.append("from ").append("`").append(table).append("` "); sql.append(toWhereSql(query, "0".equals(config.get(FindConfig.LIKE)),config.get(FindConfig.SQLHWERE))); if (config.get(FindConfig.GROUP_BY) != null && !"".equals(config.get(FindConfig.GROUP_BY))){ sql.append("group by ").append(config.get(FindConfig.GROUP_BY)).append(" "); } log.info("[{}] - 查询操作，sql: {}",table,sql); return sql.toString(); } // public void select(Map query,Map config,QueryWrapper wrapper){ // wrapper.select(config.get(FindConfig.FIELD) == null || "".equals(config.get(FindConfig.FIELD)) ? "*" : config.get(FindConfig.FIELD)); // toWhereSql(query, "0".equals(c