oracle使用javasource

在oracle 11g中使用javasource

首先定义javaSource

create or replace and compile java source named "Encrypt1" as
import java.security.SecureRandom;

import javax.crypto.Cipher;
import javax.crypto.SecretKey;
import javax.crypto.SecretKeyFactory;
import javax.crypto.spec.DESKeySpec;

public class Encrypt1 {
  private static final byte[] DES_KEY = { 21, 1, -110, 82, -32, -85, -128, -65 };
  public static String decryptBasedDes(String cryptData) {
    String decryptedData = null;
    try {
      // DES算法要求有一个可信任的随机数源
      SecureRandom sr = new SecureRandom();
      DESKeySpec deskey = new DESKeySpec(DES_KEY);
      // 创建一个密匙工厂，然后用它把DESKeySpec转换成一个SecretKey对象
      SecretKeyFactory keyFactory = SecretKeyFactory.getInstance("DES");
      SecretKey key = keyFactory.generateSecret(deskey);
      // 解密对象
      Cipher cipher = Cipher.getInstance("DES");
      cipher.init(Cipher.DECRYPT_MODE, key, sr);
      // 把字符串解码为字节数组，并解密
      decryptedData = new String(cipher.doFinal(new sun.misc.BASE64Decoder().decodeBuffer(cryptData)));
    } catch (Exception e) {
      throw new RuntimeException("解密错误，错误信息：", e);
  }
  return decryptedData;
 }
}

 

定义function

CREATE OR REPLACE FUNCTION Encrypt11 (cryptData IN STRING)
   RETURN String
IS
   LANGUAGE JAVA
   NAME 'Encrypt1.decryptBasedDes(java.lang.String) return String';

调用：

declare abc String(50);
begin
  abc:=Encrypt11('aT3dGMPB2FEMba0K881Jmg==');
  dbms_output.put_line(abc);
  end;