public void testt() throws Exception {

        try (Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/testj?user=root&allowMultiQueries=true")) {

            try (Statement statement = connection.createStatement()) {

                statement.execute("DROP TABLE IF EXISTS foo3");

                statement.execute("CREATE TABLE foo3 (bar varchar(50))");

                String sql = "insert ignore into foo3 (bar) values (?)";

                try (PreparedStatement pstmt = connection.prepareStatement(sql)) {

                    int[] vals = new int[4];

                    int start = 106;

                    int dup = 2;

                    for (int i = 0; i < 3; i++) {

                        vals[i] = start + i;

                        pstmt.setString(1, new Integer(start + i).toString());

                        pstmt.addBatch();

                    }

                    // add the dup

                    pstmt.setString(1, new Integer(dup).toString());

                    pstmt.addBatch();

                    int[] updateCounts = pstmt.executeBatch();

                    System.out.println("inserted " + updateCounts.length); //show inserted 4

                    //show :

                    //values :  0 = 1

                    //values :  1 = 1

                    //values :  2 = 1

                    //values :  3 = 1

                    for (int i = 0; i < updateCounts.length; i++) {

                        System.out.println("values :  " + i + " = " + updateCounts[i]);

                    }

                }

            }

        }

    }