public RegisterTableModel() {
        
        try (Statement stmt= con.createStatement();
             ResultSet rs = stmt.executeQuery("SELECT * FROM Register WHERE Status <> 'D'");)
        {
            while(rs.next()) {
                RegisterItem ri = new RegisterItem();
                ri.setToolID(rs.getString("ToolID"));
                ri.setEngraved(rs.getBoolean("Engraved"));
                ri.setOldID(rs.getString("OldID"));
                ri.setDescription(rs.getString("Description"));
                ri.setMake(rs.getString("Make"));
                ri.setModel(rs.getString("Model"));
                ri.setDivisionCode(rs.getString("DivisionCode"));
                ri.setDivisionDescription(rs.getString("DivisionDescription"));
                ri.setTeamID(rs.getString("TeamID"));
                ri.setUserName(rs.getString("UserName"));
                ri.setQuantity(rs.getString("Quantity"));                
                try {
                    ri.setDatePurchase(df.parse(rs.getString("DatePurchase")));
                } catch (ParseException ex) {
                    throw new IllegalArgumentException("Date from DB not 'yyyy-MM-dd'", ex);
                }
                ri.setStatus(rs.getString("Status"));
                ri.setLocationCode(rs.getString("LocationCode"));
                ri.setLocationDescription(rs.getString("LocationDescription"));
                ri.setConditionCode(rs.getString("ConditionCode"));
                ri.setConditionDescription(rs.getString("ConditionDescription"));
                ri.setSupplier(rs.getString("Supplier"));
                ri.setPrice(rs.getInt("Price"));
                addRegisterItem(ri);
            }
        } catch (SQLException ex) {
            System.err.println(ex.getClass().getName() + ": " + ex.getMessage());
        }            
       
    }