Code
Hub
Workspaces
Following
Trending
Connect
MCP
copy
Create free account
hub
/
github.com/TaXueWWL/snowalker-shardingjdbc-demo
/ functions
Functions
102 in github.com/TaXueWWL/snowalker-shardingjdbc-demo
⨍
Functions
102
◇
Types & classes
21
↓ 10 callers
Method
toString
()
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/entity/UserInfoEntity.java:45
↓ 7 callers
Method
fillZero
指定字符串位数前缀补零 @param value @param needLength @return
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/util/StringUtil.java:19
↓ 5 callers
Method
generateKey
根据路由id生成内部系统主键id, 路由id可以是内部其他系统主键id,也可以是外部第三方用户id @param targetEnum 待生成主键的目标表规则配置 @param relatedRouteId 路由id或外部第三方用户id @return
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/sequence/KeyGenerator.java:41
↓ 4 callers
Method
getDbCount
()
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/constant/DbAndTableEnum.java:89
↓ 4 callers
Method
getTbCount
()
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/constant/DbAndTableEnum.java:93
↓ 4 callers
Method
remove
()
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/util/DateUtil.java:57
↓ 3 callers
Method
getShardingKey
()
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/constant/DbAndTableEnum.java:61
↓ 3 callers
Method
getTableName
()
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/constant/DbAndTableEnum.java:57
↓ 3 callers
Method
setOrderId
(Long orderId)
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/entity/OrderInfo.java:39
↓ 3 callers
Method
setUserId
(String userId)
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/entity/OrderNewInfoEntity.java:30
↓ 3 callers
Method
setUserId
(Long userId)
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/entity/OrderInfo.java:30
↓ 2 callers
Method
addOrder
(OrderInfo orderInfo)
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/mapper/OrderMapper.java:20
↓ 2 callers
Method
formatDateYyyyMMdd2
格式化时间为时间戳:yyyy-MM-dd @param date @return
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/util/DateUtil.java:145
↓ 2 callers
Method
getDbIndexAndTbIndexMap
根据已知路由id取出库表索引,外部id和内部id均 进行ASCII转换后再对库表数量取模 @param targetEnum 待生成主键的目标表规则配置 @param relatedRouteId 路由id 取模求表 取商求库 @return
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/sequence/KeyGenerator.java:79
↓ 2 callers
Method
getDbIndexBegin
()
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/constant/DbAndTableEnum.java:81
↓ 2 callers
Method
getDbIndexByMod
@param obj @param dbCount @param tbCount @return
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/util/StringUtil.java:100
↓ 2 callers
Method
getModValue
先对指定对象取ASCII码后取模运算 @param obj @param num @return
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/util/StringUtil.java:87
↓ 2 callers
Method
getTbIndexBegin
()
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/constant/DbAndTableEnum.java:85
↓ 2 callers
Method
getTbIndexByMod
@param obj @param dbCount @param tbCount @return
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/util/StringUtil.java:114
↓ 2 callers
Method
parseNormalDateFromStr
解析字符串形式的时间戳为java.util.Date @param timeStampStr @return
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/util/DateUtil.java:102
↓ 2 callers
Method
queryOrderInfoByOrderId
(OrderInfo orderInfo)
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/mapper/OrderMapper.java:18
↓ 2 callers
Method
queryOrderInfoList
(OrderInfo orderInfo)
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/mapper/OrderMapper.java:16
↓ 2 callers
Method
setOrderId
(String orderId)
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/entity/OrderNewInfoEntity.java:39
↓ 2 callers
Method
toString
()
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/entity/OrderInfo.java:53
↓ 1 callers
Method
addOrder
(OrderInfo orderInfo)
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/service/OrderService.java:20
↓ 1 callers
Method
addOrder
(OrderNewInfoEntity orderInfo)
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/mapper/OrderNewMapper.java:21
↓ 1 callers
Method
deleteZero
指定数字字符串位数前缀去零 @param value @return
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/util/StringUtil.java:39
↓ 1 callers
Method
formatDate
格式化时间为时间戳:yyyyMMddHHmmssS @param date @return
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/util/DateUtil.java:40
↓ 1 callers
Method
getAscII
转换字符串路由id为纯数字ascII @param str @return
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/util/StringUtil.java:63
↓ 1 callers
Method
getCharsPrefix
()
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/constant/DbAndTableEnum.java:73
↓ 1 callers
Method
getDbIndexByMod
内部用户id使用取模方式对目标表库表数量取模获取分片节点 @param shardingValue @return
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/strategy/SnoWalkerComplexShardingDB.java:116
↓ 1 callers
Method
getDbIndexBySubString
该表主键使用下标方式截取数据库索引 @param targetEnum @param shardingValue @return
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/strategy/SnoWalkerComplexShardingDB.java:127
↓ 1 callers
Method
getDistributedId
生成id分布式机器位 @return 分布式机器id length与hostCount位数相同
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/sequence/KeyGenerator.java:99
↓ 1 callers
Method
getIdFromHostName
适配分布式环境,根据主机名生成id 分布式环境下,如:Kubernates云环境下,集群内docker容器名是唯一的 通过 @See org.apache.commons.lang3.SystemUtils.getHostName()获取主机名 @return
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/sequence/KeyGenerator.java:118
↓ 1 callers
Method
getIdVersion
()
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/constant/DbAndTableEnum.java:69
↓ 1 callers
Method
getIndex
根据分片键计算分片节点 @param logicTableName @param columnName @param shardingValue @return
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/strategy/SnoWalkerComplexShardingTB.java:67
↓ 1 callers
Method
getIndex
根据分片键计算分片节点 @param logicTableName @param columnName @param shardingValue @return
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/strategy/SnoWalkerComplexShardingDB.java:81
↓ 1 callers
Method
getNextVal
查redis方式 key前缀(形如:tableName_dbIndex_tbIndex_) @param targetEnum @param dbIndex @param tbIndex @return
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/sequence/SequenceGenerator.java:22
↓ 1 callers
Method
getTbIndexByMod
内部用户id使用取模方式对订单表库表数量取模获取分片节点 @param shardingValue @return
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/strategy/SnoWalkerComplexShardingTB.java:99
↓ 1 callers
Method
getTbIndexBySubString
该表主键使用下标方式截取表索引 @param targetEnum @param shardingValue @return
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/strategy/SnoWalkerComplexShardingTB.java:110
↓ 1 callers
Method
queryOrderInfoByOrderId
(OrderInfo orderInfo)
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/service/OrderService.java:18
↓ 1 callers
Method
queryOrderInfoByOrderId
(OrderNewInfoEntity orderInfo)
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/mapper/OrderNewMapper.java:19
↓ 1 callers
Method
queryOrderInfoList
(OrderInfo orderInfo)
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/service/OrderService.java:16
↓ 1 callers
Method
queryOrderInfoList
(OrderNewInfoEntity orderInfo)
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/mapper/OrderNewMapper.java:17
↓ 1 callers
Method
setUserName
(String userName)
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/entity/OrderNewInfoEntity.java:48
↓ 1 callers
Method
setUserName
(String userName)
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/entity/OrderInfo.java:48
Method
DateUtil
()
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/util/DateUtil.java:16
Method
DbAndTableEnum
(String tableName, String shardingKey, String bizType, String idVersion, String charsPrefix,
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/constant/DbAndTableEnum.java:42
Method
addOrder
(OrderInfo orderInfo)
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/service/OrderServiceImpl.java:37
Method
addOrder
(OrderNewInfoEntity orderInfo)
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/service/OrderNewSerivce.java:37
Method
doSharding
(Collection<String> availableTargetNames, Collection<ShardingValue> shardingValues)
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/strategy/SnoWalkerComplexShardingTB.java:29
Method
doSharding
@param availableTargetNames 可用数据源集合 @param shardingValues 分片键 @return sharding results for data sources or tables's names
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/strategy/SnoWalkerComplexShardingDB.java:34
Method
formatDateYyyyMM
格式化时间为时间戳:yyyy-MM-dd HH:mm:ss @param date @return
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/util/DateUtil.java:119
Method
formatDateYyyyMMdd
格式化时间为时间戳:yyyyMMdd @param date @return
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/util/DateUtil.java:67
Method
formatNormalDate
格式化时间为时间戳:yyyyMM @param date @return
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/util/DateUtil.java:93
Method
getBizType
()
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/constant/DbAndTableEnum.java:65
Method
getCurrMonthEndDate
获取本月最后一天的23:59:59 @return
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/util/DateUtil.java:184
Method
getCurrMonthFirstDate
获取本月第一天的00:00:00 @return
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/util/DateUtil.java:170
Method
getCurrMonthNum
获取当前月份整数值--用于表分区 @return
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/util/DateUtil.java:197
Method
getDesc
()
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/constant/DbAndTableEnum.java:97
Method
getId
()
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/entity/OrderNewInfoEntity.java:17
Method
getId
()
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/entity/UserInfoEntity.java:18
Method
getId
()
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/entity/OrderInfo.java:17
Method
getNextVal
redis序列获取实现方法 @param targetEnum @param dbIndex @param tbIndex @return
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/sequence/redis/RedisSequenceGenerator.java:38
Method
getNumberStartIndex
()
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/constant/DbAndTableEnum.java:77
Method
getOrderId
()
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/entity/OrderNewInfoEntity.java:35
Method
getOrderId
()
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/entity/OrderInfo.java:35
Method
getSnowFlakeId
ShardingSphere 默认雪花算法 {@link io.shardingsphere.core.keygen.DefaultKeyGenerator} 生成18位随机id,并提供静态方法设置workId @return
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/sequence/KeyGenerator.java:133
Method
getUUID
使用ShardingSphere 内置主键生成器 生成分布式主键id 共16位:其中4位减号,12位数字+小写字母 形如:3e9c3ac9-d7a1-43de-9db3-dec502e9ab3e
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/sequence/KeyGenerator.java:142
Method
getUserId
()
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/entity/OrderNewInfoEntity.java:26
Method
getUserId
()
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/entity/UserInfoEntity.java:27
Method
getUserId
()
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/entity/OrderInfo.java:26
Method
getUserName
()
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/entity/OrderNewInfoEntity.java:44
Method
getUserName
()
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/entity/UserInfoEntity.java:36
Method
getUserName
()
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/entity/OrderInfo.java:44
Method
isNumeric
判断字符串是否是纯数字,从最后一位开始判断 @param str @return
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/util/StringUtil.java:49
Method
main
(String[] args)
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/SnowalkerShardingjdbcDemoApplication.java:15
Method
parseDateFromStr
解析字符串形式的时间戳为java.util.Date @param timeStampStr @return
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/util/DateUtil.java:49
Method
parseDateFromStrYyyyMM
解析字符串形式的时间戳为java.util.Date yyyy-MM-dd HH:mm:ss @param timeStampStr @return
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/util/DateUtil.java:128
Method
parseDateFromStrYyyyMMdd
解析字符串形式的时间戳为java.util.Date @param timeStampStr @return
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/util/DateUtil.java:76
Method
parseDateFromStrYyyyMMdd2
解析字符串形式的时间戳为java.util.Date yyyy-MM-dd @param timeStampStr @return
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/util/DateUtil.java:154
Method
queryOrderInfoByOrderId
(OrderInfo orderInfo)
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/service/OrderServiceImpl.java:32
Method
queryOrderInfoByOrderId
(OrderNewInfoEntity orderInfo)
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/service/OrderNewSerivce.java:33
Method
queryOrderInfoList
(OrderInfo orderInfo)
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/service/OrderServiceImpl.java:27
Method
queryOrderInfoList
(OrderNewInfoEntity orderInfo)
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/service/OrderNewSerivce.java:29
Method
removeNormal
()
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/util/DateUtil.java:110
Method
removeYyyyMM
()
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/util/DateUtil.java:136
Method
removeYyyyMMdd
()
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/util/DateUtil.java:84
Method
removeYyyyMMdd2
()
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/util/DateUtil.java:162
Method
setId
(Integer id)
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/entity/OrderNewInfoEntity.java:21
Method
setId
(Integer id)
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/entity/UserInfoEntity.java:22
Method
setId
(String id)
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/entity/OrderInfo.java:21
Method
setUserId
(String userId)
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/entity/UserInfoEntity.java:31
Method
setUserName
(String userName)
src/main/java/com/snowalker/shardingjdbc/snowalker/demo/complex/sharding/entity/UserInfoEntity.java:40
Method
testGenerateId
测试分布式主键生成
src/test/java/com/snowalker/shardingjdbc/snowalker/demo/SnowalkerShardingjdbcDemoApplicationTests.java:82
Method
testInsertOrderInfo
()
src/test/java/com/snowalker/shardingjdbc/snowalker/demo/SnowalkerShardingjdbcDemoApplicationTests.java:30
Method
testNewOrderInsert
测试新的订单入库
src/test/java/com/snowalker/shardingjdbc/snowalker/demo/SnowalkerShardingjdbcDemoApplicationTests.java:100
Method
testQueryById
()
src/test/java/com/snowalker/shardingjdbc/snowalker/demo/SnowalkerShardingjdbcDemoApplicationTests.java:63
Method
testQueryList
默认规则跨片归并
src/test/java/com/snowalker/shardingjdbc/snowalker/demo/SnowalkerShardingjdbcDemoApplicationTests.java:52
Method
testQueryNewOrderById
测试订单明细查询
src/test/java/com/snowalker/shardingjdbc/snowalker/demo/SnowalkerShardingjdbcDemoApplicationTests.java:122
next →
1–100 of 102, ranked by callers