Java Web开发遇到 java.sql.SQLIntegrityConstraintViolationException: 解决办法

布满荆棘的人生 2024-03-17 20:39 65阅读 0赞

### **最近在学习javaweb开发update更新接口的过程中遇到了java.sql.SQLIntegrityConstraintViolationException:**  ###

### **问题如下图**  ###

### **![1d703bc0a99c4d9bb613e77577398ce9.png][]** ###

### **Cause: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '开发部' for key 'dept.name'   ; Duplicate entry '开发部' for key 'dept.name'; nested exception is java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '开发部' for key 'dept.name'\] with root cause** ###

### **我使用apipost测试接口,报错如下** ###

### **![661ef59591164805a1ddb7cd919bf62c.png][]** ###

###  **后面经过查询后明白了是使用更新sql语句时，传入的更新参数违反了数据库的[唯一约束][Link 1]条件。插入数据时，具有唯一约束条件的列值重复了。所以当我把传入的参数修改后再使用apipost就能正常使用了** ###

### **![34c178e765fe402e98eab1dcabb1ee49.png][]** ###

###  **以上只为学习过程中的记录** ###

###     ###

[1d703bc0a99c4d9bb613e77577398ce9.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/113e4558e2b44775b32a5b02b4c972e2.png
[661ef59591164805a1ddb7cd919bf62c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/5baea7d367b8483a9e6150b58b26849e.png
[Link 1]: https://so.csdn.net/so/search?q=%E5%94%AF%E4%B8%80%E7%BA%A6%E6%9D%9F&spm=1001.2101.3001.7020
[34c178e765fe402e98eab1dcabb1ee49.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/2ad3ba47e23c42908df9daefd4e5bdfb.png