Package model

Examples of model.Album


  }
  public void valueChanged(ListSelectionEvent e) {
    if (!e.getValueIsAdjusting()) {
      int row = table.getSelectedRow();
      if (row>=0) {
        Album selection = ((Album)table.getModel().getValueAt(row, 0));
        view.albumSelected(selection);
      }
     
    }
  }
View Full Code Here


    artists = new ScrollByClickOnHeaderTable(art, new String[]{"Interpreten"}, ml);
   
    //übertragen der Albums in table-gerechtes array
    length=lib.getAlbums().length;
    Album[][] alb = new Album[length+1][length+1];
    alb[0][0] = new Album(0, "Alle ("+length+")");    //<-- Die 0 als ID signalisiert, dass Alle angezeigt werden sollen
    for (int i = 1; i <= length; i++) {
      alb[i][0] = lib.getAlbums()[i-1];// i-1 weil alle noch oben drüber steht und i bei eins beginnt.
    }
    albums = new ScrollByClickOnHeaderTable(alb, new String[]{"Alben"}, ml);
   
View Full Code Here

          "inner join artists as a on a.id = al.artist " +
          "order by lower(al.name) asc");
      try {
       
        while(rsTemp.next()) {
          alben.add(new Album(rsTemp.getInt("id"), rsTemp.getString("name")));
          length++;
        }
        rsTemp.close();
      } catch (SQLException e) {
        e.printStackTrace();
        return;
      }
     
      alb =  new Album[length+1][1];
      alb[0][0]=(new Album(0, "Alle("+length+")"));
      length++;
      for (int i=1; i<length; i++) {
        alb[i][0] = alben.get(i-1);
       
      }
      //alben-tabelle aktualisieren
      String[] cols = {"Alben"};
      DefaultTableModel model = new DefaultTableModel(alb, cols);
      albums.setModel(model);
      //track-table aktualisieren.
      List<Track> tracks = new ArrayList<Track>();
      rsTemp = PhoenixCore.DBCON.executeOnLib("select t.id, t.name, ar.id as artistID, t.album as albumID, " +// und alle titel holen
          "t.genre, t.track, t.length, t.checked, t.path, ar.name as artistName, al.name as albumName " +
          "from tracks t inner join albums al on t.album=al.id inner join artists ar on al.artist=ar.id " +
          " order by lower(artistName), lower(albumName), t.track asc");
      try {
        while(rsTemp.next()) {
//          tracks.add(new Track(rsTemp.getInt("id"), rsTemp.getString("name"),
//              rsTemp.getString("artistName"), rsTemp.getString("albumName"), rsTemp
//              .getString("genre"), rsTemp.getString("track"), rsTemp
//              .getInt("length"), rsTemp.getInt("artistID"), rsTemp
//              .getInt("albumID"), rsTemp.getInt("checked") == 1 ? true
//              : false, rsTemp.getString("path")));
          tracks.add(new Track(rsTemp.getInt("id")));
        }
        rsTemp.close();
      } catch (SQLException e) {
        e.printStackTrace();
        return;
      }
      ((TrackTable)trackTable).setTracksInLib(tracks);
    }else {//ein "echter" interpret wurde selektiert.
      rsTemp = PhoenixCore.DBCON.executeOnLib("SELECT al.id, al.name from albums as al " +//alben vom interpreten holen
          "inner join artists as a on a.id = al.artist where al.artist = "
          +selectedArtist.getId()+" order by lower(al.name) asc");
      try {
       
        while(rsTemp.next()) {
          alben.add(new Album(rsTemp.getInt("id"), rsTemp.getString("name")));
          length++;
        }
        rsTemp.close();
      } catch (SQLException e) {
        e.printStackTrace();
        return;
      }
     
      alb =  new Album[length+1][1];
      alb[0][0]=(new Album(0, "Alle("+length+")", selectedArtist.getId(), selectedArtist.getName()));
      length++;
      for (int i=1; i<length; i++) {
        alb[i][0] = alben.get(i-1);
      }
      //alben-tabelle aktualisieren
View Full Code Here

TOP

Related Classes of model.Album

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.