ShardingSphere-JDBC 72 Apache ShardingSphere document assisted_encryptor: type: MD5 like_encryptor: type: CHAR_DIGEST_LIKE Read the YAML configuration to create a data source according to the createDataSource assisted_encryptor: type: MD5 like_encryptor: 9.1. ShardingSphere-JDBC 73 Apache ShardingSphere document type: CHAR_DIGEST_LIKE Related References • Core Feature: Data Encryption • Developer Guide: Data Encryption MASK_BEFORE_SPECIAL_CHARS props: special-chars: '@' replace-char: '*' keep_first_n_last_m_mask: type: KEEP_FIRST_N_LAST_M props: first-n: 3 last-m: 4 replace-char: '*' 9.1. ShardingSphere-JDBC 75 Apache ShardingSphere

ShardingSphere-JDBC 74 Apache ShardingSphere document assisted_encryptor: type: MD5 like_encryptor: type: CHAR_DIGEST_LIKE Read the YAML configuration to create a data source according to the createDataSource MASK_BEFORE_SPECIAL_CHARS props: special-chars: '@' replace-char: '*' keep_first_n_last_m_mask: type: KEEP_FIRST_N_LAST_M props: first-n: 3 last-m: 4 replace-char: '*' 9.1. ShardingSphere-JDBC 76 Apache ShardingSphere type: AES props: aes-key-value: 123456abc assisted_encryptor: type: MD5 like_encryptor: type: CHAR_DIGEST_LIKE tables: t_encrypt: columns: user_id: cipher: name: user_cipher encryptorName: aes_encryptor

type: AES props: aes-key-value: 123456abc assisted_encryptor: type: MD5 like_encryptor: type: CHAR_DIGEST_LIKE 然后通过 YamlShardingSphereDataSourceFactory 的 createDataSource 方法创建数据源。 YamlShardingSp type: AES props: aes-key-value: 123456abc assisted_encryptor: type: MD5 like_encryptor: type: CHAR_DIGEST_LIKE 相关参考 • 核心特性：数据加密 • 开发者指南：数据加密 数据脱敏 背景信息 数据脱敏 YAML 配置方式良好的可读性，通过 YAML 格式，能够快速地理解脱敏规则之间的依赖关系， MASK_BEFORE_SPECIAL_CHARS props: special-chars: '@' replace-char: '*' keep_first_n_last_m_mask: type: KEEP_FIRST_N_LAST_M props: first-n: 3 last-m: 4 replace-char: '*' 然后通过 YamlShardingSphereDataSourceFactory

type: AES props: aes-key-value: 123456abc assisted_encryptor: type: MD5 like_encryptor: type: CHAR_DIGEST_LIKE 然后通过 YamlShardingSphereDataSourceFactory 的 createDataSource 方法创建数据源。 YamlShardingSp special-chars: '@' replace-char: '*' keep_first_n_last_m_mask: type: KEEP_FIRST_N_LAST_M 9.1. ShardingSphere-JDBC 68 Apache ShardingSphere document props: first-n: 3 last-m: 4 replace-char: '*' 然后通过 Yaml assisted_encryptor: type: MD5 like_encryptor: 9.1. ShardingSphere-JDBC 74 Apache ShardingSphere document type: CHAR_DIGEST_LIKE tables: t_encrypt: columns: user_id: cipher: name: user_cipher encryptorName: aes_encryptor

type: AES props: aes-key-value: 123456abc assisted_encryptor: type: MD5 like_encryptor: type: CHAR_DIGEST_LIKE 然后通过 YamlShardingSphereDataSourceFactory 的 createDataSource 方法创建数据源。 YamlShardingSp ShardingSphere-JDBC 66 Apache ShardingSphere document assisted_encryptor: type: MD5 like_encryptor: type: CHAR_DIGEST_LIKE 相关参考 • 核心特性：数据加密 • 开发者指南：数据加密 数据脱敏 背景信息 数据脱敏 YAML 配置方式良好的可读性，通过 YAML 格式，能够快速地理解脱敏规则之间的依赖关系， MASK_BEFORE_SPECIAL_CHARS props: special-chars: '@' replace-char: '*' keep_first_n_last_m_mask: type: KEEP_FIRST_N_LAST_M props: first-n: 3 last-m: 4 replace-char: '*' 然后通过 YamlShardingSphereDataSourceFactory

