How to use prepared statement for select query in Java?

by

You need to use:

preparedStatement.executeQuery();

instead of 

preparedStatement.executeQuery(login);

when you pass in a string to executeQuery() that query is executed literally and thus the ? is send to the database which then creates the error. By passing query string you are not execution the “cached” prepared statement for which you passed the values.

More Related Contents:

  1. right syntax to use near ‘?’
  2. Hours and seconds are lost when storing a date in the database [closed]
  3. Multiple queries executed in java in single statement
  4. Using setDate in PreparedStatement
  5. Java: Insert multiple rows into MySQL with PreparedStatement
  6. How can I get the SQL of a PreparedStatement?
  7. Using “like” wildcard in prepared statement
  8. How does a PreparedStatement avoid or prevent SQL injection?
  9. Variable column names using prepared statements
  10. MySQL and JDBC with rewriteBatchedStatements=true
  11. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  12. Running a .sql script using MySQL with JDBC
  13. java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/dbname [duplicate]
  14. mysql prepared statement error: MySQLSyntaxErrorException
  15. A datetime equivalent in java.sql ? (is there a java.sql.datetime ?)
  16. PreparedStatement with list of parameters in a IN clause [duplicate]
  17. Handling MySQL datetimes and timestamps in Java
  18. Getting output from dbms_output.get_lines using JDBC
  19. Java – Can’t use ResultSet after connection close
  20. Timezones in SQL DATE vs java.sql.Date
  21. runtime error: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
  22. How do I use PostgreSQL JSON(B) operators containing a question mark “?” via JDBC
  23. MySQL connector error “The server time zone value Central European Time” [duplicate]
  24. Oracle’s RETURNING INTO usage in Java (JDBC, Prepared Statement)
  25. MySQL & Java – Get id of the last inserted value (JDBC) [duplicate]
  26. MS SQL Exception: Incorrect syntax near ‘@P0’
  27. JDBC Prepared Statement . setDate(….) doesn’t save the time, just the date.. How can I save the time as well?
  28. PreparedStatement and setTimestamp in oracle jdbc
  29. Database independence through JDBC in java
  30. java.sql.SQLException: No database selected – why?

Leave a Comment