{"id":10006892,"date":"2022-11-22T17:28:08","date_gmt":"2022-11-22T09:28:08","guid":{"rendered":"https:\/\/ityet.com\/?p=10006892"},"modified":"2022-11-22T17:28:08","modified_gmt":"2022-11-22T09:28:08","slug":"%e6%95%b0%e6%8d%ae%e8%84%b1%e6%95%8f%e7%9a%84-3-%e7%a7%8d%e5%b8%b8%e8%a7%81%e6%96%b9%e6%a1%88%ef%bc%8c%e5%a5%bd%e7%94%a8%e5%88%b0%e7%88%86%ef%bc%81","status":"publish","type":"post","link":"https:\/\/itmax.cn\/?p=10006892","title":{"rendered":"\u6570\u636e\u8131\u654f\u7684 3 \u79cd\u5e38\u89c1\u65b9\u6848\uff0c\u597d\u7528\u5230\u7206\uff01"},"content":{"rendered":"

\u6765\u6e90\uff1ablog.csdn.net\/weixin_61594803<\/p>\n

1.SQL\u6570\u636e\u8131\u654f\u5b9e\u73b0<\/h3>\n

MYSQL(\u7535\u8bdd\u53f7\u7801,\u8eab\u4efd\u8bc1)\u6570\u636e\u8131\u654f\u7684\u5b9e\u73b0<\/p>\n

-- CONCAT()\u3001LEFT()\u548cRIGHT()\u5b57\u7b26\u4e32\u51fd\u6570\u7ec4\u5408\u4f7f\u7528\uff0c\u8bf7\u770b\u4e0b\u9762\u5177\u4f53\u5b9e\u73b0\n\n-- CONCAT(str1,str2,\u2026)\uff1a\u8fd4\u56de\u7ed3\u679c\u4e3a\u8fde\u63a5\u53c2\u6570\u4ea7\u751f\u7684\u5b57\u7b26\u4e32\n-- LEFT(str,len)\uff1a\u8fd4\u56de\u4ece\u5b57\u7b26\u4e32str \u5f00\u59cb\u7684len \u6700\u5de6\u5b57\u7b26\n-- RIGHT(str,len)\uff1a\u4ece\u5b57\u7b26\u4e32str \u5f00\u59cb\uff0c\u8fd4\u56de\u6700\u53f3len \u5b57\u7b26\n\n-- \u7535\u8bdd\u53f7\u7801\u8131\u654fsql\uff1a\n\nSELECT mobilePhone AS \u8131\u654f\u524d\u7535\u8bdd\u53f7\u7801,CONCAT(LEFT(mobilePhone,3), '********' ) AS \u8131\u654f\u540e\u7535\u8bdd\u53f7\u7801 FROM t_s_user\n\n-- \u8eab\u4efd\u8bc1\u53f7\u7801\u8131\u654fsql:\n\nSELECT idcard AS \u672a\u8131\u654f\u8eab\u4efd\u8bc1, CONCAT(LEFT(idcard,3), '****' ,RIGHT(idcard,4)) AS \u8131\u654f\u540e\u8eab\u4efd\u8bc1\u53f7 FROM t_s_user<\/code><\/pre>\n
2.JAVA\u6570\u636e\u8131\u654f\u5b9e\u73b0<\/h3>\n
\u53ef\u53c2\u8003\uff1a\u6d77\u5f3a \/ sensitive-plus<\/p>\n
https:\/\/gitee.com\/strong_sea\/…<\/a><\/p><\/blockquote>\n
\u6570\u636e\u8131\u654f\u63d2\u4ef6\uff0c\u76ee\u524d\u652f\u6301\u5730\u5740\u8131\u654f\u3001\u94f6\u884c\u5361\u53f7\u8131\u654f\u3001\u4e2d\u6587\u59d3\u540d\u8131\u654f\u3001\u56fa\u8bdd\u8131\u654f\u3001\u8eab\u4efd\u8bc1\u53f7\u8131\u654f\u3001\u624b\u673a\u53f7\u8131\u654f\u3001\u5bc6\u7801\u8131\u654f \u4e00\u4e2a\u662f\u6b63\u5219\u8131\u654f\u3001\u53e6\u5916\u4e00\u4e2a\u6839\u636e\u663e\u793a\u957f\u5ea6\u8131\u654f\uff0c\u9ed8\u8ba4\u662f\u6b63\u5219\u8131\u654f\uff0c\u53ef\u4ee5\u6839\u636e\u81ea\u5df1\u7684\u9700\u8981\u914d\u7f6e\u81ea\u5df1\u7684\u89c4\u5219\u3002<\/p>\n
3.mybatis-mate-sensitive-jackson<\/h3>\n
mybatisplus \u7684\u65b0\u4f5c\uff0c\u53ef\u4ee5\u6d4b\u8bd5\u4f7f\u7528\uff0c\u751f\u4ea7\u9700\u8981\u6536\u8d39\u3002<\/p>\n
\u6839\u636e\u5b9a\u4e49\u7684\u7b56\u7565\u7c7b\u578b\uff0c\u5bf9\u6570\u636e\u8fdb\u884c\u8131\u654f\uff0c\u5f53\u7136\u7b56\u7565\u53ef\u4ee5\u81ea\u5b9a\u4e49\u3002<\/p>\n
# \u76ee\u524d\u5df2\u6709\npackage mybatis.mate.strategy;\n\npublic interface SensitiveType {\n    String chineseName = "chineseName";\n    String idCard = "idCard";\n    String phone = "phone";\n    String mobile = "mobile";\n    String address = "address";\n    String email = "email";\n    String bankCard = "bankCard";\n    String password = "password";\n    String carNumber = "carNumber";\n}<\/code><\/pre>\n
Demo \u4ee3\u7801\u76ee\u5f55<\/p>\n
\"\"<\/p>\n
Spring Boot \u57fa\u7840\u5c31\u4e0d\u4ecb\u7ecd\u4e86\uff0c\u63a8\u8350\u770b\u8fd9\u4e2a\u514d\u8d39\u6559\u7a0b\uff1a<\/p>\n
https:\/\/github.com\/javastacks\/spring-boot-best-practice<\/a><\/p><\/blockquote>\n
1\u3001pom.xml<\/p>\n
<?xml version="1.0" encoding="UTF-8"?>\n<project xmlns="http:\/\/maven.apache.org\/POM\/4.0.0" xmlns:xsi="http:\/\/www.w3.org\/2001\/XMLSchema-instance"\n         xsi:schemaLocation="http:\/\/maven.apache.org\/POM\/4.0.0 http:\/\/maven.apache.org\/xsd\/maven-4.0.0.xsd">\n    <parent>\n        <groupId>com.baomidou<\/groupId>\n        <artifactId>mybatis-mate-examples<\/artifactId>\n        <version>0.0.1-SNAPSHOT<\/version>\n    <\/parent>\n    <modelVersion>4.0.0<\/modelVersion>\n    <artifactId>mybatis-mate-sensitive-jackson<\/artifactId>\n    <dependencies>\n        <dependency>\n            <groupId>mysql<\/groupId>\n            <artifactId>mysql-connector-java<\/artifactId>\n        <\/dependency>\n    <\/dependencies>\n\n<\/project><\/code><\/pre>\n
2\u3001appliation.yml<\/p>\n
# DataSource Config\nspring:\n  datasource:\n#    driver-class-name: org.h2.Driver\n#    schema: classpath:db\/schema-h2.sql\n#    data: classpath:db\/data-h2.sql\n#    url: jdbc:h2:mem:test\n#    username: root\n#    password: test\n    driver-class-name: com.mysql.cj.jdbc.Driver\n    url: jdbc:mysql:\/\/localhost:3306\/mybatis_mate?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC\n    username: root\n    password: 123456\n# Mybatis Mate \u914d\u7f6e\nmybatis-mate:\n  cert:\n    # \u8bf7\u6dfb\u52a0\u5fae\u4fe1wx153666\u8d2d\u4e70\u6388\u6743\uff0c\u4e0d\u767d\u5ad6\u4ece\u6211\u505a\u8d77\uff01 \u6d4b\u8bd5\u8bc1\u4e66\u4f1a\u5931\u6548\uff0c\u8bf7\u52ff\u6b63\u5f0f\u73af\u5883\u4f7f\u7528\n    grant: thisIsTestLicense\n    license: as\/bsBaSVrsA9FfjC\/N77ruEt2\/QZDrW+MHETNuEuZBra5mlaXZU+DE1ZvF8UjzlLCpH3TFVH3WPV+Ya7Ugiz1Rx4wSh\/FK6Ug9lhos7rnsNaRB\/+mR30aXqtlLt4dAmLAOCT56r9mikW+t1DDJY8TVhERWMjEipbqGO9oe1fqYCegCEX8tVCpToKr5J1g1V86mNsNnEGXujnLlEw9jBTrGxAyQroD7Ns1Dhwz1K4Y188mvmRQp9t7OYrpgsC7N9CXq1s1c2GtvfItHArkqHE4oDrhaPjpbMjFWLI5\/XqZDtW3D+AVcH7pTcYZn6vzFfDZEmfDFV5fQlT3Rc+GENEg==\n\n# Logger Config\nlogging:\n  level:\n    mybatis.mate: debug<\/code><\/pre>\n
3\u3001Appliation\u542f\u52a8\u7c7b<\/p>\n
package mybatis.mate.sensitive.jackson;\n\nimport org.springframework.boot.SpringApplication;\nimport org.springframework.boot.autoconfigure.SpringBootApplication;\n\n@SpringBootApplication\npublic class SensitiveJacksonApplication {\n\n    \/\/ \u6d4b\u8bd5\u8bbf\u95ee http:\/\/localhost:8080\/info \uff0chttp:\/\/localhost:8080\/list\n    public static void main(String[] args) {\n        SpringApplication.run(SensitiveJacksonApplication.class, args);\n    }\n}<\/code><\/pre>\n
4\u3001\u914d\u7f6e\u7c7b\uff0c\u81ea\u5b9a\u4e49\u8131\u654f\u7b56\u7565<\/p>\n
package mybatis.mate.sensitive.jackson.config;\n\nimport mybatis.mate.databind.ISensitiveStrategy;\nimport mybatis.mate.strategy.SensitiveStrategy;\nimport org.springframework.context.annotation.Bean;\nimport org.springframework.context.annotation.Configuration;\n\n@Configuration\npublic class SensitiveStrategyConfig {\n\n    \/**\n     * \u6ce8\u5165\u8131\u654f\u7b56\u7565\n     *\/\n    @Bean\n    public ISensitiveStrategy sensitiveStrategy() {\n        \/\/ \u81ea\u5b9a\u4e49 testStrategy \u7c7b\u578b\u8131\u654f\u5904\u7406\n        return new SensitiveStrategy().addStrategy("testStrategy", t -> t + "***test***");\n    }\n}<\/code><\/pre>\n
5\u3001\u4e1a\u52a1\u7c7b<\/p>\n
User\uff0c\u6ce8\u89e3\u6807\u8bc6\u8131\u654f\u5b57\u6bb5\uff0c\u53ca\u9009\u7528\u8131\u654f\u7b56\u7565<\/p>\n
package mybatis.mate.sensitive.jackson.entity;\n\nimport lombok.Getter;\nimport lombok.Setter;\nimport mybatis.mate.annotation.FieldSensitive;\nimport mybatis.mate.sensitive.jackson.config.SensitiveStrategyConfig;\nimport mybatis.mate.strategy.SensitiveType;\n\n@Getter\n@Setter\npublic class User {\n    private Long id;\n    \/**\n     * \u8fd9\u91cc\u662f\u4e00\u4e2a\u81ea\u5b9a\u4e49\u7684\u7b56\u7565 {@link SensitiveStrategyConfig} \u521d\u59cb\u5316\u6ce8\u5165\n     *\/\n    @FieldSensitive("testStrategy")\n    private String username;\n    \/**\n     * \u9ed8\u8ba4\u652f\u6301\u7b56\u7565 {@link SensitiveType }\n     *\/\n    @FieldSensitive(SensitiveType.mobile)\n    private String mobile;\n    @FieldSensitive(SensitiveType.email)\n    private String email;\n\n}<\/code><\/pre>\n
UserController<\/p>\n
package mybatis.mate.sensitive.jackson.controller;\n\nimport mybatis.mate.databind.ISensitiveStrategy;\nimport mybatis.mate.databind.RequestDataTransfer;\nimport mybatis.mate.sensitive.jackson.entity.User;\nimport mybatis.mate.sensitive.jackson.mapper.UserMapper;\nimport mybatis.mate.strategy.SensitiveType;\nimport org.springframework.beans.factory.annotation.Autowired;\nimport org.springframework.web.bind.annotation.GetMapping;\nimport org.springframework.web.bind.annotation.RestController;\n\nimport javax.servlet.http.HttpServletRequest;\nimport java.util.HashMap;\nimport java.util.List;\nimport java.util.Map;\n\n@RestController\npublic class UserController {\n    @Autowired\n    private UserMapper userMapper;\n    @Autowired\n    private ISensitiveStrategy sensitiveStrategy;\n\n    \/\/ \u6d4b\u8bd5\u8bbf\u95ee http:\/\/localhost:8080\/info\n    @GetMapping("\/info")\n    public User info() {\n        return userMapper.selectById(1L);\n    }\n\n    \/\/ \u6d4b\u8bd5\u8fd4\u56de map \u8bbf\u95ee http:\/\/localhost:8080\/map\n    @GetMapping("\/map")\n    public Map<String, Object> map() {\n        \/\/ \u6d4b\u8bd5\u5d4c\u5957\u5bf9\u8c61\u8131\u654f\n        Map<String, Object> userMap = new HashMap<>();\n        userMap.put("user", userMapper.selectById(1L));\n        userMap.put("test", 123);\n        userMap.put("userMap", new HashMap<String, Object>() {{\n            put("user2", userMapper.selectById(2L));\n            put("test2", "hi china");\n        }});\n        \/\/ \u624b\u52a8\u8c03\u7528\u7b56\u7565\u8131\u654f\n        userMap.put("mobile", sensitiveStrategy.getStrategyFunctionMap()\n                .get(SensitiveType.mobile).apply("15315388888"));\n        return userMap;\n    }\n\n    \/\/ \u6d4b\u8bd5\u8bbf\u95ee http:\/\/localhost:8080\/list\n    \/\/ \u4e0d\u8131\u654f http:\/\/localhost:8080\/list?skip=1\n    @GetMapping("\/list")\n    public List<User> list(HttpServletRequest request) {\n        if ("1".equals(request.getParameter("skip"))) {\n            \/\/ \u8df3\u8fc7\u8131\u5bc6\u5904\u7406\n            RequestDataTransfer.skipSensitive();\n        }\n        return userMapper.selectList(null);\n    }\n}<\/code><\/pre>\n
UserMapper<\/p>\n
package mybatis.mate.sensitive.jackson.mapper;\n\nimport com.baomidou.mybatisplus.core.mapper.BaseMapper;\nimport mybatis.mate.sensitive.jackson.entity.User;\nimport org.apache.ibatis.annotations.Mapper;\n\n@Mapper\npublic interface UserMapper extends BaseMapper<User> {\n\n}<\/code><\/pre>\n
6\u3001\u6d4b\u8bd5<\/p>\n
GET http:\/\/localhost:8080\/list<\/a><\/p>\n
[\n  {\n    "id": 1,\n    "username": "Jone***test***",\n    "mobile": "153******81",\n    "email": "t****@baomidou.com"\n  },\n  {\n    "id": 2,\n    "username": "Jack***test***",\n    "mobile": "153******82",\n    "email": "t****@baomidou.com"\n  },\n  {\n    "id": 3,\n    "username": "Tom***test***",\n    "mobile": "153******83",\n    "email": "t****@baomidou.com"\n  }\n]<\/code><\/pre>\n
GET http:\/\/localhost:8080\/list?sk…<\/a><\/p>\n
[\n  {\n    "id": 1,\n    "username": "Jone",\n    "mobile": "15315388881",\n    "email": "test1@baomidou.com"\n  },\n  {\n    "id": 2,\n    "username": "Jack",\n    "mobile": "15315388882",\n    "email": "test2@baomidou.com"\n  },\n  {\n    "id": 3,\n    "username": "Tom",\n    "mobile": "15315388883",\n    "email": "test3@baomidou.com"\n  }\n]<\/code><\/pre>\n
\u8fd1\u671f\u70ed\u6587\u63a8\u8350\uff1a<\/strong><\/p>\n
1.1,000+ \u9053 Java\u9762\u8bd5\u9898\u53ca\u7b54\u6848\u6574\u7406(2022\u6700\u65b0\u7248)<\/a><\/p>\n
2.\u52b2\u7206\uff01Java \u534f\u7a0b\u8981\u6765\u4e86\u3002\u3002\u3002<\/a><\/p>\n
3.Spring Boot 2.x \u6559\u7a0b\uff0c\u592a\u5168\u4e86\uff01<\/a><\/p>\n
4.\u522b\u518d\u5199\u6ee1\u5c4f\u7684\u7206\u7206\u7206\u70b8\u7c7b\u4e86\uff0c\u8bd5\u8bd5\u88c5\u9970\u5668\u6a21\u5f0f\uff0c\u8fd9\u624d\u662f\u4f18\u96c5\u7684\u65b9\u5f0f\uff01\uff01<\/a><\/p>\n
5.\u300aJava\u5f00\u53d1\u624b\u518c\uff08\u5d69\u5c71\u7248\uff09\u300b\u6700\u65b0\u53d1\u5e03\uff0c\u901f\u901f\u4e0b\u8f7d\uff01<\/a><\/p>\n
\u89c9\u5f97\u4e0d\u9519\uff0c\u522b\u5fd8\u4e86\u968f\u624b\u70b9\u8d5e+\u8f6c\u53d1\u54e6\uff01<\/p>\n
https:\/\/segmentfault.com\/a\/1190000042861260<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
\u6765\u6e90\uff1ablog.csdn.net\/weixin_61594803 1.SQL\u6570\u636e\u8131\u654f\u5b9e\u73b0 MYSQL(\u7535\u8bdd\u53f7\u7801 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-10006892","post","type-post","status-publish","format-standard","hentry","category-share"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/posts\/10006892","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/itmax.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=10006892"}],"version-history":[{"count":0,"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/posts\/10006892\/revisions"}],"wp:attachment":[{"href":"https:\/\/itmax.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10006892"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itmax.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10006892"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itmax.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10006892"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}