Spring Boot 注解加密隐私信息

时间:2020-02-24 17:37:17   收藏:0   阅读:87
1、注解字段:
@Column(name = "phone", length = 100)
@ColumnTransformer(read = "AES_DECRYPT(UNHEX(phone), ‘aes_phone‘)", write = "HEX(AES_ENCRYPT(?, ‘aes_phone‘))")
private String phone;
2、原生SQL 查询加密数据:
SELECT AES_DECRYPT(UNHEX(s.phone),‘aes_phone‘) FROM TABLSE s

原文:https://blog.51cto.com/7218743/2473269

评论(0
© 2014 bubuko.com 版权所有 - 联系我们:wmxa8@hotmail.com
打开技术之扣,分享程序人生!