品优购day14注册帐号异常信息解决Duplicate entry 'zhangsan' for key 'username'

最新推荐文章于 2023-07-10 16:23:20 发布

千水久长

最新推荐文章于 2023-07-10 16:23:20 发布

阅读量1.4k

点赞数 2

CC 4.0 BY-SA版权

分类专栏：异常报错文章标签：异常报错

本文链接：https://blog.youkuaiyun.com/qq_36694268/article/details/85008727

博客讲述了在品优购day14注册过程中遇到的‘Duplicate entry 'zhangsan' for key 'username'异常，原因是尝试向数据库添加已存在的用户名。解决方法是更换用户名或在代码中增加检查，确保数据唯一性。最后强调了编写健壮代码的重要性。

异常信息

java.lang.RuntimeException: org.springframework.dao.DuplicateKeyException: 
### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'zhangsan' for key 'username'
### The error may involve com.pinyougou.mapper.TbUserMapper.insert-Inline
### The error occurred while setting parameters
### SQL: insert into tb_user (id, username, password,        phone, email, created,        updated, source_type, nick_name,        name, status, head_pic,        qq, account_balance, is_mobile_check,        is_email_check, sex, user_level,        points, experience_value, birthday,        last_login_time)     values (?, ?, ?,        ?, ?, ?,        ?, ?, ?,        ?, ?, ?,        ?, ?, ?,        ?, ?, ?,        ?, ?, ?,        ?)
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'zhangsan' for key 'username'
; SQL []; Duplicate entry 'zhangsan' for key 'username'; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'zhangsan' for key 'username'
org.springframework.dao.DuplicateKeyException: 
### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'zhangsan' for key 'username'
### The error may involve com.pinyougou.mapper.TbUserMapper.insert-Inline
### The error occurred while setting parameters
### SQL: insert into tb_user (id, username, password,        phone, email, created,        updated, source_type, nick_name,        name, status, head_pic,        qq, account_balance, is_mobile_check,        is_email_check, sex, user_level,        points, experience_value, birthday,        last_login_time)     values (?, ?, ?,        ?, ?, ?,        ?, ?, ?,        ?, ?, ?,        ?, ?, ?,        ?, ?, ?,        ?, ?, ?,        ?)
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'zhangsan' for key 'username'
; SQL []; Duplicate entry 'zhangsan' for key 'username'; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'zhan