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 | 46 ++++++++++++++++++++++++++++++++-------------- 1 files changed, 32 insertions(+), 14 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 b919465..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,10 +1,20 @@ package com.moral.api.config.mybatis; 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.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; @@ -15,29 +25,37 @@ @Configuration public class MybatisPlusConfig { - /** - * @Description: ������������������ - * @Param: [] - * @return: com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor - * @Author: ��������� - * @Date: 2021/7/15 - */ + public static ThreadLocal<String> tableName = new ThreadLocal<>(); + @Bean - public MybatisPlusInterceptor mybatisPlusInterceptor(){ + public MybatisPlusInterceptor mybatisPlusInterceptor() { MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor(); + //������������ - interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL)); + 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