在oracle中执行java例程

最新推荐文章于 2024-03-22 07:35:25 发布

jwd001

最新推荐文章于 2024-03-22 07:35:25 发布

阅读量628

点赞数

CC 4.0 BY-SA版权

分类专栏： oracle jdbc 文章标签： java oracle oracle10g string windows url

本文链接：https://blog.youkuaiyun.com/jwd001/article/details/6858227

oracle jdbc 专栏收录该内容

5 篇文章

订阅专栏

oracle10g的oralceJVM支撑java1.4. 这让我们能用java做一些ps/sql不容易处理的任务，比如访问http资源等。这篇文章写个实例。首先创建java源码，所有method必须是static public：

CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED WORKSUPPORT."zgdx/tool/Util" AS
package zgdx.tool;

import java.io.IOException;
import java.io.OutputStream;
import java.io.UnsupportedEncodingException;
import java.net.HttpURLConnection;
import java.net.URL;

public class Util {
    static public String post(String s, String content) throws UnsupportedEncodingException {
        try{
        URL url= new URL(s);
        HttpURLConnection uconn = null;
        uconn = (HttpURLConnection)url.openConnection();
        uconn.setRequestMethod("POST");
        //uconn.setConnectTimeout(4000); //1.5
        //uconn.setRequestProperty("Connection", "close");
        uconn.setRequestProperty("Content-type", "application/x-www-form-urlencoded"); // text/plain;charset=\"utf-8\"

        uconn.setRequestProperty("user-agent", "Mozilla/5.0 (Windows; U; Windows NT 5.1; zh-CN; rv:1.8.1.8) Gecko/20071008 Firefox/2.0.0.8");
        //Content-type: text/xml;charset="utf-8"Soapaction: ""Accept: text/xml, multipart/related, text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2User-Agent: JAX-WS RI 2.1.6 in JDK 6Host: 61.139.44.236Connection: keep-aliveContent-Length: 811
        uconn.setRequestProperty("Accept", "*/*");
        uconn.setRequestProperty("Host", java.net.InetAddress.getLocalHost().getHostAddress());
        byte[] byteContent = content.getBytes(); //"utf-8"
        System.out.println("write bytes len="+ byteContent.length);
        uconn.setRequestProperty("Content-Length", String.valueOf(byteContent.length));

        uconn.setDoOutput(true);
        uconn.connect();
        OutputStream out = uconn.getOutputStream();
        out.write(byteContent);
        out.close();
        int res=0;
        res = uconn.getResponseCode();
        //System.out.println("\t receive response:");
        if(res!=200){
            return "responseCode="+res+": "+ uconn.getResponseMessage();
        }
        return null;
        }catch(IOException e){
            //throw new RuntimeException(e);
            e.printStackTrace();
            return e.getMessage();
        }
    }
}
/

如果是单独的java文件，可用oracle客户端的loadjava装载。

想把post包装成oracle function, 需要

CREATE OR REPLACE PACKAGE WORKSUPPORT."ZGDX/TOOL/UTIL" AS

FUNCTION post(Param1 VARCHAR2, Param2 VARCHAR2)
return VARCHAR2
AS LANGUAGE java NAME 'zgdx.tool.Util.post(java.lang.String, java.lang.String) return java.lang.String';

end;
/
如果使用toad，可用“publish java to ps/sql”工具。

测试：

在test.jsp中<% request.setCharacterEncoding("gbk"); System.out.println("name="+ request.getParameter("name")+ new Date() ); %>

oracle 执行:

declare
res varchar2(100);
begin
res := "ZGDX/TOOL/UTIL".post('http://133.44.8.71:8084/payAfterInstall/test.jsp', 'name=XXX' );
if length(res)>0 then
dbms_output.put_line(res);
end if;
end;