我写一个查询方法。查询一些标题,但方法只能把汉字的两边空格去掉中间的就没反应 :比如搜索“王 天”(中间有个空格)在搜索框写 “王天‘就搜不到。
方法如下:
public PageInfo findExhibitionListByCriteria(
ExhibitionWithBLOBs exhibitionwithblobs, PageInfo page) {
// 调用实体类方法
ExhibitionCriteria criteria = new ExhibitionCriteria();
ExhibitionCriteria.Criteria ec = criteria.createCriteria();
// 调用实体对象判断:
if (exhibitionwithblobs != null) {
if (exhibitionwithblobs.getcTitle() != null
&& !"".equals(exhibitionwithblobs.getcTitle())) {
// 模糊查询通过cTitle:
ec.andCTitleLike("%" + exhibitionwithblobs.getcTitle() + "%");
}
if (exhibitionwithblobs.getState() != null
) {
// 字符匹配:
ec.andStateEqualTo(exhibitionwithblobs.getState());
}
}
criteria.setOrderByClause("sort asc");
List List = exhibitionDAO
.selectByExampleWithBLOBs(criteria);
page.setResultList(List);
return page;
}
我是初学者关键字搜索还不太会!