package Employees;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.swing.JOptionPane;
import javax.swing.SwingUtilities;

public final class Workers extends javax.swing.JFrame {

    Connection con;
    Statement stmt;
    ResultSet rs;
    private String id;
    private String Fname;
    
    public Workers() {
       // initComponents();
        DoConnect();
    }
    
    public void DoConnect()
    {
        try
        {
            String host = "jdbc:derby://localhost:1527/Employees";
            String uName = "root";
            String uPass = "root";
            
            con = DriverManager.getConnection(host,uName,uPass);
            stmt = con.createStatement();
            String sql = "select * from workers";
            rs = stmt.executeQuery(sql);
            
            rs.next();
            int id_col = rs.getInt("ID");
            String id_1 = Integer.toString(id_col);
            String Fnames = rs.getString("NAME");
            
            textID.setText(id_1);
            textFirstName.setText(Fnames);
           
            
            
        }
        
        catch(SQLException err)
        {
            JOptionPane.showMessageDialog(Workers.this, err.getMessage());
           
        }
    }


    
  
   @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">                          
    private void initComponents() {

        textID = new javax.swing.JTextField();
        textFirstName = new javax.swing.JTextField();

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

        textID.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                textIDActionPerformed(evt);
            }
        });

        textFirstName.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                textFirstNameActionPerformed(evt);
            }
        });

        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
                .addContainerGap(32, Short.MAX_VALUE)
                .addComponent(textID, javax.swing.GroupLayout.PREFERRED_SIZE, 75, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(30, 30, 30)
                .addComponent(textFirstName, javax.swing.GroupLayout.PREFERRED_SIZE, 108, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(155, 155, 155))
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addGap(25, 25, 25)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(textID, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(textFirstName, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addContainerGap(255, Short.MAX_VALUE))
        );

        pack();
    }// </editor-fold>                        

    private void textIDActionPerformed(java.awt.event.ActionEvent evt) {                                       
         
    }                                      

    private void textFirstNameActionPerformed(java.awt.event.ActionEvent evt) {                                              
        
    }                                             

    /**
     * @param args the command line arguments
     */

    // Variables declaration - do not modify                     
    private javax.swing.JTextField textFirstName;
    private javax.swing.JTextField textID;
    // End of variables declaration                   


public static void main(String args[]) {
      
        SwingUtilities.invokeLater(new Runnable() {
          
            @Override
            public void run()
            {
                new Workers().setVisible(true);
                
            }
        });
}
}