prepared statement

[sensory21]

Hi all,

//These are values entered in a form
String title = request.getParameter("title");
String firstname = request.getParameter("firstname");
String lastname = request.getParameter("lastname");

//The primary key is set up as auto_increment in the db
PreparedStatement pstmt = conn.prepareStatement("INSERT INTO staff VALUES(NULL,?,?,?)");
pstmt.executeUpdate();

I get this error when compiling:
"No value specified for parameter 1" ?

how do you set that the first question mark is title etc...

cheers
vero

 

[idarke]

pstmt.setString(1,title);
pstmt.setString(2,firstname);
etc...

 

[venur]

Hi

//The primary key is set up as auto_increment in the db
PreparedStatement pstmt = conn.prepareStatement("INSERT INTO staff VALUES(NULL,?,?,?)");
pstmt.setString(1,title);
pstmt.setString(2,firstName);
pstmt.setString(3,lastName);
pstmt.executeUpdate();

SQL Qry can also be written as the one below

INSERT INTO STAFF (title,firstName,lastName) VALUES (?,?,?);

Where in you can see the 1 = title, 2=firstName etc.

Hope this will help you..

Cheers
Venu

 

[sensory21]

Thank you Venu and Idarke it's fine now. x