MyBatis分頁(yè)插件的使用和抽象對(duì)象之間的轉(zhuǎn)換關(guān)系

抽象POJO鼓蜒、BO蝗茁、VO對(duì)象之間的轉(zhuǎn)換關(guān)系

各種對(duì)象關(guān)系轉(zhuǎn)換.png

例：產(chǎn)品管理中部分操作娜汁，當(dāng)需要返回的信息跟pojo不一樣時(shí)筏养，創(chuàng)建一個(gè)新的vo（value Ojbect）對(duì)象斧抱，再將其組裝返回個(gè)前端。

POJO：

Product：

public class Product {
    private Integer id;

    private Integer categoryId;

    private String name;

    private String subtitle;

    private String mainImage;

    private String subImages;

    private String detail;

    private BigDecimal price;

    private Integer stock;

    private Integer status;

    private Date createTime;

    private Date updateTime;
}

VO(value Object):

ProductDetailVo：

public class ProductDetailVo {

    private Integer id;
    private Integer categoryId;
    private String name;
    private String subtitle;
    private String mainImage;
    private String subImages;
    private String detail;
    private BigDecimal price;
    private Integer stock;
    private Integer status;
    private String createTime;
    private String updateTime;
    private String imageHost;
    private Integer parentCategoryId;
}

ProductListVo：

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;
}

ProductManageController：

/**
 * 獲取產(chǎn)品詳情
 * @param session
 * @param productId
 * @return
 */
@RequestMapping("detail.do")
@ResponseBody
public ServerResponse getDetail(HttpSession session, Integer productId){
    User user = (User) session.getAttribute(Const.CURRENT_USER);
    if(user == null){
        return ServerResponse.createByErrorCodeMessage(ResponseCode.NEED_LOGIN.getCode(),"用戶(hù)未登錄渐溶，請(qǐng)登錄管理員");
    }
    if(iUserService.checkAdminRole(user).isSuccess()){
        return iProductService.manageProductDetail(productId);
    }else {
        return ServerResponse.createByErrorMessage("無(wú)權(quán)限操作");
    }

}

/**
 * 獲取產(chǎn)品列表
 * @param session
 * @param pageNum 第幾頁(yè)
 * @param pageSize 每頁(yè)顯示多少條
 * @return
 */
@RequestMapping("list.do")
@ResponseBody
public ServerResponse getList(HttpSession session,
                              @RequestParam(value = "pageNum",defaultValue = "1") int pageNum,
                              @RequestParam(value = "pageSize",defaultValue = "10") int pageSize){
    User user = (User) session.getAttribute(Const.CURRENT_USER);
    if(user == null){
        return ServerResponse.createByErrorCodeMessage(ResponseCode.NEED_LOGIN.getCode(),"用戶(hù)未登錄辉浦，請(qǐng)登錄管理員");
    }
    if(iUserService.checkAdminRole(user).isSuccess()){
        return iProductService.getProductList(pageNum,pageSize);
    }else {
        return ServerResponse.createByErrorMessage("無(wú)權(quán)限操作");
    }

}

/**
 * 產(chǎn)品搜索
 * @param session
 * @param productName
 * @param productId
 * @param pageNum
 * @param pageSize
 * @return
 */
@RequestMapping("search.do")
@ResponseBody
public ServerResponse productSearch(HttpSession session,String productName,Integer productId,
                              @RequestParam(value = "pageNum",defaultValue = "1") int pageNum,
                              @RequestParam(value = "pageSize",defaultValue = "10") int pageSize){
    User user = (User) session.getAttribute(Const.CURRENT_USER);
    if(user == null){
        return ServerResponse.createByErrorCodeMessage(ResponseCode.NEED_LOGIN.getCode(),"用戶(hù)未登錄，請(qǐng)登錄管理員");
    }
    if(iUserService.checkAdminRole(user).isSuccess()){
        return iProductService.searchProduct(productName,productId,pageNum,pageSize);
    }else {
        return ServerResponse.createByErrorMessage("無(wú)權(quán)限操作");
    }

}

serviceImpl：

@Override
public ServerResponse<ProductDetailVo> manageProductDetail(Integer productId){
    if(productId == null){
        return ServerResponse.createByErrorCodeMessage(ResponseCode.ILLEGAL_ARGUMENT.getCode(),
                ResponseCode.ILLEGAL_ARGUMENT.getDesc());
    }
    Product product = productMapper.selectByPrimaryKey(productId);
    if(product == null){
        return ServerResponse.createByErrorMessage("產(chǎn)品已下架或者刪除");
    }
    //VO對(duì)象：value Object
    //pojo--->bo(business object)--->vo(view object)
    ProductDetailVo productDetailVo = assembleProductDetailVo(product);
    return ServerResponse.createBySuccess(productDetailVo);

}

