在java中一条sql语句中有多个函数和where条件如何替换其中的字段为空格

Question

sql : SELECT COUNT(D.id),(select qqq from qq id is null) ,id as '1211',
,VALUE(name,'未知')
,COUNT(*) ,SUM(CASE WHEN (REASON<>'' AND (pass<>1 OR REASON<>'27||')) AND (SUBSTR(state,30,1)=1 OR VALUE(SUBSTR(state,32,1),0)=1) THEN

1 ELSE 0 END) from admine D
where id='122'
AND id IN ()
AND id IN ()
AND id = ''
AND id <> ''
AND id != ''
GROUP BY VALUE(name,'未知')

如何替换字段如id,name，替换函数里的和where条件里的

Answer 1

用占位符，${id},${name},然后用值去替换这些占位符