import java.awt.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.swing.*;
import javax.swing.event.ChangeEvent;
import javax.swing.event.ChangeListener;

import java.sql.*;

public class EmployeeEdit extends JPanel{
    JLabel labelID = new JLabel("Employee ID");
    JLabel labelName = new JLabel("Employee Name");
    JLabel labelSalary = new JLabel("Employee Salary");
    JTextField textID = new JTextField(10);
    JTextField textName = new JTextField(20);
    JTextField textSalary = new JTextField(10);
    JButton edit = new JButton("Edit");
    public EmployeeEdit(){

        Connection con = null;
        int NumRows = 0;
        try {
            con = getConnection();
            String tableName = "EmpTable";
            NumRows = countRows(con, tableName);
            System.out.println("rowCount=" + NumRows);
            Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
            ResultSet resultSet = stmt.executeQuery("SELECT Emp_code, Emp_name, Emp_Salary FROM EmpTable");
            SpinnerModel model = new SpinnerNumberModel(1, 1, NumRows, 1);
            JSpinner box = new JSpinner(model);
            box.addChangeListener(new SpinnerListener());
            add(box);
            } catch (Exception e) {
                e.printStackTrace();
                System.exit(1);
            }
                add(labelID);
                add(textID);
                add(labelName);
                add(textName);
                add(labelSalary);
                add(textSalary);
                add(edit);
    }

      public static Connection getConnection() throws Exception {
            String url = "jdbc:mysql://mer.hosted.nfoservers.com:3306/";
            String dbName = "mer_junk";
            String driverName = "com.mysql.jdbc.Driver";
            String userName = "HURF";
            String password = "BLURF";
            System.out.println("Connected");
            Class.forName(driverName).newInstance();
            Connection con = DriverManager.getConnection(url+dbName, userName, password);

            return con;
      }

      public static int countRows(Connection con, String tableName) throws SQLException {
            Statement stmt = null;
            ResultSet rs = null;
            int rowCount = -1;
            try {
                stmt = con.createStatement();
                rs = stmt.executeQuery("SELECT COUNT(*) FROM " + tableName);
                rs.next();
                rowCount = rs.getInt(1);
            } finally {
                rs.close();
                stmt.close();
            }
            return rowNigger;
      }

      public void updateFields(int rowNum, ResultSet rs){
          try {
            rs.absolute(rowNum);

        } catch (SQLException e) {
            e.printStackTrace();
        }

      }

      public class SpinnerListener implements ChangeListener{

        public void stateChanged(ChangeEvent e) {
            JSpinner spinner = (JSpinner) e.getSource();
            Object value = spinner.getValue();


        }

      }



}