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_qualification, lbl_gender;
private JTextField txt_empname, txt_empid, txt_emptrn, txt_bsalary, txt_tax, txt_nsalary;
private JRadioButton Female,Male;
private JCheckBox cbox_masters,cbox_bachelors,cbox_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=getContentPane();
container.setLayout(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("Employee Name");
txt_empname = new JTextField(15);
lbl_empid= new JLabel("Employee 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("Male");
Female=new JRadioButton("Female");
Male.addItemListener(gendhandler);
Female.addItemListener(gendhandler);
ButtonGroup radgroup= new ButtonGroup();
radgroup.add(Male);
radgroup.add(Female);
QHandler qualhandler=new QHandler();
lbl_qualification= new JLabel("Qualification:");
cbox_bachelors= new JCheckBox("Bachelors");
cbox_diploma= new JCheckBox("Diploma");
cbox_masters= new JCheckBox("Masters");
cbox_bachelors.addItemListener(qualhandler);
cbox_diploma.addItemListener(qualhandler);
cbox_masters.addItemListener(qualhandler);
btn_search=new JButton("Search");
btn_update=new JButton("Update");
btn_delete=new JButton("Delete");
BHandler btnhandler=new BHandler();
btn_search.addActionListener(btnhandler);
btn_update.addActionListener(btnhandler);
btn_delete.addActionListener(btnhandler);
topPanel.add(lbl_empname);
topPanel.add(txt_empname);
topPanel.add(lbl_empid);
topPanel.add(txt_empid);
topPanel.add(lbl_emptrn);
topPanel.add(txt_emptrn);
topPanel.add(lbl_bsalary);
topPanel.add(txt_bsalary);
topPanel.add(lbl_tax);
topPanel.add(txt_tax);
topPanel.add(lbl_nsalary);
topPanel.add(txt_nsalary);
radioPanel.add(lbl_gender);
radioPanel.add(Male);
radioPanel.add(Female);
cboxPanel.add(lbl_qualification);
cboxPanel.add(cbox_bachelors);
cboxPanel.add(cbox_diploma);
cboxPanel.add(cbox_masters);
buttonPanel.add(btn_search);
buttonPanel.add(btn_update);
buttonPanel.add(btn_delete);
container.add(topPanel);
container.add(radioPanel);
container.add(cboxPanel);
container.add(buttonPanel);
setSize(400, 400);
setVisible(true);
}
public class GHandler implements ItemListener
{
public void itemStateChanged(ItemEvent event)
{
if(event.getSource()==Male)
{
genderVal="Male";
}
else if(event.getSource()==Female)
{
genderVal="Female";
}
}
}
public class QHandler implements ItemListener
{
public void itemStateChanged(ItemEvent event)
{
if(event.getSource()==cbox_bachelors)
{
if(event.getStateChange()==ItemEvent.SELECTED)
{
qualVal+="Bachelors";
}
}
else if(event.getSource()==cbox_diploma)
{
if(event.getStateChange()==ItemEvent.SELECTED)
{
qualVal+="Diploma";
}
}
else if(event.getSource()==cbox_masters)
{
if(event.getStateChange()==ItemEvent.SELECTED)
{
qualVal+="Masters";
}
}
}
}
public class BHandler implements ActionListener
{
public void actionPerformed(ActionEvent event)
{
try
{
Connection conn;
PreparedStatement searchQuery, updateQuery, deleteQuery;
ResultSet rs;
String qualification="";
String gender="";
String dbUrl="jdbc:odbc:employee";
String user="";
String password="";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection(dbUrl,user,password);
if(event.getSource()==btn_search)
{
searchQuery=conn.prepareStatement("SELECT * FROM emptable WHERE Emp_id=?");
searchQuery.setInt(1, Integer.parseInt(txt_empid.getText()));
rs=searchQuery.executeQuery();
while(rs.next()){
txt_empname.setText(rs.getString(1));
txt_emptrn.setText(""+rs.getInt(3)+"");
txt_bsalary.setText(""+rs.getInt(4)+"");
txt_tax.setText(""+rs.getInt(5)+"");
txt_nsalary.setText(""+rs.getInt(6)+"");
gender=rs.getString(7);
qualification=rs.getString(8);}
if(gender.equals("Male"))
{
Male.setSelected(true);
}
else if(gender.equals("Female"))
{
Female.setSelected(true);
}
if(qualification.regionMatches(0, "Bachelors", 1, qualification.length())==true)
{
cbox_bachelors.setSelected(true);
}
if(qualification.regionMatches(0, "Diploma", 1, qualification.length())==true)
{
cbox_diploma.setSelected(true);
}
if(qualification.regionMatches(0, "Masters", 1, qualification.length())==true)
{
cbox_masters.setSelected(true);
}
searchQuery.close();
}
else if(event.getSource()==btn_update)
{
updateQuery=conn.prepareStatement("UPDATE emptable SET Empname=?, Emp_id=?, TRN=?, Basic_Salary=?, Tax=?, Net_Salary=?, Gender=?, Qualification=? WHERE Emp_id=?");
updateQuery.setString(1, txt_empname.getText());
updateQuery.setInt(2, Integer.parseInt(txt_empid.getText()));
updateQuery.setInt(3, Integer.parseInt(txt_emptrn.getText()));
updateQuery.setInt(4, Integer.parseInt(txt_bsalary.getText()));
updateQuery.setInt(5, Integer.parseInt(txt_tax.getText()));
updateQuery.setInt(6, Integer.parseInt(txt_nsalary.getText()));
updateQuery.setString(7, genderVal);
updateQuery.setString(8, qualVal);
updateQuery.setInt(9, Integer.parseInt(txt_empid.getText()));
updateQuery.executeUpdate();
updateQuery.close();
JOptionPane.showMessageDialog(null, "update is successful");
genderVal="";
}
else if(event.getSource()==btn_delete)
{
deleteQuery=conn.prepareStatement("DELETE FROM emptable WHERE Emp_id=?");
deleteQuery.setInt(1, Integer.parseInt(txt_empid.getText()));
deleteQuery.executeUpdate();
deleteQuery.close();
JOptionPane.showMessageDialog(null, "Record deleted successfully");
}
conn.close();
}
catch(Exception e)
{
System.out.println(e.getMessage());
e.printStackTrace();
System.exit(1);
}
finally
{
}
}
}
public static void main(String[] args)
{
EmpForm empframe=new EmpForm();
empframe.setDefaultCloseOperation(JFrame.EXIT_ON_C LOSE);
}
}