public static void insertSampleData(Statement stmt){

        String insert = "INSERT INTO Locations (CODE, DESCRIPTION) VALUES ";
        
        String[] codes = { " ('F', 'Factory') ",
                           " ('S', 'Stores') ",
                           " ('EQ', 'External supplier - waiting for quotation') ",
                           " ('EA', 'External supplier - quotation received, waiting for approval from PM') ",
                           " ('ER', 'External supplier - waiting for completion of repair') "
                         };
        
        try {
            String insertLocation;
            for( int i = 0; i < codes.length; i++) {
                insertLocation = insert + codes[i];
                stmt.executeUpdate(insertLocation);
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }