Oracle导入Jar并运行

Oracle导入Jar并创建函数运行。
计算两个数的和

1、idea创建maven项目

File->New->Project…->Maven

创建包cays.sum和cays.add

SumNumber.java

package cays.sum;

/**
 * 计算数的和
 *
 * @author Chai yansheng
 * @create 2019-08-13 16:22
 **/
public class SumNumber {
    public static int sumTwoNum(int a, int b) {
        return a + b;
    }
}

AddNumber.java

package cays.add;

/**
 * 两个数的加法
 *
 * @author Chai yansheng
 * @create 2019-08-13 16:24
 **/
public class AddNumber {
    public static int addTwoInt(int a, int b) {
        return a + b;
    }
}

2、打包成jar

View->Tool Windows->Maven Project->Lifecycle->package->run

或者项目根目录下mvn clean package

3、上传Oracle

loadjava -r -f -verbose -resolve -user scott/scott D:\WorkSpace\JavaWorkSpace\OracleApp\target\sum-1.0-SNAPSHOT.jar

卸载

dropjava  -r -f -verbose -resolve -user scott/scott D:\WorkSpace\JavaWorkSpace\OracleApp\target\sum-1.0-SNAPSHOT.jar

4、把jar包导入到Oracle之后，之后创建函数

create or replace function addTwoInt(a number,b number)  return number  as 
LANGUAGE JAVA NAME  'cays/add/AddNumber.addTwoInt(int,int) return int'; 

5、运行

select addTwoInt(1,2) from dual;

成功！