JDBC LIKE '%'||?||'%'

JDBC LIKE 쓸때 예시

 

sql += "AND (NAME LIKE '%'||?||'%' OR TMP_FIELD3 LIKE '%'||?||'%') \n";