How to insert data in codename one db using prepared statement?

Question

I am trying to use to insert into the table but got the exception that array index out of bounds ?

Please give me the idea how to do that and where is I am making mistake? I have tried many conversion but doesn't get succeeded.

Following is the code

 Object[]param={ID,name,Fathername,Address,Mob,Gender,Qualification};


 try{
 db=Display.getInstance().openOrCreate("students.db");

 db.execute("insert into clStudent values('?','?','?',?,'?','?','?')", (Object[]) param) ;

Answer 1

You should drop the single quotes around the question marks in your query string.