1.错误写法
List<Record> list = Db.find("SELECT id FROM b_product_detail_phone WHERE productid = 123 AND id NOT IN (?)", "147,148");
查询结果包括148,即参数并未全部识别147,148,仅识别了147,无法分辨是几个参数。
正确写法:
1.全部字符串拼接
List<Record> list = Db.find("SELECT id FROM b_product_detail_phone WHERE productid = 123 AND id NOT IN (147,148)");
2.jfinal模板
// List<Integer> idList = Arrays.asList(147,148);
List<Integer> idList = new ArrayList<>();
idList.add(147);
idList.add(148);
SqlPara para = Db.getSqlPara("test.test1", Kv.by("idList", idList));
List<Record> list = Db.find(para);
renderJson(list);
all.sql文件内容
#namespace("test")
#include("test.sql")
#end
test.sql中内容
#sql("test1")
SELECT id FROM 表名 WHERE pid= 739 AND id NOT IN (
#for(id:idList)
#(for.index > 0 ? ", " : "")#(id)
#end
)
#end
注意:模板中,#para生成占位符,而#(value)生成值
参考: