java - in 参数化 sql 查询中的运算符

Question

我想使用参数化的 sql 查询从一个集合中搜索一个特定的值，无论它是否包含这个值，而不是这个的 sql 查询

Answer 1

据我所知，prepareStatement 不能为 IN() 子句使用逗号分隔列表。您可以使用像这样简单的东西:

private static final domainListPlaceHolder =  "<DOMAINS_LIST>";

String sql = "select p.DEALER_NAME from DEALER_PROFILE as p,DEALER_DOMAIN as d,
DELER_PROFILE_DOMAIN as pd where d.DOMAIN_ID = pd.DOMAIN_ID 
and d.DOMAIN_NAME IN (<DOMAINS_LIST>) and pd.DEALER_ID= p.DEALER_ID";

// build a comma delimited String from your array (each domain wrapped with ''), called domainList

String sqlToRun = sql.replace(domainListPlaceHolder, domainList);