Mybatis-Plus分页

最新推荐文章于 2024-07-25 10:21:31 发布

赛尔号-

最新推荐文章于 2024-07-25 10:21:31 发布

阅读量130

点赞数

分类专栏： Java 文章标签： mybatis spring java spring boot mysql

本文链接：https://blog.csdn.net/qq_36811160/article/details/110394417

版权

Java 专栏收录该内容

45 篇文章 1 订阅

订阅专栏

public interface ArticleCEIDataService extends IService<ArticleCEIData>{

}

@Service
public class ArticleCEIDataImpl extends ServiceImpl<ArticleCEIDataMapper, ArticleCEIData> implements ArticleCEIDataService {

}

@Mapper
public interface ArticleCEIDataMapper extends BaseMapper<ArticleCEIData>{

}

import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
import com.baomidou.mybatisplus.extension.plugins.PerformanceInterceptor;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Profile;
import org.springframework.transaction.annotation.EnableTransactionManagement;

@Configuration
@EnableTransactionManagement
@MapperScan("com.zbjt.datahome.api.center.mapper")
public class MybatisPlusConfig {
	/**
	 * 分页插件
	 */
	@Bean
	public PaginationInterceptor paginationInterceptor() {
		PaginationInterceptor paginationInterceptor = new PaginationInterceptor();

		/*设置接口的返回数量上限*/
		paginationInterceptor.setLimit(5000);

		return paginationInterceptor;
	}


	/**
	 * SQL执行效率插件
	 */
	@Bean
	@Profile({"dev", "test"})// 设置 dev test 环境开启
	public PerformanceInterceptor performanceInterceptor() {

		return new PerformanceInterceptor();

	}
}