ChenJiaHe
2022-01-23 7c10d91a91e86122706699a1ee73793b5bafaa06
mysql自动化加密,优化匹配查询条件
1个文件已修改
8 ■■■■ 已修改文件
src/main/java/com/hx/mybatis/aes/springbean/SqlUtils.java 8 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
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+"')");
            }
        }