SpringBoot开发项目实战记录(四)
一、 后端全局异常处理
1.1全局异常处理类
⭐知识点:
- 注意该全局异常处理类被@RestControllerAdvice注解标注
/**
* 全局异常处理
*/
@RestControllerAdvice
public class GlobalException {
@ExceptionHandler(SQLException.class)
public RespBean mySqlException(SQLException e) {
if(e instanceof SQLIntegrityConstraintViolationException) {
return RespBean.error("该数据存在关联,操作失败!");
}
return RespBean.error("数据库错误,请联系管理员");
}
}
二、职称接口管理crud
2.1 pojo
/**
* <p>
*
* </p>
*
* @author seven
* @since 2022-01-02
*/
@Data
@EqualsAndHashCode(callSuper = false)
@Accessors(chain = true)
@TableName("t_joblevel")
@ApiModel(value="Joblevel对象", description="")
public class Joblevel implements Serializable {
private static final long serialVersionUID = 1L;
@ApiModelProperty(value = "id")
@TableId(value = "id", type = IdType.AUTO)
private Integer id;
@ApiModelProperty(value = "职称名称")
private String name;
@ApiModelProperty(value = "职称等级")
private String titleLevel;
@ApiModelProperty(value = "创建时间")
@JsonFormat(pattern = "yyyy-MM-dd", timezone = "Asia/Shanghai")
private LocalDateTime createDate;
@ApiModelProperty(value = "是否启用")
private Boolean enabled;
}
2.2 职称管理的controller层(使用mybatis-plus做数据持久)
/**
* <p>
* 职称管理
* </p>
*
* @author seven
* @since 2022-01-02
*/
@Api(tags = "职称类接口管理")
@RestController
@RequestMapping("/api/system/basic/joblevel")
public class JoblevelController {
@Autowired
private IJoblevelService joblevelService;
@ApiOperation(value = "获取所有职称")
@GetMapping("/")
public List<Joblevel> getAllJobLevels() {
return joblevelService.list();
}
@ApiOperation(value = "添加一个职称")
@PostMapping("/")
public RespBean addJobLevel(@RequestBody Joblevel joblevel) {
joblevel.setCreateDate(LocalDateTime.now());
System.out.println(joblevel);
if(joblevelService.save(joblevel)) {
return RespBean.success("添加职称成功");
}
return RespBean.warning("添加职称失败");
}
@ApiOperation(value = "修改职称信息")
@PutMapping("/")
public RespBean putJobLevel(@RequestBody Joblevel joblevel) {
if (joblevelService.updateById(joblevel)) {
return RespBean.success("修改职称信息成功");
}
return RespBean.warning("修改职称信息失败");
}
@ApiOperation(value = "删除一个职称")
@DeleteMapping("/{id}")
public RespBean deleteJoblevel(@PathVariable Integer id) {
if (joblevelService.removeById(id)) {
return RespBean.success("删除一个职称成功");
}
return RespBean.warning("删除一个职称失败");
}
@ApiOperation(value = "删除一组职称")
@DeleteMapping("/")
public RespBean deleteJoblevels(Integer[] ids) {
if (joblevelService.removeByIds(Arrays.asList(ids))) {
return RespBean.success("删除一组职称成功");
}
return RespBean.success("删除一组职称失败");
}
}
三、权限组功能实现crud
3.1 pojo
/**
* <p>
*
* </p>
*
* @author seven
* @since 2022-01-02
*/
@Data
@EqualsAndHashCode(callSuper = false)
@Accessors(chain = true)
@TableName("t_role")
@ApiModel(value="Role对象", description="")
public class Role implements Serializable {
private static final long serialVersionUID = 1L;
@ApiModelProperty(value = "id")
@TableId(value = "id", type = IdType.AUTO)
private Integer id;
@ApiModelProperty(value = "名称")
private String name;
@ApiModelProperty(value = "角色名称")
private String nameZh;
}
3.2 controller类
/**
* 角色管理
*/
@Api(tags = "权限接口管理")
@RestController
@RequestMapping("/api/system/basic/role")
public class PermissController {
@Autowired
private IRoleService roleService;
@Autowired
private IMenuService menuService;
@Autowired
private IMenuRoleService menuRoleService;
@ApiOperation(value = "查询所有权限角色")
@GetMapping("/")
public List<Role> getAllRoles() {
return roleService.list();
}
@ApiOperation(value = "增加一个角色")
@PostMapping("/")
public RespBean addRole(@RequestBody Role role) {
// 判断角色名字是否规范
if (!role.getName().startsWith("ROLE_")) {
role.setName("ROLE_"+role.getName());
}
if (roleService.save(role)) {
return RespBean.success("增加角色成功");
}
return RespBean.warning("增加角色失败");
}
@ApiOperation(value = "删除一个角色")
@DeleteMapping("/role/{id}")
public RespBean deleteRole(@PathVariable Integer id){
if (roleService.removeById(id)) {
return RespBean.success("删除角色成功");
}
return RespBean.warning("删除角色失败");
}
@ApiOperation(value = "查询所有菜单")
@GetMapping("/menus")
public List<Menu> getAllMenus() {
return menuService.getAllMenus();
}
@ApiOperation(value = "根据角色id查询菜单id")
@GetMapping("/mid/{rid}")
public List<Integer> getMidByrid(@PathVariable Integer rid) {
return menuRoleService.list(new QueryWrapper<MenuRole>().eq("rid", rid)).stream().map(MenuRole::getMid).collect(Collectors.toList());
}
@ApiOperation(value = "更新角色菜单")
@PutMapping("/")
public RespBean updateMenuRole(Integer rid, Integer[] mids) {
return menuRoleService.updateMenuRole(rid, mids);
}
}
1. 根据角色id查询菜单id
⭐知识点:
查询到所有记录,获取到所有的记录的mid,然后转换成List
@ApiOperation(value = "根据角色id查询菜单id")
@GetMapping("/mid/{rid}")
public List<Integer> getMidByrid(@PathVariable Integer rid) {
return menuRoleService.list(new QueryWrapper<MenuRole>().eq("rid", rid)).stream().map(MenuRole::getMid).collect(Collectors.toList());
}
2. 更新角色菜单
@ApiOperation(value = "更新角色菜单")
@PutMapping("/")
public RespBean updateMenuRole(Integer rid, Integer[] mids) {
return menuRoleService.updateMenuRole(rid, mids);
}
3.3 service层
⭐知识点:
@Transactional开启事务操作: 因为这个逻辑里两个sql执行
1. 更新角色菜单的具体逻辑
/**
* 更新角色权限
* @param rid
* @param mids
* @return
*/
@Override
@Transactional
public RespBean updateMenuRole(Integer rid, Integer[] mids) {
// 先删除原来的权限记录
menuRoleMapper.delete(new QueryWrapper<MenuRole>().eq("rid", rid));
// 判断是否为删除数据
if (mids == null || mids.length==0) {
return RespBean.success("删除所有权限!");
}
// 批量增加权限记录
Integer integer = menuRoleMapper.insertRecord(rid, mids);
if (integer == mids.length) {
return RespBean.success("更新角色权限成功!");
}
return RespBean.warning("更新角色失败");
}
3.4 mapper层
1. 批量更新的xml
使用foreach的语法更新多个记录
<!--批量增加角色权限记录-->
<insert id="insertRecord">
insert into t_menu_role(mid, rid) values
<foreach collection="mids" item="mid" separator=",">
(#{mid}, #{rid})
</foreach>
</insert>