ssm框架 mysql下载_ssm框架向mysql数据库插入数据出现史无前列的错误请问大佬如何解决----谢谢【加急】...-优快云博客

在`ProjectTest.testRegisterPhonetestRegisterPhone`测试用例中，遇到了`DataIntegrityViolationException`，问题源于尝试更新数据库时，因值'0'不正确导致`MysqlDataTruncation`异常，具体涉及`user_data`列，该列可能期望日期类型，但接收到的是非法日期值。

ProjectTest.testRegisterPhonetestRegisterPhone(com.hp.bookstore.test.ProjectTest)org.springframework.dao.DataIntegrityViolationException:###Errorupdatingdatabase.Cause:co...

ProjectTest.testRegisterPhonetestRegisterPhone(com.hp.bookstore.test.ProjectTest)org.springframework.dao.DataIntegrityViolationException: ### Error updating database. Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect date value: '0' for column 'user_data' at row 1### The error may involve com.hp.bookstore.mapper.BookUserMapper.register-Inline### The error occurred while setting parameters### SQL: insert into book_user(user_phone,user_password,user_key,user_data) values ( user_phone=?, user_password=?, user_key=?, user_data=? )### Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect date value: '0' for column 'user_data' at row 1; SQL []; Data truncation: Incorrect date value: '0' for column 'user_data' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect date value: '0' for column 'user_data' at row 1

展开