案例属于亲身踩坑后,去除业务逻辑,简化的一个demo,下面一一贴码
# 配置数据源,给数据源起名z1或z2 spring.shardingsphere.datasource.names=z1,z2 # 配置允许一个实体类映射多张表 spring.main.allow-bean-definition-overriding=true # 配置数据源具体内容 jdbc:postgresql:// # z1 spring.shardingsphere.datasource.z1.type=com.alibaba.druid.pool.DruidDataSource spring.shardingsphere.datasource.z1.driver-class-name=org.postgresql.Driver spring.shardingsphere.datasource.z1.url=jdbc:postgresql://127.0.0.1:5432/shareding spring.shardingsphere.datasource.z1.username=postgres spring.shardingsphere.datasource.z1.password=postgres # z2 spring.shardingsphere.datasource.z2.type=com.alibaba.druid.pool.DruidDataSource spring.shardingsphere.datasource.z2.driver-class-name=org.postgresql.Driver spring.shardingsphere.datasource.z2.url=jdbc:postgresql://127.0.0.1:5432/shareding1 spring.shardingsphere.datasource.z2.username=postgres spring.shardingsphere.datasource.z2.password=postgres #t3