springmvc+mybatis+easyui分頁

道德三黃五帝，功名夏侯商周。五霸七雄鬧春秋，頃刻興亡過手。清時幾行名姓，北芒無數荒丘。前人播種後人收，說什麼原創與否。

今天和大家分享一下springmvc+mybatis+easyui的分頁實作。springmvc，mybatis的優缺點不做太多敖述大家都比較了解了，ssm架構整合的例子網上也有很多了，為什麼還要寫這篇文章那，主要是覺得大多過于零散配置方式又是千差萬别，總結一下本文希望對遇到此問題的人有所幫助，前人播種後人收。當然程式開發沒有覺得正确，誰也說不出一個正确的實作第N行代碼是什麼，由于水準有限，難免有纰漏之處，希望大家多多指點。

正文開始之前和大家說說為什麼選擇easyui，個人從13年開始管理系統前端技術使用easyui非常多，easyui很對得起easy這個詞，上手很容易，浏覽器相容性優良，文檔内容完善且有中文，datagrid請求資料參數簡單友善。

本文應用到技術相關版本如下：

技術	版本
Spring	4.0.2.RELEASE
Mybatis	3.2.6
jquery	jquery -1.11.1.js
EasyUI	1.4
Maven	2.5

技術思路：

1. 用Springmvc建構 Web應用程式的全功能 MVC 子產品

2. ORM架構選用mybatis，mybatis相對ibatis增加了mapper功能，大大簡化了開發的工作量，但是spring和mybatis整合時沒有了類似整合ibatis時的queryForList(String statementName,Object parameterObject, int skipResults, intmaxResults)方法，對于資料範圍的控制需要借助mybatis的Interceptor實作。

3. 結合思路2中提到的特點，需要定義StatementHandler類型的Interceptor，同時本執行個體将分頁相關的查詢參數封裝為PageUtil類。在該攔截器中判斷如果參數類型為PageUtil則需要對sql進行處理，将其構造為分頁模式的sql，oracle可用利用rownum，mysql利用limit函數。同時我們還可以在攔截器中擷取到查詢資料的總記錄數，這樣是相對于spring整合ibatis的又一友善之處。

4. PageUtil中封裝分頁相關的參數。由于easyui在請求時使用rows（Int類型）表示每頁顯示的記錄數，page表示目前頁，而響應時需要使用rows（List類型）表示查詢結果，total表示記錄數，是以PageUtil中的setRows，getRows方法不能簡單的依靠IDE自動生成了。同時為了友善将PageUtil作為了控制層傳回值，是以PageUtil類還需注意對其轉換為符合easyuidatagrid标準的json格式時，不必要參數的控制。

5. Spring自動掃描mybatis的xml檔案，自動掃描mapper類，service層控制事務。

程式代碼如下：

