public static void insertDataIntoEmployeeTable()

in code-optimization/db-performance-issue/java/src/main/java/com/epam/aicode/java/DBUtils.java [31:42]

• 12 lines of code
• 3 McCabe index (conditional complexity)

    public static void insertDataIntoEmployeeTable(Connection connection) throws SQLException {
        try (PreparedStatement preparedStatement = connection.prepareStatement(INSERT_INTO_EMPLOYEE_TABLE_SQL)) {
            for (int i = 1; i <= 1000000; i++) {
                preparedStatement.setInt(1, i);
                preparedStatement.setString(2, NAME + i);
                preparedStatement.addBatch();
                if (i % 1000000 == 0) {
                    preparedStatement.executeBatch();
                }
            }
        }
    }