逆向工程文件example完美结合使用PageHelper分页插件

原生的mybatis需要手写sql语句，项目数据库表多了之后，可以让你写sql语句写到手软，于是mybatis官方提供了mybatis-generator：mybatis逆向工程代码生成工具，用于简化mybatis单表操作。

在PageHelper3.几的版本的时候，使用它对逆向工程生成的查询方法进行分页时出现失效的情况，而PageHelper4开始，亲测能够与mybatis逆向工程生成的方法完美兼容，今天就和大家分享spring+mybatis+PageHelper的一个整合小案例

第一步：创建maven工程，编写pom.xml

[html]  view plain  copy

1. <!-- 集中定义依赖版本号 -->  
2.  <!-- 已经依据maven仓库给出的版本兼容信息，调节好合适的spring、mybatis-spring、mybatis、pagehelper版本号 -->  
3. <properties>  
4.     <junit.version>4.12</junit.version>  
5.     <spring.version>4.3.10.RELEASE</spring.version>  
6.       
7.     <mybatis.version>3.4.1</mybatis.version>  
8.       
9.     <mybatis.spring.version>1.3.0</mybatis.spring.version>  
10.     <mysql.version>5.1.32</mysql.version>  
11.     <slf4j.version>1.6.4</slf4j.version>  
12.       
13.     <jackson.version>2.8.8</jackson.version>  
14.       
15.     <druid.version>1.0.9</druid.version>  
16.     <httpclient.version>4.3.5</httpclient.version>  
17.     <jstl.version>1.2</jstl.version>  
18.     <servlet-api.version>2.5</servlet-api.version>  
19.     <jsp-api.version>2.0</jsp-api.version>  
20.     <joda-time.version>2.5</joda-time.version>  
21.     <commons-lang3.version>3.3.2</commons-lang3.version>  
22.     <commons-io.version>1.3.2</commons-io.version>  
23.     <commons-net.version>3.3</commons-net.version>  
24.     <!-- 4.1.6 -->  
25.     <pagehelper.version>4.1.0</pagehelper.version>  
26.       
27.     <jsqlparser.version>0.9.1</jsqlparser.version>  
28.     <commons-fileupload.version>1.3.1</commons-fileupload.version>  
29.     <jedis.version>2.7.2</jedis.version>  
30.     <solrj.version>4.10.3</solrj.version>  
31.     <dubbo.version>2.5.3</dubbo.version>  
32.     <zookeeper.version>3.4.7</zookeeper.version>  
33.     <zkclient.version>0.1</zkclient.version>  
34.     <activemq.version>5.11.2</activemq.version>  
35.     <freemarker.version>2.3.23</freemarker.version>  
36.     <quartz.version>2.2.2</quartz.version>  
37. </properties>  
38.   
39. <dependencies>  
40.     <!-- 时间操作组件 -->  
41.     <dependency>  
42.         <groupId>joda-time</groupId>  
43.         <artifactId>joda-time</artifactId>  
44.         <version>${joda-time.version}</version>  
45.     </dependency>  
46.     <!-- Apache工具组件 -->  
47.     <dependency>  
48.         <groupId>org.apache.commons</groupId>  
49.         <artifactId>commons-lang3</artifactId>  
50.         <version>${commons-lang3.version}</version>  
51.     </dependency>  
52.     <dependency>  
53.         <groupId>org.apache.commons</groupId>  
54.         <artifactId>commons-io</artifactId>  
55.         <version>${commons-io.version}</version>  
56.     </dependency>  
57.     <dependency>  
58.         <groupId>commons-net</groupId>  
59.         <artifactId>commons-net</artifactId>  
60.         <version>${commons-net.version}</version>  
61.     </dependency>  
62.     <!-- Jackson Json处理工具包 -->  
63.     <dependency>  
64.         <groupId>com.fasterxml.jackson.core</groupId>  
65.         <artifactId>jackson-databind</artifactId>  
66.         <version>${jackson.version}</version>  
67.     </dependency>  
68.     <!-- httpclient -->  
69.     <dependency>  
70.         <groupId>org.apache.httpcomponents</groupId>  
71.         <artifactId>httpclient</artifactId>  
72.         <version>${httpclient.version}</version>  
73.     </dependency>  
74.     <!-- quartz任务调度框架 -->  
75.     <dependency>  
76.         <groupId>org.quartz-scheduler</groupId>  
77.         <artifactId>quartz</artifactId>  
78.         <version>${quartz.version}</version>  
79.     </dependency>  
80.     <!-- 单元测试 -->  
81.     <dependency>  
82.         <groupId>junit</groupId>  
83.         <artifactId>junit</artifactId>  
84.         <version>${junit.version}</version>  
85.         <scope>test</scope>  
86.     </dependency>  
87.       
88.     <!-- Mybatis -->  
89.     <dependency>  
90.         <groupId>org.mybatis</groupId>  
91.         <artifactId>mybatis</artifactId>  
92.         <version>${mybatis.version}</version>  
93.     </dependency>  
94.     <dependency>  
95.         <groupId>org.mybatis</groupId>  
96.         <artifactId>mybatis-spring</artifactId>  
97.         <version>${mybatis.spring.version}</version>  
98.     </dependency>  
99.       
100.     <dependency>  
101.         <groupId>com.github.pagehelper</groupId>  
102.         <artifactId>pagehelper</artifactId>  
103.         <version>${pagehelper.version}</version>  
104.     </dependency>  
105.     <!-- MySql -->  
106.     <dependency>  
107.         <groupId>mysql</groupId>  
108.         <artifactId>mysql-connector-java</artifactId>  
109.         <version>${mysql.version}</version>  
110.     </dependency>  
111.     <!-- 连接池 -->  
112.     <dependency>  
113.         <groupId>com.alibaba</groupId>  
114.         <artifactId>druid</artifactId>  
115.         <version>${druid.version}</version>  
116.     </dependency>  
117.     <!-- Spring -->  
118.     <dependency>  
119.         <groupId>org.springframework</groupId>  
120.         <artifactId>spring-context</artifactId>  
121.         <version>${spring.version}</version>  
122.     </dependency>  
123.     <dependency>  
124.         <groupId>org.springframework</groupId>  
125.         <artifactId>spring-beans</artifactId>  
126.         <version>${spring.version}</version>  
127.     </dependency>  
128.     <dependency>  
129.         <groupId>org.springframework</groupId>  
130.         <artifactId>spring-webmvc</artifactId>  
131.         <version>${spring.version}</version>  
132.     </dependency>  
133.     <dependency>  
134.         <groupId>org.springframework</groupId>  
135.         <artifactId>spring-jdbc</artifactId>  
136.         <version>${spring.version}</version>  
137.     </dependency>  
138.     <dependency>  
139.         <groupId>org.springframework</groupId>  
140.         <artifactId>spring-aspects</artifactId>  
141.         <version>${spring.version}</version>  
142.     </dependency>  
143.     <dependency>  
144.         <groupId>org.springframework</groupId>  
145.         <artifactId>spring-jms</artifactId>  
146.         <version>${spring.version}</version>  
147.     </dependency>  
148.     <dependency>  
149.         <groupId>org.springframework</groupId>  
150.         <artifactId>spring-context-support</artifactId>  
151.         <version>${spring.version}</version>  
152.     </dependency>  
153.     <!-- 整合测试包 -->  
154.     <dependency>    
155.            <groupId>org.springframework</groupId>    
156.            <artifactId>spring-test</artifactId>    
157.            <version>${spring.version}</version>    
158.            <scope>provided</scope>    
159.     </dependency>  
160.       
161.     <!-- log4j2 -->  
162.     <dependency>  
163.            <groupId>org.apache.logging.log4j</groupId>  
164.            <artifactId>log4j-api</artifactId>  
165.            <version>2.7</version>  
166.        </dependency>  
167.        <dependency>  
168.            <groupId>org.apache.logging.log4j</groupId>  
169.            <artifactId>log4j-core</artifactId>  
170.            <version>2.7</version>  
171.        </dependency>  
172.     <dependency>  
173.             <groupId>org.apache.logging.log4j</groupId>  
174.             <artifactId>log4j-web</artifactId>  
175.             <version>2.7</version>  
176.        </dependency>  
177.     <!-- JSP相关 -->  
178.     <dependency>  
179.         <groupId>jstl</groupId>  
180.         <artifactId>jstl</artifactId>  
181.         <version>${jstl.version}</version>  
182.     </dependency>  
183.     <dependency>  
184.         <groupId>javax.servlet</groupId>  
185.         <artifactId>servlet-api</artifactId>  
186.         <version>${servlet-api.version}</version>  
187.         <scope>provided</scope>  
188.     </dependency>  
189.     <dependency>  
190.         <groupId>javax.servlet</groupId>  
191.         <artifactId>jsp-api</artifactId>  
192.         <version>${jsp-api.version}</version>  
193.         <scope>provided</scope>  
194.     </dependency>  
195.     <!-- 文件上传组件 -->  
196.     <dependency>  
197.         <groupId>commons-fileupload</groupId>  
198.         <artifactId>commons-fileupload</artifactId>  
199.         <version>${commons-fileupload.version}</version>  
200.     </dependency>  
201.     <!-- Redis客户端 -->  
202.     <dependency>  
203.         <groupId>redis.clients</groupId>  
204.         <artifactId>jedis</artifactId>  
205.         <version>${jedis.version}</version>  
206.     </dependency>  
207.     <!-- solr客户端 -->  
208.     <dependency>  
209.         <groupId>org.apache.solr</groupId>  
210.         <artifactId>solr-solrj</artifactId>  
211.         <version>${solrj.version}</version>  
212.     </dependency>  
213.     <!-- dubbo相关 -->  
214.     <dependency>  
215.         <groupId>com.alibaba</groupId>  
216.         <artifactId>dubbo</artifactId>  
217.         <version>${dubbo.version}</version>  
218.     </dependency>  
219.     <dependency>  
220.         <groupId>org.apache.zookeeper</groupId>  
221.         <artifactId>zookeeper</artifactId>  
222.         <version>${zookeeper.version}</version>  
223.     </dependency>  
224.     <dependency>  
225.         <groupId>com.github.sgroschupf</groupId>  
226.         <artifactId>zkclient</artifactId>  
227.         <version>${zkclient.version}</version>  
228.     </dependency>  
229.     <dependency>  
230.         <groupId>org.apache.activemq</groupId>  
231.         <artifactId>activemq-all</artifactId>  
232.         <version>${activemq.version}</version>  
233.     </dependency>  
234.     <dependency>  
235.         <groupId>org.freemarker</groupId>  
236.         <artifactId>freemarker</artifactId>  
237.         <version>${freemarker.version}</version>  
238.     </dependency>  
239. </dependencies>  
240.       
241.     <build>  
242.         <plugins>  
243.         <!-- 资源文件拷贝插件 -->  
244.         <plugin>  
245.             <groupId>org.apache.maven.plugins</groupId>  
246.             <artifactId>maven-resources-plugin</artifactId>  
247.             <version>2.7</version>  
248.             <configuration>  
249.                 <encoding>UTF-8</encoding>  
250.             </configuration>  
251.         </plugin>  
252.         <!-- java编译插件 -->  
253.         <plugin>  
254.             <groupId>org.apache.maven.plugins</groupId>  
255.             <artifactId>maven-compiler-plugin</artifactId>  
256.             <version>3.2</version>  
257.             <configuration>  
258.                 <source>1.7</source>  
259.                 <target>1.7</target>  
260.                 <encoding>UTF-8</encoding>  
261.             </configuration>  
262.         </plugin>  
263.         <!-- 配置Tomcat插件 -->  
264.         <plugin>  
265.             <groupId>org.apache.tomcat.maven</groupId>  
266.             <artifactId>tomcat7-maven-plugin</artifactId>  
267.             <configuration>  
268.                 <port>8080</port>  
269.                 <path>/</path>  
270.             </configuration>  
271.         </plugin>  
272.     </plugins>  
273.     </build>  

