/**
     * 登錄
     * @param data
     * @param httpServletRequest
     * @return
     */
    @PostMapping("login")
    public Map<String, Object> login(@RequestBody Map<String, String> data, HttpServletRequest httpServletRequest) {
        log.info("[執(zhí)行登錄接口]");
        String username = data.get("username");
        String email = data.get("email");
        String phone = data.get("phone");
        String password = data.get("password");
        List resultList = null;
        Map<String, String> map = new HashMap<>();
        if(username != null && "".equals(username) == false){
            map.put("username", username);
            resultList = service.select(map, new HashMap<>()).getResultList();
        }
        else if(email != null && "".equals(email) == false){
            map.put("email", email);
            resultList = service.select(map, new HashMap<>()).getResultList();
        }
        else if(phone != null && "".equals(phone) == false){
            map.put("phone", phone);
            resultList = service.select(map, new HashMap<>()).getResultList();
        }else{
            return error(30000, "賬號(hào)或密碼不能為空");
        }
        if (resultList == null || password == null) {
            return error(30000, "賬號(hào)或密碼不能為空");
        }
        //判斷是否有這個(gè)用戶
        if (resultList.size()<=0){
            return error(30000,"用戶不存在");
        }
        User byUsername = (User) resultList.get(0);
        Map<String, String> groupMap = new HashMap<>();
        groupMap.put("name",byUsername.getUserGroup());
        List groupList = userGroupService.select(groupMap, new HashMap<>()).getResultList();
        if (groupList.size()<1){
            return error(30000,"用戶組不存在");
        }
        UserGroup userGroup = (UserGroup) groupList.get(0);
        //查詢用戶審核狀態(tài)
        if (!StringUtils.isEmpty(userGroup.getSourceTable())){
            String sql = "select examine_state from "+ userGroup.getSourceTable() +" WHERE user_id = " + byUsername.getUserId();
            String res = String.valueOf(service.runCountSql(sql).getSingleResult());
            if (res==null){
                return error(30000,"用戶不存在");
            }
            if (!res.equals("已通過(guò)")){
                return error(30000,"該用戶審核未通過(guò)");
            }
        }
        //查詢用戶狀態(tài)
        if (byUsername.getState()!=1){
            return error(30000,"用戶非可用狀態(tài)，不能登錄");
        }
        String md5password = service.encryption(password);
        if (byUsername.getPassword().equals(md5password)) {
            // 存儲(chǔ)Token到數(shù)據(jù)庫(kù)
            AccessToken accessToken = new AccessToken();
            accessToken.setToken(UUID.randomUUID().toString().replaceAll("-", ""));
            accessToken.setUser_id(byUsername.getUserId());
            tokenService.save(accessToken);
            // 返回用戶信息
            JSONObject user = JSONObject.parseObject(JSONObject.toJSONString(byUsername));
            user.put("token", accessToken.getToken());
            JSONObject ret = new JSONObject();
            ret.put("obj",user);
            return success(ret);
        } else {
            return error(30000, "賬號(hào)或密碼不正確");
        }
    }

 /**
     * 修改密碼
     * @param data
     * @param request
     * @return
     */
    @PostMapping("change_password")
    public Map<String, Object> change_password(@RequestBody Map<String, String> data, HttpServletRequest request){
        // 根據(jù)Token獲取UserId
        String token = request.getHeader("x-auth-token");
        Integer userId = tokenGetUserId(token);
        // 根據(jù)UserId和舊密碼獲取用戶
        Map<String, String> query = new HashMap<>();
        String o_password = data.get("o_password");
        query.put("user_id" ,String.valueOf(userId));
        query.put("password" ,service.encryption(o_password));
        Query ret = service.count(query, service.readConfig(request));
        List list = ret.getResultList();
        Object s = list.get(0);
        int count = Integer.parseInt(list.get(0).toString());
        if(count > 0){
            // 修改密碼
            Map<String,Object> form = new HashMap<>();
            form.put("password",service.encryption(data.get("password")));
            service.update(query,service.readConfig(request),form);
            return success(1);
        }
        return error(10000,"密碼修改失??！");
    }

