写代码出现Duplicate entry ‘K2002‘ for key ‘lj

写代码出现Duplicate entry ‘K2002‘ for key ‘lj

org.springframework.dao.DuplicateKeyException:

Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry ‘K2002’ for key ‘lj_book_list.PRIMARY’ The error may exist in file [E:IdeaProjectsbookmanagetargetclassesmapperLjBookListDao.xml] The error may involve defaultParameterMap The error occurred while setting parameters SQL: insert into lj_book_list(BOOK_ID,BOOK_NAME, BOOK_AUTHOR, BOOK_PUBLISH_HOUSE, BOOK_PAGE_COUNT, BOOK_PUBLISH_DATE, BOOK_PRICE, BOOK_DETALI, BOOK_IS_DEL, CAN_BORROW_DATE, BOOK_SRC) values (?,?, ?, ?, ?, ?, ?, ?, 0, now(), ?) Cause: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry ‘K2002’ for key ‘lj_book_list.PRIMARY’

这是因为主键冲突，在第一次插入结束以后，再执行同一条数据，会在插入时主键冲突，而后报错。所以在一次性执行多条插入语句时，部分报错，应该去判断会不会造成这种原因。