1. Maven pom.xml檔案内容如下

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<groupId>com.asiainfo</groupId>
	<artifactId>cbar</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<packaging>war</packaging>
	<name>bomcreport2</name>
	<properties>
		<!-- spring版本号 -->
		<spring.version>4.0.2.RELEASE</spring.version>
		<!-- mybatis版本号 -->
		<mybatis.version>3.2.6</mybatis.version>
		<!-- log4j日志檔案管理包版本 -->
		<slf4j.version>1.7.7</slf4j.version>
		<log4j.version>1.2.17</log4j.version>
	</properties>

	<dependencies>
			<dependency>
		    <groupId>org.apache.maven.plugins</groupId>
		    <artifactId>maven-resources-plugin</artifactId>
		    <version>2.4.1</version>
		</dependency>
		<dependency>
			<groupId>junit</groupId>
			<artifactId>junit</artifactId>
			<version>4.11</version>
			<!-- 表示開發的時候引入，釋出的時候不會加載此包 -->
			<scope>test</scope>
		</dependency>
		<!-- spring核心包 -->
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-core</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-web</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-oxm</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-tx</artifactId>
			<version>${spring.version}</version>
		</dependency>

		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-jdbc</artifactId>
			<version>${spring.version}</version>
		</dependency>

		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-webmvc</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-aop</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-aspects</artifactId>
			<version>${spring.version}</version>
			<type>jar</type>
			<scope>compile</scope>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-context-support</artifactId>
			<version>${spring.version}</version>
		</dependency>

		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-test</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<!-- mybatis核心包 -->
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis</artifactId>
			<version>${mybatis.version}</version>
		</dependency>
		<!-- mybatis/spring包 -->
			<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis-spring</artifactId>
			<version>1.2.2</version>
		</dependency>
		<!-- 導入dbcp的jar包，用來在applicationContext.xml中配置資料庫 -->
		<dependency>
			<groupId>commons-dbcp</groupId>
			<artifactId>commons-dbcp</artifactId>
			<version>1.2.2</version>
		</dependency>
		<!-- JSTL标簽類 -->
		<dependency>
			<groupId>jstl</groupId>
			<artifactId>jstl</artifactId>
			<version>1.2</version>
		</dependency>
		<!-- 日志檔案管理包 -->
		<!-- log start -->
		<dependency>
			<groupId>log4j</groupId>
			<artifactId>log4j</artifactId>
			<version>${log4j.version}</version>
		</dependency>

		<dependency>
			<groupId>org.slf4j</groupId>
			<artifactId>slf4j-api</artifactId>
			<version>${slf4j.version}</version>
		</dependency>

		<dependency>
			<groupId>org.slf4j</groupId>
			<artifactId>slf4j-log4j12</artifactId>
			<version>${slf4j.version}</version>
		</dependency>
		<!-- log end -->
		<!-- 上傳元件包 -->
		<dependency>
			<groupId>commons-fileupload</groupId>
			<artifactId>commons-fileupload</artifactId>
			<version>1.3.1</version>
		</dependency>
		<dependency>
			<groupId>commons-io</groupId>
			<artifactId>commons-io</artifactId>
			<version>2.4</version>
		</dependency>
		<dependency>
			<groupId>commons-codec</groupId>
			<artifactId>commons-codec</artifactId>
			<version>1.9</version>
		</dependency>
		<dependency>
			<groupId>javax.servlet</groupId>
			<artifactId>javax.servlet-api</artifactId>
			<version>3.0.1</version>
			<scope>provided</scope>
		</dependency>
		<dependency>  
            <groupId>commons-beanutils</groupId>  
            <artifactId>commons-beanutils</artifactId>  
            <version>1.9.2</version>  
        </dependency>
		<dependency>  
            <groupId>com.fasterxml.jackson.core</groupId>  
            <artifactId>jackson-databind</artifactId>  
            <version>2.5.0</version>  
        </dependency> 
		<dependency>  
            <groupId>org.codehaus.jackson</groupId>  
            <artifactId>jackson-mapper-asl</artifactId>  
            <version>1.9.13</version>  
        </dependency>
	</dependencies>
	<build>
		<defaultGoal>compile</defaultGoal>
		<sourceDirectory>src/main/java</sourceDirectory>
		<resources>
			<resource>
				<directory>src/main/java</directory>
				<excludes>
					<exclude>**/*.java</exclude>
				</excludes>
			</resource>
		</resources>
		<plugins>
			<plugin>
				<artifactId>maven-compiler-plugin</artifactId>
				<version>2.3.2</version>
				<configuration>
					<source>1.6</source>
					<target>1.6</target>
				</configuration>
			</plugin>
			<plugin>
				<artifactId>maven-war-plugin</artifactId>
				<version>2.2</version>
				<configuration>
					<warSourceDirectory>${basedir}/WebRoot</warSourceDirectory>
					<version>3.0</version>
					<failOnMissingWebXml>false</failOnMissingWebXml>
				</configuration>
			</plugin>
		</plugins>
	</build>
</project>

2. spring-config.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:p="http://www.springframework.org/schema/p"
     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/tx
         http://www.springframework.org/schema/tx/spring-tx.xsd
         http://www.springframework.org/schema/aop
         http://www.springframework.org/schema/aop/spring-aop-3.0.xsd
         http://www.springframework.org/schema/context
         http://www.springframework.org/schema/context/spring-context-3.0.xsd">
    <context:annotation-config />
    <!-- 自動掃描com.asia包先相關類 -->
    <context:component-scan base-package="com.asia" >
        <!-- <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/> -->
    </context:component-scan>
    
    <bean id="propertyConfigurer"  
        class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">  
        <property name="location" value="classpath:base.properties" />  
    </bean>
    <!-- 定義資料源 -->
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"  
        destroy-method="close">  
        <property name="driverClassName" value="${driverClassName}" />  
        <property name="url" value="${DBTUrl}" />  
        <property name="username" value="${DBUser}" />  
        <property name="password" value="${DBPassword}" />  
        <!-- 初始化連接配接大小 -->  
        <property name="initialSize" value="${initialSize}"></property>  
        <!-- 連接配接池最大數量 -->  
        <property name="maxActive" value="${maxActive}"></property>  
        <!-- 連接配接池最大空閑 -->  
        <property name="maxIdle" value="${maxIdle}"></property>  
        <!-- 連接配接池最小空閑 -->  
        <property name="minIdle" value="${minIdle}"></property>  
        <!-- 擷取連接配接最大等待時間 -->  
        <property name="maxWait" value="${maxWait}"></property>  
    </bean>
  
    <!-- spring和MyBatis完美整合，不需要mybatis的配置映射檔案 -->  
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">  
        <property name="dataSource" ref="dataSource" />  
        <!-- 自動掃描mapping.xml檔案  --> 
        <property name="mapperLocations" value="classpath:mapping/*.xml"></property>
        <property name="plugins">
        	<array>
		      <bean class="com.asia.util.mybatispage.PageInterceptor">
		        <property name="properties">
		          <value>
		            databaseType=oracle
		          </value>
		        </property>
		      </bean>
		    </array>
        </property>
    </bean>  
  
   <!--  DAO接口所在包名，Spring會自動查找其下的類   -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">  
        <property name="basePackage" value="com.asia.*.mapper" />  
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>  
    </bean>  
  
    <!-- (事務管理)transaction manager, use JtaTransactionManager for global tx   -->
    <bean id="transactionManager"  
        class="org.springframework.jdbc.datasource.DataSourceTransactionManager">  
        <property name="dataSource" ref="dataSource" />  
    </bean>
    <tx:advice id="userTxAdvice" transaction-manager="transactionManager">
		<tx:attributes>
			<tx:method name="delete*" propagation="REQUIRED" read-only="false" rollback-for="java.lang.Exception" no-rollback-for="java.lang.RuntimeException"/>
			<tx:method name="add*" propagation="REQUIRED" read-only="false" rollback-for="java.lang.Exception" />
			<tx:method name="insert*" propagation="REQUIRES_NEW" read-only="false" rollback-for="java.lang.Exception" />
			<tx:method name="update*" propagation="REQUIRED" read-only="false" rollback-for="java.lang.Exception" />
			<tx:method name="modify*" propagation="REQUIRES_NEW" read-only="false" rollback-for="java.lang.Exception" />
			<tx:method name="find*" propagation="SUPPORTS"/>
			<tx:method name="get*" propagation="SUPPORTS"/>
			<tx:method name="select*" propagation="SUPPORTS"/>
		</tx:attributes>
	</tx:advice>
	
	<aop:config>
		<aop:pointcut id="pc" expression="execution(public * com.asia.*.service.*.*(..))" /> <!-- 把事務控制在Service層 -->
		<aop:advisor pointcut-ref="pc" advice-ref="userTxAdvice" />
	</aop:config>
</beans>

3. spring-servlet.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:p="http://www.springframework.org/schema/p"
	xmlns:context="http://www.springframework.org/schema/context"
	xmlns:util="http://www.springframework.org/schema/util" xmlns:mvc="http://www.springframework.org/schema/mvc"
	xsi:schemaLocation="
        http://www.springframework.org/schema/util
        http://www.springframework.org/schema/util/spring-util-3.0.xsd
        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/mvc
       http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd"> -->
<beans xmlns="http://www.springframework.org/schema/beans"    
 xmlns:context="http://www.springframework.org/schema/context"    
 xmlns:p="http://www.springframework.org/schema/p"    
 xmlns:mvc="http://www.springframework.org/schema/mvc"    
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"    
 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.xsd    
      http://www.springframework.org/schema/mvc    
      http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd">
	<mvc:annotation-driven />  
	<!-- <context:annotation-config /> -->
	<context:component-scan base-package="com.asia.*.controller">
	<context:include-filter type="annotation" expression="org.springframework.stereotype.Controller" /></context:component-scan>
	
	<!-- <context:component-scan base-package="com.asia.*.controller"  /> -->
<!-- 	<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver" p:prefix="/" p:suffix=".jsp" />  
 -->	<!-- <bean id="mappingJacksonHttpMessageConverter" class="org.springframework.http.converter.json.MappingJacksonHttpMessageConverter">  
        <property name="supportedMediaTypes">  
            <list>  
                <value>text/html;charset=UTF-8</value>  
            </list>  
        </property>  
    </bean>  
  
    啟動Spring MVC的注解功能，完成請求和注解POJO的映射  
    <bean class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter">  
        <property name="messageConverters">  
            <list>  
                <ref bean="mappingJacksonHttpMessageConverter" />json轉換器  
            </list>  
        </property>  
    </bean>  -->
<!-- 	<bean id="defaultViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver" p:order="3">
		<property name="viewClass" value="org.springframework.web.servlet.view.JstlView" />
		<property name="contentType" value="text/html" />
		<property name="prefix" value="/" />
		<property name="suffix" value=".jsp" />
	</bean> -->
	
	<!-- <bean class="org.springframework.web.servlet.view.ContentNegotiatingViewResolver">
	    <property name="mediaTypes">
	        <map>
	            <entry key="atom" value="application/atom+xml"/>
	            <entry key="html" value="text/html"/>
	            <entry key="json" value="application/json"/>
	        </map>
	    </property>
	    <property name="viewResolvers">
	        <list>
	            <bean class="org.springframework.web.servlet.view.BeanNameViewResolver"/>
	            <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
	                <property name="prefix" value="/WEB-INF/"/>
	                <property name="suffix" value=".jsp"/>
	            </bean>
	        </list>
	    </property>
	    <property name="defaultViews">
	        <list>
	            <bean class="org.springframework.web.servlet.view.json.MappingJackson2JsonView"/>
	        </list>
	    </property>
	</bean> -->
</beans>

4. web.xml檔案

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns="http://java.sun.com/xml/ns/javaee"
	xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
	id="WebApp_ID" version="2.5">
	<display-name>cbar</display-name>
	<context-param>
		<param-name>contextConfigLocation</param-name>
		<param-value>
			classpath:spring-config.xml
		</param-value>
	</context-param>
	<listener>
		<listener-class>
			org.springframework.web.context.ContextLoaderListener
		</listener-class>
	</listener>
	<filter>
		<filter-name>Encoding</filter-name>
		<filter-class>
			org.springframework.web.filter.CharacterEncodingFilter
		</filter-class>
		<init-param>
			<param-name>encoding</param-name>
			<param-value>utf8</param-value>
		</init-param>
	</filter>
	<filter-mapping>
		<filter-name>Encoding</filter-name>
		<url-pattern>/*</url-pattern>
	</filter-mapping>
	<servlet>
		<servlet-name>spring</servlet-name>
		<servlet-class>org.springframework.web.servlet.DispatcherServlet
		</servlet-class>
		<init-param>
			<param-name>contextConfigLocation</param-name>
			<param-value>classpath:spring-servlet.xml</param-value>
		</init-param>
		<load-on-startup>1</load-on-startup>
	</servlet>
	<servlet-mapping>
		<servlet-name>spring</servlet-name>
		<url-pattern>*.do</url-pattern>
	</servlet-mapping>
	<error-page>
		<exception-type>java.lang.Exception</exception-type>
		<location>/error.jsp</location>
	</error-page>
	<welcome-file-list>
		<welcome-file>report/report.jsp</welcome-file>
	</welcome-file-list>
</web-app>

5. PageUtil類

package com.asia.util.mybatispage;

import java.util.List;

import com.fasterxml.jackson.annotation.JsonIgnore;


public class PageUtil {
	
	private int rows;
	
	private int total;
	
	private int page;
    
	private String orderStr;
	
	private String sort;
	
	private String order;
	
	private Object queryObj;
	
	private List<?> data;
	
	@JsonIgnore
	public String getOrderStr() {
		orderStr = "";
		if (!org.springframework.util.StringUtils.isEmpty(order)) {
			String[] orders = order.split(",");
			String[] sorts = sort.split(",");
			for (int i = 0; i < sorts.length; i++) {
				orderStr += sorts[i] + " " + orders[i] + ", ";
			}
			orderStr = orderStr.endsWith(", ") ? orderStr.substring(0, orderStr.length() - 2) : orderStr;
		}
		return orderStr;
	}
	
	@JsonIgnore
	public int getPageSize() {
		return rows;
	}
	
	public List<?> getRows(){
		return data;
	}
	
	public void setRows(int rows) {
		this.rows = rows;
	}

	public int getTotal() {
		return total;
	}

	public void setTotal(int total) {
		this.total = total;
	}

	@JsonIgnore
	public int getPage() {
		return page;
	}

	public void setPage(int page) {
		this.page = page;
	}

	@JsonIgnore
	public String getSort() {
		return sort;
	}

	public void setSort(String sort) {
		this.sort = sort;
	}

	@JsonIgnore
	public String getOrder() {
		return order;
	}

	public void setOrder(String order) {
		this.order = order;
	}

	@JsonIgnore
	public Object getQueryObj() {
		return queryObj;
	}

	public void setQueryObj(Object queryObj) {
		this.queryObj = queryObj;
	}

	public void setOrderStr(String orderStr) {
		this.orderStr = orderStr;
	}

	public void setData(List<?> data) {
		this.data = data;
	}

	@Override
	public String toString() {
		return "PageUtil [rows=" + rows + ", total=" + total + ", page=" + page
				+ ", orderStr=" + orderStr + ", sort=" + sort + ", order="
				+ order + ", queryObj=" + queryObj + ", data=" + data + "]";
	}

}

6. Mybatis過濾器PageInterceptor類

package com.asia.util.mybatispage;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;
import java.util.Properties;

import org.apache.ibatis.executor.parameter.ParameterHandler;
import org.apache.ibatis.executor.statement.RoutingStatementHandler;
import org.apache.ibatis.executor.statement.StatementHandler;
import org.apache.ibatis.mapping.BoundSql;
import org.apache.ibatis.mapping.MappedStatement;
import org.apache.ibatis.mapping.ParameterMapping;
import org.apache.ibatis.plugin.Interceptor;
import org.apache.ibatis.plugin.Intercepts;
import org.apache.ibatis.plugin.Invocation;
import org.apache.ibatis.plugin.Plugin;
import org.apache.ibatis.plugin.Signature;
import org.apache.ibatis.scripting.defaults.DefaultParameterHandler;

import com.asia.util.ReflectUtil;


/**
 * 分頁攔截器
 * 
 * @author SCY
 *
 * @CreateTime 2016年2月19日下午2:21:26
 *
 * @Vsersion 1.0
 */