private ProductDetailVo assembleProductDetailVo(Product product){
    ProductDetailVo productDetailVo = new ProductDetailVo();
    productDetailVo.setId(product.getId());
    productDetailVo.setSubtitle(product.getSubtitle());
    productDetailVo.setPrice(product.getPrice());
    productDetailVo.setMainImage(product.getMainImage());
    productDetailVo.setSubImages(product.getSubImages());
    productDetailVo.setCategoryId(product.getCategoryId());
    productDetailVo.setDetail(product.getDetail());
    productDetailVo.setName(product.getName());
    productDetailVo.setStatus(product.getStatus());
    productDetailVo.setStock(product.getStock());

    //imageHost:從配置文件中獲取茎辐，不需要把url硬編碼到項(xiàng)目中宪郊，如果圖片服務(wù)器修改了掂恕，只需要修改配置文件
    productDetailVo.setImageHost(PropertiesUtil.getProperty("ftp.server.http.prefix","http://img.happymmall.com/"));
    //parentCategoryId
    Category category = categoryMapper.selectByPrimaryKey(product.getCategoryId());
    if(category == null){
        //默認(rèn)根節(jié)點(diǎn)
        productDetailVo.setParentCategoryId(0);
    }else {
        productDetailVo.setParentCategoryId(category.getParentId());
    }

    //createTime
    productDetailVo.setCreateTime(DateTimeUtil.dateToStr(product.getCreateTime()));

    //updateTime
    productDetailVo.setUpdateTime(DateTimeUtil.dateToStr(product.getUpdateTime()));

    return productDetailVo;
}

pageHelper的使用方法：

(1)記錄起始頁(yè)startPage
(2)填充sql查詢(xún)邏輯
(3)收尾

@Override
public ServerResponse<PageInfo> getProductList(int pageNum,int pageSize){
    //1.記錄起始頁(yè)startPage
    PageHelper.startPage(pageNum,pageSize);
    //2.填充sql查詢(xún)邏輯
    List<Product> productList = productMapper.selectList();

    List<ProductListVo> productListVoList = Lists.newArrayList();
    for(Product productItem : productList){
        ProductListVo productListVo = assembleProductListVo(productItem);
        productListVoList.add(productListVo);
    }
    //3.收尾
    PageInfo pageResult = new PageInfo(productList);
    //把list重置
    pageResult.setList(productListVoList);
    return ServerResponse.createBySuccess(pageResult);

}

/**
 * 組裝productListVo
 * @param product
 * @return
 */
private ProductListVo assembleProductListVo(Product product){
    ProductListVo productListVo = new ProductListVo();
    productListVo.setId(product.getId());
    productListVo.setCategoryId(product.getCategoryId());
    productListVo.setImageHost(PropertiesUtil.getProperty("ftp.server.http.prefix","http://img.happymmall.com/"));
    productListVo.setMainImage(product.getMainImage());
    productListVo.setPrice(product.getPrice());
    productListVo.setSubtitle(product.getSubtitle());
    productListVo.setStatus(product.getStatus());
    return productListVo;
}

mybatis.xml:

  <select id="selectList" resultMap="BaseResultMap" >
    SELECT <include refid="Base_Column_List"/>
    FROM mmall_product
    ORDER BY id ASC
  </select>

  <select id="selectByNameAndProductId" resultMap="BaseResultMap" parameterType="map">
    SELECT <include refid="Base_Column_List" />
    FROM mmall_product
    <where>
      <if test="productName!=null">
        AND name LIKE #{productName}
      </if>
      <if test="productId!=null">
        AND id=#{productId}
      </if>
    </where>
  </select>

為了防止硬編碼，在獲取圖片url時(shí)弛槐，使用了配置文件：

hcxmall.properties:

ftp.server.ip=
ftp.user=hcxmallftp
ftp.pass=ftppassword
#搭建的圖片服務(wù)器的前綴
ftp.server.http.prefix=http://img.happymmall.com/

alipay.callback.url=http://www.happymmall.com/order/alipay_callback.do

password.salt = geelysdafaqj23ou89ZXcj@#$@#$#@KJdjklj;D../dSF.,

因?yàn)榕渲梦募锏臇|西會(huì)在多處用到懊亡，每一次都要讀取，所以封裝了一個(gè)使用流讀取配置文件的工具類(lèi)PropertiesUtil:

package com.hcxmall.util;

import org.apache.commons.lang.StringUtils;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import java.io.IOException;
import java.io.InputStreamReader;
import java.util.Properties;

/**
 * 配置文件工具類(lèi)
 * @author HCX
 * @create 2017 - 11 - 15 18:28
 */
