ansaurus

Question

Answer 1

+6 A:

If you have specified the type of that column as int and auto-increment e.g.

`ID` int(10) unsigned NOT NULL AUTO_INCREMENT,

then you don't need to supply any value at all, so you can start the prepared statement params at 1 with name.

 query = ("insert into birthtable (nameCol, familyCol, fatherNameCol, mNameCol, dOfBirthCol, pOfBirthCol, inputCol) VALUES(?,?,?,?,?,?,?)");
        pstmt = (PreparedStatement) conn.prepareStatement(query);
        pstmt.setString(1, name);
        pstmt.setString(2, family);
        pstmt.setString(3, fatherName);
        pstmt.setString(4, mName);
        pstmt.setString(5, dOfBirth);
        pstmt.setString(6, pOfBirth);
        // Method used to insert a stream of bytes
        pstmt.setBinaryStream(7, input);

Note that, as others have said, you must include the column names, whatever they might be.

Joel 2009-12-15 16:33:39

we have 8 question marks ,and then I start with 1,so where is the value of eight question mark???

Johanna 2009-12-15 16:37:25

you need to remove one - so there will only be seven

Joel 2009-12-15 16:38:35

Answer 2

A:

You do not set the id parameter in the prepared statement assuming you're using auto increment and the column names are valid:

query = ("insert into birthtable (name, family, fatherName, mName, dOfBirth, pOfBirth, input) VALUES(?,?,?,?,?,?,?)");
pstmt = conn.prepareStatement(query);
pstmt.setString(1, name);
pstmt.setString(2, family);
pstmt.setString(3, fatherName);
pstmt.setString(4, mName);
pstmt.setString(5, dOfBirth);
pstmt.setString(6, pOfBirth);
pstmt.setBinaryStream(7, input);

You should state the column names explicitly otherwise you depend on the order in the table create statement.

Thomas Jung 2009-12-15 16:34:17

in your query ,you have 7 column with 8 question marks ?

Johanna 2009-12-15 16:38:32

@Johanna - That's right. Fixed ? and idx #.

Thomas Jung 2009-12-15 16:40:16

thanks ,I get it

Johanna 2009-12-15 16:48:20

Answer 3

A:

You don't need to specify it yourself, so you can just leave it away. But you should however specify the columns yourself, e.g.

"INSERT INTO tablename (columnname1, columnname2, columnname3) VALUES (?, ?, ?);"

otherwise the DB wouldn't know where to insert the values because there is one column missing.

BalusC 2009-12-15 16:35:45

wooow ,I get it,how tricky is this!!!!

Johanna 2009-12-15 16:47:40

Answer 4

A:

My only 2 cents is that if you want a generated ID, you may call

pstmt.getGeneratedKeys( );

If it's going to return anything valid depends on your JDBC driver implementation though.

Alexander Pogrebnyak 2009-12-15 16:42:39

ansaurus

tags:

views:

answers:

how can we use prepareStatement() ?

related questions