基于javaweb的SpringBoot小区智慧园区管理系统(java+springboot+maven+vue+mybatis+jquery+mysql)

运行环境

Java≥8、MySQL≥5.7、Node.js≥14

开发工具

后端：eclipse/idea/myeclipse/sts等均可配置运行
前端：WebStorm/VSCode/HBuilderX等均可

❗没学过node.js的不要搞前后端分离项目

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

基于javaweb的SpringBoot小区智慧园区管理系统(java+springboot+maven+vue+mybatis+jquery+mysql)

项目介绍 本项目为后台管理系统，分为管理员与业主两种角色；
管理员主要功能包括： 首页、公告查询、轮播图、资源管理、园区咨询、咨询分类、系统用户、模块管理；

业主主要功能包括： 首页、公告查询、园区咨询、修改密码、投诉服务、报修管理、业主信息、房屋信息等；

            if (value instanceof String){
                sql.append("'").append(entry.getValue()).append("'").append(",");
            }else {
                sql.append(entry.getValue()).append(",");
            }
        }
        sql.deleteCharAt(sql.length() - 1);
        sql.append(")");
        log.info("[{}] - 插入操作：{}",table,sql);
        Query query = runCountSql(sql.toString());
        query.executeUpdate();
    }

    @Transactional
    public void update(Map<String,String> query,Map<String,String> config,Map<String,Object> body){
        StringBuffer sql = new StringBuffer("UPDATE ").append("`").append(table).append("`").append(" SET ");
        for (Map.Entry<String,Object> entry:body.entrySet()){
            Object value = entry.getValue();
            if (value instanceof String){
                sql.append("`"+humpToLine(entry.getKey())+"`").append("=").append("'").append(value).append("'").append(",");
            }else {
                sql.append("`"+humpToLine(entry.getKey())+"`").append("=").append(value).append(",");
            }

        }
        sql.deleteCharAt(sql.length()-1);
        sql.append(toWhereSql(query,"0".equals(config.get(FindConfig.LIKE)),config.get(FindConfig.SQLHWERE)));
//        sql.append(";");
        log.info("[{}] - 更新操作：{}",table,sql);
        Query query1 = runCountSql(sql.toString());
        query1.executeUpdate();
    }

    public Map<String,Object> selectToPage(Map<String,String> query,Map<String,String> config){
        Query select = select(query, config);
        Map<String,Object> map = new HashMap<>();
        map.put("list",select.getResultList());
        map.put("count",count(query,config).getSingleResult());
        return map;
    }

    public Map<String,Object> selectToList(Map<String,String> query,Map<String,String> config){
        Query select = selectGroupCount(query, config);
        Map<String,Object> map = new HashMap<>();
        map.put("list",select.getResultList());
        return map;
    }

    public Map<String,Object> selectBarGroup(Map<String,String> query,Map<String,String> config){
        Query select = barGroup(query, config);
        Map<String,Object> map = new HashMap<>();
        map.put("list",select.getResultList());
        return map;

        jsonObject.put("url", "/api/upload/" + fileName);
        return success(jsonObject);
    } catch (IOException e) {
        log.info("上传失败：{}", e.getMessage());
        log.error("e=={}", e);
    }
    return error(30000, "上传失败");
}

@PostMapping("/import_db")
public Map<String, Object> importDb(@RequestParam("file") MultipartFile file) throws IOException {
    service.importDb(file);
    return success(1);
}

@RequestMapping("/export_db")
public void exportDb(HttpServletRequest request, HttpServletResponse response) throws IOException {
    HSSFWorkbook sheets = service.exportDb(service.readQuery(request), service.readConfig(request));
    response.setContentType("application/octet-stream");
    response.setHeader("Content-disposition", "attachment;filename=employee.xls");
    response.flushBuffer();
    sheets.write(response.getOutputStream());
    sheets.close();
}

