真分页

//传入参数
//页码
Integer page;
//每页多少条
Integer size;

//代码
public  List<Evaluate> evaluateList(Integer page, Integer size) 
        {        
 
       Integer iOffset = (page - 1) * size;
		Long offset = Long.valueOf(iOffset.toString());
		Integer limit = iOffset + size;
        List<Evaluate> evaluateList = evaluateMapper.findMyEvaluate(offset, limit);
       return evaluateList ;
}

//sql
<select id="evaluateList"
		resultType="com.amigo.companion.provider.order.entity.Evaluate">

		SELECT
		user_id,
		gathering_user_id,
		trade_num,
		trade_evaluation
		FROM
		evaluate_tbl
		WHERE
		deleted = 0
		LIMIT
		#{offset},#{limit}
	</select>