How to use a tablename variable for a java prepared statement insert [duplicate]

by

You can’t. You need to contruct the sql with string concatenation/placeholder with String.format. prepared statement is for the column values not for table name.

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. right syntax to use near ‘?’
  7. Is it possible to create variables at runtime in Java?
  8. Having a Column name as Input Parameter of a PreparedStatement
  9. How to use prepared statement for select query in Java?
  10. Hours and seconds are lost when storing a date in the database [closed]
  11. How to convert java.util.Date to java.sql.Date?
  12. Dates with no time or timezone component in Java/MySQL
  13. Efficient way to do batch INSERTS with JDBC
  14. Java: Insert multiple rows into MySQL with PreparedStatement
  15. How to use an arraylist as a prepared statement parameter [duplicate]
  16. How to create change listener for variable?
  17. Postgres data type cast
  18. How to enable logging for SQL statements when using JDBC
  19. What are the pros and cons of performing calculations in sql vs. in your application
  20. Cleanest way to build an SQL string in Java
  21. Is there away to generate Variables’ names dynamically in Java?
  22. mysql prepared statement error: MySQLSyntaxErrorException
  23. Spring JPA @Query with LIKE
  24. how to call a java method using a variable name?
  25. Is it possible to dynamically build a multi-dimensional array in Java?
  26. Why do I get a “variable might not have been initialized” compiler error in my switch block?
  27. PreparedStatements and performance
  28. Java String variable setting – reference or value?
  29. Database independence through JDBC in java
  30. How to escape colon `:` within a native SQL query in Hibernate?

Leave a Comment