import java.awt.EventQueue; // import packages
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JTextArea;
import javax.swing.JTextField;
public class Register extends JFrame { // create component in frame
JFrame frame;
JLabel CustomerNameLabel = new JLabel();
JTextField name = new JTextField();
JLabel CustomerAddressLabel = new JLabel();
JTextField address = new JTextField();
JLabel PhoneNumberLabel = new JLabel();
JTextField number = new JTextField();
JLabel Password1Label = new JLabel();
JTextField passwrd1 = new JTextField();
JLabel Password2Label = new JLabel();
JTextField passwrd2 = new JTextField();
JLabel UserNameLabel = new JLabel();
JTextField user = new JTextField();
JButton submit = new JButton();
JButton clear = new JButton();
JButton exit = new JButton();
public static void main(String args[]) { // initiate frame
EventQueue.invokeLater(new Runnable() {
public void run() { // run
try {
Register frame = new Register();
frame.setVisible(true);
} catch (Exception e) {
e.printStackTrace();
}
}
});
}
private void jbInit() throws Exception { // run Jbinit and throw exception , setting components in frame
getContentPane().setLayout(null);
setTitle("Register For Ordering ");
getContentPane().add(CustomerNameLabel);
CustomerNameLabel.setText("Name :");
CustomerNameLabel.setBounds(10, 10, 89, 16);
getContentPane().add(CustomerAddressLabel);
CustomerAddressLabel.setText("Address :");
CustomerAddressLabel.setBounds(10, 42, 89, 16);
getContentPane().add(PhoneNumberLabel);
PhoneNumberLabel.setText("Phone Number :");
PhoneNumberLabel.setBounds(10, 74, 323, 20);
getContentPane().add(UserNameLabel);
UserNameLabel.setText("Username :");
UserNameLabel.setBounds(10, 106, 89, 16);
getContentPane().add(Password1Label);
Password1Label.setText("Password :");
Password1Label.setBounds(10, 138 , 89, 16);
getContentPane().add(Password2Label);
Password2Label.setText("Confirm password :");
Password2Label.setBounds(10, 170, 150, 20);
getContentPane().add(name);
name.setBounds(130, 10, 250 , 20);
getContentPane().add(address);
address.setBounds(130, 42 , 250 , 20);
getContentPane().add(number);
number.setBounds(130, 74 , 150 , 20);
getContentPane().add(user);
user.setBounds(130, 106 , 150 , 20);
getContentPane().add(passwrd1);
passwrd1.setBounds(130, 138 , 150 , 20);
getContentPane().add(passwrd2);
passwrd2.setBounds(130, 170 , 150 , 20);
getContentPane().add(clear);
clear.addActionListener(new ClearActionListener());
clear.setText("CLEAR");
clear.setBounds(160, 347, 99, 26);
getContentPane().add(submit);
submit.addActionListener(new SubmitActionListener());
submit.setText("SUBMIT");
submit.setBounds(50, 347, 99, 26);
getContentPane().add(exit);
exit.addActionListener(new ExitActionListener());
exit.setText("EXIT");
exit.setBounds(270, 347, 99, 26);
}
public Register() { // setting for frame
super();
setBounds(100, 100, 430, 430);
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
try { // try and catch block
jbInit();
} catch (Throwable e) {
e.printStackTrace();
}
}
private class ClearActionListener implements ActionListener { // action for button clear
public void actionPerformed(ActionEvent e) {
clear_actionPerformed(e);
}
}
private class ExitActionListener implements ActionListener { // action for button exit
public void actionPerformed(ActionEvent e) {
exit_actionPerformed(e);
}
}
private class SubmitActionListener implements ActionListener {
public void actionPerformed(ActionEvent e)
{
String value1=user.getText();
String value2=passwrd1.getText();
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:NWIND","","");
Statement st=con.createStatement();
String query="insert into User values("+"Username,Password"+") values ('"+user+"','"+passwrd1+"')";
int result=st.executeUpdate(query);
st.close();
}
catch(Exception ea){}
}
}
protected void clear_actionPerformed(ActionEvent e) { // clear button
name.setText("");
address.setText("");
number.setText("");
user.setText("");
passwrd1.setText("");
passwrd2.setText("");
repaint();
}
protected void exit_actionPerformed(ActionEvent e) { // exit button
System.exit(0);
}
}
which type of error occurs? Specify it. Is NWIND is your dsn?