Question

ssm框架向mysql数据库插入数据出现史无前列的错误 请问大佬如何解决----谢谢【加急】

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

Answer 1

user_data这个这字段的传参数值不对，你这个字段的类型是date吧？
你传0进去 肯定不行啊，date是时间类型，你想要传0，就要改成数值类型，例如int

Answer 2

日期参数传的不对