@Intercepts({@Signature(method = "prepare", type = StatementHandler.class, args = {Connection.class})} )  
public class PageInterceptor implements Interceptor {

	private String databaseType;
	
	@Override
	public Object intercept(Invocation invocation) throws Throwable {
		final RoutingStatementHandler handler = (RoutingStatementHandler) invocation.getTarget();
		final StatementHandler delegate = (StatementHandler) ReflectUtil.getFieldValue(handler, "delegate");
		final BoundSql boundSql = delegate.getBoundSql();
        final Object obj = boundSql.getParameterObject();

        //如果參數類型為自定義的PageUtil類型則執行分頁處理
        if (obj instanceof PageUtil) {
            final PageUtil page = (PageUtil) obj;
            MappedStatement mappedStatement = (MappedStatement) ReflectUtil.getFieldValue(delegate, "mappedStatement");
            Connection connection = (Connection) invocation.getArgs()[0];
            final String sql = boundSql.getSql();//擷取原sql
            final String pageSql = this.getPageSql(page, sql);//轉換為分頁SQL
            System.out.println(pageSql);
            //擷取總記錄數
            int rowCount = getRowCount(page, mappedStatement, connection);
            System.out.println("rowCount:"+rowCount);
            page.setTotal(rowCount);
            ReflectUtil.setFieldValue(boundSql, "sql", pageSql);
        }
        return invocation.proceed();
	}

