今日指数day8实战补充(上)
1.用户管理
1.多条件综合查询
1.1 多条件综合查询接口说明
1）原型效果
2）接口说明
功能描述：多条件综合查询用户分页信息，条件包含：分页信息 用户创建日期范围
服务路径：/api/users
服务方法：Post
请求参数格式：
{"pageNum":"1","pageSize":"20","username":"","nickName":"","startTime":"","endTime":""
}
响应数据格式：
{"code": 1,"data": {"totalRows": 12,"totalPages": 1,"pageNum": 1,"pageSize": 20,"size": 12,"rows": [{"id": 1237361915165020161,"username": "admin","password": "$2a$10$JqoiFCw4LUj184ghgynYp.4kW5BVeAZYjKqu7xEKceTaq7X3o4I4W","phone": "13888888888","realName": "小池","nickName": "超级管理员","email": "875267425@qq.com","status": 1,"sex": 1,"deleted": 1,"createId": null,"updateId": "1237361915165020161","createWhere": 1,"createTime": "2019-09-22T11:38:05.000+00:00","updateTime": "2020-04-07T10:08:52.000+00:00","createUserName": null,"updateUserName": "admin"},//.....]}
}
代码实现
1. 表现层
/*** 多条件综合查询*/@ApiOperation(value = "多条件综合查询")@PostMapping("/users")public R<UserRespVo> userManager(@RequestBody UserReqVo userReqVo){return UserService.userManager(userReqVo);}
2. 服务层
R<UserRespVo> userManager(UserReqVo userReqVo);
@Overridepublic R<UserRespVo> userManager(UserReqVo userReqVo) {// 获取分页数据Integer pageNum = Integer.parseInt(userReqVo.getPageNum());Integer pageSize = Integer.parseInt(userReqVo.getPageSize());// 获取查询条件String username = userReqVo.getUsername();String nickName = userReqVo.getNickName();String startTimeString = userReqVo.getStartTime();String endTimeString = userReqVo.getEndTime();Date startTime = null;Date endTime = null;if (!StringUtils.isBlank(startTimeString) && !StringUtils.isBlank(endTimeString)){startTime = DateTime.parse(startTimeString, DateTimeFormat.forPattern("yyyy-MM-dd HH:mm:ss")).toDate();endTime = DateTime.parse(endTimeString, DateTimeFormat.forPattern("yyyy-MM-dd HH:mm:ss")).toDate();}// 设置分页参数PageHelper.startPage(pageNum,pageSize);// 查询获得所有数据List<SysUser> allUser = sysUserMapper.getSUserByIf(username,nickName,startTime,endTime);// 分页处理PageInfo<SysUser> userInfo = new PageInfo<>(allUser);UserRespVo userRespVo = new UserRespVo(userInfo);return R.ok(userRespVo);}
3. Dao层
List<SysUser> getSUserByIf(@Param("username") String username, @Param("nickName") String nickName, @Param("startTime") Date startTime, @Param("endTime") Date endTime);
<select id="getSUserByIf" resultType="com.jixu.stock.pojo.entity.SysUser">SELECT *FROM sys_userWHERE 1=1<if test="username != null and username != ''">AND username like concat('%' , #{username} , '%')</if><if test="nickName != null and nickName != ''">AND nick_name like concat('%' , #{nickName} , '%')</if><if test="startTime != null">AND created_time >= #{startTime}</if><if test="endTime != null">AND created_time <= #{endTime}</if></select>
1.2 添加用户接口说明
1）原型效果
2）接口说明
功能描述：添加用户信息
服务路径：/api/user
服务方法：Post
请求参数格式：
{"username":"mike","password":"20","phone":"15367945613","email":"123@qwe.cn","nickName":"jane","realName":"kangkang","sex":"1","createWhere":"1","status":"1"
}
响应参数格式：
{"code": 1,"msg": "操作成功"
}
代码实现
1. 表现层
/*** 添加用户*/@ApiOperation(value = "添加用户")@PostMapping("/user")public R<UserRespVo> addUser(@RequestBody AddUserReqVo addUserReqVo, HttpServletRequest request){return UserService.addUser(addUserReqVo , request);}
2. 服务层
R<UserRespVo> addUser(AddUserReqVo addUserReqVo, HttpServletRequest request);
@Overridepublic R<UserRespVo> addUser(AddUserReqVo addUserReqVo, HttpServletRequest request) {// 校验用户数据是否正确if (addUserReqVo == null || StringUtils.isBlank(addUserReqVo.getUsername())|| StringUtils.isBlank(addUserReqVo.getPassword())|| StringUtils.isBlank(addUserReqVo.getPhone())|| StringUtils.isBlank(addUserReqVo.getEmail())|| StringUtils.isBlank(addUserReqVo.getNickName())){return R.error(ResponseCode.DATA_ERROR.getMessage());}// 对密码进行加密String password = addUserReqVo.getPassword();String encode = passwordEncoder.encode(password);// 获取createIDHttpSession session = request.getSession();Long userId = (Long) session.getAttribute("user_id");SysUser sysUser = new SysUser();BeanUtils.copyProperties(addUserReqVo,sysUser);sysUser.setPassword(encode);sysUser.setCreateId(userId);// 获取状态性别Integer status = Integer.valueOf(addUserReqVo.getStatus());Integer sex = Integer.valueOf(addUserReqVo.getSex());sysUser.setStatus(status);sysUser.setSex(sex);int insert = sysUserMapper.insert(sysUser);if (insert > 0){log.info("用户注册成功");}else {log.error("用户注册失败");return R.error(ResponseCode.ERROR.getMessage());}return R.ok("操作成功");}
3. Dao层
int insert(SysUser record);
<insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.jixu.stock.pojo.entity.SysUser" useGeneratedKeys="true">insert into sys_user( id,username,password,phone,real_name,nick_name,email,status,sex,deleted,create_id,update_id,create_where,create_time,update_time)values (#{id,jdbcType=BIGINT},#{username,jdbcType=VARCHAR},#{password,jdbcType=VARCHAR},#{phone,jdbcType=VARCHAR},#{realName,jdbcType=VARCHAR},#{nickName,jdbcType=VARCHAR},#{email,jdbcType=VARCHAR},#{status,jdbcType=TINYINT},#{sex,jdbcType=TINYINT},#{deleted,jdbcType=TINYINT},#{createId,jdbcType=BIGINT},#{updateId,jdbcType=BIGINT},#{createWhere,jdbcType=TINYINT},#{createTime,jdbcType=TIMESTAMP},#{updateTime,jdbcType=TIMESTAMP})</insert>
1.3 获取用户具有的角色信息接口说明
1）原型效果
2）接口说明
功能描述：获取用户具有的角色信息，以及所有角色信息
服务路径：/user/roles/{userId}
服务方法：Get
请求参数：String userId
响应参数格式：
{
"code": 1,
"data": {"ownRoleIds": [1237258113002901515],"allRole": [{"id": 1237258113002901512,"name": "超级管理员","description": "我是超级管理员","status": 1,"createTime": "2020-01-06T15:37:45.000+00:00","updateTime": "2021-12-09T23:08:02.000+00:00","deleted": 1},{"id": 1237258113002901513,"name": "标记用户角色测试","description": "标记用户角色测试","status": 1,"createTime": "2020-01-08T02:53:35.000+00:00","updateTime": "2021-12-28T10:16:21.000+00:00","deleted": 1},//..............]
}
}
代码实现
1. 表现层
/*** 获取用户具有的角色信息*/@ApiOperation(value = "获取用户具有的角色信息")@GetMapping("/user/roles/{userId}")public R<Map<String, Object>> getRole(@PathVariable String userId){return UserService.getRole(userId);}
2. 服务层
R<Map<String, Object>> getRole(String userId);
@Overridepublic R<Map<String, Object>> getRole(String userId) {Long id = Long.valueOf(userId);// 查询获得用户角色List<Long> userRoleList = sysUserRoleMapper.getRole(id);// 查询获得所有角色信息ArrayList<SysRole> allRoleList = sysRoleMapper.getAllRole();// 封装数据HashMap<String, Object> data = new HashMap<>();data.put("ownRoleIds" , userRoleList);data.put("allRole",allRoleList);return R.ok(data);}
3. Dao层
List<Long> getRole(@Param("id") Long id);
<select id="getRole" resultType="java.lang.Long">select role_id from sys_user_role where user_id = #{id};</select>
ArrayList<SysRole> getAllRole();
<select id="getAllRole" resultType="com.jixu.stock.pojo.entity.SysRole">select id,name,description,status,create_time,update_time,deletedfrom sys_role;</select>