※ 引述《godsing (執著是苦)》之銘言:
StringBuilder sb = new StringBuilder();
sb.append("SELECT new map( 資料 FROM 表單 WHERE 1=1 ");
if(!條件1.equals("none"))
sb.append(" AND 欄位1 = 條件1");
if(!條件2.equals("none"))
sb.append(" AND 欄位2 = 條件2");
if(!條件3.equals("none"))
sb.append(" AND 欄位3 = 條件3");
PS.自己手動黏SQL字串的話請注意SQL injuction