30-08-2011, 02:51 PM
[attachment=15570]
Code:
import javax.swing.*;
import javax.swing.ImageIcon.*;
import javax.swing.JPanel.*;
import javax.swing.JOptionPane;
import java.awt.*;
import java.awt.event.*;
import java.lang.*;
import javax.swing.*;
import javax.swing.border.*;
import java.sql.*;
public class AllowancesRecord extends JDialog implements ActionListener
{
JButton b1,b2;
JTextField textField1,textField2,textField3,textField4,textField5;
JLabel label1,label2,label3,label4,label5;
public AllowancesRecord() {
setDefaultCloseOperation(JDialog.HIDE_ON_CLOSE);
Toolkit theKit=getToolkit();
Dimension wndSize=theKit.getScreenSize();
setBounds(5,10,790,550);
GridLayout grid=new GridLayout(10,2,10,20);
Container content=getContentPane();
content.setLayout(grid);
EtchedBorder edge=new EtchedBorder(EtchedBorder.RAISED);
label1=new JLabel("Employee ID");
label2=new JLabel("House Rent");
label3=new JLabel("Convence");
label4=new JLabel("Medical");
label5=new JLabel("Telecomm");
textField1=new JTextField();
textField2=new JTextField();
textField3=new JTextField();
textField4=new JTextField();
textField5=new JTextField();
b1=new JButton("cancel");
b2=new JButton("save");
b1.setBorder(edge);
b2.setBorder(edge);
content.add(textField1);
content.add(label1);
content.add(textField2);
content.add(label2);
content.add(textField3);
content.add(label3);
content.add(textField4);
content.add(label4);
content.add(textField5);
content.add(label5);
content.add(b1);
content.add(b2);
setVisible(true);
b1.addActionListener(this);
b2.addActionListener(this);
}
public void actionPerformed(ActionEvent ae)
{
Object source=ae.getSource();
if (ae.getActionCommand().equals("cancel")||source==b1)
{
System.exit(0);
}
else if(ae.getActionCommand().equals("save")||source==b2)
{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String sourceURL="jdbc:odbc:database";
Connection databaseConnection=DriverManager.getConnection(sourceURL);
Statement statement=databaseConnection.createStatement();
String str = "INSERT INTO Allowances(EmployeeID,HouseRent,Convency,Medical,Telecomm,AllowancesTotal) VALUES("+textField1.getText()+","+textField2.getText()+","+textField3.getText()+","+textField4.getText()+","+textField5.getText()+","+textField2.getText()+"+"+textField3.getText()+"+"+textField4.getText()+"+"+textField5.getText()+")";
ResultSet authorNames=statement.executeQuery(str);
/*if (authorNames.next())
{
JOptionPane.showMessageDialog(null,"Information Saved");
}
else {
JOptionPane.showMessageDialog(null,"Invalid Password");
}*/
}
catch(Exception cnfe)
{
//System.err.println(cnfe);
JOptionPane.showMessageDialog(null,"Information Saved");
}
//JOptionPane.showMessageDialog(null,"");
}
}//action performed
public static void main(String args[])
{
AllowancesRecord a=new AllowancesRecord();
}
}