From b1097dce55d857ae1ae63798911c1e7027c00de4 Mon Sep 17 00:00:00 2001 From: chenjiahe <763432473@qq.com> Date: 星期五, 28 一月 2022 14:55:11 +0800 Subject: [PATCH] Mysql数据库AES加密工具 --- src/main/java/com/hx/mybatis/aes/springbean/SqlUtils.java | 8 ++++---- 1 files changed, 4 insertions(+), 4 deletions(-) diff --git a/src/main/java/com/hx/mybatis/aes/springbean/SqlUtils.java b/src/main/java/com/hx/mybatis/aes/springbean/SqlUtils.java index b9261b6..fe8e437 100644 --- a/src/main/java/com/hx/mybatis/aes/springbean/SqlUtils.java +++ b/src/main/java/com/hx/mybatis/aes/springbean/SqlUtils.java @@ -138,7 +138,7 @@ }else{ tableAl = column.getName(); } - sql = sql.replaceAll("\\b((?<!\\.)"+tableAl+"(?!\\.))\\b","AES_DECRYPT(UNHEX("+tableAl+"),'"+aeskey+"')"); + sql = sql.replaceAll("((?<!\\.)\\b"+tableAl+"\\b(?!\\.))","AES_DECRYPT(UNHEX("+tableAl+"),'"+aeskey+"')"); } } return sqlSelect.toString()+sql; @@ -247,7 +247,7 @@ }else{ tableAl = column.getName(); } - sql = sql.replaceAll("\\b((?<!\\.)"+tableAl+"(?!\\.))\\b","AES_DECRYPT(UNHEX("+tableAl+"),'"+aeskey+"')"); + sql = sql.replaceAll("((?<!\\.)\\b"+tableAl+"\\b(?!\\.))","AES_DECRYPT(UNHEX("+tableAl+"),'"+aeskey+"')"); } } return sqlSelect.toString()+sql; @@ -411,7 +411,7 @@ }else{ tableAl = column.getName(); } - sqlWhere = sqlWhere.replaceAll("\\b((?<!\\.)"+tableAl+"(?!\\.))\\b","AES_DECRYPT(UNHEX("+tableAl+"),'"+aeskey+"')"); + sqlWhere = sqlWhere.replaceAll("((?<!\\.)\\b"+tableAl+"\\b(?!\\.))","AES_DECRYPT(UNHEX("+tableAl+"),'"+aeskey+"')"); } } @@ -489,7 +489,7 @@ }else{ tableAl = column.getName(); } - sqlWhere = sqlWhere.replaceAll("\\b((?<!\\.)"+tableAl+"(?!\\.))\\b","AES_DECRYPT(UNHEX("+tableAl+"),'"+aeskey+"')"); + sqlWhere = sqlWhere.replaceAll("((?<!\\.)\\b"+tableAl+"\\b(?!\\.))","AES_DECRYPT(UNHEX("+tableAl+"),'"+aeskey+"')"); } } -- Gitblit v1.8.0