MySQL进行数据库字段内容加密和解密

1. 使用MySQL自带的加解密函数：

-- 加密SQL
select convert(hex(AES_ENCRYPT(#{content},#{encryptkey})) using 'utf8')from dual;
-- 解密SQL
select convert(AES_DECRYPT(unhex(#{content}),#{encryptkey})using 'utf8')from dual;

2. 自定义函数进行封装：

-- 加密函数
create function ds_func_encrypt_des(p_text varchar(4000) character set utf8 COLLATE utf8_general_ci, p_key varchar(4000)) returns varchar(4000) character set utf8 COLLATE utf8_general_ci
begin
	declare v_enc varchar(4000) character set utf8 COLLATE utf8_general_ci;
	select convert(hex(AES_ENCRYPT(p_text,p_key)) using 'utf8') into v_enc;
 return v_enc;
end;

-- 解密函数
create function ds_func_decrypt_des(p_text varchar(4000), p_key varchar(4000)) returns varchar(4000) character set utf8 COLLATE utf8_general_ci
begin
	declare v_enc varchar(4000) character set utf8 COLLATE utf8_general_ci;
	select convert(AES_DECRYPT(unhex(p_text),p_key)using 'utf8') into v_enc;
 return v_enc;
end;

-- 调用加密函数
select ds_func_encrypt_des('我爱中国I Love China 521','ECMPMAIN') from dual;
-- 调用解密函数
select ds_func_decrypt_des('A85923F396E85434DF4EBFF4846CBB3D269E44C5474E720B79098286E8F2D043','ECMPMAIN') from dual;