display分页程序流程-白红宇

display分页程序流程

阅读量：6832 次

发布时间：2019-06-26

本文共 16829 字，大约阅读时间需要 56 分钟。

Task_listMapper.xml文件：

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

</resultMap>

select distinct count(*) from task_list

<!--<where>

t.singer_id = t1.singer_id

and t.song_name = #{songName}

</if>

and t.song_type = #{songType}

</if>

and t1.singer_name = #{singerName}

</if>

and t.song_price = #{songPrice}

</if>

and t.download_count = #{download_count}

</if>

and t.download_url = #{downloadUrl}

</if>

</where>

--></select>

<!--

分页查询已经使用Dialect进行分页,也可以不使用Dialect直接编写分页

因为分页查询将传 #offset#,#pageSize#,#lastRows# 三个参数,不同的数据库可以根于此三个参数属性应用不同的分页实现

-->

select distinct

from task_list

<!-- <where>

t.singer_id = t1.singer_id

and t.song_name = #{songName}

</if>

and t.song_type = #{songType}

</if>

and t1.singer_name = #{singerName}

</if>

and t.song_price = #{songPrice}

</if>

and t.download_count = #{download_count}

</if>

and t.download_url = #{downloadUrl}

</if>

</where>-->

ORDER BY task_id

</select>

**************************

com.chinaGPS.song.dao.MemberDao

