Having a Column name as Input Parameter of a PreparedStatement

by

No, JDBC does not allow this. Only column values can be set. If you want to make dynamic changes to the sql statement you will have to do it before you create the PreparedStatement.

More Related Contents:

  1. Using setDate in PreparedStatement
  2. How can I get the SQL of a PreparedStatement?
  3. How does a PreparedStatement avoid or prevent SQL injection?
  4. Variable column names using prepared statements
  5. Using Prepared Statements to set Table Name
  6. How to use a tablename variable for a java prepared statement insert [duplicate]
  7. right syntax to use near ‘?’
  8. How to use prepared statement for select query in Java?
  9. Select fields from two tables with Speedment
  10. How to get the insert ID in JDBC?
  11. java.util.Date vs java.sql.Date
  12. How to execute command with parameters?
  13. SQL parser library for Java [closed]
  14. “EEE MMM dd HH:mm:ss ZZZ yyyy” date format to java.sql.Date
  15. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  16. Hibernate Union alternatives
  17. How does Java’s PreparedStatement work?
  18. JDBC Pagination
  19. org.postgresql.util.PSQLException: FATAL: sorry, too many clients already
  20. LINQ for Java tool [closed]
  21. Queries returning multiple result sets
  22. Java “params” in method signature?
  23. How do you query object collections in Java (Criteria/SQL-like)?
  24. Passing parameters in URL without query string in Struts 2
  25. Java – Storing SQL statements in an external file [closed]
  26. Why can we use ‘this’ as an instance method parameter?
  27. Hibernate Criteria API: get n random rows
  28. Is MERGE an atomic statement in SQL2008?
  29. Hibernate Issue : Foreign key must have same number of columns as referenced primary key
  30. Does JPA support mapping to sql views?

Leave a Comment