Jfinal SQL like 动态模板

#sql("findUserList")
select u.id id,u.account account,u.username username,u.roleid roleid,(SELECT group_concat(ri.rolename) FROM system_role ri WHERE FIND_IN_SET(ri.id, u.roleid) ) AS name 
 from system_user u  


        #for(x:cond)
        #(for.index==0? "where" : "and")

        #if(x.key=="userName")
        u.username like concat('%',#para(x.value), '%')
#else
  #(x.key)  #para(x.value)
#end

#end
        order by createTime asc

#end

=================

后台

=================

Kv cond = Kv.create();
if (StrKit.notBlank(selName)) {
cond.set("userName", selName);
}
SqlPara sql = Db.getSqlPara("user.findUserList",Kv.by("cond", cond));