如何在oracle 中获取网页信息?
大家帮我看一下create or replace and compile java source named "getWebData" as/** *创建oracle存储过程的java类 *@author bromon**/
--http://www.kkivr.cn/1058.php?mobile=手机号码&linkid=linkid
package org.bromon.oracle;
import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.net.*;
import java.util.Date; public class getWebData{ public static String getdata(String url) {
String strResult;
URL page;
try{
page = new URL(url);
InputStreamReader in;
BufferedReader data;
String line;
StringBuffer buf = new StringBuffer();
URLConnection conn = page.openConnection();
conn.connect();
in = new InputStreamReader(conn.getInputStream());
data = new BufferedReader(in);
while((line = data.readLine()) != null)
strResult+=line;
return strResult;
}
}
}
然后然后在oracle中把这个类导入成为一个函数, create or replace function getWebData(url varchar2) return varchar2
as language java name也没有问题,可是我在存储过程中用的时候,老是出错,大家帮我看一下 ,多谢了。
num varchar2
num:= getWebData(“url。。具体地址”);
大家帮我看一下create or replace and compile java source named "getWebData" as/** *创建oracle存储过程的java类 *@author bromon**/
--http://www.kkivr.cn/1058.php?mobile=手机号码&linkid=linkid
package org.bromon.oracle;
import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.net.*;
import java.util.Date; public class getWebData{ public static String getdata(String url) {
String strResult;
URL page;
try{
page = new URL(url);
InputStreamReader in;
BufferedReader data;
String line;
StringBuffer buf = new StringBuffer();
URLConnection conn = page.openConnection();
conn.connect();
in = new InputStreamReader(conn.getInputStream());
data = new BufferedReader(in);
while((line = data.readLine()) != null)
strResult+=line;
return strResult;
}
}
}
然后然后在oracle中把这个类导入成为一个函数, create or replace function getWebData(url varchar2) return varchar2
as language java name也没有问题,可是我在存储过程中用的时候,老是出错,大家帮我看一下 ,多谢了。
num varchar2
num:= getWebData(“url。。具体地址”);
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货