Spring与Mybatis+PageHelper实现分页整合(三)

一.实现数据表的分页,这里用Mybatis分页插件-PageHepler实现

 

分页插件pagehelper.jar：

https://oss.sonatype.org/content/repositories/releases/com/github/pagehelper/pagehelper/ 
http://repo1.maven.org/maven2/com/github/pagehelper/pagehelper/ 
由于使用了sql解析工具，你还需要下载jsqlparser.jar

4.1.0及以后版本需要0.9.4版本

http://repo1.maven.org/maven2/com/github/jsqlparser/jsqlparser/0.9.4/ 
4.1.0以前版本需要0.9.1版本

http://repo1.maven.org/maven2/com/github/jsqlparser/jsqlparser/0.9.1/

二.在spring配置文件applicationContext.xml中配置PageHelper插件

<!--3 mybatis 会话工厂bean sqlSessionFactoryBean -->

<bean id="sessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">

<!-- 数据源 -->

<property name="dataSource" ref="dataSource" />

<!-- 实体类别名 -->

<property name="typeAliasesPackage" value="com.hlx.entity" />

<!-- mapper sql映射文件路径 -->

<property name="mapperLocations" value="classpath*:com/hlx/mapper/*Mapper.xml" />


<!-- 配置mybatis-pageHelper插件 -->

<property name="plugins">

<array>

<bean class="com.github.pagehelper.PageHelper">

<property name="properties">

<value>dialect=mysql</value>

</property>

</bean>

</array>

</property>


</bean>

三.Dao接口

 

	List<Student> findCondition(Student student);// 根据条件查询数据

四.配置文件StudentMapper.xml

<!-- 根据条件查询数据 -->

<select id="findCondition" resultType="Student" parameterType="Student">

select * from students

<trim prefix="where" prefixOverrides="AND|OR">

<if test="user!=null">

user like concat('%',#{user},'%')

</if>

<if test="email!=null">

and email like concat('%',#{email},'%')

</if>

</trim>

</select>

五.Service接口

 

	PageInfo<Student> findPageList2(int pageIndex,int pageSize,Student student);// 查询所有的数据

六.实现Service接口类

@Override

@Transactional(propagation = Propagation.SUPPORTS, readOnly = true)

public PageInfo<Student> findPageList2(int pageIndex, int pageSize,

Student student) {

// 分页

PageHelper.startPage(pageIndex, pageSize);


// 判断student不能为空

if (student != null) {

// 调用业务方法

List<Student> list = studentDao.findCondition(student);


// 返回分页对象

PageInfo<Student> pageInfo2 = new PageInfo<Student>(list);


return pageInfo2;

}

return null;


}

 七.Controller控制层

/**

* 根据条件分页数据

*

* @param request

* @param response

* @return

* @throws ServletException

* @throws IOException

*/

public String getAllPage2(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {



//当前页

int pageIndex=(request.getParameter("pageIndex")==null)?(1):(Integer.parseInt(request.getParameter("pageIndex")));


//设置每页个数 默认是10条数据

int pageSize=5;


//请求参数值/

String user=request.getParameter("user");

String email=request.getParameter("email");


//封装对象

Student student=new Student(user,email);

//



// 调用业务方法

PageInfo<Student> list = biz.findPageList2(pageIndex, pageSize,student);


// 保存数据

request.setAttribute("lists", list);

request.setAttribute("stu", student);


// 跳转路径

return "list2.jsp";


}

八.JSP页面

<form action="getAllPage2.action" method="post">

<fieldset>

<legend>根据条件查询数据</legend>

<div>

user:<input type="text" name="user" value="${stu.user }"/>

email:<input type="text" name="email" value="${stu.email }"/>

<input type="submit" value="查询"/>

</div>

</fieldset>

<!-- <form action="del2.action" method="post"> -->

<div class="main">


<table width="100%" border="1">

<caption>

<h1>学生信息</h1>

</caption>

<tr align="center">

<td width="24"><input type="checkbox" name="checkbox"

id="checkbox" /> <label for="checkbox"></label></td>

<td width="26">id</td>

<td width="90">user</td>

<td width="157">email</td>

<td width="222">date</td>

<td width="35">age</td>

<td width="112">操作</td>

</tr>


<c:if test="${lists.list.size()!=0}">


<c:forEach var="stu" items="${lists.list}">

<tr align="center">

<td><input type="checkbox" name="checkbox2" id="checkbox2"

value="${stu.id }" /> <label for="checkbox2"></label></td>

<td>${stu.id }</td>

<td>${stu.user }</td>

<td>${stu.email }</td>

<td><fmt:formatDate value="${stu.date }" type="date" />

</td>

<td>${stu.age }</td>

<td><a href="javascript:fun(${stu.id })">删除</a>/<a

href="find.action?id=${stu.id }">修改</a></td>

</tr>

</c:forEach>

</table>

<p>

第${lists.pageNum }/${lists.lastPage }页   


<c:if test="${!lists.isFirstPage}">

<a href="javascript:funPage(${lists.firstPage })">首页</a>

<a href="javascript:funPage(${lists.prePage })">上一页</a>

</c:if>


<!--显示所有的页数 -->

<c:forEach items="${lists.navigatepageNums }" var="i">

<a href="getAllPage2.action?pageIndex=${i}">${i}</a>

</c:forEach>



<c:if test="${!lists.isLastPage}">

<a href="javascript:funPage(${lists.nextPage })">下一页</a>

<a href="javascript:funPage(${lists.lastPage })">尾页</a>

</c:if>


</p>

</c:if>

<c:if test="${lists.list.size()==0}">

<tr align="center" style="color:red;"><td colspan="7">没有您要查找的数据</td></tr>

</c:if>

<p style="color:red;">${msg}</p>

<p>

<a href="studentAdd.jsp">添加</a> <input type="submit"

value="选择删除多条数据">

</p>

</div>

<!-- </form> -->


</form>

九 JS

function fun(id){

if(window.confirm("您确定要删除吗?")){

document.location.href="del.action?id="+id;

}


}


/**

* 分页跳转

* @param index

*/

function funPage(index){

document.forms[0].action="getAllPage2.action?pageIndex="+index; //指定路径

document.forms[0].submit(); //提交

}

十.效果