oracle数据库 当TIMINGTIG表发生改变，发送http请求

1.添加java source----------------------

create or replace and compile java source named jym as
import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.net.URL;
import java.net.URLConnection;

public class JYM {

    public static void sendGet(String url){
        String result ="";
        BufferedReader in = null;
        try{
            String urlName = url;
            URL realUrl = new URL(urlName);
            URLConnection conn = realUrl.openConnection();
            conn.setRequestProperty("accept", "*/*");
            conn.setRequestProperty("connection", "Keep-Alive");
            conn.connect();
            in= new BufferedReader(new InputStreamReader(conn.getInputStream()));
            String line;
            while((line = in.readLine())!=null){
                result += "/n"+line;
            }
        }catch(Exception e){
            System.out.println("发送GET请求出现异常"+e);
            e.printStackTrace();
        }
        finally{
            try{
                if(in !=null){
                    in.close();
                }
            }catch(Exception e){
                e.printStackTrace();
            }
        }
    }

}

2.存储过程
create or replace procedure lqHttp(ip varchar2)
as language java name
'JYM.sendGet(java.lang.String)';

3.TIMINGTIG表触发器  url：填写你自己的访问地址。例如http://****
CREATE TRIGGER TIMINGTIG
AFTER INSERT OR UPDATE OR DELETE ON AW_001_CDT005_000001
BEGIN
lqHttp('url');
END TIMINGTIG;