	private String getCountSql(String sql) {
		return "select count(*) from (" + sql+") a";
	}
	
	/**
	 * 生成分頁資料sql
	 * @param page
	 * @param sql
	 * @return
	 */
	private String getPageSql(PageUtil page, String sql) {
        final StringBuffer sqlBuffer = new StringBuffer(sql);
        if ("mysql".equalsIgnoreCase(databaseType)) {
            return getMysqlPageSql(page, sqlBuffer);
        } else if ("oracle".equalsIgnoreCase(databaseType)) {
            return getOraclePageSql(page, sqlBuffer);
        }
        return sqlBuffer.toString();
    }
	
	/**
	 * 生産mysql資料分頁sql
	 * @param page
	 * @param sqlBuffer
	 * @return
	 */
	private String getMysqlPageSql(PageUtil page, StringBuffer sqlBuffer) {
		int offset = (page.getPage() - 1) * page.getPageSize() ;
        sqlBuffer.append(" limit ").append(offset).append(",").append(page.getPageSize());
        return sqlBuffer.toString();
    }
	

    /**
     * 擷取Oracle資料庫的分頁查詢語句
     */
    private String getOraclePageSql(PageUtil page, StringBuffer sqlBuffer) {
    	System.out.println(page);
        int offset = (page.getPage() - 1) * page.getPageSize() + 1;
        System.out.println(offset);
        sqlBuffer.insert(0, "select u.*, rownum r from (").append(") u where rownum < ")
                .append(offset + page.getPageSize());
        sqlBuffer.insert(0, "select * from (").append(") where r >= ").append(offset);
        return sqlBuffer.toString();
    }
    
