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

}