not able to insert values

[anwesh maity]

i am not able to insert values in the database is the query correct ???

 String query = ("INSERT INTO kdnet.users VALUES ('"+firstName+"', '"+lastName+"', '"+citiicode1+"','"+address1+"','"+state+"')"); 
         
         
      
         stmt.executeUpdate(query);
         rset = stmt.executeQuery(query);
         conn.commit();
   rset.close();
       stmt.close();
      conn.close();

[Scott Selikoff]

Use PreparedStatements!!!

If you have a single quote in any of those strings (John O'Conner) its going to die. Your query with PreparedStatements should then just be "INSERT INTO kdnet.users VALUES (?,?,?,?,?)".

[minal silimkar]

please list out the exact error you are getting after execution of this code.