HP Driver for JDBC User's Manual

50 Chapter5

ALLBASE/SQL Speciﬁcs

Dynamic/Parameterized SQL Statements

The HP Driver for JDBC supports the use of parameterized SQL

statements through the java.sql.PreparedStatement interface. The

SQL statements must use a question mark (?) as the marker character

for passing the parameters.

For example, a SELECT statement with parameters in the where clause

would look like:

SELECT NAME, ADDRESS FROM ADDRBOOK WHERE NAME=?

Another example is an INSERT statement:

INSERT INTO ADDRBOOK(NAME, ADDRESS) VALUES (?,?)