Bootstrap和Java分页实例第二篇

关于此文

　　运用第一篇分页的例子，结果以失败告终。在网上又寻找了很多例子。大多是都是这一种。着手开发的项目采用spring MVC框架。符合需求。摘下来，试了一试。

网上的例子总是少一些东西。经过一番折腾。终于搞定了。下面分享出来，供参考。

分页基本逻辑思想懂了，重点是在于怎么实现。怎么实现更好。还需要进一步思考。

配置xml-pager.tld

分页控件-Pager

分页action集成类-BaseController

<div class="jb51code">
<pre class="brush:java;">
package getui.controller;

import getui.util.Pager;

import java.util.Iterator;
import java.util.List;
import java.util.Map;

import org.springframework.ui.Model;

/**

• 分页控件初始化父类
• @author Anny
  */
  public class BaseController {

//初始化分页相关信息
protected void initPage(Map<String,Object> map,Integer pageNum,Integer pageSize,Integer totalCount){
if(null==pageSize || pageSize.equals("")){
pageSize = 10; //每页显示条数
}
// if(pageSize>50){
// pageSize = 50;
// }
Integer totalPage = (totalCount+pageSize-1)/pageSize;
if(null==pageNum){
pageNum = 1;
}else if(pageNum>totalPage){
pageNum = totalPage;
}
map.put("startIndex",Pager.getStartIndex(pageNum,pageSize));
map.put("pageNum",pageNum);
map.put("totalPage",totalPage);
map.put("pageSize",pageSize);
map.put("totalCount",totalCount);
map.put("lastIndex",Pager.getLastIndex(pageSize,totalCount,totalPage,pageNum));
}

//将相关数据放入model
protected void initResult(Model model,List<Map<String,Object>> list,Map<String,Object> map){
model.addAttribute("list",list);
Iterator it = map.entrySet().iterator();
while(it.hasNext()){
Map.Entry m = (Map.Entry)it.next();
model.addAttribute(m.getKey().toString(),m.getValue());
}
}

}

实例-Dao

<div class="jb51code">
<pre class="brush:java;">
package getui.dao;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;

import org.apache.log4j.Logger;
import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.ResultSetExtractor;
import org.springframework.jdbc.core.namedparam.BeanPropertySqlParameterSource;
import org.springframework.jdbc.core.namedparam.SqlParameterSource;
import org.springframework.stereotype.Repository;

import getui.controller.GeTuiController;
import getui.entity.Branch;
import getui.entity.GetuiInfo;

@Repository("bookDao")
public class BookDao extends BaseDao{

/* 日志记录 ./
private static Logger logger = Logger.getLogger(BookDao.class);

public int getListCount(){
String sql ="select count(1) from Book";
return super.jdbcTemplate.queryForInt(sql);
}

public List getListBook(int pageIndex,int pageSize){
String sql = "select * from Book where 1=1 limit "+pageIndex+","+pageSize;

// String sql = "select a.*"
// + " from ("
// +" select id as nid,name,price"
// +" from book"
// +" order by(id) "
// +" ) a"
// +" where nid between "+pageIndex+" and "+pageSize+"";
return super.jdbcTemplate.queryForList(sql);
}

}

实例-service

<div class="jb51code">
<pre class="brush:java;">
package getui.service;

import getui.dao.BookDao;
import getui.dao.ClientInfoDao;
import getui.entity.Branch;
import getui.entity.GetuiInfo;

import java.util.List;
import java.util.Map;

import org.apache.log4j.Logger;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service("bookService")
public class BookService {

/* 日志记录 ./
private static Logger logger = Logger.getLogger(BookService.class);

@Autowired
private BookDao bookDao;

public int getListCount(){
return bookDao.getListCount();
}

public List getListBook(int pageIndex,int pageSize){
return bookDao.getListBook(pageIndex,pageSize);
// return bookDao.getListBook();
}
}

实例-action

<div class="jb51code">
<pre class="brush:java;">
package getui.controller;

import getui.service.BookService;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.apache.log4j.Logger;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;

@Controller
@RequestMapping(value = "/test")
public class TestController extends BaseController {

/* 日志记录 ./
private static Logger logger = Logger.getLogger(TestController.class);

@Autowired
private BookService bookService;

@RequestMapping("/test.do")
public String test(Model model,String type,@RequestParam(required=false) Integer pageNum,@RequestParam(required=false) Integer pageSize) {

Map<String,Object> map = new HashMap<String,Object>();
map.put("type",type);
Integer totalCount = bookService.getListCount();

this.initPage(map,pageNum,pageSize,totalCount);
List list = this.bookService.getListBook(Integer.valueOf(String.valueOf(map.get("startIndex"))),Integer.valueOf(String.valueOf(map.get("pageSize"))));
this.initResult(model,list,map);

return "book";
}

}

实例-JSP