2 Piese Muzicale

package proiect2;

import java.awt.List;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JTextField;

import com.mysql.jdbc.Statement;

public class Muzica {

    private int nr_crt;
    private String titlu_piesa;
    private String artist;
    private int an_aparitie;

public Muzica(int nr_crt, String titlu_piesa, String artist, int an_aparitie) {
    this.nr_crt=nr_crt;
    this.titlu_piesa = titlu_piesa;
        this.artist = artist;
        this.an_aparitie = an_aparitie;
    }

public String toString() {
    return "Muzica Nr Crt =" + nr_crt + ", Titlul Piesei" + titlu_piesa + ", Aristul " + artist
            + ", Anul Apritiei" + an_aparitie + "]";
}

public int getNr_crt() {
    return nr_crt;
}

public void setNr_crt(int nr_crt) {
    this.nr_crt = nr_crt;
}

public String getTitlu_piesa() {
    return titlu_piesa;
}

public void setTitlu_piesa(String titlu_piesa) {
    this.titlu_piesa = titlu_piesa;
}

public String getArtist() {
    return artist;
}

public void setArtist(String artist) {
    this.artist = artist;
}

public int getAn_aparitie() {
    return an_aparitie;
}

public void setAn_aparitie(int an_aparitie) {
    this.an_aparitie = an_aparitie;
}

public static void main(String[] args) throws SQLException, InstantiationException, IllegalAccessException, ClassNotFoundException{

    String url="jdbc:mysql://localhost:3306/test";
    Statement sql;
    ResultSet rs;
    Class.forName("com.mysql.jdbc.Driver").newInstance();
    Connection con=DriverManager.getConnection(url,"root","root");
    sql=(Statement) con.createStatement();
    rs=sql.executeQuery("select * from songs");

    ArrayList<Muzica> melodie=new ArrayList<Muzica>();

    while (rs.next()){
            melodie.add(new Muzica(rs.getInt("nr_crt"), rs.getString("titlu_piesa"), rs.getString("artist"), rs.getInt("an_aparitie")));
    }

    for(int i=0;i<melodie.size();i++)
        System.out.println(melodie.get(i).toString());

    String s = (String)JOptionPane.showInputDialog(null,"Introduceti indicele melodiei:","Input",JOptionPane.QUESTION_MESSAGE,null,null,null);
    System.out.println("Indicele introdus este: " + s);

    try {
    int indice = Integer.parseInt(s);
    melodie.remove(indice);
    } catch (NumberFormatException ex) {
        JOptionPane.showMessageDialog(null, "Numar invalid", "Eroare", JOptionPane.ERROR_MESSAGE);
    }

    con.close();
    sql.close();
    rs.close();
}
}