Named parameters in JDBC [duplicate]

by

JDBC does not support named parameters. Unless you are bound to using plain JDBC (which causes pain, let me tell you that) I would suggest to use Springs Excellent JDBCTemplate which can be used without the whole IoC Container.

NamedParameterJDBCTemplate supports named parameters, you can use them like that:

 NamedParameterJdbcTemplate jdbcTemplate = new NamedParameterJdbcTemplate(dataSource);

 MapSqlParameterSource paramSource = new MapSqlParameterSource();
 paramSource.addValue("name", name);
 paramSource.addValue("city", city);
 jdbcTemplate.queryForRowSet("SELECT * FROM customers WHERE name = :name AND city = :city", paramSource);

More Related Contents:

  1. PreparedStatement with list of parameters in a IN clause [duplicate]
  2. Using setDate in PreparedStatement
  3. java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver Exception occurring. Why?
  4. java.lang.ClassNotFoundException: com.mysql.jdbc.Driver in Eclipse
  5. What is the actual use of Class.forName(“oracle.jdbc.driver.OracleDriver”) while connecting to a database?
  6. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications link failure [duplicate]
  7. When to close Connection, Statement, PreparedStatement and ResultSet in JDBC
  8. java.sql.SQLException: Exhausted Resultset
  9. java.util.stream with ResultSet
  10. handling DATETIME values 0000-00-00 00:00:00 in JDBC
  11. JDBC ResultSet get columns with table alias
  12. How to start a transaction in JDBC?
  13. Getting an exception ORA-00942: table or view does not exist – when inserting into an existing table
  14. Driver JDBC PostgreSQL with Android [duplicate]
  15. ‘0000-00-00 00:00:00’ can not be represented as java.sql.Timestamp error
  16. oracle.jdbc.driver.OracleDriver ClassNotFoundException
  17. Populating jTable using database data
  18. How to simulate a DB for testing (Java)?
  19. is there a standard way to define a JDBC Datasource for Java EE containers?
  20. I’m getting a java.lang.classnotfoundexception: com.mysql.jdbc.Driver
  21. ResultSet.getString(1) throws java.sql.SQLException: Invalid operation at current cursor position
  22. How to get *everything* back from a stored procedure using JDBC
  23. Using a prepared statement and variable bind Order By in Java with JDBC driver
  24. How do I unit test jdbc code in java? [closed]
  25. Java 7 Automatic Resource Management JDBC (try-with-resources statement)
  26. How to map a ResultSet with unknown amount of columns to a List and display it in a HTML table?
  27. UCanAccess Initializer Error (compile/run without IDE)
  28. A datetime equivalent in java.sql ? (is there a java.sql.datetime ?)
  29. Java JDBC connection status
  30. The Network Adapter could not establish the connection when connecting with Oracle DB

Leave a Comment