Its my working project

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
public class Project extends JApplet
{
JFrame f;
ButtonListener blisten;
Connect c;
JButton NewAdd,NewSave,Show,Exit,Delete,Update,Disp;
JLabel lId,lName,lDept,lDOJ,lBasic,lAdd;
JLabel slId,slName,slDept,slDOJ,slBasic,slAdd,slTA,slDA,slPF,slHRA,slGross;
JLabel mId,mName,mDept,mDOJ,mBasic,mAdd;
JTextField EmpId,EmpName,EmpDept,EmpDOJ,EmpBasic;
JTextArea EmpAdd;
JTextField sEmpId,sEmpName,sEmpDept,sEmpDOJ,sEmpBasic,sTA,sDA,sHRA,sPF,sGross;
JTextArea sEmpAdd;
JTextField mEmpId,mEmpName,mEmpDept,mEmpDOJ,mEmpBasic;
JTextArea mEmpAdd;

Connection conn;
Statement stmt;
ResultSet rs;
private PreparedStatement insertNewStudent;
class Connect
{
public Connect()throws SQLException,ClassNotFoundException
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection("jdbc:odbc:ProjEmp","Administrator","artijanu");
stmt=conn.createStatement();
rs=stmt.executeQuery("SELECT * FROM EmpProject");
insertNewStudent=conn.prepareStatement("insert into EmpProject values(?,?,?,?,?,?)");
}
boolean validateENo(String eno)throws SQLException
{
rs=stmt.executeQuery("SELECT * FROM EmpProject where EmpId='"+eno+"'");
if(rs.next())
{
return false;
}
else
{
return true;
}
}
void InsertNewStudent(String eno,String ename,String edno,String eadd,String edoj,int esalary)throws SQLException
{
insertNewStudent.setString(1,eno);
insertNewStudent.setString(2,ename);
insertNewStudent.setString(3,edno);
insertNewStudent.setString(4,eadd);
insertNewStudent.setString(5,edoj);
insertNewStudent.setInt(6,esalary);
insertNewStudent.executeUpdate();
}
void delete(String eno)
{
try
{
stmt.executeUpdate("DELETE FROM EmpProject where EmpId='"+eno+"'");
}
catch(SQLException se)
{
System.out.println("Exception is :"+se);
}
}
void UpdateStudent(String eno,String ename,String edno,String eadd,String DOJ,String eBas)
{
try
{

int ebass=Integer.parseInt(eBas);
stmt.executeUpdate("Update EmpProject set EmpName='"+ename+"',EmpDept='"+edno+"',EmpAdd='"+eadd+"',EmpDOJ='"+DOJ+"',EmpBasic='"+ebass+"' where EmpId='"+eno+"'");
}
catch(SQLException se)
{
System.out.println("Exception is :"+se);
}
}

}

