java sources_在oracle中使用java sources

Oracle中的MD5加密用法没有搞明白，加密结果与程序中的结果不一样，只好将java中的方法搬过来。

STEP 1:

create or replace and compile java source named md5util as

import java.security.MessageDigest;

public class MD5Util

{

public static String encrypt(String s)

{

char hexDigits[] = {'0', '1', '2', '3', '4', '5', '6', '7', '8', '9', 'a', 'b', 'c', 'd','e', 'f'};

try {

byte[] strTemp = s.getBytes();

MessageDigest mdTemp = MessageDigest.getInstance("MD5");

mdTemp.update(strTemp);

byte[] md = mdTemp.digest();

int j = md.length;

char str[] = new char[j * 2];

int k = 0;

for (int i = 0; i < j; i++) {

byte byte0 = md[i];

str[k++] = hexDigits[byte0 >>> 4 & 0xf];

str[k++] = hexDigits[byte0 & 0xf];

}

return new String(str);

}

catch (Exception e){

return null;

}

}

}

STEP 2:

create or replace function md5encrypt(s varchar2)

return varchar2 as

language java name 'MD5Util.encrypt(java.lang.String) return java.lang.String';

STEP 3:

select md5encrypt('ok') from dual