Hibernate动态条件查询并分页

应用实例截图：

前台提交数据，用户可以有选择的进行填写

好吧~ 还是直接上代码吧.....

1.用户接收前台页面提交的数据DTO，该类用户接收商品Commodity的信息

public class CommodityDTO {

private Integer categoryId; // 一级分类id
private Integer subCategoryId; // 二级分类id
private String name;// 商品名称
private Float fromPrice; // 起始价格
private Float toPrice;
private Integer fromSalesVolume; // 起始销售量
private Integer toSalesVolume;

// 此处省略set/get方法
}

2.DAOImpl层

@Override
public List<Commodity> queryByRestrictions(CommodityDTO commodityDTO, int pageOffset, int pageSize) {
Session session = this.getSession();
DetachedCriteria dc = myDetachedCriteria(commodityDTO);

List<Commodity> commodities = dc.getExecutableCriteria(session)
.setFirstResult(pageOffset).setMaxResults(pageSize).list();
return commodities;
}

      /**
 * 添加动态条件
 * 
 * @param commodityDTO
 * @return
 */
private DetachedCriteria myDetachedCriteria(CommodityDTO commodityDTO) {

DetachedCriteria dc = DetachedCriteria.forClass(Commodity.class);

Integer categoryId = commodityDTO.getCategoryId();
Integer subCategoryId = commodityDTO.getSubCategoryId();
String name = commodityDTO.getName();
Float fromPrice = commodityDTO.getFromPrice();
Float toPrice = commodityDTO.getToPrice();
Integer fromSalesVolume = commodityDTO.getFromSalesVolume();
Integer toSalesVolume = commodityDTO.getToSalesVolume();

if (categoryId != null && categoryId.intValue() > 0) {
dc.add(Restrictions.eq("category.id", categoryId));
}
if (subCategoryId != null && subCategoryId.intValue() > 0) {
dc.add(Restrictions.eq("subCategory.id", subCategoryId));
}

if (name != null && !"".equals(name.trim())) {
dc.add(Restrictions.eq("name", name));
}

if (fromPrice != null && fromPrice.intValue() > 0) {
dc.add(Restrictions.ge("price", fromPrice));
}
if (toPrice != null && toPrice.intValue() > 0) {
dc.add(Restrictions.le("price", toPrice));
}

if (fromSalesVolume != null && fromSalesVolume.intValue() > 0) {
dc.add(Restrictions.ge("salesVolume", fromSalesVolume));
}
if (toSalesVolume != null && toSalesVolume.intValue() > 0) {
dc.add(Restrictions.le("salesVolume", toSalesVolume));
}
return dc;
}

3.Service层就是将DAOImpl层的数据封装成一个Pager类供Controller使用