How to dynamically define conditions for a parametrized select?

Question

Java

Hello.
For example, I have a parametrized select

String sql = "SELECT STUDENT FROM SCHOOL WHERE SCHOOL LIKE ? ";
PreparedStatement prepStmt = conn.prepareStatement(sql);
prepStmt.setString(1, "Waterloo%");
ResultSet rs = prepStmt.executeQuery();

everything is fine for cases when the filter in the select is constant, BUT there is a situation when the
select must be dynamically interpreted like

SELECT STUDENT FROM SCHOOL WHERE 
SCHOOL LIKE "Waterloo%" or SCHOOL LIKE "Stackloo%"

String sql = "SELECT STUDENT FROM SCHOOL WHERE SCHOOL LIKE ? OR SCHOOL LIKE ?";
PreparedStatement prepStmt = conn.prepareStatement(sql);
prepStmt.setString(1, filter_select);
prepStmt.setString(2, filter_select);
ResultSet rs = prepStmt.executeQuery();

What is the best way to solve this problem?

Answer 1

There is no special built-in mechanism in jdbc. You must first generate a string for a new request with parameters, then set these parameters. Or prepare several queries with different conditions and also parameterize them before execution.