Net Beans IDE 6.9.1
3.3. SCOURCE CODE
3.3.3. EMPLOYEE PAGE
3.3.3. EMPLOYEE PAGE
/*
* To change this template, choose Tools | Templates * and open the template in the editor.
*/
/*
* Employee.java *
* Created on Apr 2, 2014, 3:31:29 PM */
package employeemanagementsystem;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import javax.swing.JOptionPane;
import javax.swing.JFrame;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;
/**
*
* @author NIRO */
public class Employee extends javax.swing.JFrame {
/** Creates new form Employee */
public Employee(String empid) initComponents();
setEMPID(empid);
setText();
}
private String empid ;
public void setEMPID(String empid) {
this.empid = empid;
}
public String getEMPID() { return empid;
}
void setText() {
try {
// TODO add your handling code here:
boolean b = true;
// TODO add your handling code here:
DB.Connect.openConnection();
String sql = "select * from emp where emp_ID='" +getEMPID()+ "'";
DB.Connect.rs = DB.Connect.stat.executeQuery(sql);
if (DB.Connect.rs.next()) {
txtID.setText(DB.Connect.rs.getString(1));
txtName.setText(DB.Connect.rs.getString(2));
txtDOb.setText(DB.Connect.rs.getString(3));
txtQual.setText(DB.Connect.rs.getString(4));
txtDept.setText(DB.Connect.rs.getString(5));
txtPass.setText(DB.Connect.rs.getString(6));
txtSal.setText(DB.Connect.rs.getString(7));
txtPhone.setText(DB.Connect.rs.getString(8));
txtEmail.setText(DB.Connect.rs.getString(9));
b = false;
}
DB.Connect.rs.close();
DB.Connect.closeConnection();
if (b) {
JOptionPane.showMessageDialog(null, "Record Not Found");
}
} catch (SQLException ex) { ex.printStackTrace();
} }
/** This method is called from within the constructor to
* initialize the form.
* WARNING: Do NOT modify this code. The content of this method is
* always regenerated by the Form Editor.
*/
@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() { jLabel1 = new javax.swing.JLabel();
jLabel8 = new javax.swing.JLabel();
jLabel7 = new javax.swing.JLabel();
jLabel4 = new javax.swing.JLabel();
jLabel5 = new javax.swing.JLabel();
jLabel2 = new javax.swing.JLabel();
jLabel3 = new javax.swing.JLabel();
jLabel10 = new javax.swing.JLabel();
jLabel9 = new javax.swing.JLabel();
txtID = new javax.swing.JTextField();
txtName = new javax.swing.JTextField();
txtDOb = new javax.swing.JTextField();
txtPass = new javax.swing.JPasswordField();
txtSal = new javax.swing.JTextField();
txtPhone = new javax.swing.JTextField();
txtEmail = new javax.swing.JTextField();
txtQual = new javax.swing.JTextField();
txtDept = new javax.swing.JTextField();
jButton1 = new javax.swing.JButton();
jButton3 = new javax.swing.JButton();
jButton2 = new javax.swing.JButton();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
jLabel1.setFont(new java.awt.Font("Algerian", 1, 18));
jLabel1.setText("Online appraisal System");
jLabel8.setText("Qualificaation");
jLabel6.setText("Password");
jLabel7.setText("Salary");
jLabel4.setText("DOB");
jLabel5.setText("Department");
jLabel2.setText("Employee ID");
jLabel3.setText("Employee Name");
jLabel10.setText("Email ID");
jLabel9.setText("Phone No");
txtID.setEnabled(false);
txtName.setEnabled(false);
txtDOb.setEnabled(false);
txtSal.setEnabled(false);
txtQual.setEnabled(false);
txtDept.setEnabled(false);
jButton1.setText("Update");
jButton1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton1ActionPerformed(evt);
} });
jButton3.setText("Log Out");
jButton3.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton3ActionPerformed(evt);
} });
jButton2.setText("Notification");
jButton2.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) { jButton2ActionPerformed(evt);
} });
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup()
.addContainerGap(178, Short.MAX_VALUE)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup() .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addComponent(jLabel2)
.addComponent(jLabel3) .addComponent(jLabel4) .addComponent(jLabel8) .addComponent(jLabel6) .addComponent(jLabel7)
.addComponent(jLabel9) .addComponent(jLabel10) .addComponent(jLabel5)) .addComponent(jButton2)) .addGap(6, 6, 6)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(txtPass,javax.swing.GroupLayout.PREFERRED_SIZE,120, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(layout.createSequentialGroup() .addComponent(jButton1)
.addGap(18, 18, 18)
.addComponent(jButton3))) .addGap(226, 226, 226))
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup() .addComponent(jLabel1,javax.swing.GroupLayout.PREFERRED_SIZE,344,
javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(167, 167, 167))))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup()
.addGap(19, 19, 19)
.addComponent(jLabel1,javax.swing.GroupLayout.PREFERRED_SIZE,35, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel2)
.addComponent(txtID,javax.swing.GroupLayout.PREFERRED_SIZE,25, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel3)
.addComponent(txtNamejavax.swing.GroupLayout.PREFERRED_SIZE,25, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jLabel4, javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(txtDOb,javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE,25,
javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addGroup(javax.swing.GroupLayout.Alignment.LEADING, layout.createSequentialGroup() .addGap(24, 24, 24)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel8)
.addComponent(txtQual,javax.swing.GroupLayout.PREFERRED_SIZE,25, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGroup(layout.createSequentialGroup() .addGap(70, 70, 70)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel5)
.addComponent(txtDept,javax.swing.GroupLayout.PREFERRED_SIZE,25, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(17, 17, 17)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel6)
.addComponent(txtPass,javax.swing.GroupLayout.PREFERRED_SIZE,25, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(txtSal,javax.swing.GroupLayout.PREFERRED_SIZE,25,
javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel7))))
.addGap(11, 11, 11)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(txtPhone,javax.swing.GroupLayout.PREFERRED_SIZE,25, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel9)) .addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(txtEmail,javax.swing.GroupLayout.PREFERRED_SIZE,25,
javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel10))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED,30, Short.MAX_VALUE)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jButton3)
.addComponent(jButton1) .addComponent(jButton2)) .addContainerGap()) );
pack();
}// </editor-fold>
private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here:
Login ln=new Login();
ln.show();
this.hide();
}
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here:
updateAccount();
}
void getcol() { try {
DefaultTableModel model;
JTable tb;
JScrollPane sb;
JFrame f3 = new JFrame();
tb = new JTable();
tb.setBounds(10, 40, 10, 10);
f3.setSize(900, 450);
f3.setTitle("Report Generation");
sb = new JScrollPane(tb);
sb.setBounds(30, 60, 150, 100);
f3.add(sb);
f3.setVisible(true);
DB.Connect.openConnection();
DB.Connect.rs = DB.Connect.stat.executeQuery("select * from notification where emp_ID='"
+getEMPID()+ "'");
ResultSetMetaData rsmd = DB.Connect.rs.getMetaData();
// JPanel panel = new JPanel();
// model.addColumn("Purchase");
model = new DefaultTableModel();
model.addColumn("Employee ID");
model.addColumn("Employee Name");
model.addColumn("DOB");
model.addColumn("Qualification");
model.addColumn("Department");
model.addColumn("Password");
model.addColumn("Salary");
model.addColumn("Phone No");
model.addColumn("Email ID");
model.addColumn("Date");
model.addColumn("Time");
// model.addColumn("Purchase");
tb.setModel(model);
String data1[] = new String[11];
while (DB.Connect.rs.next()) {
data1[0] =DB.Connect.rs.getString(1);
data1[1] = DB.Connect.rs.getString(2);
data1[2] = DB.Connect.rs.getString(3);
data1[3] = DB.Connect.rs.getString(4);
data1[4] =DB.Connect. rs.getString(5);
data1[5] =DB.Connect.rs.getString(6);
data1[6] = DB.Connect.rs.getString(7);
data1[8] =DB.Connect.rs.getString(9);
data1[9] =DB.Connect.rs.getString(10);
data1[10] =DB.Connect.rs.getString(11);
model.addRow(data1);
}
DB.Connect.closeConnection();
} catch (Exception e) { e.printStackTrace();
} }
private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) { }
public void updateAccount() {
try{
DB.Connect.openConnection();
DB.Connect.stat.executeUpdate("UPDATE emp SET emp_Pass='" + txtPass.getText() +
"',emp_Phone='" + txtPhone.getText() + "',emp_Email='" + txtEmail.getText() + "' WHERE emp_ID='" + txtID.getText() + "'");
DB.Connect.closeConnection();
JOptionPane.showMessageDialog(null,"Updated Successfully");
}
catch(Exception ex) {
ex.printStackTrace();
} } /**
* @param args the command line arguments
*/
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() { public void run() {
} });
}
// Variables declaration - do not modify private javax.swing.JButton jButton1;
private javax.swing.JButton jButton2;
private javax.swing.JButton jButton3;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel10;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel3;
private javax.swing.JLabel jLabel4;
private javax.swing.JLabel jLabel5;
private javax.swing.JLabel jLabel6;
private javax.swing.JLabel jLabel7;
private javax.swing.JLabel jLabel8;
private javax.swing.JLabel jLabel9;
private javax.swing.JTextField txtDOb;
private javax.swing.JTextField txtDept;
private javax.swing.JTextField txtEmail;
private javax.swing.JTextField txtID;
private javax.swing.JTextField txtName;
private javax.swing.JPasswordField txtPass;
private javax.swing.JTextField txtPhone;
private javax.swing.JTextField txtQual;
private javax.swing.JTextField txtSal;
// End of variables declaration
CHAPTER-4
4.1. CONCLUSION
The proposed system is completely online web application which is more feasible, efficient, user friendly and economical. By adopting a system that manages the entire employee lifecycle - from recruiting to performance assessment to goal alignment to employee retention—it's safe to say that having an online automated system can truly transform your business by increasing your revenue while lowering your bottom line costs.
Features of proposed system (which we analyze)
In comparison to present system the proposed system will be less time consuming and more efficient.
Analysis will be very easy in proposed system as it is automated.
Decisions will be declared in a very short span of time just because of automated system.
The proposed system is much secure because there is no chance of paper leakage.
The appraisals and other informIIation’s are stored in secure database which is handled by an administrator and backup can be thus created for future use.