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;

  }

}