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?