JDBC sql (mysql & sqlite) large data insert snippet

gistfile1.txt

  public static void mysqlinserttest() throws SQLException{
        Connection c = DB.getConnection();
        c.setAutoCommit(false);
        String insertTableSQL = "INSERT INTO test"
                    + "(email , phone) VALUES"
                    + "(?,?)";
            PreparedStatement preparedStatement = c.prepareStatement(insertTableSQL);
            for (int i =0; i<50000; i++) {
                preparedStatement.setString(1, "email"+i);
                preparedStatement.setString(2, "00000000"+i);
                preparedStatement.addBatch();
                
                if(i!=0 && i%1000==0){//for every 1000 records, insert as a batch  
                    preparedStatement.executeBatch();
                    preparedStatement.clearBatch();
                    c.commit();
                }
            }
            preparedStatement.executeBatch();
            c.close();
    }