1、controller层
iProductService.getProductList(pageNum,pageSize);
2、service层
ServerResponse<PageInfo> getProductList(int pageNum, int pageSize);
3、service实现层
public ServerResponse<PageInfo> getProductList(int pageNum,int pageSize){
//这里使用mybatis的pagehelper
//1、startPage--start
//2、填充自己的sql查询逻辑
//3、pageHelper收尾
PageHelper.startPage(pageNum,pageSize);
List<Product> productList=productMapper.selectList();
List<ProductListVo> productListVoList=Lists.newArrayList();
for (Product productItem:productList){
ProductListVo productListVo=assembleProductListVo(productItem);
productListVoList.add(productListVo);
}
PageInfo pageResult=new PageInfo(productList);
pageResult.setList(productListVoList);
return ServerResponse.createBySuccess(pageResult);
}
private ProductListVo assembleProductListVo(Product product){
ProductListVo productListVo=new ProductListVo();
productListVo.setId(product.getId());
productListVo.setName(product.getName());
productListVo.setCategoryId(product.getCategoryId());
productListVo.setImageHost(PropertiesUtil.getProperty("ftp.server.http.prefix","http://img.mall.com/"));
productListVo.setMainImage(product.getMainImage());
productListVo.setPrice(product.getPrice());
productListVo.setSubtitle(product.getSubtitle());
productListVo.setStatus(product.getStatus());
return productListVo;
}
dao层
List<Product> selectList();
dao层(mapper)实现
<select id="selectList" resultMap="BaseResultMap" >
select
<include refid="Base_Column_List"></include>
from mmall_product
order by id asc
</select>
vo层
package com.lpy.mall.vo;
import java.math.BigDecimal;
public class ProductListVo {
private Integer id;
private Integer categoryId;
private String name;
private String subtitle;
private String mainImage;
private BigDecimal price;
private Integer status;
private String imageHost;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public Integer getCategoryId() {
return categoryId;
}
public void setCategoryId(Integer categoryId) {
this.categoryId = categoryId;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getSubtitle() {
return subtitle;
}
public void setSubtitle(String subtitle) {
this.subtitle = subtitle;
}
public String getMainImage() {
return mainImage;
}
public void setMainImage(String mainImage) {
this.mainImage = mainImage;
}
public BigDecimal getPrice() {
return price;
}
public void setPrice(BigDecimal price) {
this.price = price;
}
public Integer getStatus() {
return status;
}
public void setStatus(Integer status) {
this.status = status;
}
public String getImageHost() {
return imageHost;
}
public void setImageHost(String imageHost) {
this.imageHost = imageHost;
}
}