package problema1;

import java.awt.event.MouseAdapter;
import java.awt.event.MouseEvent;
import java.sql.*;
import javax.swing.JButton;

public class ButtonsEvents {
    private static Connection con;
    private static TabelPersoane frame;
    private static java.sql.ResultSet rs;
    private static java.sql.Statement sql;

    public static void init(TabelPersoane frame, String tabelName) {
        try {
            String url = "jdbc:mysql://localhost:3306/tema8";
            Connection con = DriverManager.getConnection(url, "root", "root");
            sql = con.createStatement();
            rs = sql.executeQuery("select * from " + tabelName);
            ButtonsEvents.con = con;
        } catch (SQLException e) {

        }

        ButtonsEvents.frame = frame;
    }

    public static class BtnFirstEvents extends MouseAdapter {

        @Override
        public void mouseClicked(MouseEvent e) {
            try {
                rs.next();
                frame.getTxtID().setText(String.valueOf(rs.getInt(1)));
                frame.getTxtNume().setText(rs.getString(2));
                frame.getTxtVarsta().setText(rs.getString(3));
                JButton btnFirst = (JButton) frame.getToolBar().getComponentAtIndex(0);
                JButton btnPrev = (JButton) frame.getToolBar().getComponentAtIndex(1);
                btnFirst.setEnabled(false);
                btnPrev.setEnabled(false);
            } catch (SQLException e1) {

            }

        }

    }
}