第二步：使用mybatis逆向工程工具生成代码:

mybatis-generator 下载地址： 逆向工程工具

该工具并不是我分享的，我也没用过，如果是不能用的，希望能够在评论区告诉我

第三步：将mybatis逆向工程生成的代码复制到我们的项目下

第四步：配置文件相关：

4.1 配置log4j2.xml文件

[html]  view plain  copy

1. <?xml version="1.0" encoding="UTF-8"?>    
2.   <Configuration status="OFF" monitorInterval="1800">  
3.       
4.       <properties>    
5.           <property name="LOG_HOME">D:/log4j2/mybatis/genertor/logs/</property>  
6.           <property name="ERROR_LOG_FILE_NAME">error</property>  
7.       </properties>    
8.       
9.       
10.       <Appenders>    
11.         <!-- 控制台打印日志 -->  
12.           <Console name="Console" target="SYSTEM_OUT">    
13.               <PatternLayout pattern="%d %-5p (%F:%L) - %m%n" />    
14.           </Console>    
15.         <!-- 日志信息输出到文件配置 -->  
16.           <RollingRandomAccessFile name="ErrorLog"    
17.                                    fileName="${LOG_HOME}/${ERROR_LOG_FILE_NAME}.log"    
18.                                    filePattern="${LOG_HOME}/${ERROR_LOG_FILE_NAME}.log.%d{yyyy-MM-dd}.gz">    
19.               <PatternLayout    
20.                       pattern="%d %-5p (%F:%L) - %m%n"/>    
21.               <Policies>    
22.                   <!-- TimeBasedTriggeringPolicy指定的size是1，结合起来就是1天生成一个新文件。如果filePattern改成%d{yyyy-MM-dd HH}.gz,此时最小粒度为小时，则每一个小时生成一个文件。 -->  
23.                   <TimeBasedTriggeringPolicy/>    
24.                   <!--  指定当文件体积大于size指定的值时，触发Rolling -->  
25.                   <SizeBasedTriggeringPolicy size="100 MB"/>    
26.               </Policies>  
27.               <!-- 指定最多保存的文件个数 -->    
28.               <DefaultRolloverStrategy max="20"/>    
29.           </RollingRandomAccessFile>    
30.           <param name="Encoding" value="UTF-8" />  
31.       </Appenders>    
32.       
33.       <Loggers>    
34.           <!-- 3rdparty Loggers -->    
35.           <logger name="org.springframework.core" level="info">    
36.           </logger>    
37.           <logger name="org.springframework.beans" level="info">    
38.           </logger>    
39.           <logger name="org.springframework.context" level="info">    
40.           </logger>    
41.           <logger name="org.springframework.web" level="info">    
42.           </logger>    
43.           <logger name="org.springframework.test.context.junit4.SpringJUnit4ClassRunner" level="info">    
44.           </logger>    
45.           <logger name="com.lmsq.shaxuntech" level="debug" includeLocation="true" additivity="false">  
46.               <appender-ref ref="ErrorLog"/>    
47.               <appender-ref ref="Console"/>    
48.           </logger>    
49.       
50.           <root level="info" includeLocation="true">  
51.               <appender-ref ref="ErrorLog"/>  
52.               <appender-ref ref="Console"/>    
53.           </root>    
54.       </Loggers>    
55.       <!--然后定义logger，只有定义了logger并引入的appender，appender才会生效-->  
56.   </Configuration>   

