- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect date value: ‘1988-09-03’ for colum 1
- 最近在练习JDBC的对数据库的表进行增删改查使用,在eclipse中写Java程序时候就会发现许多需要和sql交互并注意的地方。很多小的细节错误,就会导致你测试不成功。下面贴一个新鲜的小错误,希望看到的同学避免入坑。
1**. 问题原因:因为输出语句有错**
出现错误的语句
@Test
public void testInsert() {
Scanner scanner = new Scanner(System.in);
System.out.println("请输入用户名:");
String name = scanner.next();
System.out.println("请输入邮箱:");
String email = scanner.next();
System.out.println("请输入生日:");
String birthday = scanner.next();
String sql = "insert into customers(name,email,birth)values(?,?,?)";
``
报错如下
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect date value: '1988-09-0390' for column 'birth' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java: