java basic help......

[chathuranga8887]

int R=10;
nam aka kohomada
sql statement akka liyanna
St.executeUpadate
("INSERT INTO dk VALUES('mahes011',44444444,<WANT TO SEND R>)");


HOW CAN I USE THAT PLSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS

 

[ozone_buzzer]

("INSERT INTO dk VALUES('mahes011',44444444,<Single quatation><double quatation><plus><THE VERIABLE><plus><double quatation><Single quatation>)")

("INSERT INTO dk VALUES('mahes011',44444444,' "+R +" ')")

 

[homoelectronics]

("INSERT INTO dk VALUES('mahes011',44444444," + Integer.toString(R) + ")");

Meka hariyanta one

 

[ozone_buzzer]

("INSERT INTO dk VALUES('mahes011',44444444," + Integer.toString(R) + ")");

Meka hariyanta one

Mekath Hari..

 

[Kasun k]

Oyage Table ake "R" aka dana field aka Int akakda? naththan String or var char da thiyenne???

 

[Himoz]

("INSERT INTO dk VALUES('mahes011',44444444," + Integer.toString(R) + ")");

Meka hariyanta one

this is correct if data type regarding to the field is varchar/string.
But if u need to store a pure numeric value don't use this method.
bcz future manipulations may need to convert stored values again to Integer.

 

[chathuranga8887]

("INSERT INTO dk VALUES('mahes011',44444444,<Single quatation><double quatation><plus><THE VERIABLE><plus><double quatation><Single quatation>)")

("INSERT INTO dk VALUES('mahes011',44444444,' "+R +" ')")

ela ela thankssss

 

[chathuranga8887]

("INSERT INTO dk VALUES('mahes011',44444444," + Integer.toString(R) + ")");

Meka hariyanta one

ela thanks dear
elakiri ......