4.2配置spring相关配置文件

applicationContext-dao.xml

[html]  view plain  copy

1. <!-- 加载配置文件 -->  
2.     <context:property-placeholder location="classpath:conf/db.properties" file-encoding="utf-8" />  
3.     <!-- 数据库连接池 -->  
4.     <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"  
5.         destroy-method="close">  
6.         <property name="url" value="${jdbc.url}" />  
7.         <property name="username" value="${jdbc.username}" />  
8.         <property name="password" value="${jdbc.password}" />  
9.         <property name="driverClassName" value="${jdbc.driver}" />  
10.         <property name="maxActive" value="10" />  
11.         <property name="minIdle" value="5" />  
12.     </bean>  
13.     <!-- 让spring管理sqlsessionfactory 使用mybatis和spring整合包中的 -->  
14.     <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">  
15.         <!-- 数据库连接池 -->  
16.         <property name="dataSource" ref="dataSource" />  
17.         <!-- 加载mybatis的全局配置文件 -->  
18.         <property name="configLocation" value="classpath:mybatis/SqlMapConfig.xml" />  
19.         <!-- 配置Mapper配置文件所在路径 -->  
20.         <property name="mapperLocations" value="classpath:mybatis/mapper/*.xml"/>  
21.     </bean>  
22.     <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">  
23.         <property name="basePackage" value="com.stu.dao" />  
24.     </bean>  

application-service.xml

[html]  view plain  copy

1. <!-- 配置包扫描器 -->  
2.     <context:component-scan base-package="com.stu.service"/>  

springmvc.xml

[html]  view plain  copy

1. <!-- 加载配置文件 -->  
2.     <context:property-placeholder location="classpath:conf/*.properties" file-encoding="utf-8" />  
3.       
4.     <context:component-scan base-package="com.stu.api.controller" />  
5.     <mvc:annotation-driven />  
6.       
7.     <!-- 配置资源映射 -->  
8.     <mvc:resources location="/css/" mapping="/css/**"/>  
9.     <mvc:resources location="/js/" mapping="/js/**"/>  
10.       
11.     <!-- 配置多媒体解析器 -->  
12.     <!-- 定义文件上传解析器 -->  
13.     <bean id="multipartResolver"  
14.         class="org.springframework.web.multipart.commons.CommonsMultipartResolver">  
15.         <!-- 设定默认编码 -->  
16.         <property name="defaultEncoding" value="UTF-8"></property>  
17.         <!-- 设定文件上传的最大值5MB，5*1024*1024 -->  
18.         <property name="maxUploadSize" value="5242880"></property>  
19.     </bean>  
20.       
21.     <!-- 添加跨域请求支持 -->  
22.     <!--   
23.     <mvc:cors>  
24.         <mvc:mapping path="/**" allowed-origins="*" allow-credentials="true" max-age="1800" allowed-methods="GET,POST,PUT,DELETE,PATCH,OPTIONS"/>  
25.     </mvc:cors>   
26.     -->  

注意：这里为了方便阅读及后期扩展，将配置文件进行了分模块拆分，另外，正式的项目应该要加上事务的相关配置，这里不做演示

4.3mybatis相关配置

SqlMapConfig.xml

[html]  view plain  copy

1. <?xml version="1.0" encoding="UTF-8" ?>  
2. <!DOCTYPE configuration  
3.         PUBLIC "-//mybatis.org//DTD Config 3.0//EN"  
4.         "http://mybatis.org/dtd/mybatis-3-config.dtd">  
5. <configuration>  
6.     <typeAliases>  
7.         <package name="com.stu.pojo" />  
8.     </typeAliases>  
9.     <plugins>  
10.         <plugin interceptor="com.github.pagehelper.PageHelper">  
11.             <!-- 设置数据库类型 Oracle,Mysql,MariaDB,SQLite,Hsqldb,PostgreSQL六种数据库-->          
12.             <property name="dialect" value="mysql"/>  
13.         </plugin>  
14.     </plugins>  
15.   
16. </configuration>  

4.4 数据库链接的properties文件

 db.properties

[plain]  view plain  copy

1. jdbc.driver=com.mysql.jdbc.Driver  
2. jdbc.url=jdbc:mysql://localhost:3306/stu?characterEncoding=utf-8  
3. jdbc.username=root  
4. jdbc.password=root  

4.5web.xml的配置

