package subiectul2;

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

import javax.swing.JOptionPane;

public class MainApp {

	public static void main(String[] args) throws InstantiationException,IllegalAccessException,ClassNotFoundException,SQLException {
		// TODO Auto-generated method stub
	String url="jdbc:mysql://localhost:3306/test";
	Class.forName("com.mysql.jdbc.Driver").newInstance();
	Connection con=DriverManager.getConnection(url,"root","root");
	Statement sql=(Statement)con.createStatement();


		//preluare date din mysql
		ResultSet rs=sql.executeQuery("SELECT *FROM melodii_preferate");
		ArrayList<Melodie> melodie=new ArrayList<Melodie>();
		//pentru fiecare rand se creeaza o instanta a clasei melodie
		while(rs.next())
		{
			Melodie m=new Melodie(rs.getString("melodie"),rs.getString("artist"),rs.getString("anul_aparitiei"));
			melodie.add(m);//fiecare element e adaugat unei colectii de elemente de tip array list

		}
		//afisare in consola
		/*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);
		}*/
		/*String s=(String)JOptionPane.showInputDialog(null,"Introduceti numele melodiei pe care doriti sa o stergeti : ","Input",JOptionPane.QUESTION_MESSAGE);
		System.out.println("Indicele introdus este "+s);
		try
		{
			int indice=Integer.parseInt(s);
			melodie.remove(s);
		}catch(NumberFormatException ex)
		{
			JOptionPane.showMessageDialog(null,"numar invalid","eroare",JOptionPane.ERROR_MESSAGE);
		}*/
		String s=(String)JOptionPane.showInputDialog(null,"Introduceti indicele melodiei pe care doriti sa o stergeti :","Input",JOptionPane.QUESTION_MESSAGE);
		System.out.println("Indicele introdus este : "+s);
		try
		{
			int indice=Integer.parseInt(s);
			melodie.remove(s);

		}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();
	}

}
package subiectul2;

public class Melodie {
private String melodie;
private String artist;
private String anul_aparitiei;
public Melodie(String melodie, String artist, String anul_aparitiei) {

	this.melodie = melodie;
	this.artist = artist;
	this.anul_aparitiei = anul_aparitiei;
}
public String getMelodie() {
	return melodie;
}
public void setMelodie(String melodie) {
	this.melodie = melodie;
}
public String getArtist() {
	return artist;
}
public void setArtist(String artist) {
	this.artist = artist;
}
public String getAnul_aparitiei() {
	return anul_aparitiei;
}
public void setAnul_aparitiei(String anul_aparitiei) {
	this.anul_aparitiei = anul_aparitiei;
}
@Override
public String toString() {
	return "melodie=" + getMelodie() + ", artist=" + getArtist()+ ", anul_aparitiei=" + getAnul_aparitiei() + "]";
}


}