# 数据脱敏示例

本示例主要介绍数据脱敏组件的使用。

主要步骤如下：

准备数据
新建批量作业
画布中拖拽关系型数据库输入、数据脱敏、写日志图元
配置"关系型数据库输入"组件属性
配置"数据脱敏"组件属性
配置"写日志"组件属性
通用配置
运行
提交版本

# 准备数据

创建表 userinfo_idcard作为来源表。

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for userinfo_idcard
-- ----------------------------
DROP TABLE IF EXISTS `userinfo_idcard`;
CREATE TABLE `userinfo_idcard`  (
  `usercode` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户编码',
  `username` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户姓名',
  `idcard` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '身份证号',
  `sex` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别',
  `age` int(11) NULL DEFAULT NULL COMMENT '年龄',
  `unitcode` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属单位',
  `deptcode` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属部门',
  `telephone` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系方式',
  `createtime` date NULL DEFAULT NULL COMMENT '创建时间',
  `updatetime` date NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`usercode`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of userinfo_idcard
-- ----------------------------
INSERT INTO `userinfo_idcard` VALUES ('1', '张聪', '110101199001011990', '男', 30, '普元信息', '技术部', '18091256632', '2018-12-13', '2018-12-13');
INSERT INTO `userinfo_idcard` VALUES ('10', '王林', '120103200506163498', '男', 25, '普元信息', '技术部', '15901214578', '2018-12-13', '2018-12-13');
INSERT INTO `userinfo_idcard` VALUES ('101', '张三', '110101199001013195', '男', 35, '普元', '技术部', '11112222999', '2019-01-01', '2023-03-12');
INSERT INTO `userinfo_idcard` VALUES ('2', '王强', '130302199305141517', '男', 25, '普元信息', '售后', '15389012334', '2018-12-13', '2018-12-13');
INSERT INTO `userinfo_idcard` VALUES ('3', '魏雨', '130302199305141082', '女', 26, '普元信息', '售后', '15309872351', '2018-12-13', '2018-12-13');
INSERT INTO `userinfo_idcard` VALUES ('4', '刘飞', '450421200007167799', '男', 25, '普元信息', '事业部', '15091345789', '2018-12-13', '2019-12-13');
INSERT INTO `userinfo_idcard` VALUES ('5', '许馨', '21020219820216840X', '女', 25, '普元信息', '售后', '13090012019', '2018-12-13', '2023-12-18');
INSERT INTO `userinfo_idcard` VALUES ('6', '蔡亮', '120103200506164191', '男', 24, '普元信息', '技术部', '19081234789', '2018-12-13', '2020-12-13');
INSERT INTO `userinfo_idcard` VALUES ('7', '张强', '450421200506166854', '男', 27, '普元信息', '事业部', '19087652123', '2018-12-13', '2018-12-13');
INSERT INTO `userinfo_idcard` VALUES ('8', '杨孟', '632322199403286619', '男', 30, '普元信息', '事业部', '18790123567', '2018-12-13', '2023-11-14');
INSERT INTO `userinfo_idcard` VALUES ('9', '李建国', '63232219950328707X', '男', 50, '普元信息', '技术部', '15998760132', '2018-12-13', '2018-12-13');

SET FOREIGN_KEY_CHECKS = 1;