java后台分页
方法名:getActivityPicture
package xxx
import xxx
@Service("xxxService")
public class xxxServiceImpl implements xxxService {
@Resource
private xxx xxxDao;//xxx是你的那个mapper接口,xxxDao名字自己取
public void deal(xxx request, xxx response) {
String action = request.getAction(); //获得页面请求的action名
if ("getActivityPicture".equalsIgnoreCase(action)) {
getActivityPicture(request, response); //action等于getActivityPicture就执行这个方法getActivityPicture(request, response);
}
}
private void getActivityPicture(xxx request, xxx response) {
JSONObject reqData = request.getData();//获得请求中的数据int currentPage = reqData.getInt("page");//请求的页码,如page=3就是第三页
xxxExample example = new xxxExample();
example.createCriteria().andxxxEqualTo(reqData.getInt("xxx")) .andxxxEqualTo(xxx);//查询条件,没有查询条件这一行可不要
example.setPageSize(10);//页的大小,如一页10条数据
int index = (currentPage - 1) * example.getPageSize() + 1;// 计算索引
example.setOrderByClause("TIME DESC"); //降序,离最近的时间
example.setStart(index);//index从哪个索引开始查找
List<xxx> list = this.xxxDao
.selectByExample(example);
JSONObject JSON = new JSONObject();
JSON.put("total", list.size());//数据的总条数放到total
JSON.put("rows", JSONArray.fromObject(list));//数据转成json放到rows
JSONObject resData = new JSONObject();
resData.put("xxx", JSON);//将总数据JSON放到xxx
response.setData(resData);//将数据响应给前端
}
}