Java代码不需要写分表相关的代码。
yml配置如下 :
spring:
jpa:
hibernate:
ddl-auto: create # 项目启动时重建表 可选项 update none
shardingsphere:
datasource:
# names: test0,test1
names: test0
test0:
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: com.mysql.jdbc.Driver
url: jdbc:mysql://localhost:3306/test0
username: root
password: root
# test1:
# type: com.alibaba.druid.pool.DruidDataSource
# driver-class-name: com.mysql.jdbc.Driver
# url: jdbc:mysql://localhost:3306/test1
# username: root
# password: root
sharding:
tables:
t_order:
# actual-data-nodes: test$->{0..1}.t_order_$->{0..1}
actual-data-nodes: test0.t_order_$->{0..1}
table-strategy:
inline:
shardingColumn: order_id
algorithm-expression: t_order_$->{order_id % 2}
keyGenerator:
type: SNOWFLAKE
column: order_id
# databaseStrategy:
# inline:
# shardingColumn: user_id
# algorithmExpression: test$->{user_id % 2}
props:
sql:
show: true
代码地址如下: