Sharding-JDBC公共表

1. 环境介绍

• JDK 1.8
• SpringBoot 2.4.0
• MyBatis 2.1.4
• Druid 1.2.3
• Sharding-JDBC 4.1.1

2. 数据库创建

• 创建数据库 course_db user_db
• 创建数据表 course user dict

CREATE TABLE `course_1` (
  `cid` bigint(20) NOT NULL,
  `cname` varchar(50) COLLATE utf8_bin NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `cstatus` varchar(10) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`cid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE `course_2` (
  `cid` bigint