양방향 암호화 함수 생성

암호화 함수

DELIMITER $$

CREATE FUNCTION fn_encrypt(

p_val VARCHAR(255)

) RETURNS varchar(1000)

begin

DECLARE r_encrypt VARCHAR(1000);

 

select HEX(AES_ENCRYPT(p_val, SHA2('abc123@!', 256))) into r_encrypt from dual;

 

return r_encrypt;

end

 

select fn_encrypt('1234') from dual;

 

복구화 함수

DELIMITER $$

CREATE FUNCTION fn_decrypt(

p_val VARCHAR(255)

) RETURNS varchar(1000)

begin

DECLARE r_decrypt VARCHAR(1000);

 

 

select CONVERT(AES_DECRYPT(UNHEX(p_val), SHA2('abc123@!',256)) USING UTF8) into r_decrypt from dual;

 

return r_decrypt;

end

 

 

select fn_decrypt('7B0F2749B3FA9CFA0E6EB2B762DE75DC') from dual;