ssm+mysql一个项目同时连接多个数据库案例

最新推荐文章于 2024-06-11 15:51:42 发布

渡生远方

最新推荐文章于 2024-06-11 15:51:42 发布

阅读量270

点赞数

分类专栏： java经验

本文链接：https://blog.csdn.net/qq_40798764/article/details/95065546

版权

该博客介绍了如何在SSM（Spring、SpringMVC、MyBatis）项目中实现连接多个MySQL数据库的案例。通过DBContextHolder、DynamicDataSource和DynamicDataSourceHolder等工具类，配合controller层和配置文件（application.db.properties、applicationContextDb.xml），详细阐述了多数据库切换的实现过程。

摘要由CSDN通过智能技术生成

工具类：

1.DBContextHolder

package web.Bean;

import org.springframework.jdbc.datasource.lookup.AbstractRoutingDataSource;

public class DBContextHolder extends AbstractRoutingDataSource {
 
    @Override
    protected Object determineCurrentLookupKey() {
        // 从自定义的位置获取数据源标识
        return DynamicDataSourceHolder.getDataSource();
    }
}

2.DynamicDataSource

package web.Bean;

import org.springframework.jdbc.datasource.lookup.AbstractRoutingDataSource;

public class DynamicDataSource extends AbstractRoutingDataSource {
	protected Object determineCurrentLookupKey() {
		return DynamicDataSourceHolder.getDataSource();
	}
}

3.DynamicDataSourceHolder

package web.Bean;

public class DynamicDataSourceHolder {
	private static final ThreadLocal<String> THREAD_DATA_SOURCE = new ThreadLocal();

	public static String getDataSource() {
		return (String) THREAD_DATA_SOURCE.get();
	}

	public static void setDataSource(String dataSource) {
		THREAD_DATA_SOURCE.set(dataSource);
	}

	public static void clearDataSource() {
		THREAD_DATA_SOURCE.remove();
	}

}

controller

package web.controller;


import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Collections;
import java.util.Date;
import java.util.List;
import java.util.Set;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.ResponseBody;

import web.Bean.DBContextHolder;
import web.Bean.DynamicDataSourceHolder;
import web.mapping.student;
import web.service.InterfaceDataListService;
import web.service.SecondService;
import web.serviceImpl.RedisService;

import com.alibaba.fastjson.JSONObject;
@Controller
public class BuwanzhengshuController {
	@Autowired
	private InterfaceDataListService interfaceDataListService;

	@Autowired
	private SecondService secondService;

	/**
	 * 同时查询两个数据库的数据
	 * 
	 */
	@RequestMapping(value = "demo04", method = RequestMethod.GET, produces =