database connectivity using java

[bala kan]

good morning to you,


Hi, i did the registration page using these fields

name,username,password,dob,gender,address and city..

when i click the submit button.. it should be inserted into my database.. it is being inserted in database.. but in the descending order rather than in the last row..

codings in the submit button click event

   Submit_button.addActionListener(new ActionListener()
   {
   public void actionPerformed(ActionEvent e)
   {
    
    try
     {
        
       Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   con=DriverManager.getConnection("jdbc:odbc:sampleone");
  
 
       s=con.createStatement();
       String name=Name_text.getText();
       String username=User_Name_text.getText();
       String password=Password_text.getText();
       String dob=DOB_text.getText();
       String gender=selectedbutton(Male_rbutton,Female_rbutton);
       String address=Address_text.getText();
       String city=City_text.getText();

       int i=s.executeUpdate("insert into table1 (name,username,password,dob,gender,address,city) values ('"+name+"','"+username+"','"+password+"','"+dob+"','"+gender+"','"+address+"','"+city+"') ");

       con.close();

       
     }

  
  
     catch(ClassNotFoundException cnfex)
  {
    System.err.println("failed to load driver");
    cnfex.printStackTrace();
    System.exit(1);

  }
  
  catch(SQLException sqlex)
{
  System.err.println("unable to connect");
  sqlex.printStackTrace();
} 
       
       
   }
 
   }
   );
    
Thanks in advance

[Devaka Cooray]

What did you mean by records being inserted in the descending order?

[bala kan]

Hi devaka,

i did small mistake in ms-access database.. i used reserved word "name" field in database.. i think it would have made records to arrange like that.. just now, it had been rectified.. thank you very much for your quick response