charmingLitteDeveloper
diff --git a/‎database/code/JDBC/.idea/workspace.xml‎
Lines changed: 20 additions & 86 deletions b/‎database/code/JDBC/.idea/workspace.xml‎
Lines changed: 20 additions & 86 deletions
diff --git a/‎database/code/JDBC/out/production/JDBC/Test.class‎
-88 Bytes b/‎database/code/JDBC/out/production/JDBC/Test.class‎
-88 Bytes
diff --git a/‎database/code/JDBC/src/Test.java‎
Lines changed: 4 additions & 3 deletions b/‎database/code/JDBC/src/Test.java‎
Lines changed: 4 additions & 3 deletions
@@ -1,15 +1,16 @@
 import java.sql.Connection;
+import java.sql.Date;
 import java.sql.DriverManager;
 import java.sql.PreparedStatement;
 
 public class Test {
     public static void main(String[] args) throws Exception{
         Class.forName("com.mysql.jdbc.Driver");
         Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/db1","root","123456");
-        PreparedStatement pstmt = conn.prepareStatement("insert into psn values(?,?)");
-        for (int i = 0; i < 20000; i++) {
+        PreparedStatement pstmt = conn.prepareStatement("insert into tblA(age,birth) values (?,?);");
+        for (int i = 200000; i < 1000000; i++) {
             pstmt.setInt(1,i);
-            pstmt.setString(2,i+"");
+            pstmt.setDate(2,new Date(new java.util.Date().getTime()));
             pstmt.addBatch();
         }
         pstmt.executeBatch();