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

雨点打透心脏的1/2处 2022-03-14 08:22 166阅读 0赞

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

分页插件pagehelper.jar：

[https://oss.sonatype.org/content/repositories/releases/com/github/pagehelper/pagehelper/][https_oss.sonatype.org_content_repositories_releases_com_github_pagehelper_pagehelper]  
[http://repo1.maven.org/maven2/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/][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/][http_repo1.maven.org_maven2_com_github_jsqlparser_jsqlparser_0.9.1]

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

<bean id="sessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">
    
    
    
    <property name="dataSource" ref="dataSource" />
    
    
    
    <property name="typeAliasesPackage" value="com.hlx.entity" />
    
    
    
    <property name="mapperLocations" value="classpath*:com/hlx/mapper/*Mapper.xml" />
    
    
    
    
    <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>
    
    
    
    <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>

九 JS

**十.效果**

**![Center][]**

![Center 1][]

![Center 2][]

![Center 3][]

[https_oss.sonatype.org_content_repositories_releases_com_github_pagehelper_pagehelper]: https://oss.sonatype.org/content/repositories/releases/com/github/pagehelper/pagehelper/
[http_repo1.maven.org_maven2_com_github_pagehelper_pagehelper]: http://repo1.maven.org/maven2/com/github/pagehelper/pagehelper/
[http_repo1.maven.org_maven2_com_github_jsqlparser_jsqlparser_0.9.4]: http://repo1.maven.org/maven2/com/github/jsqlparser/jsqlparser/0.9.4/
[http_repo1.maven.org_maven2_com_github_jsqlparser_jsqlparser_0.9.1]: http://repo1.maven.org/maven2/com/github/jsqlparser/jsqlparser/0.9.1/
[Center]: /images/20220313/a00b86937fd944098aeac157f2c75b5f.png
[Center 1]: /images/20220313/2e61a7337c064ddcbf18f94cd8228b28.png
[Center 2]: /images/20220313/d74372cdf3964b0ea35b2a428aa4db3d.png
[Center 3]: /images/20220313/0c7f2e403f3f4da9a1eb485ee73f8b9f.png