public Map<String, Object> success(Object o) {
    Map<String, Object> map = new HashMap<>();
    if (o == null) {
        map.put("result", null);
        return map;
    }
    if (o instanceof List) {
        if (((List) o).size() == 1) {
            o = ((List) o).get(0);
            map.put("result", o);
        } else {
            String jsonString = JSONObject.toJSONString(o);
            JSONArray objects = service.covertArray(JSONObject.parseArray(jsonString));
            map.put("result", objects);
        }
    } else if (o instanceof Integer || o instanceof String) {
        map.put("result", o);
    } else {
        String jsonString = JSONObject.toJSONString(o);
        JSONObject jsonObject = JSONObject.parseObject(jsonString);
        JSONObject j = service.covertObject(jsonObject);

 * @return
 */
@PostMapping("forget_password")
public Map<String, Object> forgetPassword(@RequestBody User form,HttpServletRequest request) {
    JSONObject ret = new JSONObject();
    String username = form.getUsername();
    String code = form.getCode();
    String password = form.getPassword();
    // 判断条件
    if(code == null || code.length() == 0){
        return error(30000, "验证码不能为空");
    }
    if(username == null || username.length() == 0){
        return error(30000, "用户名不能为空");
    }
    if(password == null || password.length() == 0){
        return error(30000, "密码不能为空");
    }

    // 查询用户
    Map<String, String> query = new HashMap<>();
    query.put("username",username);
    Query select = service.select(query, service.readConfig(request));
    List list = select.getResultList();
    if (list.size() > 0) {
        User o = (User) list.get(0);
        JSONObject query2 = new JSONObject();
        JSONObject form2 = new JSONObject();
        // 修改用户密码
        query2.put("user_id",o.getUserId());
        form2.put("password",service.encryption(password));
        service.update(query, service.readConfig(request), form2);
        return success(1);
    }
    return error(70000,"用户不存在");
}

/**
 * 登录
 * @param data
 * @param httpServletRequest
 * @return
 */
@PostMapping("login")
public Map<String, Object> login(@RequestBody Map<String, String> data, HttpServletRequest httpServletRequest) {
    log.info("[执行登录接口]");

/**
 *
 */
@Slf4j
public class BaseController<E, S extends BaseService<E>> {

    @Setter
    protected S service;


    @PostMapping("/add")
    @Transactional
    public Map<String, Object> add(HttpServletRequest request) throws IOException {
        service.insert(service.readBody(request.getReader()));
        return success(1);
    }

    @Transactional
    public Map<String, Object> addMap(Map<String, Object> map) {
        service.insert(map);
        return success(1);
    }

    @PostMapping("/set")
    @Transactional
    public Map<String, Object> set(HttpServletRequest request) throws IOException {
        service.update(service.readQuery(request), service.readConfig(request), service.readBody(request.getReader()));
        return success(1);
    }


    @RequestMapping(value = "/del")
    @Transactional
    public Map<String, Object> del(HttpServletRequest request) {
        service.delete(service.readQuery(request), service.readConfig(request));

    @PostMapping("/add")
    @Transactional
    public Map<String, Object> add(HttpServletRequest request) throws IOException {
        Map<String,Object> paramMap = service.readBody(request.getReader());
        this.addMap(paramMap);
        return success(1);
    }

}




/**
 * 业主用户：(OwnerUser)表控制层
 *
 */
@RestController
@RequestMapping("/owner_user")
public class OwnerUserController extends BaseController<OwnerUser, OwnerUserService> {

    /**
     * 业主用户对象
     */
    @Autowired
    public OwnerUserController(OwnerUserService service) {
        setService(service);
    }

public static String humpToLine(String str) {
    if (str == null) {
        return null;
    }
    // 将驼峰字符串转换成数组
    char[] charArray = str.toCharArray();
    StringBuilder buffer = new StringBuilder();
    //处理字符串
    for (int i = 0, l = charArray.length; i < l; i++) {
        if (charArray[i] >= 65 && charArray[i] <= 90) {
            buffer.append("_").append(charArray[i] += 32);
        } else {
            buffer.append(charArray[i]);
        }
    }
    String s = buffer.toString();
    if (s.startsWith("_")){
        return s.substring(1);
    }else {
        return s;
    }
}


public JSONObject covertObject(JSONObject object) {
    if (object == null) {
        return null;
    }
    JSONObject newObject = new JSONObject();
    Set<String> set = object.keySet();
    for (String key : set) {
        Object value = object.get(key);
        if (value instanceof JSONArray) {
            //数组
            value = covertArray(object.getJSONArray(key));
        } else if (value instanceof JSONObject) {
            //对象
            value = covertObject(object.getJSONObject(key));
        }
        //这个方法自己写的改成下划线

---

项目链接：
https://javayms.github.io?id=151524180701201hx
https://javayms.pages.dev?id=151524180701201hx