Named parameterized SQL queries in Java

Question

From poking around in PreparedStatement, it appears that parameterizing SQL statements only allows the developer to specify positional arguments using ? and PreparedStatement.setX(index, value):

PreparedStatement statement = connection.prepareStatement("select * from something where id = ?;");
statement.setString(1, '5');

Is there a way to supply named parameters to prepared statements like this:

ParameterizedStatement statement = connection.parameterizeStatement(
    "select * from something where id = $id;");
statement.setString("id", "5");

Does something exist for this in Java?

Not in the JDBC api, but yes in JDBC wrapper libraries.

Sotirios Delimanolis
– Sotirios Delimanolis

2013-12-24 00:30:44 +00:00
Commented Dec 24, 2013 at 0:30 — Sotirios Delimanolis
– Sotirios Delimanolis, Commented Dec 24, 2013 at 0:30

Elliott Frisch · Accepted Answer · 2013-12-24 00:40:19Z

2

Not in the base JDK, but this sounds like the MyBatis SQL Builder Class.

For example,

// Anonymous inner class
public String deletePersonSql() {
  return new SQL() {{
    DELETE_FROM("USER");
    WHERE("ID = ${id}");
  }}.toString();
}

// Builder / Fluent style
public String insertPersonSql() {
  String sql = new SQL()
    .INSERT_INTO("USER");
    .VALUES("ID, FIRST_NAME", "${id}, ${firstName}")
    .VALUES("LAST_NAME", "${lastName}")
    .toString(); 
  return sql;
}

answered Dec 24, 2013 at 0:40

Elliott Frisch

202k20 gold badges166 silver badges265 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Evgeniy Dorofeev · Accepted Answer · 2013-12-24 05:40:21Z

1

JPA queries can use named parameters, example:

EntityManager em = ...
Query q = em.createQuery("SELECT x FROM Magazine x WHERE x.title = :titleParam and x.price > :priceParam");
q.setParameter("titleParam", "JDJ");
q.setParameter("priceParam", 5.0);
List<Magazine> results = (List<Magazine>) q.getResultList();

answered Dec 24, 2013 at 5:40

Evgeniy Dorofeev

137k31 gold badges209 silver badges288 bronze badges

Collectives™ on Stack Overflow

Named parameterized SQL queries in Java

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related