what's wrong with this java statement?

java-programmer, what'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()+"')");

java-programmer >> what's wrong with this java statement? I think you will have to use prepared statement for using variables
like that.

Nick wrote:
> 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()+"')");

java-programmer >> what's wrong with this java statement? Nick wrote:
> 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()+"')");
>

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.....

java-programmer >> what's wrong with this java statement? please check the spaces

java-programmer >> what's wrong with this java statement? 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()+"')");

java-programmer >> what's wrong with this java statement? Nick wrote:
> 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()+"')");
>

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

java-programmer >> what's wrong with this java statement? thanks!

java-programmer >> what's wrong with this java statement? thanks!