package mediam;
import java.io.*;
//f�r File Chooser
//import java.awt.*;
//import java.awt.event.*;
import javax.swing.*;
//import javax.swing.filechooser.*;
// Ende f�r FileChooser
import javax.swing.ListSelectionModel;
import java.sql.*;
//import javax.media.bean.playerbean.MediaPlayer;
//import com.mysql.jdbc.jdbc2.optional.MySqlDataSource;
//import com.sun.media.*;
//import java.lang.*;
import java.awt.event.KeyEvent;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;
import java.awt.Event;
import java.awt.BorderLayout;
import javax.swing.SwingConstants;
import javax.swing.SwingUtilities;
import javax.swing.KeyStroke;
import java.awt.Point;
import javax.swing.JFileChooser;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JMenuItem;
import javax.swing.JMenuBar;
import javax.swing.JMenu;
import javax.swing.JFrame;
import javax.swing.JDialog;
import javax.swing.JButton;
import java.awt.Rectangle;
import java.awt.Dimension;
import javax.swing.JTextPane;
import java.awt.Cursor;
import javax.swing.JList;
import javax.swing.JTextArea;
import javax.swing.JTable;
import javax.swing.JScrollPane;
import javax.swing.JTree;
import java.awt.Color;
import javax.swing.JInternalFrame;
import javax.swing.JWindow;
import java.util.*;
import javax.swing.JViewport;
import java.awt.ComponentOrientation;
import javax.swing.JTextField;
import javax.swing.JRadioButton;
//import javax.swing.JTabbedPane;
import java.awt.GridBagLayout;
//import java.awt.GridBagConstraints;
//import javax.swing.JToolBar;
import javax.swing.ImageIcon;
import javax.swing.BorderFactory;
import javax.swing.border.BevelBorder;
import java.awt.Font;
import java.awt.Toolkit;
import javax.swing.JPasswordField;
//import javax.swing.JDesktopPane;
//import javax.swing.JOptionPane;
import javax.swing.JCheckBox;
import javax.swing.JComboBox;
import javax.swing.border.TitledBorder;
import javax.swing.WindowConstants;
import javax.swing.border.SoftBevelBorder;
import javax.swing.JScrollBar;
//import com.sun.org.apache.bcel.internal.generic.IAND;
/**
* Copyright (c) 2007 by Authors: TheAnh Vuong, Mustafa Er, Fabian Boeckmann.
* Permission is granted to copy, distribute and/or modify this document
under the terms of the GNU Free Documentation License, Version 1.2
or any later version published by the Free Software Foundation;
with no Invariant Sections, no Front-Cover Texts, and no Back-Cover
Texts. A copy of the license is included in the section entitled "GNU
Free Documentation License" (http://www.gnu.org/copyleft/fdl.html)
*/
public class MediaM {
public String strSQLStatement = "Select Nr,Titel,Zusatzbeschreibung,K�nstler as Kuenstler,Album,Genre,Erscheinungsjahr,Medientyp,Dateityp,Dateipfad from media";
private Connection conn = null;
private JFrame jFrame = null;
private JPanel jContentPane = null;
private JMenuBar jJMenuBar = null;
private JMenu fileMenu = null;
private JMenu editMenu = null;
private JMenu helpMenu = null;
private JMenuItem exitMenuItem = null;
private JMenuItem aboutMenuItem = null;
private JMenuItem cutMenuItem = null;
private JMenuItem copyMenuItem = null;
private JMenuItem pasteMenuItem = null;
private JMenuItem saveMenuItem = null;
private JDialog aboutDialog = null; // @jve:decl-index=0:visual-constraint="92,755"
private JPanel aboutContentPane = null;
private JLabel aboutVersionLabel = null;
private JButton jButtonDBAnmelden = null;
private JTextPane jTextPaneMeldungen = null;
private JButton jButtonDatenholen = null;
private JTable jTablePlaylist = null;
private JTable jTablePlaylistData = null;
private JTable jTable = null;
private JButton jButtonPlay = null;
private JTextField jTextFieldNr = null;
private JTextField jTextFieldTitel = null;
private JTextField jTextFieldZusatzbeschreibung = null;
private JTextField jTextFieldKuenstler = null;
private JTextField jTextFieldAlbum = null;
private JTextField jTextFieldGenre = null;
private JTextField jTextFieldErscheinungsjahr = null;
private JTextField jTextFieldMedientyp = null;
private JTextField jTextFieldDateityp = null;
private JTextField jTextFieldDateipfad = null;
private JLabel jLabel = null;
private JLabel jLabelNr = null;
private JLabel jLabelTitel = null;
private JLabel jLabelZusatzbeschreibung = null;
private JLabel jLabelKuenstler = null;
private JLabel jLabelAlbum = null;
private JLabel jLabelGenre = null;
private JLabel jLabelErscheinungsjahr = null;
private JLabel jLabelMedientyp = null;
private JLabel jLabelDateityp = null;
private JLabel jLabelDateipfad = null;
private JButton jButtonDatenAendern = null;
private JButton jButtonDatenSchreiben = null;
private JButton jButtonNeuAnlegen = null;
private JButton jButtonDBAbmelden = null;
private JButton jButtonDBState = null;
private JButton jButtonFileChooser = null;
private JButton jButtonFilter = null;
private JLabel jLabelUeber = null;
private JMenuItem jMenuItem = null;
private JLabel jLabel1 = null;
private JLabel jLabel11 = null;
private JLabel jLabel12 = null;
private JLabel jLabel13 = null;
private JTextField jTextFieldHost = null;
private JTextField jTextFieldUser = null;
private JTextField jTextFieldDB = null;
private JPasswordField jPasswordFieldPassword = null;
private JPanel jPanel = null;
private JScrollPane jScrollPanePlaylist = null;
private JScrollPane jScrollPaneData = null;
private JViewport jViewport1 = null;
private JButton jButtonDatenLoeschen = null;
private JLabel jLabel2 = null;
private JTextField jTextFieldPlaylistName = null;
private JScrollPane jScrollPanePlaylistData = null;
private JViewport jViewport11 = null;
private JButton jButtonPlayPlayList = null;
private JButton jButtonAddToPlayList = null;
private JButton jButtonDeleteFromPlayList = null;
private JButton jButtonAddPlayList = null;
private JLabel jLabel21 = null;
private JTextField jTextFieldPlaylistNr = null;
private JFrame jFrameFilter = null; // @jve:decl-index=0:visual-constraint="16,1115"
private JPanel jContentPaneFilter = null;
private JTextField jTextFieldWie1 = null;
private JTextField jTextFieldGleich1 = null;
private JTextField jTextFieldVon1 = null;
private JTextField jTextFieldBis1 = null;
private JLabel jLabel3 = null;
private JRadioButton jRadioButtonGleich1 = null;
private JButton jButtonOK = null;
private JCheckBox jCheckBoxFilter2 = null;
private JTextField jTextFieldWie2 = null;
private JTextField jTextFieldGleich2 = null;
private JTextField jTextFieldVon2 = null;
private JTextField jTextFieldBis2 = null;
private JComboBox jComboBoxFilter2 = null;
private JRadioButton jRadioButtonWie2 = null;
private JRadioButton jRadioButtonVon2 = null;
private JRadioButton jRadioButtonUnd = null;
private JRadioButton jRadioButtonOder = null;
private JRadioButton jRadioButtonWie1 = null;
private JRadioButton jRadioButtonVon1 = null;
private JComboBox jComboBoxFilter1 = null;
private JPanel jPanelFilter1 = null;
private JButton jButtonAbbrechen = null;
private JRadioButton jRadioButtonGleich2 = null;
private JLabel jLabel8 = null;
private JPanel jPanelFilter2 = null;
private JLabel jLabel131 = null;
private JTextField jTextFieldPlayerpfad = null;
private JButton jButtonFileChooserPlayerpfad = null;
private JPanel jPanel1 = null;
private JButton jButtonNewPlaylist = null;
private JButton jButtonPlaylistLaden = null;
private JButton jButtonDeletePlayList = null;
/**
* This method initializes jButtonDBAnmelden
*
* @return javax.swing.JButton
*/
private JButton getJButtonDBAnmelden() {
if (jButtonDBAnmelden == null) {
jButtonDBAnmelden = new JButton();
jButtonDBAnmelden.setText("LOGIN");
jButtonDBAnmelden.setBounds(new Rectangle(17, 177, 133, 36));
jButtonDBAnmelden.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
// TODO Auto-generated Event stub actionPerformed()
// Anfang an DB anmelden
String hostname = jTextFieldHost.getText();
String port = "3306";
String dbname = jTextFieldDB.getText();
String user = jTextFieldUser.getText();
String password = jPasswordFieldPassword.getText();
try {
//Class.forName("org.gjt.mm.mysql.Driver").newInstance();
Class.forName("com.mysql.jdbc.Driver").newInstance();
}
catch (Exception eg) {
System.err.println("* Treiber kann nicht geladen werden.");
eg.printStackTrace();
}
try {
String url = "jdbc:mysql://"+hostname+":"+port+"/"+dbname;
conn = DriverManager.getConnection(url, user, password);
if(!conn.isClosed()){
jTextPaneMeldungen.setText("-> Verbindiung mit der MySql-Datebank hergestellt.\n" + jTextPaneMeldungen.getText());
jButtonDBAbmelden.setEnabled(true);
jButtonDBAnmelden.setEnabled(false);
jButtonDatenholen.setEnabled(true);
jButtonFilter.setEnabled(true);
jButtonDatenAendern.setEnabled(true);
jButtonDatenLoeschen.setEnabled(true);
jButtonNeuAnlegen.setEnabled(true);
jButtonDBState.setBackground(new Color(153, 255, 153) );
jButtonDBState.setText("ON");
//conn.close();
}
}
catch (SQLException sqle) {
System.out.println("SQLException: " + sqle.getMessage());
System.out.println("SQLState: " + sqle.getSQLState());
System.out.println("VendorError: " + sqle.getErrorCode());
sqle.printStackTrace();
jTextPaneMeldungen.setText("-> Es konnte keine Verbindung mit der Datenbank hergestellt werden. Bitte pr�fen Sie Ihre Eingaben!\n" + jTextPaneMeldungen.getText());
}
}// Ende an DB anmelden
});
}
return jButtonDBAnmelden;
}
/**
* This method initializes jTextPaneMeldungen
*
* @return javax.swing.JTextPane
*/
private JTextPane getJTextPaneMeldungen() {
if (jTextPaneMeldungen == null) {
jTextPaneMeldungen = new JTextPane();
jTextPaneMeldungen.setBounds(new Rectangle(8, 613, 797, 55));
jTextPaneMeldungen.setText("Systemmeldungen:");
jTextPaneMeldungen.setCursor(new Cursor(Cursor.DEFAULT_CURSOR));
jTextPaneMeldungen.setEditable(true);
}
return jTextPaneMeldungen;
}
/**
* This method initializes jButtonDatenholen
*
* @return javax.swing.JButton
*/
private JButton getJButtonDatenholen() {
if (jButtonDatenholen == null) {
jButtonDatenholen = new JButton();
jButtonDatenholen.setBounds(new Rectangle(586, 89, 107, 36));
jButtonDatenholen.setEnabled(false);
jButtonDatenholen.setText("Daten holen");
jButtonDatenholen.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
// TODO Auto-generated Event stub actionPerformed()
jButtonDatenSchreiben.setEnabled(false);
try {
if(!conn.isClosed())
{
/*Media-Daten holen */
Statement stmt = conn.createStatement();
ResultSet result = stmt.executeQuery(strSQLStatement);
int iAnzZeilen = 0; // ANzahl der Zeilen, die die SQL-Abfrage zur�ckgibt
// SQL-Select-Befehl
ResultSetMetaData metaData = result.getMetaData();
int numberOfColumns = metaData.getColumnCount();
Vector columnNames = new Vector();
for (int column = 0; column < numberOfColumns; column++) {
columnNames.addElement(metaData.getColumnLabel(column + 1));
}
// Alle Reihen einlesen
Vector rows = new Vector();
while (result.next()) {
iAnzZeilen++;
Vector newRow = new Vector();
for (int i = 1; i <= metaData.getColumnCount(); i++) {
newRow.addElement(result.getObject(i));
}
rows.addElement(newRow);
}
jTable = new JTable(rows, columnNames);
jTable.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
jScrollPaneData.setViewportView(jTable);
jTable.getTableHeader().setReorderingAllowed(false);
//Hintergrund der Tabelle setzen
jTable.setBackground(new Color(255, 255, 128));
jTextPaneMeldungen.setText("-> Es wurden " + iAnzZeilen + " Medien-Datens�tze aus der Datenbank gelesen.\n" + jTextPaneMeldungen.getText());
/*ENDE Medien-Daten holen */
/*Playlist-Daten holen */
jTextFieldPlaylistNr.setText("0");
jTextFieldPlaylistName.setText(" ");
Statement stmt_playlist = conn.createStatement();
//String strSQLStatement = "Select nr,Titel,Zusatzbeschreibung,K�nstler as Kuenstler,Album,Genre,Erscheinungsjahr,Medientyp,Dateityp,Dateipfad from media";
ResultSet result_playlist = stmt_playlist.executeQuery("select Nr,Name from playlist order by nr");
int iAnzZeilen_playlist = 0; // ANzahl der Zeilen, die die SQL-Abfrage zur�ckgibt
// SQL-Select-Befehl
ResultSetMetaData metaData_playlist = result_playlist.getMetaData();
int numberOfColumns_playlist = metaData_playlist.getColumnCount();
Vector columnNames_playlist = new Vector();
for (int column_playlist = 0; column_playlist < numberOfColumns_playlist; column_playlist++) {
columnNames_playlist.addElement(metaData_playlist.getColumnLabel(column_playlist + 1));
}
// Alle Reihen einlesen
Vector rows_playlist = new Vector();
while (result_playlist.next()) {
iAnzZeilen_playlist++;
Vector newRow_playlist = new Vector();
for (int i_playlist = 1; i_playlist <= metaData_playlist.getColumnCount(); i_playlist++) {
newRow_playlist.addElement(result_playlist.getObject(i_playlist));
}
rows_playlist.addElement(newRow_playlist);
}
//JTable jTablePlaylist;
jTablePlaylist = new JTable(rows_playlist, columnNames_playlist);
jTablePlaylist.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
jScrollPanePlaylist.setViewportView(jTablePlaylist);
jTablePlaylist.getTableHeader().setReorderingAllowed(false);
//Hintergrund der Tabelle setzen
jTablePlaylist.setBackground(new Color(255, 255, 128));
jTextPaneMeldungen.setText("-> Es wurden " + iAnzZeilen_playlist + " Playlist-Datens�tze aus der Datenbank gelesen.\n" + jTextPaneMeldungen.getText());
/* ENDE Playlist-Daten holen */
/*Playlist-Song-Daten holen */
Statement stmt_playlistdata = conn.createStatement();
//String strSQLStatement = "Select nr,Titel,Zusatzbeschreibung,K�nstler as Kuenstler,Album,Genre,Erscheinungsjahr,Medientyp,Dateityp,Dateipfad from media";
ResultSet result_playlistdata = stmt_playlistdata.executeQuery("select playlistdata.SongNr,playlistdata.titel,media.dateipfad from playlistdata left outer Join media on media.Nr = playlistdata.songnr where playlistnr = 0 ");
int iAnzZeilen_playlistdata = 0; // ANzahl der Zeilen, die die SQL-Abfrage zur�ckgibt
// SQL-Select-Befehl
ResultSetMetaData metaData_playlistdata = result_playlistdata.getMetaData();
int numberOfColumns_playlistdata = metaData_playlistdata.getColumnCount();
Vector columnNames_playlistdata = new Vector();
for (int column_playlistdata = 0; column_playlistdata < numberOfColumns_playlistdata; column_playlistdata++) {
columnNames_playlistdata.addElement(metaData_playlistdata.getColumnLabel(column_playlistdata + 1));
}
// Alle Reihen einlesen
Vector rows_playlistdata = new Vector();
while (result_playlistdata.next()) {
iAnzZeilen_playlistdata++;
Vector newRow_playlistdata = new Vector();
for (int i_playlistdata = 1; i_playlistdata <= metaData_playlistdata.getColumnCount(); i_playlistdata++) {
newRow_playlistdata.addElement(result_playlistdata.getObject(i_playlistdata));
}
rows_playlistdata.addElement(newRow_playlistdata);
}
//JTable jTablePlaylist;
jTablePlaylistData = new JTable(rows_playlistdata, columnNames_playlistdata);
jTablePlaylistData.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
jScrollPanePlaylistData.setViewportView(jTablePlaylistData);
jTablePlaylistData.getTableHeader().setReorderingAllowed(false);
//Hintergrund der Tabelle setzen
jTablePlaylistData.setBackground(new Color(255, 255, 128));
jTextPaneMeldungen.setText("-> Es wurden " + iAnzZeilen_playlistdata + " Playlist-Medien-Datens�tze aus der Datenbank gelesen.\n" + jTextPaneMeldungen.getText());
/* ENDE Playlist-Song-Daten holen */
}// Ende try
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}// ENDE if(!conn.isCloses())
}
});
}
return jButtonDatenholen;
}
/**
* This method initializes jScrollPaneData
*
* @return javax.swing.JScrollPane
*/
private JScrollPane getJScrollPaneData() {
if (jScrollPaneData == null) {
JScrollBar jScrollBar = new JScrollBar();
jScrollBar.setCursor(new Cursor(Cursor.DEFAULT_CURSOR));
JViewport jViewport = new JViewport();
jViewport.setCursor(new Cursor(Cursor.DEFAULT_CURSOR));
jViewport.setEnabled(true);
jViewport.setOpaque(true);
jViewport.setScrollMode(1);
jViewport.setComponentOrientation(ComponentOrientation.LEFT_TO_RIGHT);
jScrollPaneData = new JScrollPane();
jScrollPaneData.setBounds(new Rectangle(7, 307, 800, 301));
jScrollPaneData.setBackground(Color.lightGray);
jScrollPaneData.setCursor(new Cursor(Cursor.DEFAULT_CURSOR));
jScrollPaneData.setHorizontalScrollBar(jScrollBar);
jScrollPaneData.setColumnHeader(jViewport);
}
return jScrollPaneData;
}
/**
* This method initializes jTable
*
* @return javax.swing.JTable
*/
private JTable getJTable() {
if (jTable == null) {
jTable = new JTable();
jTable.setBackground(new Color(255, 255, 128));
//jTable.setBounds(new Rectangle(65, 27, 347, 119));
}
return jTable;
}
private JTable getJTablePlaylist() {
if (jTablePlaylist == null) {
jTablePlaylist = new JTable();
jTablePlaylist.setBackground(new Color(255, 255, 128));
//jTable.setBounds(new Rectangle(65, 27, 347, 119));
}
return jTablePlaylist;
}
/**
* This method initializes jButtonPlay
*
* @return javax.swing.JButton
*/
private JButton getJButtonPlay() {
if (jButtonPlay == null) {
jButtonPlay = new JButton();
jButtonPlay.setText("PLAY");
jButtonPlay.setBounds(new Rectangle(589, 9, 148, 69));
jButtonPlay.setIcon(new ImageIcon(getClass().getResource("/mediam/Bilder/tplayh.gif")));
jButtonPlay.setBorder(BorderFactory.createBevelBorder(BevelBorder.RAISED));
jButtonPlay.setFont(new Font("John Handy LET", Font.BOLD, 18));
jButtonPlay.setForeground(new Color(153, 0, 51));
jButtonPlay.setBackground(new Color(204, 204, 255));
jButtonPlay.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
// TODO Auto-generated Event stub actionPerformed()
try {
//Runtime.getRuntime().exec("C:\\Programme\\Windows Media Player\\wmplayer.exe");
//String cmdstart[] = { "cmd.exe", "dir"};
int iaktuelleZeile = jTable.getSelectedRow();
Object sDateipfad = jTable.getValueAt(iaktuelleZeile, 9);
Runtime.getRuntime().exec(jTextFieldPlayerpfad.getText() + " /prefetch:1 "+"\""+sDateipfad+"\"");
} catch (Exception e2) {
System.err.println(e2.toString());
} // Ende try Runtime.getRuntime
}
});
}
return jButtonPlay;
}
/**
* This method initializes jTextFieldNr
*
* @return javax.swing.JTextField
*/
private JTextField getJTextFieldNr() {
if (jTextFieldNr == null) {
jTextFieldNr = new JTextField();
jTextFieldNr.setBounds(new Rectangle(375, 10, 200, 20));
jTextFieldNr.setBackground(Color.white);
jTextFieldNr.setColumns(0);
jTextFieldNr.setSelectionEnd(30);
jTextFieldNr.setEnabled(false);
}
return jTextFieldNr;
}
/**
* This method initializes jTextFieldTitel
*
* @return javax.swing.JTextField
*/
private JTextField getJTextFieldTitel() {
if (jTextFieldTitel == null) {
jTextFieldTitel = new JTextField();
jTextFieldTitel.setBounds(new Rectangle(375, 40, 200, 20));
jTextFieldTitel.setEnabled(false);
}
return jTextFieldTitel;
}
/**
* This method initializes jTextFieldZusatzbeschreibung
*
* @return javax.swing.JTextField
*/
private JTextField getJTextFieldZusatzbeschreibung() {
if (jTextFieldZusatzbeschreibung == null) {
jTextFieldZusatzbeschreibung = new JTextField();
jTextFieldZusatzbeschreibung.setBounds(new Rectangle(375, 70, 200, 20));
jTextFieldZusatzbeschreibung.setEnabled(false);
}
return jTextFieldZusatzbeschreibung;
}
/**
* This method initializes jTextFieldKuenstler
*
* @return javax.swing.JTextField
*/
private JTextField getJTextFieldKuenstler() {
if (jTextFieldKuenstler == null) {
jTextFieldKuenstler = new JTextField();
jTextFieldKuenstler.setBounds(new Rectangle(375, 100, 200, 20));
jTextFieldKuenstler.setEnabled(false);
}
return jTextFieldKuenstler;
}
/**
* This method initializes jTextFieldAlbum
*
* @return javax.swing.JTextField
*/
private JTextField getJTextFieldAlbum() {
if (jTextFieldAlbum == null) {
jTextFieldAlbum = new JTextField();
jTextFieldAlbum.setBounds(new Rectangle(375, 130, 200, 20));
jTextFieldAlbum.setEnabled(false);
}
return jTextFieldAlbum;
}
/**
* This method initializes jTextFieldGenre
*
* @return javax.swing.JTextField
*/
private JTextField getJTextFieldGenre() {
if (jTextFieldGenre == null) {
jTextFieldGenre = new JTextField();
jTextFieldGenre.setBounds(new Rectangle(375, 160, 200, 20));
jTextFieldGenre.setEnabled(false);
}
return jTextFieldGenre;
}
/**
* This method initializes jTextFieldErscheinungsjahr
*
* @return javax.swing.JTextField
*/
private JTextField getJTextFieldErscheinungsjahr() {
if (jTextFieldErscheinungsjahr == null) {
jTextFieldErscheinungsjahr = new JTextField();
jTextFieldErscheinungsjahr.setBounds(new Rectangle(375, 190, 200, 20));
jTextFieldErscheinungsjahr.setEnabled(false);
}
return jTextFieldErscheinungsjahr;
}
/**
* This method initializes jTextFieldMedientyp
*
* @return javax.swing.JTextField
*/
private JTextField getJTextFieldMedientyp() {
if (jTextFieldMedientyp == null) {
jTextFieldMedientyp = new JTextField();
jTextFieldMedientyp.setBounds(new Rectangle(375, 220, 200, 20));
jTextFieldMedientyp.setEnabled(false);
}
return jTextFieldMedientyp;
}
/**
* This method initializes jTextFieldDateityp
*
* @return javax.swing.JTextField
*/
private JTextField getJTextFieldDateityp() {
if (jTextFieldDateityp == null) {
jTextFieldDateityp = new JTextField();
jTextFieldDateityp.setBounds(new Rectangle(375, 250, 200, 20));
jTextFieldDateityp.setEnabled(false);
}
return jTextFieldDateityp;
}
/**
* This method initializes jTextFieldDateipfad
*
* @return javax.swing.JTextField
*/
private JTextField getJTextFieldDateipfad() {
if (jTextFieldDateipfad == null) {
jTextFieldDateipfad = new JTextField();
jTextFieldDateipfad.setBounds(new Rectangle(375, 280, 167, 20));
jTextFieldDateipfad.setEnabled(false);
}
return jTextFieldDateipfad;
}
/**
* This method initializes jButtonDatenAendern
*
* @return javax.swing.JButton
*/
private JButton getJButtonDatenAendern() {
if (jButtonDatenAendern == null) {
jButtonDatenAendern = new JButton();
jButtonDatenAendern.setBounds(new Rectangle(586, 132, 152, 36));
jButtonDatenAendern.setEnabled(false);
jButtonDatenAendern.setIcon(new ImageIcon(getClass().getResource("/mediam/Bilder/edit_50percent.GIF")));
jButtonDatenAendern.setText(" �ndern");
jButtonDatenAendern.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
//System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
int iaktuelleZeile = jTable.getSelectedRow();
if(iaktuelleZeile>=0){
jTable.setEnabled(false);
jButtonNeuAnlegen.setEnabled(false);
jButtonDatenholen.setEnabled(false);
jButtonFilter.setEnabled(false);
jButtonDBAbmelden.setEnabled(false);
jTable.setBackground(new Color(255,153,153));
jButtonDatenSchreiben.setEnabled(true);
Object sNr = jTable.getValueAt(iaktuelleZeile, 0);
Object sTitel = jTable.getValueAt(iaktuelleZeile, 1);
Object sZusatzbeschreibung = jTable.getValueAt(iaktuelleZeile, 2);
Object sKuenstler = jTable.getValueAt(iaktuelleZeile, 3);
Object sAlbum = jTable.getValueAt(iaktuelleZeile, 4);
Object sGenre = jTable.getValueAt(iaktuelleZeile, 5);
Object sErscheinungsjahr = jTable.getValueAt(iaktuelleZeile, 6);
Object sMedientyp = jTable.getValueAt(iaktuelleZeile, 7);
Object sDateityp = jTable.getValueAt(iaktuelleZeile, 8);
Object sDateipfad = jTable.getValueAt(iaktuelleZeile, 9);
jTextFieldNr.setText(sNr.toString());
jTextFieldTitel.setText((String)sTitel);
jTextFieldZusatzbeschreibung.setText((String)sZusatzbeschreibung);
jTextFieldKuenstler.setText((String)sKuenstler);
jTextFieldAlbum.setText((String)sAlbum);
jTextFieldGenre.setText((String)sGenre);
jTextFieldErscheinungsjahr.setText((String)sErscheinungsjahr);
jTextFieldMedientyp.setText((String)sMedientyp);
jTextFieldDateityp.setText((String)sDateityp);
jTextFieldDateipfad.setText((String)sDateipfad);
jTextFieldNr.setEnabled(false);
jTextFieldTitel.setEnabled(true);
jTextFieldZusatzbeschreibung.setEnabled(true);
jTextFieldKuenstler.setEnabled(true);
jTextFieldAlbum.setEnabled(true);
jTextFieldGenre.setEnabled(true);
jTextFieldErscheinungsjahr.setEnabled(true);
jTextFieldMedientyp.setEnabled(true);
jTextFieldDateityp.setEnabled(true);
jTextFieldDateipfad.setEnabled(true);
}//ENDE if(iaktuelleZeile>=0){
}
});
}
return jButtonDatenAendern;
}
/**
* This method initializes jButtonDatenSchreiben
*
* @return javax.swing.JButton
*/
private JButton getJButtonDatenSchreiben() {
if (jButtonDatenSchreiben == null) {
jButtonDatenSchreiben = new JButton();
jButtonDatenSchreiben.setBounds(new Rectangle(586, 176, 152, 36));
jButtonDatenSchreiben.setRolloverEnabled(true);
jButtonDatenSchreiben.setActionCommand("�nderung speichern");
jButtonDatenSchreiben.setEnabled(false);
jButtonDatenSchreiben.setMnemonic(KeyEvent.VK_UNDEFINED);
jButtonDatenSchreiben.setIcon(new ImageIcon(getClass().getResource("/mediam/Bilder/save_as_50percent.GIF")));
jButtonDatenSchreiben.setText(" Speichern");
jButtonDatenSchreiben.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
jButtonDatenSchreiben.setEnabled(false);
jButtonNeuAnlegen.setEnabled(true);
jButtonDatenholen.setEnabled(true);
jButtonFilter.setEnabled(true);
jButtonDBAbmelden.setEnabled(true);
jTable.setEnabled(true);
jTextFieldNr.setEnabled(false);
jTextFieldTitel.setEnabled(false);
jTextFieldZusatzbeschreibung.setEnabled(false);
jTextFieldKuenstler.setEnabled(false);
jTextFieldAlbum.setEnabled(false);
jTextFieldGenre.setEnabled(false);
jTextFieldErscheinungsjahr.setEnabled(false);
jTextFieldMedientyp.setEnabled(false);
jTextFieldDateityp.setEnabled(false);
jTextFieldDateipfad.setEnabled(false);
jTable.setBackground(new Color(255,255,128));
jButtonDatenAendern.setEnabled(true);
jButtonDatenLoeschen.setEnabled(true);
// Daten schreiben
try {
if(!conn.isClosed()){
// Es wurde ein neuer Datensatz angelegt
if (jTextFieldNr.getText().equals("0")){
String newString = null;
Statement newstmt = conn.createStatement();
newString = "insert into media (titel,album,dateipfad,dateityp,erscheinungsjahr,genre,k�nstler,medientyp,zusatzbeschreibung)" +
"values ('" + jTextFieldTitel.getText() + "'"
+ ",'" + jTextFieldAlbum.getText() + "'"
+ ",'" + jTextFieldDateipfad.getText().replaceAll("\\\\", "\\\\\\\\") + "'"
+ ",'" + jTextFieldDateityp.getText() + "'"
+ ",'" + jTextFieldErscheinungsjahr.getText() + "'"
+ ",'" + jTextFieldGenre.getText() + "'"
+ ",'" + jTextFieldKuenstler.getText() + "'"
+ ",'" + jTextFieldMedientyp.getText()+ "'"
+ ",'" + jTextFieldZusatzbeschreibung.getText() + "'"
+ ");";
boolean newresult = newstmt.execute(newString);
// Aktualisieren der Ausgabe
Statement stmt = conn.createStatement();
ResultSet result = stmt.executeQuery("Select nr,Titel,Zusatzbeschreibung,K�nstler as Kuenstler,Album,Genre,Erscheinungsjahr,Medientyp,Dateityp,Dateipfad from media where nr = (select max(nr) from media) UNION ALL " + strSQLStatement);
// SQL-Select-Befehl
ResultSetMetaData metaData = result.getMetaData();
int numberOfColumns = metaData.getColumnCount();
Vector columnNames = new Vector();
for (int column = 0; column < numberOfColumns; column++) {
columnNames.addElement(metaData.getColumnLabel(column + 1));
}
//Alle Reihen einlesen
Vector rows = new Vector();
while (result.next()) {
Vector newRow = new Vector();
for (int i = 1; i <= metaData.getColumnCount(); i++) {
newRow.addElement(result.getObject(i));
}
rows.addElement(newRow);
}
jTable = new JTable(rows, columnNames);
jTable.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
jScrollPaneData.setViewportView(jTable);
jTable.getTableHeader().setReorderingAllowed(false);
//Hintergrund der Tabelle setzen
jTable.setBackground(new Color(255, 255, 128));
// Ende Aktualsieren der Ausgaba
}//if (jTextFieldNr.getText().equals("0")){
//Ende Es wurde ein neuer Datensatz angelegt
// Ein bestehender Datensatz wird ver�ndert
if (!jTextFieldNr.getText().equals("0")){
String updateString = null;
Statement upstmt = conn.createStatement();
updateString = "update media set titel = '" + jTextFieldTitel.getText() + "'"
+ ",album = '" + jTextFieldAlbum.getText() + "'"
+ ",Dateipfad = '" + jTextFieldDateipfad.getText().replaceAll("\\\\", "\\\\\\\\") + "'"
+ ",Dateityp = '" + jTextFieldDateityp.getText() + "'"
+ ",Erscheinungsjahr = '" + jTextFieldErscheinungsjahr.getText() + "'"
+ ",genre = '" + jTextFieldGenre.getText() + "'"
+ ",k�nstler = '" + jTextFieldKuenstler.getText() + "'"
+ ",medientyp = '" + jTextFieldMedientyp.getText()+ "'"
+ ",zusatzbeschreibung = '" + jTextFieldZusatzbeschreibung.getText() + "'"
+ " where nr=" + jTextFieldNr.getText() + ";";
int upresult = upstmt.executeUpdate(updateString);
// Wenn der Datensatz aktualisiert werden konnte
// werden die neuen Inhalte in die untere Tabelle
// �bernommen und dargestellt
if (upresult > 0){
jTable.setValueAt(jTextFieldTitel.getText(), jTable.getSelectedRow(), 1);
jTable.setValueAt(jTextFieldZusatzbeschreibung.getText(), jTable.getSelectedRow(), 2);
jTable.setValueAt(jTextFieldKuenstler.getText(), jTable.getSelectedRow(), 3);
jTable.setValueAt(jTextFieldAlbum.getText(), jTable.getSelectedRow(), 4);
jTable.setValueAt(jTextFieldGenre.getText(), jTable.getSelectedRow(), 5);
jTable.setValueAt(jTextFieldErscheinungsjahr.getText(), jTable.getSelectedRow(), 6);
jTable.setValueAt(jTextFieldMedientyp.getText(), jTable.getSelectedRow(), 7);
jTable.setValueAt(jTextFieldDateityp.getText(), jTable.getSelectedRow(), 8);
jTable.setValueAt(jTextFieldDateipfad.getText(), jTable.getSelectedRow(), 9);
}// ENDE if upresult(>0){
}//if (!jTextFieldNr.getText().equals("0")){
//Ende // Ein bestehender Datensatz wird ver�ndert
}// Ende if(!conn.isClosed()){
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
} // Ende try
//
// Ende Daten schreiben
}
});
}
return jButtonDatenSchreiben;
}
/**
* This method initializes jButtonNeuAnlegen
*
* @return javax.swing.JButton
*/
private JButton getJButtonNeuAnlegen() {
if (jButtonNeuAnlegen == null) {
jButtonNeuAnlegen = new JButton();
jButtonNeuAnlegen.setBounds(new Rectangle(587, 264, 151, 36));
jButtonNeuAnlegen.setRolloverEnabled(true);
jButtonNeuAnlegen.setText(" Neu");
jButtonNeuAnlegen.setEnabled(false);
jButtonNeuAnlegen.setMnemonic(KeyEvent.VK_UNDEFINED);
jButtonNeuAnlegen.setIcon(new ImageIcon(getClass().getResource("/mediam/Bilder/empty_document_50percent.GIF")));
jButtonNeuAnlegen.setActionCommand("�nderung speichern");
jButtonNeuAnlegen.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
jTextFieldNr.setEnabled(false);
jTextFieldTitel.setEnabled(true);
jTextFieldZusatzbeschreibung.setEnabled(true);
jTextFieldKuenstler.setEnabled(true);
jTextFieldAlbum.setEnabled(true);
jTextFieldGenre.setEnabled(true);
jTextFieldErscheinungsjahr.setEnabled(true);
jTextFieldMedientyp.setEnabled(true);
jTextFieldDateityp.setEnabled(true);
jTextFieldDateipfad.setEnabled(true);
jTextFieldNr.setText("0");
jTextFieldTitel.setText("");
jTextFieldZusatzbeschreibung.setText("");
jTextFieldKuenstler.setText("");
jTextFieldAlbum.setText("");
jTextFieldGenre.setText("");
jTextFieldErscheinungsjahr.setText("");
jTextFieldMedientyp.setText("");
jTextFieldDateityp.setText("");
jTextFieldDateipfad.setText("");
jButtonDatenAendern.setEnabled(false);
jButtonDatenLoeschen.setEnabled(false);
jButtonDatenSchreiben.setEnabled(true);
//Ende Action performed
}
});
}
return jButtonNeuAnlegen;
}
/**
* This method initializes jButtonDBAbmelden
*
* @return javax.swing.JButton
*/
private JButton getJButtonDBAbmelden() {
if (jButtonDBAbmelden == null) {
jButtonDBAbmelden = new JButton();
jButtonDBAbmelden.setEnabled(false);
jButtonDBAbmelden.setBounds(new Rectangle(17, 216, 133, 36));
jButtonDBAbmelden.setText("LOGOFF");
jButtonDBAbmelden.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
try {
if(!conn.isClosed()){
conn.close();
jButtonDBAnmelden.setEnabled(true);
jButtonDBAbmelden.setEnabled(false);
jButtonDatenholen.setEnabled(false);
jButtonFilter.setEnabled(false);
jButtonDatenAendern.setEnabled(false);
jButtonDatenLoeschen.setEnabled(false);
jButtonDBState.setBackground(new Color(255, 153, 153) );
jButtonDBState.setText("OFF");
jButtonNeuAnlegen.setEnabled(false);
jTextPaneMeldungen.setText("-> Datenbankverbindung wurde getrennt.\n" + jTextPaneMeldungen.getText());
}
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
}
});
}
return jButtonDBAbmelden;
}
/**
* This method initializes jButtonDBState
*
* @return javax.swing.JButton
*/
private JButton getJButtonDBState() {
if (jButtonDBState == null) {
jButtonDBState = new JButton();
jButtonDBState.setText("OFF");
jButtonDBState.setEnabled(true);
jButtonDBState.setRolloverEnabled(false);
jButtonDBState.setToolTipText("Datenbank Status");
jButtonDBState.setBounds(new Rectangle(118, 7, 61, 26));
jButtonDBState.setBackground(new Color(255, 153, 153));
}
return jButtonDBState;
}
/**
* This method initializes jButtonFileChooser
*
* @return javax.swing.JButton
*/
private JButton getJButtonFileChooser() {
if (jButtonFileChooser == null) {
jButtonFileChooser = new JButton();
jButtonFileChooser.setBounds(new Rectangle(545, 277, 30, 23));
jButtonFileChooser.setIcon(new ImageIcon(getClass().getResource("/mediam/Bilder/open_file_50percent.GIF")));
jButtonFileChooser.setBackground(new Color(204, 204, 204));
jButtonFileChooser.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
// ANfang
if (jTextFieldDateityp.isEnabled()){
//Create a file chooser
JFileChooser fc = new JFileChooser();
// int returnVal = fc.showOpenDialog(FileChooser.this);
int returnVal = fc.showOpenDialog(jFrame);
if (returnVal == JFileChooser.APPROVE_OPTION) {
File file = fc.getSelectedFile();
jTextFieldDateipfad.setText(file.getAbsolutePath().toString());
}
}//if (jTextFieldDateityp.isEnabled())
// ENDE
}
});
}
return jButtonFileChooser;
}
/**
* This method initializes jButtonFilter
*
* @return javax.swing.JButton
*/
private JButton getJButtonFilter() {
if (jButtonFilter == null) {
jButtonFilter = new JButton();
jButtonFilter.setBounds(new Rectangle(696, 89, 40, 36));
jButtonFilter.setEnabled(false);
jButtonFilter.setIcon(new ImageIcon(getClass().getResource("/mediam/Bilder/filter_50percent.GIF")));
jButtonFilter.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
// Anfang Filter FB
//strSQLStatement = "Select nr,Titel,Zusatzbeschreibung,K�nstler as Kuenstler,Album,Genre,Erscheinungsjahr,Medientyp,Dateityp,Dateipfad from media";
getJFrameFilter().setVisible(true);
getJFrame().setEnabled(false);
// inkl. Where
// Ende Filter FB
}
});
}
return jButtonFilter;
}
/**
* This method initializes jMenuItem
*
* @return javax.swing.JMenuItem
*/
private JMenuItem getJMenuItem() {
if (jMenuItem == null) {
jMenuItem = new JMenuItem();
}
return jMenuItem;
}
/**
* This method initializes jTextFieldHost
*
* @return javax.swing.JTextField
*/
private JTextField getJTextFieldHost() {
if (jTextFieldHost == null) {
jTextFieldHost = new JTextField();
jTextFieldHost.setText("localhost");
jTextFieldHost.setBounds(new Rectangle(81, 9, 71, 20));
}
return jTextFieldHost;
}
/**
* This method initializes jTextFieldUser
*
* @return javax.swing.JTextField
*/
private JTextField getJTextFieldUser() {
if (jTextFieldUser == null) {
jTextFieldUser = new JTextField();
jTextFieldUser.setText("root");
jTextFieldUser.setBounds(new Rectangle(81, 51, 71, 20));
}
return jTextFieldUser;
}
/**
* This method initializes jTextFieldDB
*
* @return javax.swing.JTextField
*/
private JTextField getJTextFieldDB() {
if (jTextFieldDB == null) {
jTextFieldDB = new JTextField();
jTextFieldDB.setText("MediaM");
jTextFieldDB.setBounds(new Rectangle(81, 30, 71, 20));
}
return jTextFieldDB;
}
/**
* This method initializes jPasswordFieldPassword
*
* @return javax.swing.JPasswordField
*/
private JPasswordField getJPasswordFieldPassword() {
if (jPasswordFieldPassword == null) {
jPasswordFieldPassword = new JPasswordField();
jPasswordFieldPassword.setBounds(new Rectangle(81, 72, 71, 20));
jPasswordFieldPassword.setText("");
}
return jPasswordFieldPassword;
}
/**
* This method initializes jPanel
*
* @return javax.swing.JPanel
*/
private JPanel getJPanel() {
if (jPanel == null) {
jLabel131 = new JLabel();
jLabel131.setBounds(new Rectangle(9, 107, 67, 20));
jLabel131.setText("Playerpfad");
jPanel = new JPanel();
jPanel.setLayout(null);
jPanel.setBounds(new Rectangle(10, 35, 168, 266));
jPanel.setBackground(new Color(204, 153, 0));
jPanel.add(getJButtonDBAbmelden(), null);
jPanel.add(getJPasswordFieldPassword(), null);
jPanel.add(jLabel13, null);
jPanel.add(jLabel11, null);
jPanel.add(getJTextFieldUser(), null);
jPanel.add(getJTextFieldDB(), null);
jPanel.add(getJTextFieldHost(), null);
jPanel.add(jLabel1, null);
jPanel.add(jLabel12, null);
jPanel.add(getJButtonDBAnmelden(), null);
jPanel.add(jLabel131, null);
jPanel.add(getJTextFieldPlayerpfad(), null);
jPanel.add(getJButtonFileChooserPlayerpfad(), null);
}
return jPanel;
}
/**
* This method initializes jScrollPanePlaylist
*
* @return javax.swing.JScrollPane
*/
private JScrollPane getJScrollPanePlaylist() {
if (jScrollPanePlaylist == null) {
jScrollPanePlaylist = new JScrollPane();
jScrollPanePlaylist.setBounds(new Rectangle(807, 307, 202, 81));
jScrollPanePlaylist.setColumnHeader(getJViewport1());
jScrollPanePlaylist.setBackground(Color.lightGray);
}
return jScrollPanePlaylist;
}
/**
* This method initializes jViewport1
*
* @return javax.swing.JViewport
*/
private JViewport getJViewport1() {
if (jViewport1 == null) {
jViewport1 = new JViewport();
jViewport1.setComponentOrientation(ComponentOrientation.LEFT_TO_RIGHT);
jViewport1.setEnabled(true);
jViewport1.setOpaque(true);
jViewport1.setScrollMode(1);
jViewport1.setCursor(new Cursor(Cursor.DEFAULT_CURSOR));
}
return jViewport1;
}
/**
* This method initializes jButtonDatenLoeschen
*
* @return javax.swing.JButton
*/
private JButton getJButtonDatenLoeschen() {
if (jButtonDatenLoeschen == null) {
jButtonDatenLoeschen = new JButton();
jButtonDatenLoeschen.setBounds(new Rectangle(587, 220, 151, 36));
jButtonDatenLoeschen.setMnemonic(KeyEvent.VK_UNDEFINED);
jButtonDatenLoeschen.setActionCommand("�nderung speichern");
jButtonDatenLoeschen.setIcon(new ImageIcon(getClass().getResource("/mediam/Bilder/erase_50percent.GIF")));
jButtonDatenLoeschen.setRolloverEnabled(true);
jButtonDatenLoeschen.setText("L�schen");
jButtonDatenLoeschen.setEnabled(false);
jButtonDatenLoeschen.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
// Anfang Button-L�schen
int iaktuelleZeile = jTable.getSelectedRow();
if(iaktuelleZeile>=0){
try {
if(!conn.isClosed())
{
/*Datensatz l�schen*/
Statement stmt = conn.createStatement();
boolean result_delete = stmt.execute("delete from media where nr="+jTable.getValueAt(iaktuelleZeile, 0));
jTextPaneMeldungen.setText("-> Es wurde 1 Medien-Datensatz aus der Datenbank gel�scht.\n" + jTextPaneMeldungen.getText());
// Darstellung Median-Daten neu aufbauen
ResultSet result = stmt.executeQuery(strSQLStatement);
int iAnzZeilen = 0; // ANzahl der Zeilen, die die SQL-Abfrage zur�ckgibt
// SQL-Select-Befehl
ResultSetMetaData metaData = result.getMetaData();
int numberOfColumns = metaData.getColumnCount();
Vector columnNames = new Vector();
for (int column = 0; column < numberOfColumns; column++) {
columnNames.addElement(metaData.getColumnLabel(column + 1));
}
// Alle Reihen einlesen
Vector rows = new Vector();
while (result.next()) {
iAnzZeilen++;
Vector newRow = new Vector();
for (int i = 1; i <= metaData.getColumnCount(); i++) {
newRow.addElement(result.getObject(i));
}
rows.addElement(newRow);
}
jTable = new JTable(rows, columnNames);
jTable.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
jScrollPaneData.setViewportView(jTable);
jTable.getTableHeader().setReorderingAllowed(false);
//Hintergrund der Tabelle setzen
jTable.setBackground(new Color(255, 255, 128));
//jTextPaneMeldungen.setText("-> Es wurden " + iAnzZeilen + " Medien-Datens�tze aus der Datenbank gelesen.\n" + jTextPaneMeldungen.getText());
/*ENDE Medien-Daten holen */
}// Ende try
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}// ENDE if(!conn.isCloses())
}//ENDE if(iaktuelleZeile>=0){
// Ende actionperformed Button-L�schen
}
});
}
return jButtonDatenLoeschen;
}
/**
* This method initializes jTextFieldPlaylistName
*
* @return javax.swing.JTextField
*/
private JTextField getJTextFieldPlaylistName() {
if (jTextFieldPlaylistName == null) {
jTextFieldPlaylistName = new JTextField();
jTextFieldPlaylistName.setBounds(new Rectangle(896, 423, 112, 24));
}
return jTextFieldPlaylistName;
}
/**
* This method initializes jScrollPanePlaylistData
*
* @return javax.swing.JScrollPane
*/
private JScrollPane getJScrollPanePlaylistData() {
if (jScrollPanePlaylistData == null) {
jScrollPanePlaylistData = new JScrollPane();
jScrollPanePlaylistData.setBounds(new Rectangle(807, 450, 202, 218));
jScrollPanePlaylistData.setColumnHeader(getJViewport11());
jScrollPanePlaylistData.setBackground(Color.lightGray);
}
return jScrollPanePlaylistData;
}
/**
* This method initializes jViewport11
*
* @return javax.swing.JViewport
*/
private JViewport getJViewport11() {
if (jViewport11 == null) {
jViewport11 = new JViewport();
jViewport11.setComponentOrientation(ComponentOrientation.LEFT_TO_RIGHT);
jViewport11.setEnabled(true);
jViewport11.setOpaque(true);
jViewport11.setScrollMode(1);
jViewport11.setCursor(new Cursor(Cursor.DEFAULT_CURSOR));
}
return jViewport11;
}
/**
* This method initializes jButtonPlayPlayList
*
* @return javax.swing.JButton
*/
private JButton getJButtonPlayPlayList() {
if (jButtonPlayPlayList == null) {
jButtonPlayPlayList = new JButton();
jButtonPlayPlayList.setBounds(new Rectangle(810, 139, 196, 37));
jButtonPlayPlayList.setBackground(new Color(230, 160, 230));
jButtonPlayPlayList.setText("Play Playlist");
jButtonPlayPlayList.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
// Anfang actionperformed PlayPlaylist
// Anfang Playliststring zusammenstellen
String strPlaylistString = " ";
try {
if(!conn.isClosed())
{
/*Playlist-Song-Daten holen */
Statement stmt_playlistdata = conn.createStatement();
ResultSet result_playlistdata = stmt_playlistdata.executeQuery("select media.dateipfad from playlistdata left outer Join media on media.Nr = playlistdata.songnr where playlistdata.playlistnr = "+ jTextFieldPlaylistNr.getText());
while (result_playlistdata.next())
strPlaylistString = strPlaylistString + " \"" + result_playlistdata.getString(1)+"\" ";
/* ENDE Playlist-Song-Daten holen */
}// Ende try
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}// ENDE if(!conn.isCloses())
// Ende Playliststring zusammenstellen
// Mediaplayer ansteuern
try {
//Runtime.getRuntime().exec("C:\\Programme\\Windows Media Player\\wmplayer.exe");
Runtime.getRuntime().exec(jTextFieldPlayerpfad.getText() + " /prefetch:1 "+strPlaylistString);
} catch (Exception e2) {
System.err.println(e2.toString());
} // Ende try Runtime.getRuntime
// Ende Media-Player ansteuern
// Ende Action-Performed PlayPlaylist
}
});
}
return jButtonPlayPlayList;
}
/**
* This method initializes jButtonAddToPlayList
*
* @return javax.swing.JButton
*/
private JButton getJButtonAddToPlayList() {
if (jButtonAddToPlayList == null) {
jButtonAddToPlayList = new JButton();
jButtonAddToPlayList.setBounds(new Rectangle(810, 61, 196, 37));
jButtonAddToPlayList.setBackground(new Color(230, 160, 230));
jButtonAddToPlayList.setText("Zur PL hinzuf�gen");
jButtonAddToPlayList.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
// Anfang Action Performed AddtoPlaylist
int iaktuelleZeile = jTable.getSelectedRow();
if(iaktuelleZeile>=0){
try {
if(!conn.isClosed()){
String newString = null;
Statement newstmt = conn.createStatement();
newString = "insert into playlistdata (playlistnr,songnr,titel) " +
" values (" + jTextFieldPlaylistNr.getText()
+ "," + jTable.getValueAt(iaktuelleZeile, 0)
+ ",'" + jTable.getValueAt(iaktuelleZeile, 1) + "'"+
")";
boolean newresult = newstmt.execute(newString);
// Aktualisieren der Ausgabe
Statement stmt = conn.createStatement();
ResultSet result = stmt.executeQuery("Select SongNr,titel from playlistdata where playlistnr = "+ jTextFieldPlaylistNr.getText());
// SQL-Select-Befehl
ResultSetMetaData metaData = result.getMetaData();
int numberOfColumns = metaData.getColumnCount();
Vector columnNames = new Vector();
for (int column = 0; column < numberOfColumns; column++) {
columnNames.addElement(metaData.getColumnLabel(column + 1));
}
//Alle Reihen einlesen
Vector rows = new Vector();
while (result.next()) {
Vector newRow = new Vector();
for (int i = 1; i <= metaData.getColumnCount(); i++) {
newRow.addElement(result.getObject(i));
}
rows.addElement(newRow);
}
jTablePlaylistData = new JTable(rows, columnNames);
jTablePlaylistData.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
jScrollPanePlaylistData.setViewportView(jTablePlaylistData);
jTablePlaylistData.getTableHeader().setReorderingAllowed(false);
//Hintergrund der Tabelle setzen
jTablePlaylistData.setBackground(new Color(255, 255, 128));
// Ende Aktualsieren der Ausgaba
}// Ende if(!conn.isClosed()){
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
} // Ende try
} // ENDE if(iaktuelleZeile>=0){
// Ende Action Performed Addtoplaylist
}
});
}
return jButtonAddToPlayList;
}
/**
* This method initializes jButtonDeleteFromPlayList
*
* @return javax.swing.JButton
*/
private JButton getJButtonDeleteFromPlayList() {
if (jButtonDeleteFromPlayList == null) {
jButtonDeleteFromPlayList = new JButton();
jButtonDeleteFromPlayList.setBounds(new Rectangle(810, 100, 196, 37));
jButtonDeleteFromPlayList.setBackground(new Color(230, 160, 230));
jButtonDeleteFromPlayList.setText("Von PL l�schen");
jButtonDeleteFromPlayList
.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
// Anfang Action Performed Delete From Playlist
int iaktuelleZeile = jTablePlaylistData.getSelectedRow();
if(iaktuelleZeile>=0){
try {
if(!conn.isClosed()){
String delString = null;
Statement delstmt = conn.createStatement();
delString = "delete from playlistdata where playlistnr = "
+ jTextFieldPlaylistNr.getText()
+ " and songnr = " + jTablePlaylistData.getValueAt(iaktuelleZeile, 0);
boolean delresult = delstmt.execute(delString);
// Aktualisieren der Ausgabe
Statement stmt = conn.createStatement();
ResultSet result = stmt.executeQuery("Select SongNr,titel from playlistdata where playlistnr = "+jTextFieldPlaylistNr.getText());
// SQL-Select-Befehl
ResultSetMetaData metaData = result.getMetaData();
int numberOfColumns = metaData.getColumnCount();
Vector columnNames = new Vector();
for (int column = 0; column < numberOfColumns; column++) {
columnNames.addElement(metaData.getColumnLabel(column + 1));
}
//Alle Reihen einlesen
Vector rows = new Vector();
while (result.next()) {
Vector newRow = new Vector();
for (int i = 1; i <= metaData.getColumnCount(); i++) {
newRow.addElement(result.getObject(i));
}
rows.addElement(newRow);
}
jTablePlaylistData = new JTable(rows, columnNames);
jTablePlaylistData.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
jScrollPanePlaylistData.setViewportView(jTablePlaylistData);
jTablePlaylistData.getTableHeader().setReorderingAllowed(false);
//Hintergrund der Tabelle setzen
jTablePlaylistData.setBackground(new Color(255, 255, 128));
// Ende Aktualsieren der Ausgaba
}// Ende if(!conn.isClosed()){
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
} // Ende try
} // ENDE if(iaktuelleZeile>=0){
// Ende Action Performed DeleteFrom playlist
}
});
}
return jButtonDeleteFromPlayList;
}
/**
* This method initializes jButtonAddPlayList
*
* @return javax.swing.JButton
*/
private JButton getJButtonAddPlayList() {
if (jButtonAddPlayList == null) {
jButtonAddPlayList = new JButton();
jButtonAddPlayList.setBounds(new Rectangle(810, 178, 196, 37));
jButtonAddPlayList.setBackground(new Color(230, 160, 230));
jButtonAddPlayList.setText("Playlist speichern");
jButtonAddPlayList.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
try {
if(!conn.isClosed()){
String newString = null;
Statement newstmt = conn.createStatement();
// Es wurde ein neue Playlist eingeben
if(jTextFieldPlaylistNr.getText().equals("0"))
{
newString = "insert into playlist (name) " +
" values ('" + jTextFieldPlaylistName.getText()+ "')";
boolean newresult = newstmt.execute(newString);
// Neu vergeben PLaylist-Nr. ermitteln
newString = "select max(nr) from playlist";
newresult = newstmt.execute(newString);
ResultSet sqlresult = newstmt.getResultSet();
// Von der DB neu vergeben PLaylist-Nr. ermitteln
Object iMaxPLNr = -1;
while (sqlresult.next()) {
iMaxPLNr = sqlresult.getInt(1);
}
jTextFieldPlaylistNr.setText(iMaxPLNr.toString());
// Playlist-Medien-daten unter der neuen Playlist Nr. speichern
newString = "update playlistdata set playlistnr = " + iMaxPLNr + " where playlistnr = 0";
newresult = newstmt.execute(newString);
// Neue Playlist in die DB speichern
// Aktualisieren der Ausgabe
Statement stmt = conn.createStatement();
ResultSet result = stmt.executeQuery("Select SongNr,titel from playlistdata where playlistnr = "+ jTextFieldPlaylistNr.getText());
// SQL-Select-Befehl
ResultSetMetaData metaData = result.getMetaData();
int numberOfColumns = metaData.getColumnCount();
Vector columnNames = new Vector();
for (int column = 0; column < numberOfColumns; column++) {
columnNames.addElement(metaData.getColumnLabel(column + 1));
}
//Alle Reihen einlesen
Vector rows = new Vector();
while (result.next()) {
Vector newRow = new Vector();
for (int i = 1; i <= metaData.getColumnCount(); i++) {
newRow.addElement(result.getObject(i));
}
rows.addElement(newRow);
}
jTablePlaylistData = new JTable(rows, columnNames);
jTablePlaylistData.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
jScrollPanePlaylistData.setViewportView(jTablePlaylistData);
jTablePlaylistData.getTableHeader().setReorderingAllowed(false);
//Hintergrund der Tabelle setzen
jTablePlaylistData.setBackground(new Color(255, 255, 128));
// Ende Aktualsieren der Ausgaba
/*Playlist-Daten holen */
Statement stmt_playlist = conn.createStatement();
//String strSQLStatement = "Select nr,Titel,Zusatzbeschreibung,K�nstler as Kuenstler,Album,Genre,Erscheinungsjahr,Medientyp,Dateityp,Dateipfad from media";
ResultSet result_playlist = stmt_playlist.executeQuery("select Nr,Name from playlist order by nr");
int iAnzZeilen_playlist = 0; // ANzahl der Zeilen, die die SQL-Abfrage zur�ckgibt
// SQL-Select-Befehl
ResultSetMetaData metaData_playlist = result_playlist.getMetaData();
int numberOfColumns_playlist = metaData_playlist.getColumnCount();
Vector columnNames_playlist = new Vector();
for (int column_playlist = 0; column_playlist < numberOfColumns_playlist; column_playlist++) {
columnNames_playlist.addElement(metaData_playlist.getColumnLabel(column_playlist + 1));
}
// Alle Reihen einlesen
Vector rows_playlist = new Vector();
while (result_playlist.next()) {
iAnzZeilen_playlist++;
Vector newRow_playlist = new Vector();
for (int i_playlist = 1; i_playlist <= metaData_playlist.getColumnCount(); i_playlist++) {
newRow_playlist.addElement(result_playlist.getObject(i_playlist));
}
rows_playlist.addElement(newRow_playlist);
}
//JTable jTablePlaylist;
jTablePlaylist = new JTable(rows_playlist, columnNames_playlist);
jTablePlaylist.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
jScrollPanePlaylist.setViewportView(jTablePlaylist);
jTablePlaylist.getTableHeader().setReorderingAllowed(false);
//Hintergrund der Tabelle setzen
jTablePlaylist.setBackground(new Color(255, 255, 128));
jTextPaneMeldungen.setText("-> Es wurden " + iAnzZeilen_playlist + " Playlist-Datens�tze aus der Datenbank gelesen.\n" + jTextPaneMeldungen.getText());
/* ENDE Playlist-Daten holen */
}// if(jTextFieldPlaylistNr.getText()= "0")
else{//es wurde eine bestehende Playlist ge�ndert
newString = "update playlist set name = " +
"'"+jTextFieldPlaylistName.getText() +"' where nr = " + jTextFieldPlaylistNr.getText();
boolean newresult = newstmt.execute(newString);
// Aktualisieren der Ausgabe
Statement stmt = conn.createStatement();
ResultSet result = stmt.executeQuery("Select nr,name from playlist");
// SQL-Select-Befehl
ResultSetMetaData metaData = result.getMetaData();
int numberOfColumns = metaData.getColumnCount();
Vector columnNames = new Vector();
for (int column = 0; column < numberOfColumns; column++) {
columnNames.addElement(metaData.getColumnLabel(column + 1));
}
//Alle Reihen einlesen
Vector rows = new Vector();
while (result.next()) {
Vector newRow = new Vector();
for (int i = 1; i <= metaData.getColumnCount(); i++) {
newRow.addElement(result.getObject(i));
}
rows.addElement(newRow);
}
jTablePlaylist = new JTable(rows, columnNames);
jTablePlaylist.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
jScrollPanePlaylist.setViewportView(jTablePlaylist);
jTablePlaylist.getTableHeader().setReorderingAllowed(false);
//Hintergrund der Tabelle setzen
jTablePlaylist.setBackground(new Color(255, 255, 128));
// Ende Aktualsieren der Ausgaba
}// Ende
}// Ende if(!conn.isClosed()){
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
} // Ende try
// Enden neue PL hinzuf�gen
}
});
}
return jButtonAddPlayList;
}
/**
* This method initializes jTextFieldPlaylistNr
*
* @return javax.swing.JTextField
*/
private JTextField getJTextFieldPlaylistNr() {
if (jTextFieldPlaylistNr == null) {
jTextFieldPlaylistNr = new JTextField();
jTextFieldPlaylistNr.setBounds(new Rectangle(896, 395, 112, 24));
jTextFieldPlaylistNr.setText("0");
jTextFieldPlaylistNr.setEditable(false);
}
return jTextFieldPlaylistNr;
}
/**
* This method initializes jFrameFilter
*
* @return javax.swing.JFrame
*/
private JFrame getJFrameFilter() {
if (jFrameFilter == null) {
jFrameFilter = new JFrame();
jFrameFilter.setEnabled(true);
jFrameFilter.setTitle("Filter");
jFrameFilter.setDefaultCloseOperation(WindowConstants.DO_NOTHING_ON_CLOSE);
jFrameFilter.setSize(new Dimension(650, 593));
jFrameFilter.setContentPane(getJContentPaneFilter());
jFrameFilter.setVisible(true);
}
return jFrameFilter;
}
/**
* This method initializes jContentPaneFilter
*
* @return javax.swing.JPanel
*/
private JPanel getJContentPaneFilter() {
if (jContentPaneFilter == null) {
jLabel8 = new JLabel();
jLabel8.setBounds(new Rectangle(465, 420, 17, 16));
jLabel8.setText("bis");
jLabel8.setVisible(false);
jLabel3 = new JLabel();
jLabel3.setText("bis");
jLabel3.setBounds(new Rectangle(438, 114, 17, 16));
jContentPaneFilter = new JPanel();
jContentPaneFilter.setLayout(null);
jContentPaneFilter.add(getJButtonOK(), null);
jContentPaneFilter.add(getJCheckBoxFilter2(), null);
jContentPaneFilter.add(getJTextFieldWie2(), null);
jContentPaneFilter.add(getJTextFieldGleich2(), null);
jContentPaneFilter.add(getJTextFieldBis2(), null);
jContentPaneFilter.add(getJComboBoxFilter2(), null);
jContentPaneFilter.add(getJRadioButtonWie2(), null);
jContentPaneFilter.add(getJRadioButtonVon2(), null);
jContentPaneFilter.add(getJRadioButtonUnd(), null);
jContentPaneFilter.add(getJRadioButtonOder(), null);
jContentPaneFilter.add(getJPanelFilter1(), null);
jContentPaneFilter.add(getJButtonAbbrechen(), null);
jContentPaneFilter.add(getJRadioButtonGleich2(), null);
jContentPaneFilter.add(jLabel8, null);
jContentPaneFilter.setVisible(true);
jContentPaneFilter.add(getJTextFieldVon2(), null);
jContentPaneFilter.add(getJPanelFilter2(), null);
ButtonGroup ButtonGroupUndOder = new ButtonGroup();
ButtonGroupUndOder.add(jRadioButtonOder); ButtonGroupUndOder.add(jRadioButtonUnd);
}
return jContentPaneFilter;
}
/**
* This method initializes jTextFieldWie1
*
* @return javax.swing.JTextField
*/
private JTextField getJTextFieldWie1() {
if (jTextFieldWie1 == null) {
jTextFieldWie1 = new JTextField();
jTextFieldWie1.setBounds(new Rectangle(303, 24, 106, 20));
}
return jTextFieldWie1;
}
/**
* This method initializes jTextFieldGleich1
*
* @return javax.swing.JTextField
*/
private JTextField getJTextFieldGleich1() {
if (jTextFieldGleich1 == null) {
jTextFieldGleich1 = new JTextField();
jTextFieldGleich1.setEnabled(false);
jTextFieldGleich1.setBounds(new Rectangle(303, 69, 106, 20));
}
return jTextFieldGleich1;
}
/**
* This method initializes jTextFieldVon1
*
* @return javax.swing.JTextField
*/
private JTextField getJTextFieldVon1() {
if (jTextFieldVon1 == null) {
jTextFieldVon1 = new JTextField();
jTextFieldVon1.setEnabled(false);
jTextFieldVon1.setBounds(new Rectangle(303, 114, 106, 20));
}
return jTextFieldVon1;
}
/**
* This method initializes jTextFieldBis1
*
* @return javax.swing.JTextField
*/
private JTextField getJTextFieldBis1() {
if (jTextFieldBis1 == null) {
jTextFieldBis1 = new JTextField();
jTextFieldBis1.setEnabled(false);
jTextFieldBis1.setBounds(new Rectangle(468, 114, 106, 20));
}
return jTextFieldBis1;
}
/**
* This method initializes jRadioButtonGleich1
*
* @return javax.swing.JRadioButton
*/
private JRadioButton getJRadioButtonGleich1() {
if (jRadioButtonGleich1 == null) {
jRadioButtonGleich1 = new JRadioButton();
jRadioButtonGleich1.setText("gleich");
jRadioButtonGleich1.setBounds(new Rectangle(198, 69, 59, 24));
jRadioButtonGleich1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
jTextFieldWie1.setEnabled(false);
jTextFieldWie1.setText("");
jTextFieldGleich1.setEnabled(true);
jTextFieldGleich1.setText("");
jTextFieldVon1.setEnabled(false);
jTextFieldVon1.setText("");
jTextFieldBis1.setEnabled(false);
jTextFieldBis1.setText("");
jRadioButtonWie1.setSelected(false);
jRadioButtonGleich1.setSelected(true);
jRadioButtonVon1.setSelected(false);
}
});
}
return jRadioButtonGleich1;
}
/**
* This method initializes jButtonOK
*
* @return javax.swing.JButton
*/
private JButton getJButtonOK() {
if (jButtonOK == null) {
jButtonOK = new JButton();
jButtonOK.setBounds(new Rectangle(180, 510, 121, 26));
jButtonOK.setText("OK");
jButtonOK.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
try {
if(!conn.isClosed()){
// Abfrage von Daten aus der tabelle Media
strSQLStatement = "Select Nr,Titel,Zusatzbeschreibung,K�nstler as Kuenstler,Album,Genre,Erscheinungsjahr,Medientyp,Dateityp,Dateipfad from media";
{
// WIE Suche 1
if (jRadioButtonWie1.isSelected()){
if (!jTextFieldWie1.getText().equals("")) {
strSQLStatement = strSQLStatement + " where " + jComboBoxFilter1.getSelectedItem() + " Like '%" + jTextFieldWie1.getText() +"%'"; }}
// GLEICH Suche 1
if (jRadioButtonGleich1.isSelected()){
if (!jTextFieldGleich1.getText().equals("")){
strSQLStatement = strSQLStatement + " where " + jComboBoxFilter1.getSelectedItem() + " = '"+ jTextFieldGleich1.getText() +"'"; }}
// VON BIS Suche 1
if (jRadioButtonVon1.isSelected()){
if (!jTextFieldVon1.getText().equals("")){
if (!jTextFieldBis1.getText().equals("")){
strSQLStatement = strSQLStatement + " where " + jComboBoxFilter1.getSelectedItem() + " between '"+ jTextFieldVon1.getText() + "' and '" + jTextFieldBis1.getText() +"'";}}}
// 2. Filter
//Abfrage dass die Suche nicht mit leeren Argumenten gestartet wird
if (jCheckBoxFilter2.isSelected()&& (!(jTextFieldWie2.getText().equals("")
&& jTextFieldGleich2.getText().equals("") && jTextFieldVon2.getText().equals("") && jTextFieldBis2.getText().equals("")))){
if ((jTextFieldWie1.getText().equals("") && jTextFieldGleich1.getText().equals("") && jTextFieldVon1.getText().equals("") && jTextFieldBis1.getText().equals("")))
{}
else{
if (jRadioButtonUnd.isSelected())
strSQLStatement = strSQLStatement + " and ";
else
strSQLStatement = strSQLStatement + " or ";
// WIE Suche 2
if (jRadioButtonWie2.isSelected()){
if (!jTextFieldWie2.getText().equals("")) {
strSQLStatement = strSQLStatement + jComboBoxFilter2.getSelectedItem() + " Like '%" + jTextFieldWie2.getText() +"%'"; }}
// GLEICH Suche 2
if (jRadioButtonGleich2.isSelected()){
if (!jTextFieldGleich2.getText().equals("")){
strSQLStatement = strSQLStatement + jComboBoxFilter2.getSelectedItem() + " = '"+ jTextFieldGleich2.getText() +"'"; }}
// VON BIS Suche 3
if (jRadioButtonVon2.isSelected()){
if (!jTextFieldVon2.getText().equals("")){
if (!jTextFieldBis2.getText().equals("")){
strSQLStatement = strSQLStatement + jComboBoxFilter2.getSelectedItem() + " between '"+ jTextFieldVon2.getText() + "' and '" + jTextFieldBis2.getText() +"'";
}}}
}}// Ende 2. FIlter
/*Media-Daten holen */
Statement stmt = conn.createStatement();
ResultSet result = stmt.executeQuery(strSQLStatement);
int iAnzZeilen = 0; // ANzahl der Zeilen, die die SQL-Abfrage zur�ckgibt
// SQL-Select-Befehl
ResultSetMetaData metaData = result.getMetaData();
int numberOfColumns = metaData.getColumnCount();
Vector columnNames = new Vector();
for (int column = 0; column < numberOfColumns; column++) {
columnNames.addElement(metaData.getColumnLabel(column + 1));
}
// Alle Reihen einlesen
Vector rows = new Vector();
while (result.next()) {
iAnzZeilen++;
Vector newRow = new Vector();
for (int i = 1; i <= metaData.getColumnCount(); i++) {
newRow.addElement(result.getObject(i));
}
rows.addElement(newRow);
}
jTable = new JTable(rows, columnNames);
jTable.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
jScrollPaneData.setViewportView(jTable);
jTable.getTableHeader().setReorderingAllowed(false);
//Hintergrund der Tabelle setzen
jTable.setBackground(new Color(255, 255, 128));
jTextPaneMeldungen.setText("-> Es wurden " + iAnzZeilen + " Medien-Datens�tze aus der Datenbank gelesen.\n" + jTextPaneMeldungen.getText());
/*ENDE Medien-Daten holen */
getJFrame().setEnabled(true);
getJFrameFilter().setVisible(false);
}}}
catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}// ENDE if(!conn.isCloses())
// ENDE Button OK
}
});
}
return jButtonOK;
}
/**
* This method initializes jCheckBoxFilter2
*
* @return javax.swing.JCheckBox
*/
private JCheckBox getJCheckBoxFilter2() {
if (jCheckBoxFilter2 == null) {
jCheckBoxFilter2 = new JCheckBox();
jCheckBoxFilter2.setBounds(new Rectangle(30, 255, 66, 24));
jCheckBoxFilter2.setText("2. Filter");
jCheckBoxFilter2.setSelected(false);
jCheckBoxFilter2.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
if (jCheckBoxFilter2.isSelected()) {
jComboBoxFilter2.setVisible(true);
jRadioButtonWie2.setVisible(true);
jRadioButtonGleich2.setVisible(true);
jRadioButtonVon2.setVisible(true);
jRadioButtonUnd.setVisible(true);
jRadioButtonOder.setVisible(true);
jPanelFilter2.setVisible(true);
jTextFieldWie2.setVisible(true);
jTextFieldGleich2.setVisible(true);
jTextFieldVon2.setVisible(true);
jTextFieldBis2.setVisible(true);
jLabel8.setVisible(true);
}
else {
jComboBoxFilter2.setVisible(false);
jRadioButtonWie2.setVisible(false);
jRadioButtonGleich2.setVisible(false);
jRadioButtonVon2.setVisible(false);
jRadioButtonUnd.setVisible(false);
jRadioButtonOder.setVisible(false);
jPanelFilter2.setVisible(false);
jTextFieldWie2.setVisible(false);
jTextFieldGleich2.setVisible(false);
jTextFieldVon2.setVisible(false);
jTextFieldBis2.setVisible(false);
jLabel8.setVisible(false);}
}
});
}
return jCheckBoxFilter2;
}
/**
* This method initializes jTextFieldWie2
*
* @return javax.swing.JTextField
*/
private JTextField getJTextFieldWie2() {
if (jTextFieldWie2 == null) {
jTextFieldWie2 = new JTextField();
jTextFieldWie2.setBounds(new Rectangle(330, 330, 106, 20));
jTextFieldWie2.setVisible(false);
}
return jTextFieldWie2;
}
/**
* This method initializes jTextFieldGleich2
*
* @return javax.swing.JTextField
*/
private JTextField getJTextFieldGleich2() {
if (jTextFieldGleich2 == null) {
jTextFieldGleich2 = new JTextField();
jTextFieldGleich2.setBounds(new Rectangle(330, 375, 106, 20));
jTextFieldGleich2.setEnabled(false);
jTextFieldGleich2.setVisible(false);
}
return jTextFieldGleich2;
}
/**
* This method initializes jTextFieldVon2
*
* @return javax.swing.JTextField
*/
private JTextField getJTextFieldVon2() {
if (jTextFieldVon2 == null) {
jTextFieldVon2 = new JTextField();
jTextFieldVon2.setBounds(new Rectangle(330, 420, 106, 20));
jTextFieldVon2.setEnabled(false);
jTextFieldVon2.setVisible(false);
}
return jTextFieldVon2;
}
/**
* This method initializes jTextFieldBis2
*
* @return javax.swing.JTextField
*/
private JTextField getJTextFieldBis2() {
if (jTextFieldBis2 == null) {
jTextFieldBis2 = new JTextField();
jTextFieldBis2.setBounds(new Rectangle(495, 420, 106, 20));
jTextFieldBis2.setEnabled(false);
jTextFieldBis2.setVisible(false);
}
return jTextFieldBis2;
}
/**
* This method initializes jComboBoxFilter2
*
* @return javax.swing.JComboBox
*/
private JComboBox getJComboBoxFilter2() {
if (jComboBoxFilter2 == null) {
jComboBoxFilter2 = new JComboBox();
jComboBoxFilter2.setBounds(new Rectangle(45, 330, 151, 25));
jComboBoxFilter2.setMaximumRowCount(4);
jComboBoxFilter2.setVisible(false);
jComboBoxFilter2.addItem("Nr");
jComboBoxFilter2.addItem("Titel");
jComboBoxFilter2.addItem("Zusatzbeschreibung");
jComboBoxFilter2.addItem("K�nstler");
jComboBoxFilter2.addItem("Album");
jComboBoxFilter2.addItem("Genre");
jComboBoxFilter2.addItem("Erscheinungsjahr");
jComboBoxFilter2.addItem("Medientyp");
jComboBoxFilter2.addItem("Dateityp");
}
return jComboBoxFilter2;
}
/**
* This method initializes jRadioButtonWie2
*
* @return javax.swing.JRadioButton
*/
private JRadioButton getJRadioButtonWie2() {
if (jRadioButtonWie2 == null) {
jRadioButtonWie2 = new JRadioButton();
jRadioButtonWie2.setBounds(new Rectangle(255, 330, 45, 24));
jRadioButtonWie2.setSelected(true);
jRadioButtonWie2.setText("wie");
jRadioButtonWie2.setVisible(false);
jRadioButtonWie2.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
jTextFieldWie2.setEnabled(true);
jTextFieldWie2.setText("");
jTextFieldGleich2.setEnabled(false);
jTextFieldGleich2.setText("");
jTextFieldVon2.setEnabled(false);
jTextFieldVon2.setText("");
jTextFieldBis2.setEnabled(false);
jTextFieldBis2.setText("");
jRadioButtonWie2.setSelected(true);
jRadioButtonGleich2.setSelected(false);
jRadioButtonVon2.setSelected(false);
}
});
}
return jRadioButtonWie2;
}
/**
* This method initializes jRadioButtonVon2
*
* @return javax.swing.JRadioButton
*/
private JRadioButton getJRadioButtonVon2() {
if (jRadioButtonVon2 == null) {
jRadioButtonVon2 = new JRadioButton();
jRadioButtonVon2.setBounds(new Rectangle(255, 420, 45, 24));
jRadioButtonVon2.setText("von");
jRadioButtonVon2.setVisible(false);
jRadioButtonVon2.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
jTextFieldWie2.setEnabled(false);
jTextFieldWie2.setText("");
jTextFieldGleich2.setEnabled(false);
jTextFieldGleich2.setText("");
jTextFieldVon2.setEnabled(true);
jTextFieldVon2.setText("");
jTextFieldBis2.setEnabled(true);
jTextFieldBis2.setText("");
jRadioButtonWie2.setSelected(false);
jRadioButtonGleich2.setSelected(false);
jRadioButtonVon2.setSelected(true);
}
});
}
return jRadioButtonVon2;
}
/**
* This method initializes jRadioButtonUnd
*
* @return javax.swing.JRadioButton
*/
private JRadioButton getJRadioButtonUnd() {
if (jRadioButtonUnd == null) {
jRadioButtonUnd = new JRadioButton();
jRadioButtonUnd.setBounds(new Rectangle(150, 255, 49, 24));
jRadioButtonUnd.setSelected(true);
jRadioButtonUnd.setText("UND");
jRadioButtonUnd.setVisible(false);
jRadioButtonUnd.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
jRadioButtonOder.setSelected(false);
}
});
}
return jRadioButtonUnd;
}
/**
* This method initializes jRadioButtonOder
*
* @return javax.swing.JRadioButton
*/
private JRadioButton getJRadioButtonOder() {
if (jRadioButtonOder == null) {
jRadioButtonOder = new JRadioButton();
jRadioButtonOder.setBounds(new Rectangle(210, 255, 57, 24));
jRadioButtonOder.setText("ODER");
jRadioButtonOder.setVisible(false);
jRadioButtonOder.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
jRadioButtonUnd.setSelected(false);
}
});
}
return jRadioButtonOder;
}
/**
* This method initializes jRadioButtonWie1
*
* @return javax.swing.JRadioButton
*/
private JRadioButton getJRadioButtonWie1() {
if (jRadioButtonWie1 == null) {
jRadioButtonWie1 = new JRadioButton();
jRadioButtonWie1.setMnemonic(KeyEvent.VK_UNDEFINED);
jRadioButtonWie1.setRolloverEnabled(false);
//jRadioButtonWie1.setSelected(true);
jRadioButtonWie1.setBounds(new Rectangle(198, 24, 45, 24));
jRadioButtonWie1.setText("wie");
//jRadioButtonWie1.setRolloverEnabled(false);
//jRadioButtonWie1.setMnemonic(KeyEvent.VK_UNDEFINED);
jRadioButtonWie1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
jTextFieldWie1.setEnabled(true);
jTextFieldWie1.setText("");
jTextFieldGleich1.setEnabled(false);
jTextFieldGleich1.setText("");
jTextFieldVon1.setEnabled(false);
jTextFieldVon1.setText("");
jTextFieldBis1.setEnabled(false);
jTextFieldBis1.setText("");
jRadioButtonWie1.setSelected(true);
jRadioButtonGleich1.setSelected(false);
jRadioButtonVon1.setSelected(false);
}
});
}
return jRadioButtonWie1;
}
/**
* This method initializes jRadioButtonVon1
*
* @return javax.swing.JRadioButton
*/
private JRadioButton getJRadioButtonVon1() {
if (jRadioButtonVon1 == null) {
jRadioButtonVon1 = new JRadioButton();
jRadioButtonVon1.setText("von");
jRadioButtonVon1.setBounds(new Rectangle(198, 114, 45, 24));
jRadioButtonVon1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
jTextFieldWie1.setEnabled(false);
jTextFieldWie1.setText("");
jTextFieldGleich1.setEnabled(false);
jTextFieldGleich1.setText("");
jTextFieldVon1.setEnabled(true);
jTextFieldVon1.setText("");
jTextFieldBis1.setEnabled(true);
jTextFieldBis1.setText("");
jRadioButtonWie1.setSelected(false);
jRadioButtonGleich1.setSelected(false);
jRadioButtonVon1.setSelected(true);
}
});
}
return jRadioButtonVon1;
}
/**
* This method initializes jComboBoxFilter1
*
* @return javax.swing.JComboBox
*/
private JComboBox getJComboBoxFilter1() {
if (jComboBoxFilter1 == null) {
jComboBoxFilter1 = new JComboBox();
jComboBoxFilter1.setMaximumRowCount(4);
jComboBoxFilter1.setBounds(new Rectangle(18, 24, 151, 25));
jComboBoxFilter1.addItem("Nr");
jComboBoxFilter1.addItem("Titel");
jComboBoxFilter1.addItem("Zusatzbeschreibung");
jComboBoxFilter1.addItem("K�nstler");
jComboBoxFilter1.addItem("Album");
jComboBoxFilter1.addItem("Genre");
jComboBoxFilter1.addItem("Erscheinungsjahr");
jComboBoxFilter1.addItem("Medientyp");
jComboBoxFilter1.addItem("Dateityp");
}
return jComboBoxFilter1;
}
/**
* This method initializes jPanelFilter1
*
* @return javax.swing.JPanel
*/
private JPanel getJPanelFilter1() {
if (jPanelFilter1 == null) {
jPanelFilter1 = new JPanel();
jPanelFilter1.setLayout(null);
jPanelFilter1.setBounds(new Rectangle(30, 60, 586, 167));
jPanelFilter1.setBorder(BorderFactory.createTitledBorder(null, "Suche nach...", TitledBorder.DEFAULT_JUSTIFICATION, TitledBorder.DEFAULT_POSITION, new Font("Dialog", Font.BOLD, 12), new Color(51, 51, 51)));
jPanelFilter1.add(jLabel3, null);
jPanelFilter1.add(getJTextFieldBis1(), null);
jPanelFilter1.add(getJTextFieldVon1(), null);
jPanelFilter1.add(getJRadioButtonVon1(), null);
jPanelFilter1.add(getJRadioButtonGleich1(), null);
jPanelFilter1.add(getJTextFieldGleich1(), null);
jPanelFilter1.add(getJTextFieldWie1(), null);
jPanelFilter1.add(getJRadioButtonWie1(), null);
jPanelFilter1.add(getJComboBoxFilter1(), null);
}
return jPanelFilter1;
}
/**
* This method initializes jButtonAbbrechen
*
* @return javax.swing.JButton
*/
private JButton getJButtonAbbrechen() {
if (jButtonAbbrechen == null) {
jButtonAbbrechen = new JButton();
jButtonAbbrechen.setBounds(new Rectangle(345, 510, 121, 26));
jButtonAbbrechen.setText("Abbrechen");
jButtonAbbrechen.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
getJFrame().setEnabled(true);
getJFrameFilter().setVisible(false);
}
});
}
return jButtonAbbrechen;
}
/**
* This method initializes jRadioButtonGleich2
*
* @return javax.swing.JRadioButton
*/
private JRadioButton getJRadioButtonGleich2() {
if (jRadioButtonGleich2 == null) {
jRadioButtonGleich2 = new JRadioButton();
jRadioButtonGleich2.setBounds(new Rectangle(255, 375, 59, 24));
jRadioButtonGleich2.setText("gleich");
jRadioButtonGleich2.setVisible(false);
jRadioButtonGleich2.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
jTextFieldWie2.setEnabled(false);
jTextFieldWie2.setText("");
jTextFieldGleich2.setEnabled(true);
jTextFieldGleich2.setText("");
jTextFieldVon2.setEnabled(false);
jTextFieldVon2.setText("");
jTextFieldBis2.setEnabled(false);
jTextFieldBis2.setText("");
jRadioButtonWie2.setSelected(false);
jRadioButtonGleich2.setSelected(true);
jRadioButtonVon2.setSelected(false);
}
});
}
return jRadioButtonGleich2;
}
/**
* This method initializes jPanelFilter2
*
* @return javax.swing.JPanel
*/
private JPanel getJPanelFilter2() {
if (jPanelFilter2 == null) {
jPanelFilter2 = new JPanel();
jPanelFilter2.setLayout(null);
jPanelFilter2.setBorder(BorderFactory.createTitledBorder(null, "Suche nach...", TitledBorder.DEFAULT_JUSTIFICATION, TitledBorder.DEFAULT_POSITION, new Font("Dialog", Font.BOLD, 12), new Color(51, 51, 51)));
jPanelFilter2.setBounds(new Rectangle(33, 291, 586, 166));
jPanelFilter2.setVisible(false);
}
return jPanelFilter2;
}
/**
* This method initializes jTextFieldPlayerpfad
*
* @return javax.swing.JTextField
*/
private JTextField getJTextFieldPlayerpfad() {
if (jTextFieldPlayerpfad == null) {
jTextFieldPlayerpfad = new JTextField();
jTextFieldPlayerpfad.setBounds(new Rectangle(9, 131, 134, 20));
jTextFieldPlayerpfad.setText("d:\\programme\\windows media player\\wmplayer.exe");
}
return jTextFieldPlayerpfad;
}
/**
* This method initializes jButtonFileChooserPlayerpfad
*
* @return javax.swing.JButton
*/
private JButton getJButtonFileChooserPlayerpfad() {
if (jButtonFileChooserPlayerpfad == null) {
jButtonFileChooserPlayerpfad = new JButton();
jButtonFileChooserPlayerpfad.setBounds(new Rectangle(146, 131, 18, 20));
jButtonFileChooserPlayerpfad.setIcon(new ImageIcon(getClass().getResource("/mediam/Bilder/open_file_50percent.GIF")));
jButtonFileChooserPlayerpfad.setBackground(new Color(204, 204, 204));
jButtonFileChooserPlayerpfad
.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
//Create a file chooser
JFileChooser fc = new JFileChooser();
// int returnVal = fc.showOpenDialog(FileChooser.this);
int returnVal = fc.showOpenDialog(jFrame);
if (returnVal == JFileChooser.APPROVE_OPTION) {
File file = fc.getSelectedFile();
jTextFieldPlayerpfad.setText(file.getAbsolutePath().toString());
}
}
});
}
return jButtonFileChooserPlayerpfad;
}
/**
* This method initializes jPanel1
*
* @return javax.swing.JPanel
*/
private JPanel getJPanel1() {
if (jPanel1 == null) {
jPanel1 = new JPanel();
jPanel1.setLayout(new GridBagLayout());
jPanel1.setBounds(new Rectangle(238, 6, 511, 297));
jPanel1.setBorder(new SoftBevelBorder(SoftBevelBorder.RAISED));
jPanel1.setBackground(new Color(204, 204, 204));
}
return jPanel1;
}
/**
* This method initializes jButtonNewPlaylist
*
* @return javax.swing.JButton
*/
private JButton getJButtonNewPlaylist() {
if (jButtonNewPlaylist == null) {
jButtonNewPlaylist = new JButton();
jButtonNewPlaylist.setBounds(new Rectangle(810, 22, 196, 37));
jButtonNewPlaylist.setText("Neue Playlist");
jButtonNewPlaylist.setBackground(new Color(230, 160, 230));
jButtonNewPlaylist.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
jTextFieldPlaylistNr.setText("0");
jTextFieldPlaylistName.setText(" ");
try {
if(!conn.isClosed()){
String newString = null;
Statement newstmt = conn.createStatement();
newString = "delete from playlistdata where playlistnr = 0 ";
boolean newresult = newstmt.execute(newString);
// Aktualisieren der Ausgabe
Statement stmt = conn.createStatement();
ResultSet result = stmt.executeQuery("Select SongNr,titel from playlistdata");
//SQL-Select-Befehl
ResultSetMetaData metaData = result.getMetaData();
int numberOfColumns = metaData.getColumnCount();
Vector columnNames = new Vector();
for (int column = 0; column < numberOfColumns; column++) {
columnNames.addElement(metaData.getColumnLabel(column + 1));
}
//Alle Reihen einlesen
Vector rows = new Vector();
while (result.next()) {
Vector newRow = new Vector();
for (int i = 1; i <= metaData.getColumnCount(); i++) {
newRow.addElement(result.getObject(i));
}
rows.addElement(newRow);
}
jTablePlaylistData = new JTable(rows, columnNames);
jTablePlaylistData.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
jScrollPanePlaylistData.setViewportView(jTablePlaylistData);
jTablePlaylistData.getTableHeader().setReorderingAllowed(false);
//Hintergrund der Tabelle setzen
jTablePlaylistData.setBackground(new Color(255, 255, 128));
jScrollPanePlaylistData.setViewportView(null);
// Ende Aktualsieren der Ausgaba
}// Ende if(!conn.isClosed()){
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
} // Ende try
}
});
}
return jButtonNewPlaylist;
}
/**
* This method initializes jButtonPlaylistLaden
*
* @return javax.swing.JButton
*/
private JButton getJButtonPlaylistLaden() {
if (jButtonPlaylistLaden == null) {
jButtonPlaylistLaden = new JButton();
jButtonPlaylistLaden.setBounds(new Rectangle(810, 256, 196, 37));
jButtonPlaylistLaden.setText("Playlist laden");
jButtonPlaylistLaden.setBackground(new Color(230, 160, 229));
jButtonPlaylistLaden.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
int iaktuelleZeile = jTablePlaylist.getSelectedRow();
if(iaktuelleZeile>=0){
try {
if(!conn.isClosed()){
jTextFieldPlaylistNr.setText(jTablePlaylist.getValueAt(iaktuelleZeile, 0).toString());
jTextFieldPlaylistName.setText(jTablePlaylist.getValueAt(iaktuelleZeile, 1).toString());
// Aktualisieren der Ausgabe
Statement stmt = conn.createStatement();
ResultSet result = stmt.executeQuery("Select SongNr,titel from playlistdata where playlistnr = "+jTextFieldPlaylistNr.getText());
// SQL-Select-Befehl
ResultSetMetaData metaData = result.getMetaData();
int numberOfColumns = metaData.getColumnCount();
Vector columnNames = new Vector();
for (int column = 0; column < numberOfColumns; column++) {
columnNames.addElement(metaData.getColumnLabel(column + 1));
}
//Alle Reihen einlesen
Vector rows = new Vector();
while (result.next()) {
Vector newRow = new Vector();
for (int i = 1; i <= metaData.getColumnCount(); i++) {
newRow.addElement(result.getObject(i));
}
rows.addElement(newRow);
}
jTablePlaylistData = new JTable(rows, columnNames);
jTablePlaylistData.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
jScrollPanePlaylistData.setViewportView(jTablePlaylistData);
jTablePlaylistData.getTableHeader().setReorderingAllowed(false);
//Hintergrund der Tabelle setzen
jTablePlaylistData.setBackground(new Color(255, 255, 128));
// Ende Aktualsieren der Ausgaba
}// Ende if(!conn.isClosed()){
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
} // Ende try
}
// Ende PL laden
}
});
}
return jButtonPlaylistLaden;
}
/**
* This method initializes jButtonDeletePlayList
*
* @return javax.swing.JButton
*/
private JButton getJButtonDeletePlayList() {
if (jButtonDeletePlayList == null) {
jButtonDeletePlayList = new JButton();
jButtonDeletePlayList.setBounds(new Rectangle(810, 217, 196, 37));
jButtonDeletePlayList.setText("PL l�schen");
jButtonDeletePlayList.setBackground(new Color(230, 160, 230));
jButtonDeletePlayList.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
int iaktuelleZeile = jTablePlaylist.getSelectedRow();
int iAnzZeilen = 0;
if(iaktuelleZeile>=0){
try {
if(!conn.isClosed()){
String delString = null;
Statement delstmt = conn.createStatement();
delString = "delete from playlist where nr = " +
jTablePlaylist.getValueAt(iaktuelleZeile, 0);
boolean delresult = delstmt.execute(delString);
delString = "delete from playlistdata where playlistnr = " +
jTextFieldPlaylistNr.getText();
delresult = delstmt.execute(delString);
jTextFieldPlaylistNr.setText("0");
// Aktualisieren der Ausgabe
Statement stmt = conn.createStatement();
ResultSet result = stmt.executeQuery("Select SongNr,titel from playlistdata where playlistnr = "+jTextFieldPlaylistNr.getText());
// SQL-Select-Befehl
ResultSetMetaData metaData = result.getMetaData();
int numberOfColumns = metaData.getColumnCount();
Vector columnNames = new Vector();
for (int column = 0; column < numberOfColumns; column++) {
columnNames.addElement(metaData.getColumnLabel(column + 1));
}
//Alle Reihen einlesen
Vector rows = new Vector();
while (result.next()) {
iAnzZeilen++;
Vector newRow = new Vector();
for (int i = 1; i <= metaData.getColumnCount(); i++) {
newRow.addElement(result.getObject(i));
}
rows.addElement(newRow);
}
jTablePlaylistData = new JTable(rows, columnNames);
jTablePlaylistData.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
jScrollPanePlaylistData.setViewportView(jTablePlaylistData);
jTablePlaylistData.getTableHeader().setReorderingAllowed(false);
//Hintergrund der Tabelle setzen
jTablePlaylistData.setBackground(new Color(255, 255, 128));
if ( iAnzZeilen<1){
jScrollPanePlaylistData.setViewportView(null);
}
// Ende Aktualsieren der Ausgaba
// Aktualisieren der PlalyistAusgabe
result = stmt.executeQuery("Select nr,name from playlist");
// SQL-Select-Befehl
metaData = result.getMetaData();
numberOfColumns = metaData.getColumnCount();
columnNames = new Vector();
for (int column = 0; column < numberOfColumns; column++) {
columnNames.addElement(metaData.getColumnLabel(column + 1));
}
//Alle Reihen einlesen
rows = new Vector();
while (result.next()) {
iAnzZeilen++;
Vector newRow = new Vector();
for (int i = 1; i <= metaData.getColumnCount(); i++) {
newRow.addElement(result.getObject(i));
}
rows.addElement(newRow);
}
jTablePlaylist = new JTable(rows, columnNames);
jTablePlaylist.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
jScrollPanePlaylist.setViewportView(jTablePlaylist);
jTablePlaylist.getTableHeader().setReorderingAllowed(false);
//Hintergrund der Tabelle setzen
jTablePlaylist.setBackground(new Color(255, 255, 128));
if ( iAnzZeilen<1){
jScrollPanePlaylist.setViewportView(null);
}
// Ende Aktualsieren der Playlist-Ausgabe
}// Ende if(!conn.isClosed()){
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
} // Ende try
}
// ENDE PL l�schen
//Ende PL l�schen
}
});
}
return jButtonDeletePlayList;
}
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
SwingUtilities.invokeLater(new Runnable() {
public void run() {
MediaM application = new MediaM();
application.getJFrame().setVisible(true);
}
});
}
/**
* This method initializes jFrame
*
* @return javax.swing.JFrame
*/
private JFrame getJFrame() {
if (jFrame == null) {
jFrame = new JFrame();
jFrame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
jFrame.setIconImage(Toolkit.getDefaultToolkit().getImage(getClass().getResource("/mediam/Bilder/player_logo.jpg")));
jFrame.setJMenuBar(getJJMenuBar());
jFrame.setSize(1021, 726);
jFrame.setContentPane(getJContentPane());
jFrame.setTitle("MEDIAM Version 1.4.1 Multimedia Management Progamm");
}
return jFrame;
}
/**
* This method initializes jContentPane
*
* @return javax.swing.JPanel
*/
private JPanel getJContentPane() {
if (jContentPane == null) {
jLabel21 = new JLabel();
jLabel21.setBounds(new Rectangle(809, 395, 84, 22));
jLabel21.setText("Playlist-Nr.");
jLabel2 = new JLabel();
jLabel2.setBounds(new Rectangle(809, 423, 84, 26));
jLabel2.setText("Playlist-Name");
jLabel13 = new JLabel();
jLabel13.setText("Passwort");
jLabel13.setBounds(new Rectangle(11, 72, 59, 20));
jLabel12 = new JLabel();
jLabel12.setText("DB");
jLabel12.setBounds(new Rectangle(11, 30, 59, 20));
jLabel11 = new JLabel();
jLabel11.setText("User");
jLabel11.setBounds(new Rectangle(11, 51, 59, 16));
jLabel1 = new JLabel();
jLabel1.setText("Host");
jLabel1.setBounds(new Rectangle(11, 9, 59, 20));
jLabelDateipfad = new JLabel();
jLabelDateipfad.setBounds(new Rectangle(250, 280, 125, 20));
jLabelDateipfad.setText("Dateipfad");
jLabelDateityp = new JLabel();
jLabelDateityp.setBounds(new Rectangle(250, 250, 125, 20));
jLabelDateityp.setText("Dateityp");
jLabelMedientyp = new JLabel();
jLabelMedientyp.setBounds(new Rectangle(250, 220, 125, 20));
jLabelMedientyp.setText("Medientyp");
jLabelErscheinungsjahr = new JLabel();
jLabelErscheinungsjahr.setBounds(new Rectangle(250, 190, 125, 20));
jLabelErscheinungsjahr.setText("Erscheinungsjahr");
jLabelGenre = new JLabel();
jLabelGenre.setBounds(new Rectangle(250, 160, 125, 20));
jLabelGenre.setText("Genre");
jLabelAlbum = new JLabel();
jLabelAlbum.setBounds(new Rectangle(250, 130, 125, 20));
jLabelAlbum.setText("Album");
jLabelKuenstler = new JLabel();
jLabelKuenstler.setBounds(new Rectangle(250, 100, 125, 20));
jLabelKuenstler.setText("K�nstler");
jLabelZusatzbeschreibung = new JLabel();
jLabelZusatzbeschreibung.setBounds(new Rectangle(250, 70, 125, 20));
jLabelZusatzbeschreibung.setText("Zusatzbeschreibung");
jLabelTitel = new JLabel();
jLabelTitel.setBounds(new Rectangle(250, 40, 125, 20));
jLabelTitel.setText("Titel");
jLabelNr = new JLabel();
jLabelNr.setBounds(new Rectangle(250, 10, 125, 20));
jLabelNr.setText("Nr.");
jLabel = new JLabel();
jLabel.setBounds(new Rectangle(11, 7, 109, 25));
jLabel.setComponentOrientation(ComponentOrientation.LEFT_TO_RIGHT);
jLabel.setText("Datenbank-Status");
jContentPane = new JPanel();
jContentPane.setLayout(null);
jContentPane.setBackground(Color.lightGray);
jContentPane.setComponentOrientation(ComponentOrientation.LEFT_TO_RIGHT);
jContentPane.add(getJTextPaneMeldungen(), null);
jContentPane.add(getJButtonDatenholen(), null);
jContentPane.add(getJScrollPaneData(), null);
jContentPane.add(getJTable(), null);
jContentPane.add(getJTablePlaylist(), null);
jContentPane.add(getJTextFieldNr(), null);
jContentPane.add(getJTextFieldTitel(), null);
jContentPane.add(getJTextFieldZusatzbeschreibung(), null);
jContentPane.add(getJTextFieldKuenstler(), null);
jContentPane.add(getJTextFieldAlbum(), null);
jContentPane.add(getJTextFieldGenre(), null);
jContentPane.add(getJTextFieldErscheinungsjahr(), null);
jContentPane.add(getJTextFieldMedientyp(), null);
jContentPane.add(getJTextFieldDateityp(), null);
jContentPane.add(getJTextFieldDateipfad(), null);
jContentPane.add(jLabel, null);
jContentPane.add(jLabelNr, null);
jContentPane.add(jLabelTitel, null);
jContentPane.add(jLabelZusatzbeschreibung, null);
jContentPane.add(jLabelKuenstler, null);
jContentPane.add(jLabelAlbum, null);
jContentPane.add(jLabelGenre, null);
jContentPane.add(jLabelErscheinungsjahr, null);
jContentPane.add(jLabelMedientyp, null);
jContentPane.add(jLabelDateityp, null);
jContentPane.add(jLabelDateipfad, null);
jContentPane.add(getJButtonDatenAendern(), null);
jContentPane.add(getJButtonDatenSchreiben(), null);
jContentPane.add(getJButtonNeuAnlegen(), null);
jContentPane.add(getJButtonPlay(), null);
jContentPane.add(getJButtonFileChooser(), null);
jContentPane.add(getJButtonFilter(), null);
jContentPane.add(getJPanel(), null);
jContentPane.add(getJButtonDBState(), null);
jContentPane.add(getJScrollPanePlaylist(), null);
jContentPane.add(getJButtonDatenLoeschen(), null);
jContentPane.add(jLabel2, null);
jContentPane.add(getJTextFieldPlaylistName(), null);
jContentPane.add(getJScrollPanePlaylistData(), null);
jContentPane.add(getJButtonPlayPlayList(), null);
jContentPane.add(getJButtonAddToPlayList(), null);
jContentPane.add(getJButtonDeleteFromPlayList(), null);
jContentPane.add(getJButtonAddPlayList(), null);
jContentPane.add(jLabel21, null);
jContentPane.add(getJTextFieldPlaylistNr(), null);
jContentPane.add(getJPanel1(), null);
jContentPane.add(getJButtonNewPlaylist(), null);
jContentPane.add(getJButtonPlaylistLaden(), null);
jContentPane.add(getJButtonDeletePlayList(), null);
}
return jContentPane;
}
/**
* This method initializes jJMenuBar
*
* @return javax.swing.JMenuBar
*/
private JMenuBar getJJMenuBar() {
if (jJMenuBar == null) {
jJMenuBar = new JMenuBar();
jJMenuBar.add(getFileMenu());
jJMenuBar.add(getEditMenu());
jJMenuBar.add(getHelpMenu());
}
return jJMenuBar;
}
/**
* This method initializes jMenu
*
* @return javax.swing.JMenu
*/
private JMenu getFileMenu() {
if (fileMenu == null) {
fileMenu = new JMenu();
fileMenu.setText("Datei");
fileMenu.add(getSaveMenuItem());
fileMenu.add(getExitMenuItem());
}
return fileMenu;
}
/**
* This method initializes jMenu
*
* @return javax.swing.JMenu
*/
private JMenu getEditMenu() {
if (editMenu == null) {
editMenu = new JMenu();
editMenu.setText("Bearbeiten");
editMenu.add(getCutMenuItem());
editMenu.add(getCopyMenuItem());
editMenu.add(getPasteMenuItem());
}
return editMenu;
}
/**
* This method initializes jMenu
*
* @return javax.swing.JMenu
*/
private JMenu getHelpMenu() {
if (helpMenu == null) {
helpMenu = new JMenu();
helpMenu.setText("Hilfe");
helpMenu.add(getAboutMenuItem());
helpMenu.add(getJMenuItem());
}
return helpMenu;
}
/**
* This method initializes jMenuItem
*
* @return javax.swing.JMenuItem
*/
private JMenuItem getExitMenuItem() {
if (exitMenuItem == null) {
exitMenuItem = new JMenuItem();
exitMenuItem.setText("Beenden");
exitMenuItem.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
System.exit(0);
}
});
}
return exitMenuItem;
}
/**
* This method initializes jMenuItem
*
* @return javax.swing.JMenuItem
*/
private JMenuItem getAboutMenuItem() {
if (aboutMenuItem == null) {
aboutMenuItem = new JMenuItem();
aboutMenuItem.setText("�ber");
aboutMenuItem.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
JDialog aboutDialog = getAboutDialog();
aboutDialog.pack();
Point loc = getJFrame().getLocation();
loc.translate(20, 20);
aboutDialog.setLocation(loc);
aboutDialog.setVisible(true);
}
});
}
return aboutMenuItem;
}
/**
* This method initializes aboutDialog
*
* @return javax.swing.JDialog
*/
private JDialog getAboutDialog() {
if (aboutDialog == null) {
aboutDialog = new JDialog(getJFrame(), true);
aboutDialog.setTitle("About MediaM");
aboutDialog.setBounds(new Rectangle(100, 100, 489, 300));
aboutDialog.setBounds(new Rectangle(100, 100, 361, 365));
aboutDialog.setContentPane(getAboutContentPane());
}
return aboutDialog;
}
/**
* This method initializes aboutContentPane
*
* @return javax.swing.JPanel
*/
private JPanel getAboutContentPane() {
if (aboutContentPane == null) {
jLabelUeber = new JLabel();
String CopyrightT ="";
CopyrightT = CopyrightT + "<html>(C)Copyright 2007 by Authors:<p>*Dr. TheAnh Vuong <p>*Mustafa Er <p>*Fabian B�ckmann <p><p>";
CopyrightT = CopyrightT + "Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.2 or any later version published by the Free Software Foundation; with no Invariant Sections, no Front-Cover Texts, and no Back-Cover Texts. A copy of the license is included in the section entitled \"GNU Free Documentation License\" (http://www.gnu.org/copyleft/fdl.html)";
jLabelUeber.setText(CopyrightT);
// jLabelUeber.setText("Copyright 2007 by Mustafa Er & Fabian B�ckmann @ TFH Bochum");
jLabelUeber.setForeground(Color.black);
jLabelUeber.setHorizontalTextPosition(SwingConstants.CENTER);
jLabelUeber.setHorizontalAlignment(SwingConstants.CENTER);
aboutContentPane = new JPanel();
aboutContentPane.setLayout(new BorderLayout());
aboutContentPane.setPreferredSize(new Dimension(400, 400));
aboutContentPane.add(getAboutVersionLabel(), BorderLayout.NORTH);
aboutContentPane.add(jLabelUeber, BorderLayout.CENTER);
}
return aboutContentPane;
}
/**
* This method initializes aboutVersionLabel
*
* @return javax.swing.JLabel
*/
private JLabel getAboutVersionLabel() {
if (aboutVersionLabel == null) {
aboutVersionLabel = new JLabel();
aboutVersionLabel.setText("<html> MediaM Version 1.4.1 <p>A Multimedia Application of Vuong-Mediapp Project <p> http://sourceforge.net/projects/vuong-mediapp/</html> ");
aboutVersionLabel.setHorizontalTextPosition(SwingConstants.CENTER);
aboutVersionLabel.setForeground(Color.blue);
aboutVersionLabel.setHorizontalAlignment(SwingConstants.CENTER);
}
return aboutVersionLabel;
}
/**
* This method initializes jMenuItem
*
* @return javax.swing.JMenuItem
*/
private JMenuItem getCutMenuItem() {
if (cutMenuItem == null) {
cutMenuItem = new JMenuItem();
cutMenuItem.setText("Ausschneiden");
cutMenuItem.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_X,
Event.CTRL_MASK, true));
}
return cutMenuItem;
}
/**
* This method initializes jMenuItem
*
* @return javax.swing.JMenuItem
*/
private JMenuItem getCopyMenuItem() {
if (copyMenuItem == null) {
copyMenuItem = new JMenuItem();
copyMenuItem.setText("Kopieren");
copyMenuItem.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_C,
Event.CTRL_MASK, true));
}
return copyMenuItem;
}
/**
* This method initializes jMenuItem
*
* @return javax.swing.JMenuItem
*/
private JMenuItem getPasteMenuItem() {
if (pasteMenuItem == null) {
pasteMenuItem = new JMenuItem();
pasteMenuItem.setText("Einf�gen");
pasteMenuItem.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_V,
Event.CTRL_MASK, true));
}
return pasteMenuItem;
}
/**
* This method initializes jMenuItem
*
* @return javax.swing.JMenuItem
*/
private JMenuItem getSaveMenuItem() {
if (saveMenuItem == null) {
saveMenuItem = new JMenuItem();
saveMenuItem.setText("Speichern");
saveMenuItem.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_S,
Event.CTRL_MASK, true));
}
return saveMenuItem;
}
}