	/**
	 * 擷取總資料量
	 * @param page
	 * @param mappedStatement
	 * @param connection
	 * @return
	 * @throws SQLException
	 */
	private int getRowCount(PageUtil page, MappedStatement mappedStatement, Connection connection) throws SQLException {
		int totalRecord = 0;
		BoundSql boundSql = mappedStatement.getBoundSql(page);
		String sql = boundSql.getSql();
		String countSql = this.getCountSql(sql);
		List<ParameterMapping> parameterMappings = boundSql.getParameterMappings();
		BoundSql countBoundSql = new BoundSql(mappedStatement.getConfiguration(), countSql, parameterMappings, page);
		ParameterHandler parameterHandler = new DefaultParameterHandler(mappedStatement, page, countBoundSql);
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		try {
		   pstmt = connection.prepareStatement(countSql);
		   parameterHandler.setParameters(pstmt);
		   rs = pstmt.executeQuery();
		   if (rs.next()) {
			   totalRecord = rs.getInt(1);
		   }
		}  finally {
		   try {
		      if (rs != null)
		          rs.close();
		       
		   } finally{
			   if (pstmt != null)
		        pstmt.close();
		   }
		}
		return totalRecord;
    }
	
    
    @Override
	public Object plugin(Object target) {
		return Plugin.wrap(target, this);
	}
    
    
	@Override
	public void setProperties(Properties properties) {
		this.databaseType = properties.getProperty("databaseType");
	}
}

以下相關内容為樣例程式代碼，已簡單的使用者資訊管理為例

7. UserInfo類

package com.asia.demo.bean;

public class UserInfo {

	private int id;
	private String uname;
	private String birthday;
	private String sex;
	private String address;
	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}

	public String getUname() {
		return uname;
	}

	public void setUname(String uname) {
		this.uname = uname;
	}

	public String getBirthday() {
		return birthday;
	}

	public void setBirthday(String birthday) {
		this.birthday = birthday;
	}

	public String getSex() {
		return sex;
	}

	public void setSex(String sex) {
		this.sex = sex;
	}

	public String getAddress() {
		return address;
	}

	public void setAddress(String address) {
		this.address = address;
	}

	@Override
	public String toString() {
		return "UserInfo [id=" + id + ", uname=" + uname + ", birthday="
				+ birthday + ", sex=" + sex + ", address=" + address + "]";
	}

}

8. UserController類

package com.asia.demo.controller;

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

import javax.annotation.Resource;

import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.ResponseBody;

import com.asia.demo.bean.UserInfo;
import com.asia.demo.service.IUserService;
import com.asia.util.mybatispage.PageUtil;

@Controller
@RequestMapping("/user")
public class UserController {
	@Resource
	private IUserService userService;

	@RequestMapping(value="/searchUser")
	public @ResponseBody PageUtil search(UserInfo uesrInfo, PageUtil pu) {
		pu.setQueryObj(uesrInfo);//設定查詢條件
		List<UserInfo> data= userService.searchUser(pu);
		pu.setData(data);//設定回報結果
		return pu;
	}
	
	public IUserService getUserService() {
		return userService;
	}

	public void setUserService(IUserService userService) {
		this.userService = userService;
	}

}

9. UserInfoMapper類

package com.asia.demo.mapper;

import java.util.List;

import org.springframework.stereotype.Repository;

import com.asia.demo.bean.UserInfo;
import com.asia.util.mybatispage.PageUtil;

