public static void insertSampleData(Statement stmt) {
        
        String populateTools = "INSERT INTO Tools (ToolID, Engraved, OldID, Description, Make, Model,"+
                                                  "DivisionCode, TeamID, UserName, "+
                                                  "Quantity, DatePurchase, Status," +
                                                  "LocationCode, ConditionCode, Supplier, Price) "+
                               "VALUES ( 'SS0021', 0, 'PV01', 'ToolDescr01', 'ToolMake01', 'ToolModel01', "+
                                       " 'B', 'ToolTeam01', 'ToolUsr01', "+
                                       " '1', '2323-02-03', 'R', "+
                                       " 'F', 'A', 'Supp01', 111 )";
        try {
            String s;
            for( int i = 1; i < 50; i++) {
                s = populateTools.replaceAll( "1", Integer.toString(i) );
                stmt.executeUpdate(s);
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }