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;