2019-11-08 16:17
@doubuxingle 可以,谢谢。Db.template('xxx',Kv.by('dbName','value1').set('zcbfid','value2')) 这个,如果是参数多怎么使用呀?
2019-11-08 15:58
public static String sjjdList(String dbName, String zcbfid) {
return "select dgnd as id,''as pid,dgnd+'年度'as [text],dgnd from [" + dbName + "]..sjjd where zcbfid='" + zcbfid + "' group by dgnd " +
"union all " +
"select code,left(code,len(code)-3) as pcode,jdmc,dgnd from [" + dbName + "]..sjjd where zcbfid='"+ zcbfid +"' " +
"order by id";
}
之前 是这样写的,我想使用 Enjoy SQL 模板