@Repository("userInfoMapper")
public interface UserInfoMapper {
	
	public List<UserInfo> queryUser();
	
	public List<UserInfo> searchUser(PageUtil spu);
}

10. Mybatis配置檔案UserMapper.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">
<mapper namespace="com.asia.demo.mapper.UserInfoMapper">
	<!-- 查詢所有記錄 -->
	<select id="queryUser" resultType="com.asia.demo.bean.UserInfo">
		select id, uname, birthday, sex, address from userinfo
	</select>
	<select id="searchUser" resultType="com.asia.demo.bean.UserInfo" parameterType="com.asia.util.mybatispage.PageUtil">
		select id, uname, birthday, sex, address from userinfo 
		<where>
			<if test="queryObj.uname != null">
				AND uname = #{queryObj.uname}
			</if>
			<if test="queryObj.sex != null ">
	           AND sex = #{queryObj.sex}
	        </if>
		</where>
	</select>
</mapper>

11. UserServiceImpl類，接口代碼省略

package com.asia.demo.service.impl;

import java.util.List;

import javax.annotation.Resource;

import org.springframework.stereotype.Service;

import com.asia.demo.bean.UserInfo;
import com.asia.demo.mapper.UserInfoMapper;
import com.asia.demo.service.IUserService;
import com.asia.util.mybatispage.PageUtil;

@Service("userServiceImpl")
public class UserServiceImpl implements IUserService {

	@Resource
	private UserInfoMapper userInfoMapper;
	
	@Override
	public List<UserInfo> queryUser() {
		return userInfoMapper.queryUser();
	}

	@Override
	public List<UserInfo> searchUser(PageUtil spu) {
		return userInfoMapper.searchUser(spu);
	}

	public UserInfoMapper getUserInfoMapper() {
		return userInfoMapper;
	}

	public void setUserInfoMapper(UserInfoMapper userInfoMapper) {
		this.userInfoMapper = userInfoMapper;
	}

}

12. UserList.jsp

<%@ page contentType="text/html; charset=UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
	<title>查詢</title>
	<meta http-equiv="pragma" content="no-cache" />
	<meta http-equiv="cache-control" content="no-cache" />
	<meta http-equiv="expires" content="0" />
	<link type="text/css" href="<%=path %>/common/jquery/easyui/css/default/easyui.css" target="_blank" rel="external nofollow"   rel="stylesheet" charset='UTF-8'>
	<link type="text/css" href="<%=path %>/common/jquery/easyui/css/icon.css" target="_blank" rel="external nofollow"  rel="stylesheet" charset='UTF-8'>
	<script type="text/javascript">
	var basePath="<%=path %>";
	</script>
	<script language="javascript" src="<%=path %>/common/jquery/core/jquery-1.11.1.js"></script>
	<script language="javascript" src="<%=path %>/common/jquery/easyui/js/jquery.easyui.min.js"></script>
	<script language="javascript" src="<%=path %>/demo/js/UserList.js"></script>
</head>
<body class="body">
<table width="98%">
    <tr>
        <td>
            <table id="userInfo" title="">
		    </table>  
        </td>
    </tr>
</table>

</body>
</html>

13. UserList.js

/**
 * 設定列
 * 
 * @return
 */
function getColumns() {
	return [[
             {field:'id', title:"編号", checkbox:true},
		   	 {field:'user', title:"使用者名", halign:'center', align:'center',sortable:true, width:278},
		   	 {field:'birthday', title:"出生日期", halign:'center', align:'center', sortable:true, width:150},
		   	 {field:'sex', title:"性别", halign:'center', align:'center',sortable:true, width:80},
		   	/* {field:'address', title:"狀态", halign:'center', align:'center',sortable:true, width:80,
		   		formatter: function(value,row,index){
					return taskState.get(value);
				}
		   	 },*/
		   	 {field:'address', title:"位址", halign:'center', align:'center',sortable:true, width:180}
		   	 ]];
}


/**
 * 初始化頁面
 */
