[ACCEPTED]-Using a variable instead of a parameter index with a JDBC prepared statement-jdbc

Accepted answer

Score: 28

Standard JDBC PreparedStatements don't have 2 this ability. Spring JDBC provides this 1 functionality through NamedParameterJdbcTemplate.

Score: 17

As kd304 mentioned in the comment to my 3 posting, this is a very nice solution if 2 you don't want to incorporate another 3rd 1 party library (like Spring) into your project: Javaworld Article: Named Parameters for PreparedStatement

Score: 6

Using a raw PreparedStatement, this is not 11 possible, as you say. It is possible with 10 CallableStatement, but that requires a stored 9 procedure rather than just a SQL statement.

ORM 8 layers like Hibernate also provide named 7 parameter substitution, and Hibernate also 6 allows you to execute native SQL, bypassing 5 the OR mapping functionality completely.

So 4 if you were really keen to use named parameters, you 3 could employ Hibernate as a way of doing 2 this; you'd only be using a tiny fraction 1 of its functionality.

Source: stackoverflow.com

[ACCEPTED]-Using a variable instead of a parameter index with a JDBC prepared statement-jdbc

In a JDBC ResultSet, what should happen when getLong() or getShort() is called on an int result column?

Java PreparedStatement UTF-8 character problem

How to create a java.sql.Blob object in Java SE 1.5.0 with a byte[] input?

ResultSet vs RowSet: Which one to choose and when?

Inserting Binary data into MySQL (without PreparedStatement's)

Cannot connect to database using JDBC on Glassfish3

Java - How to get Column name on Result Set

how to call a stored function from jdbc?

simple query: not implemented by SQLite JDBC driver

Check if ResultSet is empty in Java