HELP problems linking an applet form to a Database

[Richie01]

Ok, here i have the code for the form...but whenever i click update, delete or search all it does is close the form and nothing is done to the database. Could someone be kind enough to help me out here...

import java.awt.*;
import java.awt.event. *;
import javax.swing.*;
import java.sql.*;
import java.net.*;
import java.util.*;

public class EmpForm extends JFrame
{
private JLabel lbl_empname, lbl_empid, lbl_emptrn, lbl_bsalary, lbl_tax, lbl_nsalary, lbl_qualificati on, lbl_gender;
private JTextField txt_empname, txt_empid, txt_emptrn, txt_bsalary, txt_tax, txt_nsalary;
private JRadioButton Female,Male;
private JCheckBox cbox_masters,cb ox_bachelors,cb ox_diploma;
private JButton btn_search, btn_update, btn_delete;
private JPanel topPanel, radioPanel, cboxPanel, buttonPanel;
private String genderVal, qualVal;

public EmpForm()
{
super("Employee information");
Container container=getCo ntentPane();
container.setLa yout(new FlowLayout());

JPanel topPanel=new JPanel(new GridLayout(6,2) );;
JPanel radioPanel=new JPanel(new GridLayout(1,3) );
JPanel cboxPanel=new JPanel(new GridLayout(1,4) );
JPanel buttonPanel=new JPanel(new GridLayout(1,4) );

lbl_empname= new JLabel("Employe e Name");
txt_empname = new JTextField(15);
lbl_empid= new JLabel("Employe e ID");
txt_empid = new JTextField(15);
lbl_emptrn= new JLabel("TRN");
txt_emptrn = new JTextField(15);
lbl_bsalary= new JLabel("Basic Salary");
txt_bsalary = new JTextField(15);
lbl_tax= new JLabel("Tax");
txt_tax = new JTextField(15);
lbl_nsalary= new JLabel("Net Salary");
txt_nsalary = new JTextField(15);
lbl_gender=new JLabel("Gender" );

GHandler gendhandler=new GHandler();
Male=new JRadioButton("M ale");
Female=new JRadioButton("F emale");
Male.addItemLis tener(gendhandl er);
Female.addItemL istener(gendhan dler);
ButtonGroup radgroup= new ButtonGroup();
radgroup.add(Ma le);
radgroup.add(Fe male);

QHandler qualhandler=new QHandler();
lbl_qualificati on= new JLabel("Qualifi cation:");
cbox_bachelors= new JCheckBox("Bach elors");
cbox_diploma= new JCheckBox("Dipl oma");
cbox_masters= new JCheckBox("Mast ers");
cbox_bachelors. addItemListener (qualhandler);
cbox_diploma.ad dItemListener(q ualhandler);
cbox_masters.ad dItemListener(q ualhandler);

btn_search=new JButton("Search ");
btn_update=new JButton("Update ");
btn_delete=new JButton("Delete ");

BHandler btnhandler=new BHandler();
btn_search.addA ctionListener(b tnhandler);
btn_update.addA ctionListener(b tnhandler);
btn_delete.addA ctionListener(b tnhandler);

topPanel.add(lb l_empname);
topPanel.add(tx t_empname);
topPanel.add(lb l_empid);
topPanel.add(tx t_empid);
topPanel.add(lb l_emptrn);
topPanel.add(tx t_emptrn);
topPanel.add(lb l_bsalary);
topPanel.add(tx t_bsalary);
topPanel.add(lb l_tax);
topPanel.add(tx t_tax);
topPanel.add(lb l_nsalary);
topPanel.add(tx t_nsalary);

radioPanel.add( lbl_gender);
radioPanel.add( Male);
radioPanel.add( Female);

cboxPanel.add(l bl_qualificatio n);
cboxPanel.add(c box_bachelors);
cboxPanel.add(c box_diploma);
cboxPanel.add(c box_masters);

buttonPanel.add (btn_search);
buttonPanel.add (btn_update);
buttonPanel.add (btn_delete);

container.add(t opPanel);
container.add(r adioPanel);
container.add(c boxPanel);
container.add(b uttonPanel);

setSize(400, 400);
setVisible(true );

}

public class GHandler implements ItemListener
{
public void itemStateChange d(ItemEvent event)
{
if(event.getSou rce()==Male)
{
genderVal="Male ";
}
else if(event.getSou rce()==Female)
{
genderVal="Fema le";
}
}
}

public class QHandler implements ItemListener
{
public void itemStateChange d(ItemEvent event)
{
if(event.getSou rce()==cbox_bac helors)
{
if(event.getSta teChange()==Ite mEvent.SELECTED )
{
qualVal+="Bache lors";
}
}
else if(event.getSou rce()==cbox_dip loma)
{
if(event.getSta teChange()==Ite mEvent.SELECTED )
{
qualVal+="Diplo ma";
}
}
else if(event.getSou rce()==cbox_mas ters)
{
if(event.getSta teChange()==Ite mEvent.SELECTED )
{
qualVal+="Maste rs";
}
}
}
}

public class BHandler implements ActionListener
{
public void actionPerformed (ActionEvent event)
{
try
{
Connection conn;
PreparedStateme nt searchQuery, updateQuery, deleteQuery;
ResultSet rs;
String qualification=" ";
String gender="";
String dbUrl="jdbc:odb c:employee";
String user="";
String password="";
Class.forName(" sun.jdbc.odbc.J dbcOdbcDriver") ;
conn = DriverManager.g etConnection(db Url,user,passwo rd);

if(event.getSou rce()==btn_sear ch)
{

searchQuery=con n.prepareStatem ent("SELECT * FROM emptable WHERE Emp_id=?");
searchQuery.set Int(1, Integer.parseIn t(txt_empid.get Text()));
rs=searchQuery. executeQuery();
while(rs.next() ){
txt_empname.set Text(rs.getStri ng(1));
txt_emptrn.setT ext(""+rs.getIn t(3)+"");
txt_bsalary.set Text(""+rs.getI nt(4)+"");
txt_tax.setText (""+rs.getInt(5 )+"");
txt_nsalary.set Text(""+rs.getI nt(6)+"");
gender=rs.getSt ring(7);
qualification=r s.getString(8); }

if(gender.equal s("Male"))
{
Male.setSelecte d(true);
}
else if(gender.equal s("Female"))
{
Female.setSelec ted(true);
}

if(qualificatio n.regionMatches (0, "Bachelors" , 1, qualification.l ength())==true)
{
cbox_bachelors. setSelected(tru e);
}
if(qualificatio n.regionMatches (0, "Diploma", 1, qualification.l ength())==true)
{
cbox_diploma.se tSelected(true) ;
}
if(qualificatio n.regionMatches (0, "Masters", 1, qualification.l ength())==true)
{
cbox_masters.se tSelected(true) ;
}

searchQuery.clo se();
}
else if(event.getSou rce()==btn_upda te)
{
updateQuery=con n.prepareStatem ent("UPDATE emptable SET Empname=?, Emp_id=?, TRN=?, Basic_Salary=?, Tax=?, Net_Salary=?, Gender=?, Qualification=? WHERE Emp_id=?");

updateQuery.set String(1, txt_empname.get Text());
updateQuery.set Int(2, Integer.parseIn t(txt_empid.get Text()));
updateQuery.set Int(3, Integer.parseIn t(txt_emptrn.ge tText()));
updateQuery.set Int(4, Integer.parseIn t(txt_bsalary.g etText()));
updateQuery.set Int(5, Integer.parseIn t(txt_tax.getTe xt()));
updateQuery.set Int(6, Integer.parseIn t(txt_nsalary.g etText()));
updateQuery.set String(7, genderVal);
updateQuery.set String(8, qualVal);
updateQuery.set Int(9, Integer.parseIn t(txt_empid.get Text()));
updateQuery.exe cuteUpdate();
updateQuery.clo se();
JOptionPane.sho wMessageDialog( null, "update is successful");
genderVal="";
}
else if(event.getSou rce()==btn_dele te)
{
deleteQuery=con n.prepareStatem ent("DELETE FROM emptable WHERE Emp_id=?");
deleteQuery.set Int(1, Integer.parseIn t(txt_empid.get Text()));
deleteQuery.exe cuteUpdate();
deleteQuery.clo se();
JOptionPane.sho wMessageDialog( null, "Record deleted successfully");
}

conn.close();

}

catch(Exception e)
{
System.out.prin tln(e.getMessag e());
e.printStackTra ce();
System.exit(1);
}

finally
{

}

}
}

public static void main(String[] args)
{
EmpForm empframe=new EmpForm();
empframe.setDef aultCloseOperat ion(JFrame.EXIT _ON_CLOSE);
}
}