Top "Prepared-statement" questions

PreparedStatement IN clause alternatives?

What are the best workarounds for using a SQL IN clause with instances of java.sql.PreparedStatement, which is not …

java security jdbc prepared-statement in-clause

Get query from java.sql.PreparedStatement

In my code I am using java.sql.PreparedStatement. I then execute the setString() method to populate the wildcards of …

java jdbc prepared-statement

PreparedStatement with list of parameters in a IN clause

How to set value for in clause in a preparedStatement in JDBC while executing a query. Example: connection.prepareStatement("Select * …

java jdbc prepared-statement in-clause

How can I get the SQL of a PreparedStatement?

I have a general Java method with the following method signature: private static ResultSet runSQLResultSet(String sql, Object... queryParams) It …

java sql jdbc prepared-statement

Using setDate in PreparedStatement

In order to make our code more standard, we were asked to change all the places where we hardcoded our …

java sql oracle jdbc prepared-statement

Can I bind an array to an IN() condition?

I'm curious to know if it's possible to bind an array of values to a placeholder using PDO. The use …

php arrays pdo prepared-statement where-in

Using "like" wildcard in prepared statement

I am using prepared statements to execute mysql database queries. And I want to implement a search functionality based on …

java mysql jdbc prepared-statement

PDO Prepared Inserts multiple rows in single query

I am currently using this type of SQL on MySQL to insert multiple rows of values in one single query: …

php pdo insert prepared-statement

Java: Insert multiple rows into MySQL with PreparedStatement

I want to insert multiple rows into a MySQL table at once using Java. The number of rows is dynamic. …

java mysql jdbc prepared-statement batch-insert

PreparedStatement setNull(..)

Java PreparedStatement provides a possibility to explicitely set a Null value. This possibility is: prepStmt.setNull(parameterIndex, Types.VARCHAR); Are …

java jdbc prepared-statement