preparedStatement syntax error

by

The solution to your problem is actually very easy, you are calling Statement.executeQuery(String) when you want to call PreparedStatement.executeQuery() –

this.stmt = con.prepareStatement(sql); // Prepares the Statement.
stmt.setInt(1, randNum);               // Binds the parameter.
// return this.stmt.executeQuery(sql); // calls Statement#executeQuery
return this.stmt.executeQuery();       // calls your set-up PreparedStatement

More Related Contents:

  1. Java: Insert multiple rows into MySQL with PreparedStatement
  2. Using “like” wildcard in prepared statement
  3. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  4. right syntax to use near ‘?’
  5. mysql prepared statement error: MySQLSyntaxErrorException
  6. Is there a way to retrieve the autoincrement ID from a prepared statement
  7. How to use prepared statement for select query in Java?
  8. SQL syntax error in "insert into 'keys'(a,b,c,d,e) values(?,?,?,?,?)" [closed]
  9. Hours and seconds are lost when storing a date in the database [closed]
  10. How to import the Mysql database using Java
  11. Using threads to make database requests
  12. Multiple queries executed in java in single statement
  13. ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long on connect to MySQL
  14. Connection to Db dies after >4
  15. No suitable driver found for ‘jdbc:mysql://localhost:3306/mysql [duplicate]
  16. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications link failure [duplicate]
  17. Connect to remote MySQL database through SSH using Java
  18. How to resolve Unable to load authentication plugin ‘caching_sha2_password’ issue
  19. When should we use a PreparedStatement instead of a Statement?
  20. Retrieve an Image stored as BLOB on a MYSQL DB
  21. Can I execute multiple queries separated by semicolon with MySQL Connector/J? [duplicate]
  22. No Database selected when retrieving from mysql website
  23. SQL Error: 0, SQLState: 08S01 Communications link failure [duplicate]
  24. Populate JFreechart TimeSeriesCollection from Mysql DB?
  25. How to correctly write UTF-8 strings into MySQL through JDBC interface
  26. PreparedStatements and performance
  27. Which is best data type for phone number in MySQL and what should Java type mapping for it be?
  28. Stumped SQL Exception for JDBC
  29. A datetime equivalent in java.sql ? (is there a java.sql.datetime ?)
  30. A persistent connection with JDBC to MySQL

Leave a Comment