oralce mysql 密码加密解密函数

//oralce

create or replace function "DECRYPT_DES"(p_text varchar2,p_key varchar2) return varchar2 is     v_text varchar2(2000); begin     dbms_obfuscation_toolkit.DESDECRYPT(input_string => UTL_RAW.CAST_TO_varchar2(p_text),key_string =>p_key, decrypted_string=> v_text);     v_text := rtrim(v_text,chr(0));     dbms_output.put_line(v_text);     return v_text; end;

create or replace function "ENCRYPT_DES"(p_text varchar2, p_key varchar2) return varchar2 is     v_text varchar2(4000);     v_enc varchar2(4000);     raw_input RAW(128) ;     key_input RAW(128) ;     decrypted_raw RAW(2048); begin     v_text := rpad( p_text, (trunc(length(p_text)/8)+1)*8, chr(0));     raw_input := UTL_RAW.CAST_TO_RAW(v_text);     key_input := UTL_RAW.CAST_TO_RAW(p_key);     dbms_obfuscation_toolkit.DESEncrypt(input => raw_input,key => key_input,encrypted_data =>decrypted_raw);     v_enc := rawtohex(decrypted_raw);     return v_enc; end;

 

//mysql utf-8

create function DECRYPT_DES(p_text varchar(256),p_key varchar(256)) RETURNS varchar(256) begin     declare c varchar(256);     select AES_DECRYPT(UNHEX(p_text),p_key) from dual into c;     return c; end;

CREATE FUNCTION `ENCRYPT_DES`(p_text varchar(256),p_key varchar(256)) RETURNS varchar(256) CHARSET utf8 begin     declare c varchar(256);     select HEX(AES_ENCRYPT(p_text,p_key)) from dual into c;     return c; end

SELECT DECRYPT_DES(ENCRYPT_DES('aaa','bbb'),'bbb') from dual;