81,092
社区成员
发帖
与我相关
我的任务
分享
int categoryid = Integer.parseInt(request.getParameter("id"));
String keyWord = request.getParameter("keyWord");
// 获取当前页
String currPage = request.getParameter("currPage");
String hql = "from Info d ";
Object[] where = null;
String action = request.getContextPath() + "/baseData/med.do?command=blurQuery";
// 转码
if (currPage != null && !currPage.isEmpty()) {
keyWord = StringUtil.encodeZh(keyWord);
}
if (keyWord != null && !keyWord.isEmpty()) {
action += "&keyWord=" + StringUtil.encodeURL(keyWord);
keyWord = "%" + keyWord + "%";
hql += " where d.categoryId like ? or d.title like ? or d.description like ?";
where = new Object[] {categoryid,keyWord, keyWord };
}
// 分页查询
Map map = this.getPage(hql, recPerPage, currPage, action, where);
<hibernate-mapping package="com.lyq.persistence">
<class name="Info" table="tb_info">
<!-- 主键 -->
<id name="id">
<generator class="native"/>
</id>
<property name="title" not-null="true" />
……
<!-- 与类别的多对一关系 -->
<many-to-one name="Category" column="categoryId" cascade="save-update"/>
</class>