 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Java Forum / General / April 2006what's wrong with this java statement?
i can execute the following statement properly stmt.execute("insert into computer values('fd','mic',123,'fds')"); but when i substitute the parameters into the statement errors occour,what's wrong with the following statement? *jmodel ,jbrand, jprice, jdesc are text field stmt.execute("insert into computer values ('" +jmodel.toString()+"','"+jbrand.toString()+"',"+Integer.parseInt(jprice.toString())+",'"+jdesc.toString()+"')"); I think you will have to use prepared statement for using variables like that. > i can execute the following statement properly > [quoted text clipped - 8 lines] > > +jmodel.toString()+"','"+jbrand.toString()+"',"+Integer.parseInt(jprice.toString())+",'"+jdesc.toString()+"')"); > i can execute the following statement properly > [quoted text clipped - 8 lines] > > +jmodel.toString()+"','"+jbrand.toString()+"',"+Integer.parseInt(jprice.toString())+",'"+jdesc.toString()+"')"); To use ' " and several other characters in a value, they must be escaped. Prepare statements take care of the escaping for you; but require more code. But it simplifies the escaping and PreparedStatements can be reused if doing a lot of inserts at one time. There is a good example on the JDBC tutorial on java.sun.com. Watchout - SQL indicies are 1 based not 0 based as in Java..... please check the spaces Hi, The problem is because of usage of "toString()" .... U should use getText() to get the text present in a text field. Try executing this statement and it should work: stmt.execute("insert into computer values ('" +jmodel.getText()+"','"+jbrand.getText()+"',"+Integer.parseInt(jprice.getText())+",'"+jdesc.getText()+"')"); thanks! > i can execute the following statement properly > [quoted text clipped - 8 lines] > > +jmodel.toString()+"','"+jbrand.toString()+"',"+Integer.parseInt(jprice.toString())+",'"+jdesc.toString()+"')"); What was the error(s)? Was it SQLException? (because fields in data base are too short and string returning by JTextField::toString() usually very long) Was it NumberFormatException? (because you didn't override one of your text field toString() to return numeric string?) You have already one response about using text fields: instead of toString use getText thanks! Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.