mybatis数据加解密

最新推荐文章于 2024-09-29 11:28:13 发布

Singularity_Wu

最新推荐文章于 2024-09-29 11:28:13 发布

阅读量1k

点赞数

分类专栏：数据库学习

本文链接：https://blog.csdn.net/SNOW_wu/article/details/90213055

版权

数据库学习专栏收录该内容

2 篇文章 0 订阅

订阅专栏

<sql id="getKey">
      '${@com.xx.xxx.xx.xx.utils.AesUtil@getKey()}'
</sql>

<sql id="Base_Column_List">
  id, name, parent_id, company_id, CONVERT(AES_DECRYPT(FROM_BASE64(phone),<include refid="getKey"/>) USING UTF8) as phone, description, delete_flag, create_by, create_time,
  modified_by, modified_time
</sql>

TO_BASE64(AES_ENCRYPT(#{phone,jdbcType=VARCHAR},<include refid="getKey"/>)),

@Component
@ConfigurationProperties(prefix = "aes")
public class AesUtil {
    private String key;

    private static String aesKey = "";

    public static String getKey() {
        return aesKey;
    }

    public void setKey(String key) {
        this.aesKey = key;
    }

    public static String getAesKey() {
        return aesKey;
    }

    public static void setAesKey(String aesKey) {
        AesUtil.aesKey = aesKey;
    }
}