public class MemberDao extends BaseMyBatisDao<Task_list, java.lang.Integer>{

/**

* 获取下载任务列表分页

* @param pageRequest

* @return

public Page<Task_list> getTaskList(PageRequest pageRequest){

Page<Task_list> page = pageQuery(pageRequest);

return page;

}

***********************

package com.chinaGPS.song.service;

import java.util.List;

import com.chinaGPS.song.pojo.Task_list;

import com.chinaGPS.song.util.page.Page;

import com.chinaGPS.song.util.page.PageRequest;

public interface TaskInfoService {

public List<Task_list>selectTaskList();

/**

* 获取分页下载任务列表

* @return

Page<Task_list> getAllTaskList(PageRequest pageRequest);

}

*********************

package com.chinaGPS.song.util.page;

import java.io.Serializable;

import java.util.ArrayList;

import java.util.Collections;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

/**

* 分页请求信息

* 其中范型<T>为filters的类型

* @author badqiu

public class PageRequest<T> implements Serializable {

/**

* 过滤参数

private T filters;

/**

* 页号码,页码从1开始

private int pageNumber;

/**

* 分页大小

private int pageSize;

/**

* 排序的多个列,如: username desc

private String sortColumns;

public PageRequest() {

this(0,0);

}

public PageRequest(T filters) {

this(0,0,filters);

}

public PageRequest(int pageNumber, int pageSize) {

this(pageNumber,pageSize,(T)null);

}

public PageRequest(int pageNumber, int pageSize, T filters) {

this(pageNumber,pageSize,filters,null);

}

public PageRequest(int pageNumber, int pageSize,String sortColumns) {

this(pageNumber,pageSize,null,sortColumns);

}

public PageRequest(int pageNumber, int pageSize, T filters,String sortColumns) {

this.pageNumber = pageNumber;

this.pageSize = pageSize;

setFilters(filters);

setSortColumns(sortColumns);

}

public T getFilters() {

return filters;

}

public void setFilters(T filters) {

this.filters = filters;

}

public int getPageNumber() {

return pageNumber;

}

public void setPageNumber(int pageNumber) {

this.pageNumber = pageNumber;

}

public int getPageSize() {

return pageSize;

}

public void setPageSize(int pageSize) {

this.pageSize = pageSize;

}

public String getSortColumns() {

return sortColumns;

}

/**

* 排序的列,可以同时多列,使用逗号分隔,如 username desc,age asc

* @return

public void setSortColumns(String sortColumns) {

this.sortColumns = sortColumns;

}

/**

* 将sortColumns进行解析以便返回SortInfo以便使用

* @return

public List<SortInfo> getSortInfos() {

return Collections.unmodifiableList(SortInfo.parseSortColumns(sortColumns));

}

**********************

package com.chinaGPS.song.service.impl;

import java.util.List;

import com.chinaGPS.song.dao.MemberDao;

import com.chinaGPS.song.pojo.Task_list;

import com.chinaGPS.song.service.TaskInfoService;

import com.chinaGPS.song.util.page.Page;

import com.chinaGPS.song.util.page.PageRequest;

public class TaskInfoServiceImpl implements TaskInfoService {

private MemberDao memberDao;

public MemberDao getMemberDao() {

return memberDao;

}

public void setMemberDao(MemberDao memberDao) {

this.memberDao = memberDao;

}

/* (non-Javadoc)

* @see com.chinaGPS.song.service.TaskInfoService#getAllSongList(com.chinaGPS.song.util.page.PageRequest)

public Page<Task_list> getAllTaskList(PageRequest pageRequest) {

return memberDao.getTaskList(pageRequest);

}

************************

package com.chinaGPS.song.action.sysmanage;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

import javax.servlet.http.HttpSession;

import org.apache.commons.lang.StringUtils;

import org.apache.struts2.ServletActionContext;

import org.displaytag.tags.TableTagParameters;

import org.displaytag.util.ParamEncoder;

import com.chinaGPS.song.action.BaseAction;

import com.chinaGPS.song.pojo.Song_info;

import com.chinaGPS.song.pojo.Task_list;

import com.chinaGPS.song.service.TaskInfoService;

import com.chinaGPS.song.util.page.Page;

import com.chinaGPS.song.util.page.PageRequest;

public class TaskListAction extends BaseAction {

private static final long serialVersionUID = -1209389500331569006L;

private TaskInfoService taskInfoService;

private List<Task_list> list;

private PageRequest<Map> pageRequest;

private int pageSize = 5;

private int startPage = 1;

private int pageNumbers;

public String songsTaskList() {

String pageIndexName = new ParamEncoder("row")

.encodeParameterName(TableTagParameters.PARAMETER_PAGE); // 页数的参数名

startPage = StringUtils.isBlank(getParameter(pageIndexName)) ? 1

: (Integer.parseInt(getParameter(pageIndexName))); // 当前页数

if (startPage == 0) {

startPage = 1;

}

if(pageRequest==null)

pageRequest = new PageRequest(new HashMap());

pageRequest.setPageNumber(startPage);

pageRequest.setPageSize(pageSize);

pageRequest.setSortColumns(null);

Page<Task_list> page = taskInfoService.getAllTaskList(pageRequest);

list = page.getResult();

pageNumbers = page.getTotalCount();

return SUCCESS;

}

public TaskInfoService getTaskInfoService() {

return taskInfoService;

}

public PageRequest<Map> getPageRequest() {

return pageRequest;

}

public void setPageRequest(PageRequest<Map> pageRequest) {

this.pageRequest = pageRequest;

}

public int getPageSize() {

return pageSize;

}

public void setPageSize(int pageSize) {

this.pageSize = pageSize;

}

public int getStartPage() {

return startPage;

}

public void setStartPage(int startPage) {

this.startPage = startPage;

}

public int getPageNumbers() {

return pageNumbers;

}

public void setPageNumbers(int pageNumbers) {

this.pageNumbers = pageNumbers;

}

public void setTaskInfoService(TaskInfoService taskInfoService) {

this.taskInfoService = taskInfoService;

}

public List<Task_list> getList() {

return list;

}

public void setList(List<Task_list> list) {

this.list = list;

}

************************JSP

<%@ taglib uri="http://displaytag.sf.net" prefix="display"%>

<display:table name="list" id="row" partialList="true"

pagesize="${pageSize}" size="${pageNumbers}"

requestURI="songsTaskList.action" class="table">

<display:column property="taskId" title="用户"/>

<display:column property="mId" title="性别"/>

<display:column property="mName" title="车载" />

<display:column property="mPhonenumber" title="车牌" />

<display:column property="songid" title="歌曲" />

<display:column property="downloadTime" title="发送时间" />

<display:column property="downloadStatus" title="发送状态" />

<display:column title="基本操作"> <div align="center">

</div>

</display:column>

</display:table>

**********************application-action-sys.xml

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xmlns:context="http://www.springframework.org/schema/context"

xmlns:aop="http://www.springframework.org/schema/aop"

xmlns:tx="http://www.springframework.org/schema/tx"

xsi:schemaLocation="http://www.springframework.org/schema/beans

http://www.springframework.org/schema/beans/spring-beans-3.0.xsd

http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd

http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd

http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd"

default-autowire="byName">

</bean>

</beans>

***********************application-dao.xml

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xmlns:context="http://www.springframework.org/schema/context"

xmlns:aop="http://www.springframework.org/schema/aop"

xmlns:tx="http://www.springframework.org/schema/tx"

xsi:schemaLocation="http://www.springframework.org/schema/beans

http://www.springframework.org/schema/beans/spring-beans-3.0.xsd

http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd

http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd

http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd"

default-autowire="byName">

</bean>

</beans>

******************application-core.xml

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"

xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"

xsi:schemaLocation="http://www.springframework.org/schema/beans

http://www.springframework.org/schema/beans/spring-beans-3.0.xsd

http://www.springframework.org/schema/context

http://www.springframework.org/schema/context/spring-context-3.0.xsd

http://www.springframework.org/schema/aop

http://www.springframework.org/schema/aop/spring-aop-3.0.xsd

http://www.springframework.org/schema/tx

http://www.springframework.org/schema/tx/spring-tx-3.0.xsd"

default-autowire="byName">

<context:property-placeholder location="/WEB-INF/jdbc/mysql.properties" />

<!-- <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">

<property name="driverClassName" value="${jdbc.driverClassName}" /> <property

name="url" value="${jdbc.url}" /> </bean> -->

</bean>

<!-- <property name="configLocation" value="classpath:mybatis-config.xml"

/> -->

<bean id="sqlSessionFactory"

class="com.chinaGPS.song.util.SqlSessionFactoryFactoryBean">

<list>

<value>classpath*:/com/chinaGPS/song/mapper/Song_infoMapper.xml</value>

<value>classpath*:/com/chinaGPS/song/mapper/Song_singerMapper.xml</value>

<value>classpath*:/com/chinaGPS/song/mapper/Task_listMapper.xml</value>

</list>

</property>

</bean>

<!-- <property name="mapperInterface" value="com.chinaGPS.song.dao.UserDao"

/> -->

<!-- <property name="mapperInterface" value="com.chinaGPS.song.dao.ISBookDao"

/> -->

<!-- <property name="mapperInterface" value="com.chinaGPS.song.dao.IAddressDao"

/> -->

<bean name="transactionManager"

class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

</bean>

<tx:advice id="txAdvice" transaction-manager="transactionManager">

<tx:attributes>

<tx:method name="delete*" propagation="REQUIRED" />

<tx:method name="insert*" propagation="REQUIRED" />

<tx:method name="update*" propagation="REQUIRED" />

<tx:method name="register*" propagation="REQUIRED" />

<tx:method name="modify*" propagation="REQUIRED" />

<tx:method name="add*" propagation="REQUIRED" />

<tx:method name="*lock*" propagation="REQUIRED" />

<tx:method name="reset*" propagation="REQUIRED" />

<tx:method name="find*" read-only="true"/>

<tx:method name="get*" read-only="true"/>

<tx:method name="query*" read-only="true"/>

</tx:attributes>

</tx:advice>

<aop:config>

<aop:pointcut id="allMagangerMethod" expression="execution(* com.chinaGPS.song.dao.base.BaseService.*(..))" />

<aop:pointcut id="allMagangerMethod1" expression="execution(* com.chinaGPS.song.service.impl.*ServiceImpl.*(..))" />

<aop:pointcut id="allMagangerMethod2" expression="execution(* com.chinaGPS.song.service.*Service.*(..))" />

<aop:advisor pointcut-ref="allMagangerMethod" advice-ref="txAdvice" />

<aop:advisor pointcut-ref="allMagangerMethod1" advice-ref="txAdvice" />

<aop:advisor pointcut-ref="allMagangerMethod2" advice-ref="txAdvice" />

</aop:config>

</beans>

*********************application-service.xml

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xmlns:context="http://www.springframework.org/schema/context"

xmlns:aop="http://www.springframework.org/schema/aop"

xmlns:tx="http://www.springframework.org/schema/tx"

xsi:schemaLocation="http://www.springframework.org/schema/beans

http://www.springframework.org/schema/beans/spring-beans-3.0.xsd

http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd

http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd

http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd"

default-autowire="byName">

</bean>

</beans>

转载于:https://blog.51cto.com/hzywy/740070

你可能感兴趣的文章

C++的64位整数

查看>>

Entity Framework 6 Recipes 2nd Edition（9-5）译->删除一个断开的实体

Github获取仓库最新Release版本号API

查看>>

搭建自己的PHP框架心得（一）

查看>>

ReactiveCocoa代码实践之-更多思考

查看>>

了解一下JAVA中的NIO模块

查看>>

java编解码技术,json序列化与二进制序列化

Uncaught RangeError: Maximum call stack size exceeded解决思路

查看>>

运用.net core配合VS 2015制作nuget包

查看>>

JSP三大指令 /9大内置对象 /Javabean / EL

查看>>

WebPack系列：Webpack编译的代码如何在tomcat中使用时静态资源路径不对的问题如何解决...

查看>>

《HelloGitHub》之GitHub Bot

查看>>

node.js常见的一些错误信息

查看>>