package pack_subiect_restaurant;

public class Restaurant
{
	private String denumire;
	private String specific;
	private String zona;
	public Restaurant(String denumire, String specific, String zona) {
		super();
		this.denumire = denumire;
		this.specific = specific;
		this.zona = zona;
	}
	public String getDenumire() {
		return denumire;
	}
	public String getSpecific() {
		return specific;
	}
	public String getZona() {
		return zona;
	}
	public void setDenumire(String denumire) {
		this.denumire = denumire;
	}
	public void setSpecific(String specific) {
		this.specific = specific;
	}
	public void setZona(String zona) {
		this.zona = zona;
	}
	@Override
	public String toString() {
		return "denumire=" + denumire + ", specific=" + specific + ", zona=" + zona;
	}


}
package pack_subiect_restaurant;

import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;

import javax.swing.DefaultListModel;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JList;

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;

public class Frame1 extends JFrame
{
	/**
	 *
	 */
	private static final long serialVersionUID = 1L;
	Vector<Restaurant> restaurant=new Vector<>();
	JList<Object> lista;
	DefaultListModel<Object> model;
	public Frame1() throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException
	{
		super("Frame1");
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		setSize(400,400);
		getContentPane().setLayout(null);
		model=new DefaultListModel<>();
		lista=new JList<>(model);

		String url="jdbc:mysql://localhost:3306/test";
		Class.forName("com.mysql.cj.jdbc.Driver").newInstance();
		Connection con=(Connection) DriverManager.getConnection(url,"root"," ");
		Statement sql=(Statement) con.createStatement();
		ResultSet rs=sql.executeQuery("SELECT *FROM restaurant");
		JLabel titlu=new JLabel("Lista restaurante");
		//SETARE LOCATIE
		titlu.setBounds(100, 20, 100, 100);
		lista.setBounds(100,40,150,150);
		//ADAUGARE ELEMENTE
		getContentPane().add(titlu);
		getContentPane().add(lista);

		while(rs.next())
		{
			Restaurant res=new Restaurant(rs.getString(1),rs.getString(2),rs.getString(3));
			restaurant.add(res);
		}
		for(int i=0;i<restaurant.size();i++)
		{
			Restaurant r = (Restaurant) restaurant.elementAt(i);
			model.addElement(r.toString());
		}
		con.close();
		sql.close();
		rs.close();


	}

}
class MainFrame1 {

	public static void main(String[] args) throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException{
		JFrame fereastra=new Frame1();
		fereastra.setVisible(true);

	}

}
package pack_subiect_restaurant;

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

import javax.swing.DefaultListModel;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JList;
import javax.swing.JTextField;

import com.mysql.jdbc.Statement;

public class Frame2 extends JFrame
{
	/**
	 *
	 */
	private static final long serialVersionUID = 1L;
	static Vector<String> melodii=new Vector<String>();
	static JButton stergere= new JButton("Sterge");
	static JLabel  melodie=new JLabel("Melodie");
	static JTextField txtMelodie= new JTextField();
	static DefaultListModel<Object> model=new DefaultListModel<>();
	static JList<Object> lista=new JList<Object>(model);
	static Connection con;
	static Statement stmt;
	static ResultSet rs;
	public Frame2() throws SQLException
	{
		super("Frame2");
		setDefaultCloseOperation(EXIT_ON_CLOSE);
		setSize(400,400);
		getContentPane().setLayout(null);
		model=new DefaultListModel<>();
		lista=new JList<>(model);
		//SETARE LOCATIE
		melodie.setBounds(60, 20, 100, 100);
		txtMelodie.setBounds(100,20,100,100);
		stergere.setBounds(60,60,100,100);
		lista.setBounds(60, 100, 200, 200);
		//ADAUGARE ELEMENTE
		getContentPane().add(melodie);
		getContentPane().add(txtMelodie);
		getContentPane().add(stergere);
		getContentPane().add(lista);

		String url = "jdbc:mysql://localhost:3306/test";
		Connection con=DriverManager.getConnection(url, "root", "root");
		Statement stmt = (Statement)con.createStatement();
		ResultSet rs=stmt.executeQuery("Select *from melodii");

		while(rs.next()) {
			melodii.add(rs.getString(1));

		}
		for(int i=0;i<melodii.size();i++)
		{
			model.addElement(melodii.elementAt(i));
		}
		stergere.addActionListener(new Clicked());
		con.close();
		stmt.close();
		rs.close();




	}
}
class MainFrame2 {

	public static void main(String[] args) throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException{
		JFrame fereastra=new Frame2();
		fereastra.setVisible(true);

	}

}
package pack_subiect_restaurant;

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.SQLException;

import com.mysql.jdbc.PreparedStatement;

public class Clicked implements ActionListener
{

	@Override
	public void actionPerformed(ActionEvent arg0)
	{
		String melodieS=Frame2.txtMelodie.getText();
		for(int i=0;i<Frame2.melodii.size();i++)
		{
			if(Frame2.melodii.elementAt(i).equals(melodieS))
			{
				Frame2.melodii.remove(i);
				Frame2.model.removeElementAt(i);
				try {
					PreparedStatement deleteStmt=(PreparedStatement) Frame2.con.prepareStatement("Delete from melodii where melodie=?");
					deleteStmt.setString(1, melodieS);
					deleteStmt.execute();
					Frame2.rs=Frame2.stmt.executeQuery("Select *from melodii");
				} catch (SQLException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
				}
			}
		}

	}

}