db2使用Java存储过程实现MD5函数

import java.security.MessageDigest;
import COM.ibm.db2.app.UDF;
public class MD5UDF extends UDF {    
    public static String MD5(String s) {        
        String s1 = new String("");        
        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 ) {                
                byte byte0 = md[i];                
                str[k++] = hexDigits[byte0 >>> 4 & 0xf];                
                str[k++] = hexDigits[byte0 & 0xf];            
                }            
            s1 = new String(str);        
            } catch (Exception e) {            
                System.out.println(e.getMessage());        
                }        
        return "{" + s1 + "}";    
        }
    
    public static void main(String[] args){
        System.out.println(MD5("asdf"));
    }
}

DROP FUNCTION BI_MD5;

CREATE FUNCTION BI_MD5(VARCHAR(200))
RETURNS VARCHAR(70)
EXTERNAL NAME ‘MD5UDF:MD5UDF.MD5‘
FENCED VARIANT
NO SQL
EXTERNAL ACTION 
LANGUAGE JAVA
PARAMETER STYLE JAVA