ShardingSphere-jdbc 5.5.0 + spring boot 基础配置 - 实战篇

环境准备

版本

spring boot 2.7.17
shardingsphere-jdbc 5.5.0
druid 1.2.23

数据库说明

本示例数据库为单机多库schema的架构，以一主一从作为集群演示，转为一主多从数据库集群时，可自定义修改配置。

集群

一主一从：
逻辑主库：ds_basic、ds0000、ds0001（ds_basic为数据简单、量少的元数据库）
逻辑从库：ds0000_slave、ds0001_slave

配置

配置文件

Maven依赖

         <dependency>
            <groupId>org.apache.shardingsphere</groupId>
            <artifactId>shardingsphere-jdbc</artifactId>
            <version>5.5.0</version>
            <exclusions>
                <exclusion>
                    <groupId>org.apache.shardingsphere</groupId>
                    <artifactId>shardingsphere-test-util</artifactId>
                </exclusion>
            </exclusions>
        </dependency>

        <dependency>
            <groupId>org.yaml</groupId>
            <artifactId>snakeyaml</artifactId>
            <version>2.2</version>
        </dependency>

spring boot配置

application.yml

spring:
  application:
    name: demo
  main:
    allow-bean-definition-overriding: true
  datasource:
    driver-class-name: org.apache.shardingsphere.driver.ShardingSphereDriver
    url: jdbc:shardingsphere:classpath:sharding.yaml

shardingsphere-jdbc配置

自定义配置1：SM4加解密存储数据

shardingsphere 5.5.0移除了sm4算法，两种方式解决：
1、使用官方shardingpshere plugin，找到相关组件依赖引用即可，
2、自己添加sm4算法代码SPI实现。
本文使用方式2（注意：ShardingSphere-jdbc 5.5.1版本加密算法接口升级了，以下sm4的SPI代码不适用，后续推出适配版本）。

1. 增加spi扩展
   
   org.apache.shardingsphere.encrypt.spi.EncryptAlgorithm增加以下代码：

     com.demo.core.encrypt.SM4EncryptAlgorithm

2. SM4算法代码

package com.demo.core.encrypt;

import lombok.EqualsAndHashCode;
import lombok.Getter;
import lombok.SneakyThrows;
import org.apache.shardingsphere.encrypt.spi.EncryptAlgorithm;
import org.apache.shardingsphere.encrypt.spi.EncryptAlgorithmMetaData;
import org.apache.shardingsphere.infra.algorithm.core.context.AlgorithmSQLContext;
import org.apache.shardingsphere.infra.algorithm.core.exception.AlgorithmInitializationException;
import org.apache.shardingsphere.infra.exception.core.ShardingSpherePreconditions;
import org.bouncycastle.jce.provider.BouncyCastleProvider;
import org.bouncycastle.pqc.math.linearalgebra.ByteUtils;

import javax.crypto.Cipher;
import javax.crypto.spec.IvParameterSpec;
import javax.crypto.spec.SecretKeySpec;
import java.nio.charset.StandardCharsets;
import java.security.GeneralSecurityException;
import java.security.Security;
import java.util.Arrays;
import java.util.HashSet;
import java.util.Optional;
import java.util.Properties;
import java.util.Set;

/**
* shardingsphere SM4 encrypt algorithm.
* @author Robin Wang
*/
@EqualsAndHashCode
public final class SM4EncryptAlgorithm implements EncryptAlgorithm {
   
   static {
       Security.addProvider(new BouncyCastleProvider());
   }

   @Getter
   private final EncryptAlgorithmMetaData metaData = new EncryptAlgorithmMetaData(true, true, false);

   private static final String SM4_KEY = "sm4-key";
   
   private static final String SM4_IV = "sm4-iv";
   
   private static final String SM4_MODE = "sm4-mode";
   
   private static final String SM4_PADDING = "sm4-padding";
   
   private static final int KEY_LENGTH = 16;
   
   private static final int IV_LENGTH = 16;
   
   private static final Set<String> MODES = new HashSet<>(Arrays.asList("ECB", "CBC"));
   
   private static final Set<String> PADDINGS = new HashSet<>(Arrays.asList("PKCS5Padding", "PKCS7Padding"));
   
   private byte[] sm4Key;
   
   private byte[] sm4Iv;
   
   private String sm4ModePadding;
   
   @Override
   public void init(final Properties props) {
       String sm4Mode = createSm4Mode(props);
       String sm4Padding = createSm4Padding(props);
       sm4ModePadding = "SM4/" + sm4Mode + "/" + sm4Padding;
       sm4Key = createSm4Key(props);
       sm4Iv = createSm4Iv(props, sm4Mode);
   }
   
   private String createSm4Mode(final Properties props) {
       ShardingSpherePreconditions.checkState(props.containsKey(SM4_MODE), () -> new AlgorithmInitializ