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



