新增异常\r\n### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstrain

错误完整提示:

"新增异常\r\n### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '23434375573' for key 'PRIMARY'\r\n### The error may exist in file [C:\\Users\\xxxx\\xxxxx\\xxxx\\xxxx\\target\\classes\\mapper\\InsertMapMapper.xml]\r\n### The error may involve com.xxxx.dao.InsertMapMapper.insertInfo2-Inline\r\n### The error occurred while setting parameters\r\n### SQL: insert into WUXING_WARN_STATION_WATER_LEVEL          (               ID          ,              STWARNID          ,              STCD          ,              STNM          ,              LONGITUDE          ,              LATITUDE          ,              ORIGINALADCD          ,              ORIGINALADNM          ,              STWARNSTM          ,              STWARNETM          ,              STWARNNM          ,              STWARNDESC          ,              FLOODLIMITWL          ,              NOWWL          ,              ADCD          ,              TONG_TIME          ,              OP          ,              REMARK          )          values                         (                   ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              )                         , (                   ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              )                         , (                   ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              ,                  ?              )\r\n### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '23434375573' for key 'PRIMARY'\n; Duplicate entry '23434375573' for key 'PRIMARY'; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '23434375573' for key 'PRIMARY'",

在往表里插入数据的时候,报了个错,原因是数据表中设置了主键(Primary Key),而主键对应的值是不允许重复的,我在插入的时候重复了“23434375573”这个值,所以报错。只要在每次插入的时候,保证这个主键唯一就行了。

 

 

 

 

 

  • 3
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值