//CLASA MELODIE
package TEST2_exercitii;

public class Melodie
{
	private int Id;
	private String melodie;
	private String artist;
	private int an_aparitie;
	public Melodie(int Id,String melodie, String artist, int an_aparitie) {
		this.Id = Id;
		this.melodie = melodie;
		this.artist = artist;
		this.an_aparitie = an_aparitie;
	}
	public int getId() {
		return Id;
	}
	public String getMelodie() {
		return melodie;
	}
	public String getArtist() {
		return artist;
	}
	public int getAn_aparitie() {
		return an_aparitie;
	}
	public void setId(int Id) {
		this.Id = Id;
	}
	public void setMelodie(String melodie) {
		this.melodie = melodie;
	}
	public void setArtist(String artist) {
		this.artist = artist;
	}
	public void setAn_aparitie(int an_aparitie) {
		this.an_aparitie = an_aparitie;
	}
	@Override
	public String toString() {
		return "Melodie id=" + Id +", melodie= +" + melodie + ", artist=" + artist + ", an_aparitie=" + an_aparitie;
	}

}
//CLASA PENTRU BAZA DE DATE
package TEST2_exercitii;

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

import javax.swing.JOptionPane;
import com.mysql.jdbc.Statement;

public class Baza_date {

	public static void main(String[] args) throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException {
		String url = "jdbc:mysql://localhost:3306/test";
		Class.forName ("com.mysql.jdbc.Driver").newInstance ();
		Connection con = DriverManager.getConnection (url, "root", "");
		Statement sql=(Statement) con.createStatement();
		ResultSet rs=sql.executeQuery("SELECT * FROM melodii");
		ArrayList<Melodie> melodie=new ArrayList<Melodie>();
		while(rs.next())
		{
			Melodie m=new Melodie(rs.getInt("Id"),rs.getString("melodie"),rs.getString("artist"),rs.getInt("an_aparitie"));
			melodie.add(m);
		}
		for(Melodie i:melodie)
			System.out.println(i.toString());

		String s = (String)JOptionPane.showInputDialog(null,"Introduceti indicele melodiei:","Input",JOptionPane.QUESTION_MESSAGE);
		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);
		}
		System.out.println("Melodiile dupa stergere:");
		for(Melodie i:melodie)
			System.out.println(i.toString());
		con.close();
		sql.close();
		rs.close();

	}

}