• com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect date value: ‘1988-09-03’ for colum 1
• 最近在练习JDBC的对数据库的表进行增删改查使用，在eclipse中写Java程序时候就会发现许多需要和sql交互并注意的地方。很多小的细节错误，就会导致你测试不成功。下面贴一个新鲜的小错误，希望看到的同学避免入坑。

1**. 问题原因：因为输出语句有错**

出现错误的语句

@Testpublic 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 1at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3513)at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2046)at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1964)at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1949)at com.guigu4.exer.Exer1Test.update(Exer1Test.java:52)at com.guigu4.exer.Exer1Test.testInsert(Exer1Test.java:23)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)at java.lang.reflect.Method.invoke(Unknown Source)at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)at org.junit.runners.ParentRunner.run(ParentRunner.java:363)at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:89)at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:41)at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:541)at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:763)at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:463)at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:209)
添加失败`

**请注意这里的System.out.println（），这里是输出并换行，所以当我输入用户名后它就自动跳到下一行，然后就会导致这一行的输入数据变成了下一个输入数据，引起了输入类型不正确的错误。

当我把上面的**System.out.println（）**换成**System.out.print（）**问题就完美解决啦