Ebean手动解密

Question

  @Encrypted
  @Column(columnDefinition="varchar(50)")
  public String password;

注意：我已经将加密字段的datatype设置为varchar而不是binary，如下所示。因此，Ebean可能还会对生成的二进制数据进行十六进制。

class CustomEncryptKey implements EncryptKey{ 

   private String tableName;
   private String columnName;

   public CustomEncryptKey(String tableName, String columnName){
      this.tableName = tableName;
      this.columnName = columnName;
   }

 @Override 
 public String getStringValue() {     
        return "my-encryption-key";     
 }     
}

Answer 1

我设法找出了答案。对于My-SQL

解密：

SELECT CAST(AES_DECRYPT(encrypted-field,'my-encryption-key') as CHAR(50)) from table

要加密：

SELECT AES_ENCRYPT(encrypted-field,'my-encryption-key') from table;

ENCRYPT('AES', STRINGTOUTF8('<encryption-key>'), STRINGTOUTF8('<text to be encrypted>'))

TRIM(CHAR(0) FROM UTF8TOSTRING(DECRYPT('AES', STRINGTOUTF8('<encryption-key>'), '<text to be encrypted>')))