* 注冊(cè)
     * @param user
     * @return
     */
    @PostMapping("register")
    public Map<String, Object> signUp(@RequestBody User user) {
        // 查詢用戶
        Map<String, String> query = new HashMap<>();
        query.put("username",user.getUsername());
        List list = service.select(query, new HashMap<>()).getResultList();
        if (list.size()>0){
            return error(30000, "用戶已存在");
        }
        user.setUserId(null);
        user.setPassword(service.encryption(user.getPassword()));
        service.save(user);
        return success(1);
}
/**
     * 用戶ID：[0,8388607]用戶獲取其他與用戶相關(guān)的數(shù)據(jù)
     */
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "user_id")
    private Integer userId;
    /**
     * 賬戶狀態(tài)：[0,10](1可用|2異常|3已凍結(jié)|4已注銷)
     */
    @Basic
    @Column(name = "state")
    private Integer state;
    /**
     * 所在用戶組：[0,32767]決定用戶身份和權(quán)限
     */
    @Basic
    @Column(name = "user_group")
    private String userGroup;
    /**
     * 上次登錄時(shí)間：
     */
    @Basic
    @Column(name = "login_time")
    private Timestamp loginTime;
    /**
     * 手機(jī)號(hào)碼：[0,11]用戶的手機(jī)號(hào)碼，用于找回密碼時(shí)或登錄時(shí)
     */
    @Basic
    @Column(name = "phone")
    private String phone;
    /**
     * 手機(jī)認(rèn)證：[0,1](0未認(rèn)證|1審核中|2已認(rèn)證)
     */
    @Basic
    @Column(name = "phone_state")
    private Integer phoneState;
    /**
     * 用戶名：[0,16]用戶登錄時(shí)所用的賬戶名稱
     */
    @Basic
    @Column(name = "username")
    private String username;
    /**
     * 昵稱：[0,16]
     */
    @Basic
    @Column(name = "nickname")
    private String nickname;
    /**
     * 密碼：[0,32]用戶登錄所需的密碼，由6-16位數(shù)字或英文組成
     */
    @Basic
    @Column(name = "password")
    private String password;
    /**
     * 郵箱：[0,64]用戶的郵箱，用于找回密碼時(shí)或登錄時(shí)
     */
    @Basic
    @Column(name = "email")
    private String email;
    /**
     * 郵箱認(rèn)證：[0,1](0未認(rèn)證|1審核中|2已認(rèn)證)
     */
    @Basic
    @Column(name = "email_state")
    private Integer emailState;
    /**
     * 頭像地址：[0,255]
     */
    @Basic
    @Column(name = "avatar")
    private String avatar;
    /**
     * 創(chuàng)建時(shí)間：
     */
    @Basic
    @Column(name = "create_time")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Timestamp createTime;
    @Basic
    @Transient
    private String code;
}

@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);
}
    public Map<String,Object> readBody(BufferedReader reader){
        BufferedReader br = null;
        StringBuilder sb = new StringBuilder("");
        try{
            br = reader;
            String str;
            while ((str = br.readLine()) != null){
                sb.append(str);
            }
            br.close();
            String json = sb.toString();
            return JSONObject.parseObject(json, Map.class);
        }catch (IOException e){
            e.printStackTrace();
        }finally{
            if (null != br){
                try{
                    br.close();
                }catch (IOException e){
                    e.printStackTrace();
                }
            }
        }
        return null;
}
    public void insert(Map<String,Object> body){
        StringBuffer sql = new StringBuffer("INSERT INTO ");
        sql.append("`").append(table).append("`").append(" (");
        for (Map.Entry<String,Object> entry:body.entrySet()){
            sql.append("`"+humpToLine(entry.getKey())+"`").append(",");
        }
        sql.deleteCharAt(sql.length()-1);
        sql.append(") VALUES (");
        for (Map.Entry<String,Object> entry:body.entrySet()){
            Object value = entry.getValue();
            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();
    }

@RequestMapping(value = "/del")
    @Transactional
    public Map<String, Object> del(HttpServletRequest request) {
        service.delete(service.readQuery(request), service.readConfig(request));
        return success(1);
}
    @Transactional
    public void delete(Map<String,String> query,Map<String,String> config){
        StringBuffer sql = new StringBuffer("DELETE FROM ").append("`").append(table).append("`").append(" ");
        sql.append(toWhereSql(query, "0".equals(config.get(FindConfig.GROUP_BY))));
        log.info("[{}] - 刪除操作：{}",table,sql);
        Query query1 = runCountSql(sql.toString());
        query1.executeUpdate();
    }