Using Prepared Statements to set Table Name

by

A table name can’t be used as a parameter. It must be hard coded. So you can do something like:

private String query1 = "SELECT plantID, edrman, plant, vaxnode FROM [" + reportDate + "?]";

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. How to use a tablename variable for a java prepared statement insert [duplicate]
  6. right syntax to use near ‘?’
  7. Having a Column name as Input Parameter of a PreparedStatement
  8. How to use prepared statement for select query in Java?
  9. String variable in java to get and store the json array in table column
  10. How to get the insert ID in JDBC?
  11. java.util.Date vs java.sql.Date
  12. How to call a stored procedure from Java and JPA
  13. Running a .sql script using MySQL with JDBC
  14. Prevent SQL injection attacks in a Java program
  15. Java Date – Insert into database
  16. Most efficient conversion of ResultSet to JSON?
  17. LINQ for Java tool [closed]
  18. SQL prepared statement how to select via multiple possible menu selections?
  19. Class.forName(JDBC_DRIVER) no longer needed?
  20. Is there any good dynamic SQL builder library in Java? [closed]
  21. Bulk insert in Java using prepared statements batch update
  22. PreparedStatement setNull(..)
  23. How can I detect a SQL table’s existence in Java?
  24. Java – Storing SQL statements in an external file [closed]
  25. JPA Select latest instance for each item
  26. Should I use composite primary keys or not?
  27. How to use SELECT IN clause in JDBCTemplates?
  28. Searching between dates in SQL with JDBC?
  29. Getting last record from mysql
  30. How to avoid OOM (Out of memory) error when retrieving all records from huge table?

Leave a Comment