jQuery(function() {
	var gridParam = {
			rownumbers:true,
			loadMsg : "資料加載中",
			pagination : true,
			multiSort : true,
		    pageSize :  10,
			pageList : [  10, 20, 30, 50, 100 ],
			striped : true,
			columns : getColumns(),
			//queryParams : queryParams,
			url:basePath+"/user/searchUser.do",
			collapsible : true,
			singleSelect : true,
			idField : "id" // 支援跨頁選擇
		};
		
		$('#userInfo').datagrid(gridParam);
		$('#userInfo').datagrid("getPager").pagination( {
			pageSize : 10,
			displayMsg : '目前資料範圍 {from} 到 {to} ，共 {total} 條記錄',
			beforePageText : '目前',
			afterPageText : '  ,共 {pages}頁'
		});
});

springmvc+mybatis+easyui分頁

補充ReflectUtil

package com.asia.util;

import java.lang.reflect.Field;


/**
 * 反射工具類
 * @author SCY
 *
 * @createDate 2013-12-19上午09:29:45
 * 
 * @version 1.0
 */
public class ReflectUtil {
	
	private ReflectUtil(){
		
	}
	
	
	/**
	 * 反射擷取對象String類型屬性值
	 * @param obj
	 * @param paramName
	 * @return String 對象屬性值
	 * @throws Exception
	 */
	public static String getObjValue(Object obj, String paramName)
			throws Exception{
		
		String getMethodName = "get"
				+ Character.toUpperCase(paramName.charAt(0))
				+ paramName.substring(1);
		return (String) obj.getClass().getMethod(getMethodName).invoke(obj);
	}

	/**
	 * 為對象某String類型屬性設定指定值
	 * @param obj 待指派對象
	 * @param paramName  屬性名稱
	 * @param paramValue 屬性值
	 * @throws Exception
	 */
	public static void setObjValue(Object obj, String paramName,
			String paramValue) throws Exception {
		
		String getMethodName = "set"
				+ Character.toUpperCase(paramName.charAt(0))
				+ paramName.substring(1);
		obj.getClass().getMethod(getMethodName, String.class).invoke(obj,
				paramValue);
	}
	
	 /**
     * 利用反射擷取指定對象的指定屬性
	 * @throws IllegalAccessException 
	 * @throws IllegalArgumentException 
     */
    public static Object getFieldValue(Object obj, String fieldName) throws IllegalArgumentException, IllegalAccessException {
        Object result = null;
        final Field field = ReflectUtil.getField(obj, fieldName);
        if (field != null) {
			field.setAccessible(true);
			result = field.get(obj);
        }
        return result;
    }

    /**
     * 利用反射擷取指定對象裡面的指定屬性
     */
    private static Field getField(Object obj, String fieldName) {
        Field field = null;
        for (Class<?> clazz = obj.getClass(); clazz != Object.class; clazz = clazz.getSuperclass()) {
            try {
                field = clazz.getDeclaredField(fieldName);
                break;
            } catch (NoSuchFieldException e) {
                // 這裡不用做處理，子類沒有該字段可能對應的父類有，都沒有就傳回null。
            }
        }
        return field;
    }

    /**
     * 利用反射設定指定對象的指定屬性為指定的值
     * @throws IllegalAccessException 
     * @throws IllegalArgumentException 
     */
    public static void setFieldValue(Object obj, String fieldName, String fieldValue) throws IllegalArgumentException, IllegalAccessException {
        final Field field = ReflectUtil.getField(obj, fieldName);
        if (field != null) {
        	field.setAccessible(true);
            field.set(obj, fieldValue);
        }
    }
}

demo下載下傳位址

http://download.csdn.net/download/suijiarui/9515485

歡迎大家拍磚

springmvc+mybatis+easyui分頁

繼續閱讀

Java String.format方法的簡單使用

neo4j之cypher使用文檔

GitHub連夜封殺！這份阿裡 10W 字内部 Java 字面試手冊到底有多強？

用mybatis的generator插件在項目中自動生成dao及entity

spark/scala關于【資源檔案】加載方法概述外部檔案加載方案測試資源檔案打包入jar包中小結

mybatis_入門程式Mybatis入門

AOP程式設計_Android優雅權限架構(1)概念基礎，2021金三銀四前言正文大綱正文

SpringMVC傳回用戶端Json/XML資料

Ajax發送和擷取json資料到Spring mvc 1.spring mvc後端2.web前段

Effective Java 8:通用程式設計

OOM三種類型

工廠模式-三種類型

【遞歸】高效率求2的n次幂

從mybatis到mybatis plus(mp)

win10本地scala和spark安裝安裝scala安裝spark

scala (3) Function 和 Method