数据库;
CREATE OR REPLACE FUNCTION MD5( passwd IN VARCHAR2) RETURN VARCHAR2
IS
retval varchar2(32);
BEGIN
retval := (case when passwd is null then null else utl_raw.cast_to_raw(DBMS_OBFUSCATION_TOOLKIT.MD5(INPUT_STRING => passwd)) end);
RETURN retval;
END;
declare
cursor c_ip is
select a.password,a.rowid from uos_staff a;
begin
for r_ip in c_ip loop
begin
update uos_staff s set s.password = utl_raw.cast_to_varchar2(utl_encode.base64_encode(utl_raw.cast_to_raw(MD5(r_ip.password))))
where s.rowid = r_ip.rowid;
commit;
end;
end loop;
end;
java:
Base64.encode(getMD5String(checkNum).getBytes());
public static String getMD5String(String str) {
try {
// 生成一个MD5加密计算摘要
MessageDigest md = MessageDigest.getInstance("MD5");
// 计算md5函数
md.update(str.getBytes());
// digest()最后确定返回md5 hash值,返回值为8位字符串。因为md5 hash值是16位的hex值,实际上就是8位的字符
// BigInteger函数则将8位的字符串转换成16位hex值,用字符串来表示;得到字符串形式的hash值
//一个byte是八位二进制,也就是2位十六进制字符(2的8次方等于16的2次方)
return new BigInteger(1, md.digest()).toString(16).toUpperCase();
} catch (Exception e) {
e.printStackTrace();
return "";
}
}
js:
btoa(md5("ssr").toUpperCase());
<script type="text/javascript" src="./js/md5.min.js"></script>
md5: md5.min.js
链接:https://pan.baidu.com/s/1kgpKzLitZ83WEj5jhkDeXQ
提取码:ccun