nutz模糊查询报错，%号内的条件都加上了单引号

.......... if (!DataTypeUtil.isEmptyStr(xtNoticePojo.getNoticeTitle()))
{
sql+=" and t1.title like '%@noticeTitle%' ";
noticeTitle = xtNoticePojo.getNoticeTitle();
}
}
MIniUIGridResultMap list = new MIniUIGridResultMap(pm, sql, dao(), "RECEIVE_USER_ID", getLoginCzyId(), "STATUS_ID",SysConstant.STATUS.VALID.getId(),"noticeTitle",noticeTitle,"senderId",senderId);





```
打印的sql语句   .........and t.STATUS_ID=11  and t1.title like '%'你'%' )'

wendal

1楼•2227天前

@是参数，等价于预编译sql中的"?"

qq_39fcc7a4 2楼•2227天前

对，但是我这样写打印出的sql语句会把模糊查询的条件加上单引号,我该怎么写呢？

wendal

3楼•2227天前

sql+=" and t1.title like@noticeTitle ";
sqls.setParam(noticeTitle, "%" + noticeTitle + "%");

qq_39fcc7a4 4楼•2227天前

{	
				noticeTitle = "%" + xtNoticePojo.getNoticeTitle() + "%";
				sql+=" and t1.title like @noticeTitle ";
			}

请先登陆