Spring Boot integrated MyBatis and paging plugin

Maven dependencies:

<dependency>    <groupId>com.github.pagehelper</groupId>    <artifactid>pagehelper </artifactId>    <version>4.1.6</version></dependency>

Mybatisconfig.java:

Importjava.util.Properties;ImportJavax.sql.DataSource;ImportOrg.apache.ibatis.plugin.Interceptor;Importorg.apache.ibatis.session.SqlSessionFactory;ImportOrg.mybatis.spring.SqlSessionFactoryBean;Importorg.mybatis.spring.SqlSessionTemplate;Importorg.springframework.beans.factory.annotation.Autowired;ImportOrg.springframework.context.annotation.Bean;Importorg.springframework.context.annotation.Configuration;ImportOrg.springframework.jdbc.datasource.DataSourceTransactionManager;ImportOrg.springframework.transaction.PlatformTransactionManager;Importorg.springframework.transaction.annotation.EnableTransactionManagement;ImportOrg.springframework.transaction.annotation.TransactionManagementConfigurer;ImportCom.github.pagehelper.PageHelper, @Configuration @EnableTransactionManagement Public classMybatisconfigImplementstransactionmanagementconfigurer {@Autowired DataSource DataSource; @Bean (Name= "Sqlsessionfactory")     Publicsqlsessionfactory Sqlsessionfactorybean () {Sqlsessionfactorybean bean=NewSqlsessionfactorybean ();        Bean.setdatasource (DataSource); //Paging PluginPagehelper Pagehelper =NewPagehelper (); Properties Props=NewProperties (); Props.setproperty ("Reasonable", "true"); Props.setproperty ("Supportmethodsarguments", "true"); Props.setproperty ("Returnpageinfo", "Check"); Props.setproperty ("Params", "Count=countsql");        Pagehelper.setproperties (props); //Add pluginBean.setplugins (Newinterceptor[] {pagehelper}); Try {            returnBean.getobject (); } Catch(Exception e) {e.printstacktrace (); return NULL; }} @Bean Publicsqlsessiontemplate sqlsessiontemplate (sqlsessionfactory sqlsessionfactory) {return Newsqlsessiontemplate (sqlsessionfactory); } @Bean @Override PublicPlatformtransactionmanager Annotationdriventransactionmanager () {return NewDatasourcetransactionmanager (DataSource); }        }

After the Pagehelper.startpage (pagenum,pagesize) method call, there must be a mapper query method that must be consumed.

List<map> Result=usermapper.getuser ()

return new PageInfo (result)

When you know the data type, you can do a strong turn. String s=json.tojsonstring (JSON); Jsonobject Json=jsonobject.parentobject (String s)

Also encountered postman can not use the problem, because opened a green bean VPN ...

Spring Boot integrated MyBatis and paging plugin