title: 54.达梦数据库集成sharding-jdbc  
CreateTime: 2019-07-11 00:00:54  
UpdateTime: 2019-07-11 00:00:54  
CategoryName: web  
---

---
title: "54.达梦数据库集成sharding-jdbc"
date: 2019-07-11T00:00:54+08:00
draft: false
tags: ["sharding-jdbc"]
categories: ["web"]
author: "springrain"
---

## 1.	sharding-jdbc介绍

https://shardingsphere.apache.org/document/current/cn/quick-start/sharding-jdbc-quick-start/

## 2.	达梦集成

### 2.1	驱动支持
sharding-jdbc默认不支持达梦数据库,需要根据驱动增加支持  
[下载sharding-jdbc-dm](/public/54/sharding-jdbc-dm.zip)  [下载sharding-jdbc-dm-src](/public/54/sharding-jdbc-dm-src.zip)

pom中引用
```xml
<dependency>
    <groupId>com.css</groupId>
    <artifactId>sharding-jdbc-dm</artifactId>
    <version>4.0.1.0</version>
</dependency>
```

### 2.2	修改DataSource实现

[下载DataSourceConfig.java](/public/54/DataSourceConfig.java)

### 2.3	依据create_Time日期字段,按照天分表

[下载ResourceCPUHISCreateTimePreciseShardingAlgorithm.java](/public/54/ResourceCPUHISCreateTimePreciseShardingAlgorithm.java)   
[下载ResourceCPUHISCreateTimeRangeShardingAlgorithm.java](/public/54/ResourceCPUHISCreateTimeRangeShardingAlgorithm.java)  

### 2.4	测试用例
[下载ShardingJDBCTests.java](/public/54/ShardingJDBCTests.java)