[转载]DB2数据库的表数据加密代码解析
<P>信息来源: 邪恶八进制信息安全团队</P><P><SPAN class=top11>例：<BR><BR>
<TABLE cellSpacing=0 borderColorDark=#ffffff cellPadding=2 width="90%" align=center borderColorLight=black border=1>
<TBODY>
<TR>
<TD style="FONT-SIZE: 10pt" bgColor=#e6e6e6><FONT face="Verdana, Arial, Helvetica, sans-serif" size=2>1. <BR><BR>C:\>db2 create table encode_demo(col1 varchar(100) for bit data) <SPAN style="COLOR: red">//字段col1数据按二进制存放</SPAN><BR><BR>DB20000I SQL 命令成功完成。<BR><BR>2. <BR><BR>C:\>db2 set encryption password = 'loveunix' <SPAN style="COLOR: red">//设置加密解密的passwd</SPAN><BR><BR>DB20000I SQL 命令成功完成。<BR><BR>3.<BR><BR>C:\>db2 values(encrypt('loveunix')) <SPAN style="COLOR: red">//先预览一下加密后的loveunix<!--emo&:)--><!--endemo--></SPAN><BR><BR>1<BR><BR>---------------------------------------------------<BR><BR>x'08BC44FF6A05A3D5240E86CFB2CE60F243AA83C41B7221D7'<BR><BR>4.<BR><BR>C:\>db2 insert into encode_demo values(encrypt('loveunix')) <SPAN style="COLOR: red">//插记录</SPAN><BR><BR>DB20000I SQL 命令成功完成。<BR><BR>5.<BR><BR>C:\>db2 select decrypt_char(col1) as encode from encode_demo <SPAN style="COLOR: red">//解密,检索记录</SPAN><BR><BR>ENCODE<BR><BR>--------------------------------------------------------------------------------<BR><BR>loveunix<BR><BR>1 条记录已选择。</FONT></TD></TR></TBODY></TABLE></SPAN></P>
页:
[1]