package muzicaSQL;

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 musisql {

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

	public musisql(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{
		// TODO Auto-generated method stub
		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<musisql> melodie=new ArrayList<musisql>();

		while (rs.next()){
				melodie.add(new musisql(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);
		// afisare
		for(int i=0;i<melodie.size();i++)
			System.out.println(melodie.get(i).toString());
		// afisare end
		} catch (NumberFormatException ex) {
			JOptionPane.showMessageDialog(null, "Numar invalid", "Eroare", JOptionPane.ERROR_MESSAGE);
		}

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

}