5.1.0的可以直接升级,此次代码比较完整,可以正常使用!
SpringBoot、Mybaits-Plus、Druid
解决druid启动报错的问题
中文社区—————————— 官方网站
完整DEMO,自己搭一个项目就可以直接复制使用
网盘项目压缩包
com.alibaba
druid-spring-boot-starter
1.2.8
// yml需要排除druid的自动配置 否则无法启动项目!
spring:
autoconfigure:
exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure
4.0.0 org.sharding sharding5.1.1 1.0-SNAPSHOT org.springframework.boot spring-boot-starter-parent 2.6.6 UTF-8 UTF-8 1.8 org.springframework.boot spring-boot-starter-web mysql mysql-connector-java 8.0.17 cn.hutool hutool-all 5.8.3 org.apache.shardingsphere shardingsphere-jdbc-core-spring-boot-starter 5.1.1 com.alibaba druid-spring-boot-starter 1.2.8 com.baomidou mybatis-plus-boot-starter 3.3.1 com.baomidou mybatis-plus-generator org.projectlombok lombok 1.18.4 provided junit junit 4.12 org.springframework.boot spring-boot-starter-test test org.junit.vintage junit-vintage-engine
YML
server:
port: 8888
#mybatis
mybatis-plus:
#mapper-locations: classpath*:/mapper*.xml,classpath*:/mapper
public static String shardingTablesCheckAndCreatAndReturn(String logicTableName, String resultTableName) {
synchronized (logicTableName.intern()) {
// 缓存中有此表 返回
if (tableNameCache.contains(resultTableName)) {
return resultTableName;
}
// 缓存中无此表 建表 并添加缓存
// 调用mapper 创建表
// @Update("CREATE TABLE IF NOT EXISTS ${name} LIKE hss_history")
hssHistoryMapper.createTable(resultTableName);
tableNameCache.add(resultTableName);
}
return resultTableName;
}
public static void tableNameCacheReload() {
// 读取数据库中所有表名
List tableNameList = getAllTableNameBySchema();
// 删除旧的缓存(如果存在)
ShardingAlgorithmTool.tableNameCache.clear();
// 写入新的缓存
ShardingAlgorithmTool.tableNameCache.addAll(tableNameList);
}
public static List getAllTableNameBySchema() {
List res = new ArrayList<>();
// 获取数据中的表名,需要自己构建数据源 SHOW TABLES like 'hss_history%'
// List tableNames = hssHistoryMapper.showTables();
Environment env = SpringUtil.getApplicationContext().getEnvironment();
try (Connection connection = DriverManager.getConnection(env.getProperty("spring.datasource.druid.url"), env.getProperty("spring.datasource.druid.username"), env.getProperty("spring.datasource.druid.password"));
Statement st = connection.createStatement()) {
try (ResultSet rs = st.executeQuery("SHOW TABLES like 'hss_history%'")) {
while (rs.next()) {
res.add(rs.getString(1));
}
}
} catch (Exception e) {
e.printStackTrace();
}
return res;
}
public static HashSet cacheTableNames() {
return tableNameCache;
}
}
项目启动就执行
package sharding.config;
import lombok.extern.slf4j.Slf4j;
import org.springframework.boot.CommandLineRunner;
import org.springframework.core.annotation.Order;
import org.springframework.stereotype.Component;
@Slf4j
@Order(value = 1) // 数字越小 越先执行
@Component
public class ShardingTablesLoadRunner implements CommandLineRunner {
@Override
public void run(String... args) {
ShardingAlgorithmTool.tableNameCacheReload();
}
}
SpringUtil,普通类注入bean
package sharding.utils;
import org.springframework.beans.BeansException;
import org.springframework.beans.factory.NoSuchBeanDefinitionException;
import org.springframework.context.ApplicationContext;
import org.springframework.context.ApplicationContextAware;
import org.springframework.core.env.Environment;
import org.springframework.stereotype.Component;
@Component
public class SpringUtil implements ApplicationContextAware {
private static ApplicationContext applicationContext = null;
public SpringUtil() {
}
public void setApplicationContext(ApplicationContext arg0) throws BeansException {
if (applicationContext == null) {
applicationContext = arg0;
}
}
public static ApplicationContext getApplicationContext() {
return applicationContext;
}
public static void setAppCtx(ApplicationContext webAppCtx) {
if (webAppCtx != null) {
applicationContext = webAppCtx;
}
}
public static T getBean(Class clazz) {
return getApplicationContext().getBean(clazz);
}
public static T getBean(String name, Class clazz) throws ClassNotFoundException {
return getApplicationContext().getBean(name, clazz);
}
public static final Object getBean(String beanName) {
return getApplicationContext().getBean(beanName);
}
public static final Object getBean(String beanName, String className) throws ClassNotFoundException {
Class clz = Class.forName(className);
return getApplicationContext().getBean(beanName, clz.getClass());
}
public static boolean containsBean(String name) {
return getApplicationContext().containsBean(name);
}
public static boolean isSingleton(String name) throws NoSuchBeanDefinitionException {
return getApplicationContext().isSingleton(name);
}
public static Class> getType(String name) throws NoSuchBeanDefinitionException {
return getApplicationContext().getType(name);
}
public static String[] getAliases(String name) throws NoSuchBeanDefinitionException {
return getApplicationContext().getAliases(name);
}
public static String getActiveProfile() {
if (applicationContext == null) {
throw new RuntimeException("applicationContext属性为null,请检查是否注入了SpringContextHolder!");
}
Environment env = applicationContext.getEnvironment();
// 获取环境变量
String[] strings = env.getActiveProfiles();
return applicationContext.getEnvironment().getActiveProfiles()[0];
}
}