varchar(10), w_street_1 varchar(20), w_street_2 varchar(20), w_city varchar(20), w_state char(2), w_zip char(9) ); create table bmsql_district ( d_w_id integer not null, d_id integer not null, d_ytd varchar(20), d_state char(2), d_zip char(9) ); create table bmsql_customer ( c_w_id integer not null, c_d_id integer not null, c_id integer not null, c_discount decimal(4,4), c_credit char(2), c_last varchar(16) varchar(20), c_street_2 varchar(20), c_city varchar(20), c_state char(2), c_zip char(9), c_phone char(16), c_since timestamp, c_middle char(2), c_data varchar(500) ); create sequence bmsql_hist_id_seq;

varchar(10), w_street_1 varchar(20), w_street_2 varchar(20), w_city varchar(20), w_state char(2), w_zip char(9) ); create table bmsql_district ( d_w_id integer not null, d_id integer not null, d_ytd varchar(20), d_state char(2), d_zip char(9) ); create table bmsql_customer ( c_w_id integer not null, c_d_id integer not null, c_id integer not null, c_discount decimal(4,4), c_credit char(2), c_last varchar(16) varchar(20), c_street_2 varchar(20), c_city varchar(20), c_state char(2), c_zip char(9), c_phone char(16), c_since timestamp, c_middle char(2), c_data varchar(500) ); create sequence bmsql_hist_id_seq;

runoob_tbl(runoob_id INT UNSIGNED AUTO_INCREMENT,runoob_title VAR‐ CHAR(100) NOT NULL,runoob_author VARCHAR(40) NOT NULL,runoob_test NATIONAL CHAR(40),submission_date DATE,PRIMARY KEY (runoob_id))ENGINE=InnoDB runoob_id INT UNSIGNED AUTO_INCREMENT, runoob_title VAR‐ CHAR(100) NOT NULL, runoob_author VARCHAR(40) NOT NULL , runoob_test NATIONAL CHAR(40), submission_date DATE, PRIMARY KEY (runoob_id)) `id` bigint(20) NOT NULL AUTO_INCREMENT, `k` int(11) NOT NULL DEFAULT 0, `c` char(120) NOT NULL DEFAULT '', `pad` char(60) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ); 测试场景配置 ShardingSphere‐JDBC 使用与

runoob_id INT UNSIGNED AUTO_INCREMENT, runoob_title VAR‐ CHAR(100) NOT NULL, runoob_author VARCHAR(40) NOT NULL, runoob_test NATIONAL CHAR(40), submission_date DATE, PRIMARY KEY (runoob_id)) `id` bigint(20) NOT NULL AUTO_INCREMENT, `k` int(11) NOT NULL DEFAULT 0, `c` char(120) NOT NULL DEFAULT '', `pad` char(60) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ); 测试场景配置 ShardingSphere‐JDBC 使用与 varchar(10), w_street_1 varchar(20), w_street_2 varchar(20), w_city varchar(20), w_state char(2), w_zip char(9) ); create table bmsql_district ( d_w_id integer not null, d_id integer not null, d_ytd

varchar(10), w_street_1 varchar(20), w_street_2 varchar(20), w_city varchar(20), w_state char(2), w_zip char(9) ); create table bmsql_district ( d_w_id integer not null, d_id integer not null, d_ytd varchar(20), d_state char(2), d_zip char(9) ); create table bmsql_customer ( c_w_id integer not null, c_d_id integer not null, c_id integer not null, c_discount decimal(4,4), c_credit char(2), c_last varchar(16) varchar(20), c_street_2 varchar(20), c_city varchar(20), c_state char(2), c_zip char(9), c_phone char(16), c_since timestamp, c_middle char(2), c_data varchar(500) ); create sequence bmsql_hist_id_seq;