mybatis在springboot中的应用 mybatis逆向工程与分页在springboot中的应用及遇到坑

<parent>
 <groupId>org.springframework.boot</groupId>
 <artifactId>spring-boot-starter-parent</artifactId>
 <version>1.5.2.RELEASE</version>
 <relativePath/> <!-- lookup parent from repository -->
</parent>
<properties>
 <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
 <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
 <java.version>1.8</java.version>
</properties>
<dependencies>
 <dependency>
  <groupId>org.springframework.boot</groupId>
  <artifactId>spring-boot-starter-web</artifactId>
 </dependency>
 <dependency>
  <groupId>org.springframework.boot</groupId>
  <artifactId>spring-boot-starter-test</artifactId>
 </dependency>
 <dependency>
  <groupId>org.mybatis.spring.boot</groupId>
  <artifactId>mybatis-spring-boot-starter</artifactId>
  <version>1.3.0</version>
 </dependency>
 <dependency>
  <groupId>mysql</groupId>
  <artifactId>mysql-connector-java</artifactId>
  <scope>runtime</scope>
 </dependency>
 <!--分页插件-->
 <dependency>
   <groupId>com.github.pagehelper</groupId>
   <artifactId>pagehelper-spring-boot-starter</artifactId>
   <version>1.2.1</version>
 </dependency>
 <!-- alibaba的druid数据库连接池 -->
 <dependency>
  <groupId>com.alibaba</groupId>
  <artifactId>druid</artifactId>
  <version>1.0.29</version>
 </dependency>
</dependencies>
<build>
 <plugins>
  <plugin>
   <groupId>org.springframework.boot</groupId>
   <artifactId>spring-boot-maven-plugin</artifactId>
  </plugin>
  <!-- mybatis generator 自动生成代码插件 -->
  <plugin>
   <groupId>org.mybatis.generator</groupId>
   <artifactId>mybatis-generator-maven-plugin</artifactId>
   <version>1.3.2</version>
   <configuration>
    <configurationFile>${basedir}/src/main/resources/generator/generatorConfig.xml</configurationFile>
    <overwrite>true</overwrite>
    <verbose>true</verbose>
   </configuration>
  </plugin>
 </plugins>
</build>

@SpringBootApplication
public class Main {
 public static void main(String[] args) {
  SpringApplication.run(Main.class, args);
 }
}

server:
 port: 8080
spring:
 datasource:
  name: test
  url: jdbc:mysql://localhost:3306/test
  username: root
  password: 123456
  driver-class-name: com.mysql.jdbc.Driver
## 该配置节点为独立的节点
mybatis:
 mapper-locations: classpath:mapper/*.xml
#pagehelper分页插件
pagehelper:
 helperDialect: mysql
 reasonable: true
 supportMethodsArguments: true
 params: count=countSql

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN" "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<generatorConfiguration>
 <!-- 数据库驱动:选择你的本地硬盘上面的数据库驱动包-->
 <classPathEntry location="E:\plugins\maven\repo\mysql\mysql-connector-java\5.1.41\mysql-connector-java-5.1.41.jar"/>
 <context id="DB2Tables" targetRuntime="MyBatis3">
  <commentGenerator>
   <property name="suppressDate" value="true"/>
   <!-- 是否去除自动生成的注释 true：是 ： false:否 -->
   <property name="suppressAllComments" value="true"/>
  </commentGenerator>
  <!--数据库链接URL，用户名、密码 -->
  <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://localhost/test" userId="root" password="123456">
  </jdbcConnection>
  <javaTypeResolver>
   <property name="forceBigDecimals" value="false"/>
  </javaTypeResolver>
  <!-- 生成pojo类的位置-->
  <javaModelGenerator targetPackage="com.luis.entity" targetProject="src/main/java">
   <property name="enableSubPackages" value="true"/>
   <property name="trimStrings" value="true"/>
  </javaModelGenerator>
  <!-- 生成映射文件的包名和位置-->
  <sqlMapGenerator targetPackage="mapper" targetProject="src/main/resources">
   <!-- enableSubPackages 是否让schema作为包的后缀-->
   <property name="enableSubPackages" value="false"/>
  </sqlMapGenerator>
  <!-- 生成mapper接口的位置-->
  <javaClientGenerator type="XMLMAPPER" targetPackage="com.luis.mapper" targetProject="src/main/java">
   <!-- enableSubPackages 是否让schema作为包的后缀-->
   <property name="enableSubPackages" value="false"/>
  </javaClientGenerator>
  <!-- 指定数据库表 -->
  <table schema="" tableName="user"></table>
 </context>
</generatorConfiguration>

DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
 `id` bigint(20) NOT NULL,
 `name` varchar(255) NOT NULL,
 `age` int(4) NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `user` VALUES ('1', 'wanger', '22');
INSERT INTO `user` VALUES ('2', 'zhangsan', '18');
INSERT INTO `user` VALUES ('3', 'lisi', '23');
INSERT INTO `user` VALUES ('4', 'wangwu', '21');

public interface UserService {
 User selectByName(String name);
 List<User> findAllUser(int pageNum, int pageSize);
}

@Service
public class UserServiceImpl implements UserService {
 @Autowired
 private UserMapper userMapper;
 @Override
 public User selectByName(String name) {
  UserExample example = new UserExample();
  Criteria criteria = example.createCriteria();
  criteria.andNameEqualTo(name);
  List<User> users = userMapper.selectByExample(example);
  if (users != null && users.size() > 0) {
   return users.get(0);
  }
  return null;
 }
 /**
  * pageNum 开始页数
  * pageSize 每页显示的数据条数
  */
 @Override
 public List<User> findAllUser(int pageNum, int pageSize) {
  //将参数传给方法实现分页
  PageHelper.startPage(pageNum, pageSize);
  UserExample example = new UserExample();
  List<User> list = userMapper.selectByExample(example);
  return list;
 }
}

@Controller
@RestController
public class UserController {
 @Autowired
 private UserService userService;
 @RequestMapping("/test")
 public User querUserByName() {
  User user = userService.selectByName("luis");
  System.out.println(user.toString());
  return user;
 }
 @RequestMapping("/list")
 public List<User> querUser() {
  List<User> list = userService.findAllUser(1, 2);
  //获取分页信息
  PageInfo<User> pageInfo = new PageInfo<>(list);
  System.out.println("total:" + pageInfo.getTotal());
  System.out.println("pages:" + pageInfo.getPages());
  System.out.println("pageSize:" + pageInfo.getPageSize());
  return list;
 }
}