public class PropertiesUtil {

    private static Logger logger = LoggerFactory.getLogger(PropertiesUtil.class);

    private static Properties props;

    //在tomcat啟動(dòng)時(shí)讀取里面的配置:使用靜態(tài)代碼塊
    //執(zhí)行順序：靜態(tài)代碼塊（在類(lèi)被加載的時(shí)候執(zhí)行且僅執(zhí)行一次）>普通代碼塊>構(gòu)造代碼塊
    //靜態(tài)代碼塊：一般用于初始化靜態(tài)變量乎串。
    static{
        String fileName = "hcxmall.properties";
        props = new Properties();
        try {
            props.load(new InputStreamReader(PropertiesUtil.class.getClassLoader().getResourceAsStream(fileName),"UTF-8"));
        } catch (IOException e) {
            logger.error("配置文件讀取異常",e);
        }
    }

    /**
     * 獲取hcxmall.propeties文件中的信息：通過(guò)key獲取value
     * @param key
     * @return
     */
    public static String getProperty(String key){
        String value = props.getProperty(key.trim());
        if(StringUtils.isBlank(value)){
        return null;
    }
        return value.trim();
}

    public static String getProperty(String key,String defaultValue){
        String value = props.getProperty(key.trim());
        if(StringUtils.isBlank(value)){
            value = defaultValue;
        }
        return value.trim();
    }
}

在進(jìn)行時(shí)間的轉(zhuǎn)換時(shí)店枣，也可使用工具類(lèi)，其中叹誉，應(yīng)用joda-time實(shí)現(xiàn)：

DateTimeUtil:

package com.hcxmall.util;

import org.apache.commons.lang.StringUtils;
import org.joda.time.DateTime;
import org.joda.time.format.DateTimeFormat;
import org.joda.time.format.DateTimeFormatter;

import java.util.Date;

/**
 * 時(shí)間轉(zhuǎn)換工具類(lèi)
 *
 * @author HCX
 * @create 2017 - 11 - 15 18:57
 */
public class DateTimeUtil {

    public static final String STANDARD_FORMAT = "yyyy-MM-dd HH:mm:ss";

    //joda-time

    public static Date strToDate(String dateTimeStr){
        DateTimeFormatter dateTimeFormatter = DateTimeFormat.forPattern(STANDARD_FORMAT);
        DateTime dateTime = dateTimeFormatter.parseDateTime(dateTimeStr);
        return dateTime.toDate();
        //strToDate("2010-01-01 11:11:11","yyyy-MM-dd HH:mm:ss"); Fri Jan 01 11:11:11 CST 2010
    }


    public static String dateToStr(Date date){
        if(date == null){
            return StringUtils.EMPTY;
        }
        DateTime dateTime = new DateTime(date);
        return dateTime.toString(STANDARD_FORMAT);
        //dateToStr(new Date(),"yyyy-MM-dd HH:mm:ss"); 2017-11-15 19:15:50
    }

    /**
     * 字符串轉(zhuǎn)date
     * @param dateTimeStr
     * @param formatStr
     * @return
     */
    public static Date strToDate(String dateTimeStr,String formatStr){
        DateTimeFormatter dateTimeFormatter = DateTimeFormat.forPattern(formatStr);
        DateTime dateTime = dateTimeFormatter.parseDateTime(dateTimeStr);
        return dateTime.toDate();
        //strToDate("2010-01-01 11:11:11","yyyy-MM-dd HH:mm:ss"); Fri Jan 01 11:11:11 CST 2010
    }

    /**
     * date轉(zhuǎn)字符串
     * @param date
     * @param formatStr 要轉(zhuǎn)化成的格式 例：yyyy-MM-dd HH:mm:ss
     * @return
     */
    public static String dateToStr(Date date,String formatStr){
        if(date == null){
            return StringUtils.EMPTY;
        }
        DateTime dateTime = new DateTime(date);
        return dateTime.toString(formatStr);
        //dateToStr(new Date(),"yyyy-MM-dd HH:mm:ss"); 2017-11-15 19:15:50
    }
}

在上面實(shí)現(xiàn)屬性的拷貝時(shí)鸯两，頻繁的編寫(xiě)get()和set()方法，此時(shí)长豁，也可以使用工具類(lèi)來(lái)完成

pom.xml:

<!--分頁(yè)插件-->
<dependency>
  <groupId>com.github.pagehelper</groupId>
  <artifactId>pagehelper</artifactId>
  <version>4.1.0</version>
</dependency>

<!--時(shí)間處理jar-->
<dependency>
  <groupId>joda-time</groupId>
  <artifactId>joda-time</artifactId>
  <version>2.3</version>
</dependency>