package com.itheima;
import com.itheima.mapper.TDictMapper;
import com.itheima.mapper.TOrderMapper;
import com.itheima.mapper.TUserMapper;
import com.itheima.mapper.TbLogMapper;
import com.itheima.pojo.TDict;
import com.itheima.pojo.TOrder;
import com.itheima.pojo.TUser;
import com.itheima.pojo.TbLog;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import java.math.BigDecimal;
import java.util.Random;
@SpringBootTest
public class ShardingDemoApplicationTests {
@Autowired
private TOrderMapper tOrderMapper;
@Autowired
private TDictMapper tDictMapper;
@Autowired
private TUserMapper tUserMapper;
@Autowired
private TbLogMapper tbLogMapper;
//测试分表
@Test
public void test1() {
int orderId=0;
Random random=new Random();
for (int i = 1; i <=20; i++) {
//0,1 +1 ==>1,2
//保证随机生成奇数或者偶数
orderId+=random.nextInt(2)+1;
TOrder order = TOrder.builder().orderId(Long.valueOf(orderId))
.userId(Long.valueOf(i))
.status("1")
.price(new BigDecimal(300)).build();
tOrderMapper.insert(order);
}
}
//测试水平分库分表
@Test
public void test2() {
int orderId=0;
int userId=0;
Random random=new Random();
for (int i = 1; i <=40; i++) {
//0,1 +1 ==>1,2
//保证随机生成奇数或者偶数
orderId+=random.nextInt(2)+1;
userId+=random.nextInt(2)+1;
TOrder order = TOrder.builder().orderId(Long.valueOf(orderId))
.userId(Long.valueOf(userId))
.status("1")
.price(new BigDecimal(300)).build();
tOrderMapper.insert(order);
}
}
/*
测试广播表
期望效果:两个库下的表都有数据
*/
@Test
public void test3(){
TDict build = TDict.builder().dictId(1l).code("666").type("1").value("888")
.build();
tDictMapper.insert(build);
}
//测试垂直分库
@Test
public void test4(){
for (int i = 1; i <= 5; i++) {
TUser user = TUser.builder().userId(Long.valueOf(i)).userType("1").fullname("小白"+i).build();
tUserMapper.insert(user);
}
}
//测试默认数据源,对于没有做分片处理的操作,直接访问默认数据源
@Test
public void test5(){
TbLog tbLog = TbLog.builder().id(Long.valueOf(1)).info("这是一个测试").build();
tbLogMapper.insert(tbLog);
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
shardingJdbc 小demo 源码下载
共142个文件
xml:101个
class:14个
properties:13个
需积分: 3 5 下载量 191 浏览量
2023-01-30
10:32:23
上传
评论
收藏 123KB RAR 举报
温馨提示
Apache ShardingSphere 是一套开源的分布式数据库解决方案组成的生态圈。 组成部分: JDBC、Proxy 和 Sidecar(规划中)这 3 款既能够独立部署,又支持混合部署配合使用的产品组成。 功能特性:它们均提供标准化的数据水平扩展、分布式事务和分布式治理等功能,可适用于如 Java 同构、异构语言、云原生等各种多样化的应用场景。
资源推荐
资源详情
资源评论
收起资源包目录
shardingJdbc 小demo 源码下载 (142个子文件)
ShardingDemoApplicationTests.class 4KB
TOrder.class 3KB
TDict.class 3KB
TUser.class 3KB
TbLog.class 2KB
TOrder$TOrderBuilder.class 2KB
TDict$TDictBuilder.class 2KB
TUser$TUserBuilder.class 1KB
TbLog$TbLogBuilder.class 1KB
ShardingDemoApplication.class 747B
TOrderMapper.class 571B
TbLogMapper.class 567B
TUserMapper.class 567B
TDictMapper.class 567B
.gitignore 184B
sharding-demo.iml 10KB
maven-wrapper.jar 57KB
ShardingDemoApplicationTests.java 2KB
TOrder.java 639B
TDict.java 596B
TUser.java 544B
TbLog.java 450B
TOrderMapper.java 442B
TbLogMapper.java 434B
TUserMapper.java 434B
TDictMapper.java 434B
ShardingDemoApplication.java 316B
information_schema.FNRwLQ.meta 76B
application-test4.properties 3KB
application-test4.properties 3KB
application-test2.properties 2KB
application-test2.properties 2KB
application-test1.properties 2KB
application-test3.properties 2KB
application-test1.properties 1KB
application-test3.properties 1KB
application-test5.properties 1KB
application-test5.properties 821B
application.properties 325B
application.properties 253B
maven-wrapper.properties 233B
91748392-ff1c-4281-8a1f-a4e8da1f7012.xml 35KB
workspace.xml 10KB
TOrderMapper.xml 3KB
TOrderMapper.xml 3KB
templates.xml 3KB
TDictMapper.xml 3KB
TDictMapper.xml 3KB
TUserMapper.xml 3KB
TUserMapper.xml 3KB
TbLogMapper.xml 2KB
TbLogMapper.xml 2KB
pom.xml 2KB
dataSources.local.xml 987B
compiler.xml 894B
jarRepositories.xml 880B
Maven__org_apache_shardingsphere_sharding_jdbc_spring_boot_starter_4_0_0_RC1.xml 766B
Maven__org_apache_shardingsphere_sharding_core_parse_postgresql_4_0_0_RC1.xml 745B
Maven__org_apache_shardingsphere_sharding_core_parse_sqlserver_4_0_0_RC1.xml 738B
Maven__org_mybatis_spring_boot_mybatis_spring_boot_autoconfigure_2_1_4.xml 730B
Maven__org_apache_shardingsphere_sharding_core_parse_oracle_4_0_0_RC1.xml 717B
Maven__org_apache_shardingsphere_sharding_core_parse_common_4_0_0_RC1.xml 717B
Maven__org_springframework_boot_spring_boot_test_autoconfigure_2_7_7.xml 713B
Maven__org_apache_shardingsphere_sharding_core_parse_mysql_4_0_0_RC1.xml 710B
Maven__org_apache_shardingsphere_sharding_transaction_core_4_0_0_RC1.xml 710B
Maven__com_vaadin_external_google_android_json_0_0_20131108_vaadin1.xml 700B
Maven__org_apache_shardingsphere_sharding_core_parse_spi_4_0_0_RC1.xml 696B
Maven__org_springframework_boot_spring_boot_starter_logging_2_7_7.xml 692B
Maven__org_apache_shardingsphere_sharding_core_optimize_4_0_0_RC1.xml 689B
Maven__org_mybatis_spring_boot_mybatis_spring_boot_starter_2_1_4.xml 688B
Maven__org_apache_shardingsphere_sharding_core_execute_4_0_0_RC1.xml 682B
Maven__org_apache_shardingsphere_sharding_core_rewrite_4_0_0_RC1.xml 682B
Maven__org_springframework_boot_spring_boot_autoconfigure_2_7_7.xml 678B
Maven__org_apache_shardingsphere_sharding_core_common_4_0_0_RC1.xml 675B
Maven__org_springframework_boot_spring_boot_starter_test_2_7_7.xml 671B
Maven__org_springframework_boot_spring_boot_starter_jdbc_2_7_7.xml 671B
Maven__org_apache_shardingsphere_sharding_core_entry_4_0_0_RC1.xml 668B
Maven__org_apache_shardingsphere_sharding_core_merge_4_0_0_RC1.xml 668B
Maven__org_apache_shardingsphere_sharding_core_route_4_0_0_RC1.xml 668B
Maven__org_apache_shardingsphere_sharding_jdbc_core_4_0_0_RC1.xml 661B
Maven__org_apache_shardingsphere_sharding_core_api_4_0_0_RC1.xml 654B
Maven__org_springframework_boot_spring_boot_starter_2_7_7.xml 636B
Maven__org_junit_platform_junit_platform_commons_1_8_2.xml 633B
Maven__jakarta_activation_jakarta_activation_api_1_2_2.xml 633B
Maven__jakarta_annotation_jakarta_annotation_api_1_3_5.xml 633B
Maven__org_junit_platform_junit_platform_engine_1_8_2.xml 626B
Maven__org_junit_jupiter_junit_jupiter_params_5_8_2.xml 615B
Maven__org_springframework_boot_spring_boot_test_2_7_7.xml 615B
Maven__org_junit_jupiter_junit_jupiter_engine_5_8_2.xml 615B
Maven__jakarta_xml_bind_jakarta_xml_bind_api_2_3_3.xml 611B
Maven__javax_annotation_javax_annotation_api_1_3_2.xml 611B
Maven__org_springframework_spring_expression_5_3_24.xml 609B
Maven__org_apache_logging_log4j_log4j_to_slf4j_2_17_2.xml 608B
Maven__org_apache_commons_commons_collections4_4_2.xml 605B
Maven__org_mockito_mockito_junit_jupiter_4_5_1.xml 598B
Maven__org_junit_jupiter_junit_jupiter_api_5_8_2.xml 594B
Maven__org_springframework_spring_context_5_3_24.xml 588B
Maven__net_bytebuddy_byte_buddy_agent_1_12_20.xml 585B
Maven__org_springframework_boot_spring_boot_2_7_7.xml 580B
Maven__ch_qos_logback_logback_classic_1_2_11.xml 575B
共 142 条
- 1
- 2
资源评论
律二萌萌哒
- 粉丝: 385
- 资源: 45
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功