数据库唯一性约束异常插入处理详解编程语言

CREATE TABLE `auth_role` ( 
    `id` INT(11) NOT NULL AUTO_INCREMENT COMMENT '主键', 
    `rolename` VARCHAR(50) NULL DEFAULT NULL COMMENT '角色名称', 
    `adduser` INT(11) NULL DEFAULT NULL COMMENT '添加人', 
    `addtime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间', 
    PRIMARY KEY (`id`), 
    UNIQUE INDEX `rolename` (`rolename`) 
)COMMENT='统一平台角色' 
COLLATE='utf8_general_ci' 
ENGINE=InnoDB 
ROW_FORMAT=COMPACT 
AUTO_INCREMENT=15;

    @RequestMapping(value="/insertSelective",method={RequestMethod.GET,RequestMethod.POST}) 
    @ResponseBody 
    public Object insertSelective(Auth_role record,HttpSession session){ 
        Userinfo sessionUserinfo = (Userinfo)session.getAttribute("CURR_USER"); 
        String sessionuserid = sessionUserinfo.getUserid().toString(); 
        record.setAdduser(Integer.parseInt(sessionuserid));
 
        Map map = new HashMap(); 
        int result = 0; 
        /*异常处理*/ 
        try { 
            result = service.insertSelective(record); 
        }catch (org.springframework.dao.DuplicateKeyException e){ 
            /*异常处理截获流程,如果是存在DuplicateKeyException则是重名,直接返回到前端,id主键为自增长,不会重复*/ 
            map.put("code", "fail"); 
            map.put("msg", "该角色名已存在!"); 
            return map; 
        } 
        /*正常返回流程*/ 
        if (result == 1) { 
            map.put("code", "success"); 
            map.put("msg", CN_MessageEnum.AddSuccess.getName()); 
        }else { 
            map.put("code", "fail"); 
            map.put("msg", CN_MessageEnum.AddFailed.getName()); 
        } 
        return map; 
    }