SpringBoot:JPA + Druid 多数据源
参考出处, 根据Spring版本不同做出了相应的调整
上一篇:Spring Data JPA:分类查询、自定义查询、联表(多表查询)
-
创建两个数据库test和books,test数据库包含t_user表,books包含book表:
t_user表建立:
SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for t_user -- ---------------------------- DROP TABLE IF EXISTS `t_user`; CREATE TABLE `t_user` ( `t_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号', `t_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称', `t_age` int(10) NULL DEFAULT NULL COMMENT '年龄', `t_address` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '家庭住址', `t_pwd` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL COMMENT '用户登录密码', PRIMARY KEY (`t_id`) USING BTREE ) ENGINE = MyISAM AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_user -- ---------------------------- INSERT INTO `t_user` VALUES (1, 'Ray', 6, 'zh', '123'); INSERT INTO `t_user` VALUES (2, 'q343509740', 18, 'zh', '456'); INSERT INTO `t_user` VALUES (3, 'Rain', 24, 'zh', '789'); SET FOREIGN_KEY_CHECKS = 1;
book表建立:
SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for book -- ---------------------------- DROP TABLE IF EXISTS `book`; CREATE TABLE `book` ( `b_id` int(11) NOT NULL AUTO_INCREMENT, `b_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`b_id`) USING BTREE ) ENGINE = MyISAM AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of book -- ---------------------------- INSERT INTO `book` VALUES (1, 'SpringBoot入门'); INSERT INTO `book` VALUES (2, 'SpringData实战'); INSERT INTO `book` VALUES (3, 'SpringData放弃'); SET FOREIGN_KEY_CHECKS = 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 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>2.1.6.RELEASE</version> <relativePath/> <!-- lookup parent from repository --> </parent> <groupId>wen</groupId> <artifactId>datademo</artifactId> <version>0.0.1-SNAPSHOT</version> <name>datademo</name> <description>Demo project for Sp