Insert data to database with execsql

Question

I can insert data to my database with this:

mydb.execSQL("INSERT INTO " + TABLE_NAME + " (NAME, CITY) VALUES 
('John','Toronto')");

But if I use the parameter as fallow for CITY, my application crashes:

String str2="Toronto";
mydb.execSQL("INSERT INTO " + TABLE_NAME + " (NAME, CITY) VALUES 
('John',str2)");

why?

Which DBMS product are you using? What programming language is that? — , Feb 25 '18 at 19:38

score 0 · Answer 1 · answered Feb 25 '18 at 18:45

0

String str2='Toronto';

Try using single quotations otherwise execSQL will assume your query ends at the double quotes.

answered Feb 25 '18 at 18:45

Using single quotation will cause this error: Error:(47, 26) error: unclosed character literal – Hossein Mozaffari Feb 25 '18 at 18:51
Would this work? `mydb.execSQL("INSERT INTO " + TABLE_NAME + " (NAME, CITY) VALUES ('John',"+str2+")");` – Feb 25 '18 at 18:55
No, it doesn't work. my application crashes with this. – Hossein Mozaffari Feb 25 '18 at 19:08
this is the right code: mydb.execSQL("INSERT INTO " + TABLE_NAME + " (NAME, CITY) VALUES ('John',' "+str2+" ')"); – Hossein Mozaffari Feb 25 '18 at 19:36

1 Answers1