\u4e00\u3001\u80cc\u666f<\/h2>\n
\u5728\u6211\u4eec\u6570\u636e\u5e93\u4e2d\u6709\u4e9b\u65f6\u5019\u4f1a\u4fdd\u5b58\u4e00\u4e9b\u7528\u6237\u7684\u654f\u611f\u4fe1\u606f\uff0c\u6bd4\u5982\uff1a\u624b\u673a\u53f7\u3001\u94f6\u884c\u5361\u7b49\u4fe1\u606f\uff0c\u5982\u679c\u8fd9\u4e9b\u4fe1\u606f\u4ee5\u660e\u6587\u7684\u65b9\u5f0f\u4fdd\u5b58\uff0c\u90a3\u4e48\u662f\u4e0d\u5b89\u5168\u7684\u3002\u5047\u5982\uff1a\u9ed1\u5ba2\u9ed1\u8fdb\u4e86\u6570\u636e\u5e93\uff0c\u6216\u8005\u79bb\u804c\u4eba\u5458\u5bfc\u51fa\u4e86\u6570\u636e\uff0c\u90a3\u4e48\u5c31\u53ef\u80fd\u5bfc\u81f4\u8fd9\u4e9b\u654f\u611f\u6570\u636e\u7684\u6cc4\u6f0f\u3002\u56e0\u6b64\u6211\u4eec\u5c31\u9700\u8981\u627e\u5230\u4e00\u79cd\u65b9\u6cd5\u6765\u89e3\u51b3\u8fd9\u4e2a\u95ee\u9898\u3002<\/p>\n
\u4e8c\u3001\u89e3\u51b3\u65b9\u6848<\/h2>\n
\u7531\u4e8e\u6211\u4eec\u7cfb\u7edf\u4e2d\u4f7f\u7528\u4e86Mybatis\u4f5c\u4e3a\u6570\u636e\u5e93\u6301\u4e45\u5c42\uff0c\u56e0\u6b64\u51b3\u5b9a\u4f7f\u7528Mybatis\u7684TypeHandler\u6216Plugin\u6765\u89e3\u51b3\u3002<\/p>\n
TypeHandler<\/strong> : \u9700\u8981\u6211\u4eec\u5728\u67d0\u4e9b\u5217\u4e0a\u624b\u52a8\u6307\u5b9a typeHandler \u6765\u9009\u62e9\u4f7f\u7528\u90a3\u4e2atypeHandler\u6216\u8005\u6839\u636e Plugin<\/strong> : \u53ef\u4ee5\u62e6\u622a\u7cfb\u7edf\u4e2d\u7684 select\u3001insert\u3001update\u3001delete\u7b49\u8bed\u53e5\uff0c\u4e5f\u80fd\u83b7\u53d6\u5230sql\u6267\u884c\u524d\u7684\u53c2\u6570\u548c\u6267\u884c\u540e\u7684\u6570\u636e\u3002<\/p>\n \u7ecf\u8fc7\u8003\u8651\uff0c\u51b3\u5b9a\u4f7f\u7528TypeHandler\u6765\u52a0\u89e3\u5bc6\u6570\u636e\u3002<\/p>\n \u63a8\u8350\u4e00\u4e2a Spring Boot \u57fa\u7840\u6559\u7a0b\u53ca\u5b9e\u6218\u793a\u4f8b\uff1a<\/p>\n https:\/\/github.com\/javastacks…<\/a><\/p><\/blockquote>\n \u6211\u4eec\u6709\u4e00\u5f20\u5ba2\u6237\u8868customer\uff0c\u91cc\u9762\u6709\u5ba2\u6237\u624b\u673a\u53f7(phone)\u548c\u5ba2\u6237\u5730\u5740(address)\u7b49\u5b57\u6bb5\uff0c\u5176\u4e2d\u5ba2\u6237\u624b\u673a\u53f7(phone)\u662f\u9700\u8981\u52a0\u5bc6\u4fdd\u5b58\u5230\u6570\u636e\u5e93\u4e2d\u7684\u3002<\/p>\n 1\u3001\u5728\u6dfb\u52a0\u5ba2\u6237\u4fe1\u606f\u65f6\uff0c\u81ea\u52a8\u5c06\u5ba2\u6237\u624b\u673a\u53f7\u52a0\u5bc6\u4fdd\u5b58\u5230\u6570\u636e\u4e2d\u3002<\/p>\n 2\u3001\u5728\u67e5\u8be2\u5ba2\u6237\u4fe1\u606f\u65f6\uff0c\u81ea\u52a8\u89e3\u5bc6\u5ba2\u6237\u624b\u673a\u53f7\u3002<\/p>\n 1\u3001\u7f16\u5199\u4e00\u4e2a\u5b9e\u4f53\u7c7b\uff0c\u51e1\u662f\u6b64\u5b9e\u4f53\u7c7b\u7684\u6570\u636e\u90fd\u8868\u793a\u9700\u8981\u52a0\u89e3\u5bc6\u7684<\/strong><\/p>\n 2\u3001\u7f16\u5199\u4e00\u4e2a\u52a0\u89e3\u5bc6\u7684TypeHandler<\/strong><\/p>\n \u6ce8\u610f\u26a0\ufe0f\uff1a<\/p>\n 3\u3001sql\u8bed\u53e5\u4e2d\u5199\u6cd5<\/strong><\/p>\n SQL\u4e2d\u6ca1\u6709\u4ec0\u4e48\u7279\u6b8a\u7684\u5199\u6cd5\u3002<\/p>\n 4\u3001\u914d\u7f6e\u6587\u4ef6\u4e2d\u6307\u5b9aTypehandler\u7684\u5305\u8def\u5f84<\/strong><\/p>\n 5\u3001\u7f16\u5199\u540e\u53f0\u4ee3\u7801<\/strong><\/p>\n \u540e\u53f0\u4ee3\u7801\u6bd4\u8f83\u7b80\u5355\uff0c\u76f4\u63a5\u67e5\u770b\uff1a<\/p>\n \u201c<\/p>\n http:\/\/dw-z.ink\/1s520<\/a><\/p>\n<\/blockquote>\n \u8d34\u4e00\u4e2amapper\u5c42\u7684\u622a\u56fe\u3002<\/p>\n 6\u3001\u6d4b\u8bd5\u7ed3\u679c<\/strong><\/p>\n \u4ece\u6d4b\u8bd5\u7ed3\u679c\u4e2d\u53ef\u77e5\uff0c\u6dfb\u52a0\u6570\u636e\u65f6\uff0c\u9700\u8981\u52a0\u5bc6\u7684\u6570\u636e(phone)\u5728\u6570\u636e\u5e93\u4e2d\u5df2\u7ecf\u52a0\u5bc6\u4e86\uff0c\u5728\u67e5\u8be2\u7684\u65f6\u5019\uff0c\u52a0\u5bc6\u7684\u6570\u636e\u5df2\u7ecf\u81ea\u52a8\u89e3\u5bc6\u4e86\u3002<\/p>\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@MappedJdbcTypes<\/code> \u548c @MappedTypes<\/code>\u6ce8\u89e3\u6765\u81ea\u884c\u63a8\u65ad\u3002<\/p>\n<result column="phone" property="phone"\ntypeHandler="com.huan.study.mybatis.typehandler.EncryptTypeHandler"\/><\/code><\/pre>\n\u4e09\u3001\u9700\u6c42<\/h2>\n
\u56db\u3001\u5b9e\u73b0\u601d\u8def<\/h2>\n
public class Encrypt {\n private String value;\n\n public Encrypt() {\n }\n\n public Encrypt(String value) {\n this.value = value;\n }\n\n public String getValue() {\n return value;\n }\n\n public void setValue(String value) {\n this.value = value;\n }\n}<\/code><\/pre>\n\n
package com.huan.study.mybatis.typehandler;\n\nimport cn.hutool.crypto.SecureUtil;\nimport cn.hutool.crypto.symmetric.AES;\nimport org.apache.ibatis.type.BaseTypeHandler;\nimport org.apache.ibatis.type.JdbcType;\nimport org.apache.ibatis.type.MappedJdbcTypes;\nimport org.apache.ibatis.type.MappedTypes;\n\nimport java.nio.charset.StandardCharsets;\nimport java.sql.CallableStatement;\nimport java.sql.PreparedStatement;\nimport java.sql.ResultSet;\nimport java.sql.SQLException;\n\n\/**\n * \u52a0\u89e3\u5bc6TypeHandler\n *\n * @author huan.fu 2021\/5\/18 - \u4e0a\u53489:20\n *\/\n@MappedJdbcTypes(JdbcType.VARCHAR)\n@MappedTypes(Encrypt.class)\npublic class EncryptTypeHandler extends BaseTypeHandler<Encrypt> {\n\n private static final byte[] KEYS = "12345678abcdefgh".getBytes(StandardCharsets.UTF_8);\n\n \/**\n * \u8bbe\u7f6e\u53c2\u6570\n *\/\n @Override\n public void setNonNullParameter(PreparedStatement ps, int i, Encrypt parameter, JdbcType jdbcType) throws SQLException {\n if (parameter == null || parameter.getValue() == null) {\n ps.setString(i, null);\n return;\n }\n AES aes = SecureUtil.aes(KEYS);\n String encrypt = aes.encryptHex(parameter.getValue());\n ps.setString(i, encrypt);\n }\n\n \/**\n * \u83b7\u53d6\u503c\n *\/\n @Override\n public Encrypt getNullableResult(ResultSet rs, String columnName) throws SQLException {\n return decrypt(rs.getString(columnName));\n }\n\n \/**\n * \u83b7\u53d6\u503c\n *\/\n @Override\n public Encrypt getNullableResult(ResultSet rs, int columnIndex) throws SQLException {\n return decrypt(rs.getString(columnIndex));\n }\n\n \/**\n * \u83b7\u53d6\u503c\n *\/\n @Override\n public Encrypt getNullableResult(CallableStatement cs, int columnIndex) throws SQLException {\n return decrypt(cs.getString(columnIndex));\n }\n\n public Encrypt decrypt(String value) {\n if (null == value) {\n return null;\n }\n return new Encrypt(SecureUtil.aes(KEYS).decryptStr(value));\n }\n}<\/code><\/pre>\n\n
@MappedTypes<\/code>\uff1a\u8868\u793a\u8be5\u5904\u7406\u5668\u5904\u7406\u7684java\u7c7b\u578b\u662f\u4ec0\u4e48\u3002<\/li>\n@MappedJdbcTypes<\/code>\uff1a\u8868\u793a\u5904\u7406\u5668\u5904\u7406\u7684Jdbc\u7c7b\u578b\u3002<\/li>\n<\/ul>\n<?xml version="1.0" encoding="UTF-8"?>\n<!DOCTYPE mapper PUBLIC "-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN" "http:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd">\n<mapper namespace="com.huan.study.mybatis.mappers.CustomerMapper">\n\n <resultMap id="BaseResultMapper" type="com.huan.study.mybatis.entity.Customer">\n <id column="id" property="id"\/>\n <result column="phone" property="phone"\/>\n <result column="address" property="address"\/>\n <\/resultMap>\n\n <insert id="addCustomer">\n insert into customer(phone,address) values (#{phone},#{address})\n <\/insert>\n\n <select id="findCustomer" resultMap="BaseResultMapper">\n select * from customer where phone = #{phone}\n <\/select>\n\n<\/mapper><\/code><\/pre>\nmybatis.type-handlers-package=com.huan.study.mybatis.typehandler<\/code><\/pre>\n\n
\n
<\/p>\n
<\/p>\n