Separate HTML for Basic Foil 13 PreparedStatement class

Basic HTML version of Foils prepared 7 October 97

Foil 13 PreparedStatement class

From Overview of JDBC and its use with Microsoft Access ARL Database Tutorial -- February 98. by Nancy McCracken(Sangetta Aggarwal, Udayan Parvate, Tom Pulikal)

PreparedStatements inherit all functionality of Statements.

It may have an IN parameter, which will be indicated by a "?" in the SQL statement.

Each IN parameter is specified in number order from left to right by a setxxx method. ResultSet rs = stmt.executeQuery("select * from tb1 where name = ?"); stmt.setString(1, "bill");

The setxxx methods will convert parameters to appropriate SQL types, or user may use more general stmt.setObject(1, value, "SQLtype");