Ps.setString(1, '%' + searchCriteria + '%') Īs you can see, the setup work is a lot like using a PreparedStatement with an INSERT, UPDATE, or DELETE, but in the case of a SQL SELECT statement you process the results you get back from the ResultSet.

PreparedStatement ps = conn.prepareStatement(query)

create the preparedstatement and add the criteria SearchCriteria = searchCriteria.toUpperCase() String query = 'SELECT id, text FROM blogs WHERE UPPER(text) LIKE ?' Private List getTopics (Connection conn, String searchCriteria) Given that background, here’s a sample Java method that shows this PreparedStatement/SELECT/LIKE combination. I tried adding it directly to the SQL SELECT statement, then realized I just needed to use the ? character there, and then add the wildcards in the ps.setString() statement.

As requested, it uses a SQL SELECT statement with a LIKE clause.įor me, the hard part of this example is figuring out how to use wildcard characters with your PreparedStatement parameter. Here’s an example of how to use a JDBC PreparedStatement with a SQL SELECT query when accessing a database. Java/JDBC FAQ: Can you share an example of a PreparedStatement with a SQL SELECT statement and LIKE clause? You can now hire Alvin Alexander for Scala or Flutter side projects!Ĭontact me at (al) at valleyprogramming (dot) com for details.

Com mysql jdbc preparedstatement