Java实现数据库新增修改防止编码重复功能

案例

项目中添加菜单实现防止菜单编码重复功能

实现

数据库表创建索引

 可添加多个字段

 Java层逻辑代码

@ApiOperation(value = "添加菜单")
@RequestMapping(value = "/insertMenu", method = RequestMethod.POST)
public Result insertMenu(@RequestBody Menu menu) {
    Result result = new Result();
    try {
        menu.setCreatorId( userManager.getUserId() );
        menuService.insert( menu );
        result.setData( menu.getMenuId() );
    } catch (BusinessException b) {
        result.setCode( ResultCodeEnum.SYSTEMERROR.getCode(), b.getMessage() );
    } catch (Exception e) {
        if (StringUtils.indexOfIgnoreCase( e.getCause().getMessage(), "idx_sys_menu_code" ) != -1) {
            result.setCode( ResultCodeEnum.SYSTEMERROR.getCode(), "编码重复" );
        } else {
            result.setCode( ResultCodeEnum.SYSTEMERROR.getCode(), ResultCodeEnum.SYSTEMERROR.getName() );
        }
        logger.error( "添加菜单:", e );
    }
    return result;
}