class EmployeePanel extends JPanel
{
public EmployeePanel()
{
setLayout(new GridLayout(8,2));
add(lId);
add(EmpId);
add(lName);
add(EmpName);
add(lDept);
add(EmpDept);
add(lAdd);
add(new JScrollPane(EmpAdd));
add(lDOJ);
add(EmpDOJ);
add(lBasic);
add(EmpBasic);
add(NewAdd);
add(NewSave);
add(Delete);
add(Update);
}
}
class DispEmpPanel extends JPanel
{
public DispEmpPanel()
{
add(slId);
add(sEmpId);
setLayout(new GridLayout(12,2));
sEmpName.setEnabled(false);
sEmpDept.setEnabled(false);
sEmpAdd.setEnabled(false);
sEmpDOJ.setEnabled(false);
sEmpBasic.setEnabled(false);
sTA.setEnabled(false);
sDA.setEnabled(false);
sHRA.setEnabled(false);
sPF.setEnabled(false);
sGross.setEnabled(false);;
add(slName);
add(sEmpName);
add(slDept);
add(sEmpDept);
add(slAdd);
add(new JScrollPane(sEmpAdd));
add(slDOJ);
add(sEmpDOJ);
add(slBasic);
add(sEmpBasic);
add(slTA);
add(sTA);
add(slDA);
add(sDA);
add(slHRA);
add(sHRA);
add(slPF);
add(sPF);
add(slGross);
add(sGross);
add(Show);
add(Exit);
}
}
class ModifyEmp extends JPanel
{
public ModifyEmp()
{
add(mId);
add(mEmpId);
setLayout(new GridLayout(7,2));
add(mName);
add(mEmpName);
add(mDept);
add(mEmpDept);
add(mAdd);
add(new JScrollPane(mEmpAdd));
add(mDOJ);
add(mEmpDOJ);
add(mBasic);
add(mEmpBasic);
add(Disp);
add(Update);
}
}
class ButtonListener implements ActionListener
{
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==NewAdd)
{
System.out.println("Add Clicked");
EmpId.setText("");
EmpName.setText("");
EmpDept.setText("");
EmpDOJ.setText("");
EmpBasic.setText("");
EmpAdd.setText("");
}
if(e.getSource()==NewSave)
{
System.out.println("Save Clicked");
try
{
if(!c.validateENo(EmpId.getText()))
System.out.println("Already exists");
else
{
c.InsertNewStudent(EmpId.getText(),EmpName.getText(),EmpDept.getText(),EmpAdd.getText(),EmpDOJ.getText(),Integer.parseInt(EmpBasic.getText()));
System.out.println("Inserted");
}
}
catch(Exception ec)
{
System.out.println("Exception is :"+ec);
}
}
if(e.getSource()==Show)
{
System.out.println("Show clicked");
try
{
String eid=sEmpId.getText();
rs=stmt.executeQuery("select * from EmpProject where EmpId='"+eid+"'");
if(rs.next())
{
sEmpId.setText(rs.getString(1));
sEmpName.setText(rs.getString(2));
sEmpDept.setText(rs.getString(3));
sEmpAdd.setText(rs.getString(4));
sEmpDOJ.setText(rs.getString(5));
sEmpBasic.setText(String.valueOf(rs.getInt(6)));
sHRA.setText(String.valueOf(rs.getInt(7)));
sDA.setText(String.valueOf(rs.getInt(8)));
sTA.setText(String.valueOf(rs.getInt(9)));
sPF.setText(String.valueOf(rs.getInt(10)));
sGross.setText(String.valueOf(rs.getInt(11)));
}
}
catch(Exception e1)
{
System.out.println("Exception is :"+e1);
}
}
if(e.getSource()==Exit)
{
System.exit(0);
}
if(e.getSource()==Delete)
{
c.delete(EmpId.getText());
}
if(e.getSource()==Disp)
{
System.out.println("Disp clicked");
try
{
String eid=mEmpId.getText();
rs=stmt.executeQuery("select * from EmpProject where EmpId='"+eid+"'");
if(rs.next())
{
mEmpId.setText(rs.getString(1));
mEmpName.setText(rs.getString(2));
mEmpDept.setText(rs.getString(3));
mEmpAdd.setText(rs.getString(4));
mEmpDOJ.setText(rs.getString(5));
mEmpBasic.setText(String.valueOf(rs.getInt(6)));
}
}
catch(Exception e2)
{
System.out.println("Exception is :"+e2);
}
}
if(e.getSource()==Update)
{
System.out.println("Update clicked");
try
{
if(!c.validateENo(mEmpId.getText()))
{
c.UpdateStudent(mEmpId.getText(),mName.getText(),mEmpDept.getText(),mEmpAdd.getText(),mDOJ.getText(),mBasic.getText());
}
}
catch(Exception rrr)
{
System.out.println("Excdsfdeption is :"+rrr);
}
}

}
}
public void init()
{
try
{
c=new Connect();
}
catch(Exception e)
{
System.out.println("Hello"+e);
}
blisten=new ButtonListener();
initialize();
Container c=getContentPane();
JTabbedPane tab=new JTabbedPane(SwingConstants.TOP);
tab.addTab("New Employee Data Entry",new ImageIcon("gheart.gif"),new EmployeePanel(),"Enter New Employee Details");
tab.addTab("Disp Employee Details",new ImageIcon("gheart.gif"),new DispEmpPanel(),"Display Employee Details");
tab.addTab("Modify Employee Details",new ImageIcon("gheart.gif"),new ModifyEmp(),"Modify Employee Details");
tab.setBackground(Color.red);
c.add(tab);
}
public void initialize()
{
NewAdd=new JButton("ADD");
NewSave=new JButton("SAVE IT");
Show=new JButton("Show");
Disp=new JButton("Display it!!!");
Exit=new JButton("Exit");
Delete=new JButton("Delete");
Update=new JButton("Modify");
NewAdd.addActionListener(blisten);
NewSave.addActionListener(blisten);
Show.addActionListener(blisten);
Exit.addActionListener(blisten);
Delete.addActionListener(blisten);
Update.addActionListener(blisten);
Disp.addActionListener(blisten);
EmpId=new JTextField(4);
EmpName=new JTextField(15);
EmpDept=new JTextField(4);
EmpAdd=new JTextArea(5,10);
EmpDOJ=new JTextField(4);
EmpBasic=new JTextField(4);
sEmpId=new JTextField(4);
sEmpName=new JTextField(15);
sEmpDept=new JTextField(4);
sEmpAdd=new JTextArea(5,10);
sEmpDOJ=new JTextField(4);
sEmpBasic=new JTextField(4);
sTA=new JTextField(5);
sDA=new JTextField(5);
sHRA=new JTextField(5);
sPF=new JTextField(5);
sGross=new JTextField(5);
mEmpId=new JTextField(4);
mEmpName=new JTextField(15);
mEmpDept=new JTextField(4);
mEmpAdd=new JTextArea(5,10);
mEmpDOJ=new JTextField(4);
mEmpBasic=new JTextField(4);
lId=new JLabel("Employee ID");
lName=new JLabel("Employee Name");
lDept=new JLabel("Employee Dept");
lDOJ=new JLabel("Date of Joining(MM/DD/YYYY)");
lBasic=new JLabel("Basic Salary");
lAdd =new JLabel("Employee Address");
slId=new JLabel("Employee ID");
slName=new JLabel("Employee Name");
slDept=new JLabel("Employee Dept");
slDOJ=new JLabel("Date of Joining(YYYY/MM/DD)");
slBasic=new JLabel("Basic Salary");
slAdd =new JLabel("Employee Address");
slHRA =new JLabel("House Rent Allowance");
slTA =new JLabel("Travelling Allowance");
slDA =new JLabel("Dearness Allowance");
slPF =new JLabel("Provident Fund Deduction");
slGross=new JLabel("GROSS SALARY");
mId=new JLabel("Employee ID");
mName=new JLabel("Employee Name");
mDept=new JLabel("Employee Dept");
mDOJ=new JLabel("Date of Joining(YYYY/MM/DD)");
mBasic=new JLabel("Basic Salary");
mAdd =new JLabel("Employee Address");
}
}
/*

*/