From 4c4b97b0fc6b418254b8b7c29e55c7ee8f39997b Mon Sep 17 00:00:00 2001 From: jinpengyong <jpy123456> Date: Fri, 08 Oct 2021 10:05:56 +0800 Subject: [PATCH] 臭氧预测实测对比 --- screen-api/src/main/java/com/moral/api/config/mybatis/MybatisPlusConfig.java | 54 +++++++++++++++++++++++++++++++----------------------- 1 files changed, 31 insertions(+), 23 deletions(-) diff --git a/screen-api/src/main/java/com/moral/api/config/mybatis/MybatisPlusConfig.java b/screen-api/src/main/java/com/moral/api/config/mybatis/MybatisPlusConfig.java index 8b810d5..a43b5e9 100644 --- a/screen-api/src/main/java/com/moral/api/config/mybatis/MybatisPlusConfig.java +++ b/screen-api/src/main/java/com/moral/api/config/mybatis/MybatisPlusConfig.java @@ -1,13 +1,20 @@ package com.moral.api.config.mybatis; -import com.baomidou.mybatisplus.core.parser.ISqlParser; +import com.baomidou.mybatisplus.annotation.DbType; import com.baomidou.mybatisplus.extension.parsers.DynamicTableNameParser; import com.baomidou.mybatisplus.extension.parsers.ITableNameHandler; import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor; -import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor; import com.baomidou.mybatisplus.extension.plugins.handler.TableNameHandler; import com.baomidou.mybatisplus.extension.plugins.inner.DynamicTableNameInnerInterceptor; +import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor; +import com.moral.api.entity.HistoryFiveMinutely; +import com.moral.api.mapper.HistoryFiveMinutelyMapper; +import com.moral.api.service.HistorySecondUavService; +import com.moral.api.service.impl.HistorySecondUavServiceImpl; +import com.moral.api.service.impl.OrganizationServiceImpl; import org.apache.ibatis.reflection.MetaObject; +import org.apache.ibatis.session.SqlSessionFactory; +import org.springframework.beans.factory.annotation.Value; import org.springframework.context.annotation.Bean; import org.springframework.context.annotation.Configuration; @@ -18,36 +25,37 @@ @Configuration public class MybatisPlusConfig { - /** - * ������������ - */ - @Bean - public PaginationInterceptor paginationInterceptor() { - PaginationInterceptor paginationInterceptor = new PaginationInterceptor(); - return paginationInterceptor; - } + public static ThreadLocal<String> tableName = new ThreadLocal<>(); - /** - * @Description: ������������������ - * @Param: [] - * @return: com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor - * @Author: ��������� - * @Date: 2021/7/15 - */ @Bean - public MybatisPlusInterceptor mybatisPlusInterceptor(){ + public MybatisPlusInterceptor mybatisPlusInterceptor() { MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor(); + + //������������ + interceptor.addInnerInterceptor(new PaginationInnerInterceptorIIL(DbType.MYSQL)); + + // ������������SQL��������� DynamicTableNameInnerInterceptor dynamicTableNameInnerInterceptor = new DynamicTableNameInnerInterceptor(); - HashMap<String, TableNameHandler> map = new HashMap<String, TableNameHandler>(); - map.put("history_five_minutely",(sql,tableName)->{ Date date = new Date(); - SimpleDateFormat sdf = new SimpleDateFormat("yyyyMM"); - String month = sdf.format(date); - return tableName+"_"+month;}); + HashMap<String, TableNameHandler> map = new HashMap<>(); + map.put("history_hourly", (sql, tableName) -> tableName+this.tableName.get()); + map.put("history_five_minutely", (sql, tableName) -> tableName+this.tableName.get()); dynamicTableNameInnerInterceptor.setTableNameHandlerMap(map); interceptor.addInnerInterceptor(dynamicTableNameInnerInterceptor); + return interceptor; } + /*@Bean + public MybatisPlusInterceptor mybatisPlusInterceptor() { + MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor(); + + //������������ + PaginationInnerInterceptorIIL paginationInnerInterceptorIIL = new PaginationInnerInterceptorIIL(DbType.MYSQL); + paginationInnerInterceptorIIL.setMultiTableQueryName(multiTableQueryNames); + interceptor.addInnerInterceptor(paginationInnerInterceptorIIL); + + return interceptor; + }*/ } -- Gitblit v1.8.0