所为多数据库就是采用不同数据库实例中的多个库,或者同一个数据库实例中的不同库。
下面开始实现jdbctemplate多数据源:
github:https://github.com/fengqing11/datasources-jdbctemplate
完整项目结构图:
创建数据库:
有两个数据库,创建数据库之前请先创建好两个数据库。
jdbctemplate.sql
# Host: localhost (Version: 5.7.26)
# Date: 2020-01-19 15:23:50
# Generator: MySQL-Front 5.3 (Build 4.234)
/*!40101 SET NAMES utf8 */;
#
# Structure for table "book"
#
CREATE TABLE `book` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`author` varchar(255) DEFAULT NULL,
PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
#
# Data for table "book"
#
INSERT INTO `book` VALUES (1,'a啊大苏打','是的啊');
jbdctemplate2.sql
# Host: localhost (Version: 5.7.26)
# Date: 2020-01-19 15:23:59
# Generator: MySQL-Front 5.3 (Build 4.234)
/*!40101 SET NAMES utf8 */;
#
# Structure for table "book"
#
CREATE TABLE `book` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`author` varchar(255) DEFAULT NULL,
PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
#
# Data for table "book"
#
INSERT INTO `book` VALUES (1,'苏打','是的啊是的');
创建项目,pom.xml如下:
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<