[html]  view plain  copy

1. <?xml version="1.0" encoding="UTF-8"?>  
2. <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" version="2.5">  
3.   <display-name>Mybatis-generator</display-name>  
4.   <welcome-file-list>  
5.     <welcome-file>index.html</welcome-file>  
6.     <welcome-file>index.htm</welcome-file>  
7.     <welcome-file>index.jsp</welcome-file>  
8.     <welcome-file>default.html</welcome-file>  
9.     <welcome-file>default.htm</welcome-file>  
10.     <welcome-file>default.jsp</welcome-file>  
11.   </welcome-file-list>  
12.       
13.     <!-- 解决post乱码 -->  
14.   <filter>  
15.       <filter-name>characterEncoding</filter-name>  
16.       <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>  
17.   <init-param>  
18.       <param-name>encoding</param-name>  
19.       <param-value>UTF-8</param-value>  
20.   </init-param>  
21.   </filter>  
22.     
23.   <filter-mapping>  
24.       <filter-name>characterEncoding</filter-name>  
25.       <url-pattern>/*</url-pattern>  
26.   </filter-mapping>  
27.     
28.    <!-- log4j2-begin -->  
29.      <listener>  
30.         <listener-class>org.apache.logging.log4j.web.Log4jServletContextListener</listener-class>  
31.      </listener>  
32.      <filter>  
33.          <filter-name>log4jServletFilter</filter-name>  
34.         <filter-class>org.apache.logging.log4j.web.Log4jServletFilter</filter-class>  
35.      </filter>  
36.      <filter-mapping>  
37.          <filter-name>log4jServletFilter</filter-name>  
38.          <url-pattern>/*</url-pattern>  
39.         <dispatcher>REQUEST</dispatcher>  
40.          <dispatcher>FORWARD</dispatcher>  
41.          <dispatcher>INCLUDE</dispatcher>  
42.          <dispatcher>ERROR</dispatcher>  
43.      </filter-mapping>  
44.      <!-- log4j2-end -->  
45.        
46.      <!-- 支持GET、POST、PATCH、PUT与DELETE请求 -->    
47.      <filter>    
48.         <filter-name>httpPutFormFilter</filter-name>    
49.         <filter-class>org.springframework.web.filter.HttpPutFormContentFilter</filter-class>    
50.     </filter>    
51.     <filter-mapping>    
52.         <filter-name>httpPutFormFilter</filter-name>    
53.         <url-pattern>/*</url-pattern>  
54.     </filter-mapping>  
55.     <!--   
56.     <filter>    
57.         <filter-name>hiddenHttpMethodFilter</filter-name>    
58.         <filter-class>org.springframework.web.filter.HiddenHttpMethodFilter</filter-class>    
59.     </filter>    
60.         
61.     <filter-mapping>    
62.         <filter-name>hiddenHttpMethodFilter</filter-name>    
63.         <url-pattern>/*</url-pattern>    
64.     </filter-mapping>   
65.     -->   
66.       
67.   <!-- 加载spring配置文件 -->  
68.   <listener>  
69.      <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>  
70.   </listener>  
71.   <context-param>  
72.       <param-name>contextConfigLocation</param-name>  
73.       <param-value>classpath:spring/applicationContext*.xml</param-value>  
74.   </context-param>  
75.     
76.   <!-- 加载springmvc配置文件 -->  
77.   <servlet>  
78.       <servlet-name>springmvc</servlet-name>  
79.       <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>  
80.       <load-on-startup>1</load-on-startup>  
81.        <init-param>  
82.            <param-name>contextConfigLocation</param-name>  
83.            <param-value>classpath:spring/springmvc.xml</param-value>     
84.        </init-param>  
85.   </servlet>  
86.     
87.   <servlet-mapping>  
88.     <servlet-name>springmvc</servlet-name>  
89.     <!-- 指定拦截路径 -->  
90.     <url-pattern>/</url-pattern>  
91.   </servlet-mapping>  
92.     
93. </web-app>  

第五步：创建service层引用Mapper接口

接口：

[java]  view plain  copy

1. package com.stu.service;  
2.   
3. import java.util.List;  
4.   
5. import com.stu.pojo.TUser;  
6.   
7. public interface UserService {  
8.       
9.     public List<TUser> getUserInfo( String keywords, Integer page, Integer size);  
10.       
11. }  

实现类：

[java]  view plain  copy

1. package com.stu.service.impl;  
2.   
3. import java.util.List;  
4.   
5. import org.apache.commons.lang3.StringUtils;  
6. import org.springframework.beans.factory.annotation.Autowired;  
7. import org.springframework.stereotype.Service;  
8.   
9. import com.github.pagehelper.PageHelper;  
10. import com.github.pagehelper.PageInfo;  
11. import com.stu.dao.TUserMapper;  
12. import com.stu.pojo.TUser;  
13. import com.stu.pojo.TUserExample;  
14. import com.stu.service.UserService;  
15. @Service  
16. public class UserServiceImpl implements UserService {  
17.     @Autowired  
18.     private TUserMapper userMapper;  
19.   
20.     @Override  
21.     public List<TUser> getUserInfo(String keywords, Integer page, Integer size) {  
22.         PageHelper.startPage(page, size);  
23.         TUserExample example = new TUserExample();  
24.         if (!StringUtils.isBlank(keywords)) {  
25.             example.createCriteria().andUsernameLike(keywords + "%");  
26.         }  
27.         List<TUser> list = userMapper.selectByExample(example);  
28.         PageInfo<TUser> info = new PageInfo<TUser>(list);  
29.         System.out.println("页码: "  + info.getPageNum());  
30.         System.out.println("每页大小: "  + info.getSize());  
31.         System.out.println("总页数: "  + info.getPages());  
32.         System.out.println("总记录数: "  + info.getTotal());  
33.         return list;  
34.     }  
35.   
36. }  

注意:keywords是查询条件，对应表字段---->username

第六步：创建Controller

[java]  view plain  copy

1. package com.stu.api.controller;  
2.   
3. import java.io.UnsupportedEncodingException;  
4. import java.util.List;  
5.   
6. import javax.annotation.Resource;  
7.   
8. import org.springframework.web.bind.annotation.GetMapping;  
9. import org.springframework.web.bind.annotation.RequestMapping;  
10. import org.springframework.web.bind.annotation.RestController;  
11.   
12. import com.stu.pojo.TUser;  
13. import com.stu.service.UserService;  
14.   
15. @RestController  
16. @RequestMapping("/api/v2/users")  
17. public class UserController {  
18.     @Resource  
19.     private UserService userService;  
20.       
21.     @GetMapping("/")  
22.     public List<TUser> getUserInfo( String keywords ,Integer page, Integer size){  
23.         System.out.println("page : " + page);  
24.         System.out.println("size : " + size);  
25.         if(keywords != null){  
26.             try {  
27.                 keywords=new String(keywords.getBytes("ISO-8859-1"),"UTF-8");  
28.             } catch (UnsupportedEncodingException e) {  
29.                 e.printStackTrace();  
30.             }  
31.         }  
32.         List<TUser> user = userService.getUserInfo(keywords , page, size);  
33.         return user;  
34.     }  
35.       
36. }  

第七步：运行项目 ，测试

1、使用tomcat7:run运行项目

2、在浏览器中输入:http://localhost:8080/api/v2/users/?keyword=张三&page=1&size=2

数据返回成功:

[plain]  view plain  copy

1. {"data":[{"id":1,"username":"王五","password":null,"state":0,"isdel":false,"addTime":1487644664000,"money":null,"leftMoney":22.1,"remark":null},{"id":2,"username":"张三","password":null,"state":0,"isdel":false,"addTime":1487644811000,"money":null,"leftMoney":22.1,"remark":null}],"meta":{"respCode":0,"respMsg":null,"detail":"OK","url":null},"pagination":{"page":1,"size":2,"totalPage":58,"totalCode":116}}