SQL加密语句

Hana335566

于 2022-04-27 18:54:01 发布

阅读量1.2k

点赞数

文章标签： java 后端

本文链接：https://blog.youkuaiyun.com/Hana335566/article/details/124457887

版权

这个SQL语句展示了如何进行数据库查询，其中包含了加解密操作。查询涉及交易日期、时间、金额、账户余额等关键字段，并使用了特定的加密秘钥进行账户号码和名称的解密。此操作可能在金融或数据安全相关的系统中用于保护敏感客户信息。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SELECT
T.`TRADE_DATE_STR` AS TradeDate,
LPAD(T.`TRADE_TIME_STR`,6,0) AS TradeTime,
null AS CreNo,
T.`REMARKS` AS Message,
T.`TRANS_AMOUNT` AS Amt,
T.`ACCT_BAL` AS Balance,
T.`CRD_FLAG` AS Flag,
CAST(AES_DECRYPT(UNHEX(T.`TARGET_ACCT_NO`), '${@com.gdbbk.datacentre.service.impl.CommonServiceImpl@DATABASE_KEY}') AS char) AS TargetAcctNo,
CAST(AES_DECRYPT(UNHEX(T.`TARGET_ACCT_NAME`), '${@com.gdbbk.datacentre.service.impl.CommonServiceImpl@DATABASE_KEY}') AS char) AS TargetAcctName,
T.`TELLER_SERIAL_NUM` AS TradeId,
null AS BusPayId,
null AS Remark,
null AS Remark1,
null AS Remark2,
null AS Remark3
FROM ${tableName} T
WHERE AES_DECRYPT(UNHEX(CLIENT_ACCT_NO), '${@com.gdbbk.datacentre.service.impl.CommonServiceImpl@DATABASE_KEY}')=#{CLIENT_ACCT_NO,jdbcType=VARCHAR}
AND TRADE_DATE_STR=#{TRADE_TRADE_DATE,jdbcType=VARCHAR};