package Matei;

import java.awt.EventQueue;

import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.border.EmptyBorder;

import com.mysql.cj.xdevapi.PreparableStatement;

import java.awt.BorderLayout;
import javax.swing.JTextField;
import javax.swing.JList;
import javax.swing.DefaultListModel;
import javax.swing.JButton;
import javax.swing.SwingConstants;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.awt.event.ActionEvent;

public class Matei extends JFrame {

	private JPanel contentPane;
	private JTextField txtAdaugare;

	/**
	 * Launch the application.
	 */
	public static void main(String[] args) {
		EventQueue.invokeLater(new Runnable() {
			public void run() {
				try {
					Matei frame = new Matei();
					frame.setVisible(true);
				} catch (Exception e) {
					e.printStackTrace();
				}
			}
		});
	}

	/**
	 * Create the frame.
	 * @throws SQLException 
	 */
	public Matei() throws SQLException {
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		setBounds(100, 100, 450, 300);
		contentPane = new JPanel();
		contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));

		setContentPane(contentPane);
		contentPane.setLayout(new BorderLayout(0, 0));
		
		DefaultListModel mylist=new DefaultListModel();
		
		JList list = new JList(mylist);
		contentPane.add(list, BorderLayout.CENTER);
		
		String url="jdbc:mysql://localhost:3306/matei";
		String sql="Select * From matei";
		Connection con=DriverManager.getConnection(url,"root","root");
		Statement statement=con.createStatement();
		ResultSet rs=statement.executeQuery(sql);
		
		while(rs.next())
		{
			String s=rs.getInt(1)+","+rs.getString(2)+","+rs.getString(3)+","+rs.getInt(4);
			mylist.addElement(s);
			
		}
		
		
		txtAdaugare = new JTextField();
		txtAdaugare.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				String s=txtAdaugare.getText();
				mylist.addElement(s);
				
				String sql="Insert into Matei Values(?,?,?,?)";
				try {
					PreparedStatement ps=con.prepareStatement(sql);
					String [] v;
					v=s.split(",");
					ps.setInt(1, Integer.parseInt(v[0]));
					ps.setString(2, v[1]);
					ps.setString(3, v[2]);
					ps.setInt(4, Integer.parseInt(v[3]));
					ps.executeUpdate();
					//ps.close();
					
				} catch (SQLException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
				}
			}
		});
		contentPane.add(txtAdaugare, BorderLayout.NORTH);
		txtAdaugare.setColumns(10);
		
		
		
		JButton btnStergere = new JButton("Stergere");
		btnStergere.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				String sql="Delete From Matei where id=?";
				try {
					PreparedStatement ps=con.prepareStatement(sql);
					String a=(String) list.getSelectedValue();
					int b=Integer.parseInt(a.split(",")[0]);
					ps.setInt(1, b);
					ps.executeUpdate();
					ps.close();
				} catch (SQLException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
				}
				mylist.remove(list.getSelectedIndex());
			}
		});
		contentPane.add(btnStergere, BorderLayout.SOUTH);
		//rs.close();
		//statement.close();
		//con.close();
	}

}