import java.awt.BorderLayout;
import java.awt.EventQueue;

import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.border.EmptyBorder;
import javax.swing.JButton;
import java.awt.GridLayout;

import java.sql.*;
import javax.sql.*;
import javax.swing.JLabel;
import javax.swing.JTextField;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;

public class frmHallgato extends JFrame {

    private JPanel contentPane;

    /**
     * Launch the application.
     */
    public static final String USER="root";
    public static final String PASS="root";
    public static final String DB_URL="jdbc:mysql://localhost:3311/egyetem";
    public static Connection kapcsolat;
    public static ResultSet rs;
    public static Statement lekerdezes;

    private JTextField txtSzak;
    private JTextField txtTagozat;
    private JTextField txtHid;
    private JTextField txtHNeve;
    private JTextField txtEvfolyam;
    public static void main(String[] args) {
        EventQueue.invokeLater(new Runnable() {
            public void run() {
                try {
                    Class.forName("com.mysql.jdbc.Driver");
                    kapcsolat = DriverManager.getConnection(DB_URL,USER,PASS);
                    String sql = "select  * from hallgato inner join szak"
                            + " on szak.Szakazonosito=hallgato.Szakazonosito "
                            + " where evfolyam='I'";
                    lekerdezes = kapcsolat.createStatement();
                    rs  = lekerdezes.executeQuery(sql);
                    while(rs.next())
                    {
                        int hId = rs.getInt(1);
                        String hNeve = rs.getString(2);
                        String hEvfolyam = rs.getString("Evfolyam");
                        String szNeve = rs.getString(7);
                        String ki = String.format("%s(%d):%s,%s",
                                hNeve,hId,szNeve,hEvfolyam);
                        System.out.println(ki);
                    }
                    rs.first();

                    frmHallgato frame = new frmHallgato();
                    frame.setVisible(true);
                } catch (Exception e) {
                    e.printStackTrace();
                }
            }
        });
    }

    /**
     * Create the frame.
     */
    public frmHallgato() {
        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        setBounds(100, 100, 450, 300);
        contentPane = new JPanel();
        contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
        contentPane.setLayout(new BorderLayout(0, 0));
        setContentPane(contentPane);

        JPanel pNav = new JPanel();
        contentPane.add(pNav, BorderLayout.SOUTH);
        pNav.setLayout(new GridLayout(0, 4, 0, 0));

        JButton btnElso = new JButton("Els\u0151");
        btnElso.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent arg0) {
            try {
                rs.first();
                betolt();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }

            }
        });
        pNav.add(btnElso);

        JButton btnElozo = new JButton("El\u00F6z\u0151");
        btnElozo.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                  try {
                        rs.previous();
                        betolt();
                    } catch (SQLException h) {
                        // TODO Auto-generated catch block
                        h.printStackTrace();
                    }
            }
        });
        pNav.add(btnElozo);

        JButton btnKovetkezo = new JButton("K\u00F6vetkez\u0151");
        btnKovetkezo.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent arg0) {
               try {
                rs.next();
                betolt();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }

            }


        });
        pNav.add(btnKovetkezo);

        JButton btnUtolso = new JButton("Utols\u00F3");
        btnUtolso.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                  try {
                        rs.last();
                        betolt();
                    } catch (SQLException h) {
                        // TODO Auto-generated catch block
                        h.printStackTrace();
                    }
            }
        });
        pNav.add(btnUtolso);

        JPanel pAdatok = new JPanel();
        contentPane.add(pAdatok, BorderLayout.CENTER);
        pAdatok.setLayout(new GridLayout(5, 2, 0, 0));

        JLabel lblNewLabel = new JLabel("Hallgat\u00F3 azonos\u00EDt\u00F3");
        pAdatok.add(lblNewLabel);

        txtHid = new JTextField();
        pAdatok.add(txtHid);
        txtHid.setColumns(10);

        JLabel lblNewLabel_1 = new JLabel("Hallgat\u00F3 neve");
        pAdatok.add(lblNewLabel_1);

        txtHNeve = new JTextField();
        pAdatok.add(txtHNeve);
        txtHNeve.setColumns(10);

        JLabel lblNewLabel_2 = new JLabel("\u00C9vfolyam");
        pAdatok.add(lblNewLabel_2);

        txtEvfolyam = new JTextField();
        pAdatok.add(txtEvfolyam);
        txtEvfolyam.setColumns(10);

        JLabel lblNewLabel_3 = new JLabel("Tagozat");
        pAdatok.add(lblNewLabel_3);

        txtTagozat = new JTextField();
        pAdatok.add(txtTagozat);
        txtTagozat.setColumns(10);

        JLabel lblNewLabel_4 = new JLabel("Szak neve");
        pAdatok.add(lblNewLabel_4);

        txtSzak = new JTextField();
        pAdatok.add(txtSzak);
        txtSzak.setColumns(10);
    }

    protected void betolt() throws SQLException {
        // TODO Auto-generated method stub
        String h = rs.getString(2);
        txtHNeve.setText(h);
    }

}