public void loadAllAssets(){
        try {        
            ResultSet dbAllAssets = null;
            Statement statement;
            statement = connection.createStatement();
            dbAllAssets = statement.executeQuery( "SELECT Asset.ID, Asset.assetName, Asset.assetType, Task.taskID" +
                                                    "FROM Asset INNER JOIN Task ON Asset.ID = Task.assetID;");                     
            while(dbAllAssets.next())
            {
                SetOfTasks assetTasks = new SetOfTasks();
                for(int i=0; i<allTasks.size();i++){
                    if(allTasks.get(i).getTaskID()==dbAllAssets.getInt("assetID")){
                        assetTasks.addTask(allTasks.get(i));
                    }
                }
                Asset tempAsset = new Asset(dbAllAssets.getInt("ID"), dbAllAssets.getString("assetName"), dbAllAssets.getString("type"), assetTasks);
                allAssets.addAsset(tempAsset);
            }
        } catch (SQLException ex) {
            Logger.getLogger(testFrame3Tim.class.getName()).log(Level.SEVERE, null, ex);
        }
    }