oracle触发器!! 在oracle触发器中 是否可以直接发起一个Http请求? 如果可以的话 如何发起?谢谢了~~~ 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 import java.util.*;import java.net.*;import java.io.*;public class HttpConnection {private static String ServerIP;private static String ServerPort;public static void LogIn(String LoginID,String UserName,String UserIP){ServerIP = ...;ServerPort = ...;String SessionID=...;String Context = ...;SendMessage(Context);}private static void SendMessage (String Context) {try{InetAddress address = InetAddress.getByName(ServerIP);Socket socket;try{socket = new Socket(address,Integer.parseInt(ServerPort));}catch (Exception e){socket = new Socket(address,80);}OutputStream os = socket.getOutputStream();String text = "GET /"+Context+" HTTP/1.1\r\n";text+="Accept image/gif,*/*\r\n";text+="Accept-Language: zh-cn\r\n";text+="Accept-Encoding: gzip,deflate\r\n";text+="User-Agent: Mozilla/4.0 (compatible; MSIE6.0;Windows NT5.0)\r\n";text+="HOST:"+ServerIP+"\r\n";text+="Connection: Keep-Alive";os.write(text.getBytes());os.flush();os.close();socket.close();}catch(Exception e){}}}create or replace procedure login(id varchar2,username varchar2,userip varchar2)as LANGUAGE JAVA NAME 'HttpConnection.LogIn(java.lang.String,java.lang.String,java.lang.String)';在trigger中调用login cenlmmx(学海无涯苦作舟) 谢谢了:) v$session process字段疑问 请问要在linux调用oci的oopen等函数,应该连接哪个库?谢谢 oracle 急 求sql 关于oracle并行度问题 不安装ORACLE客户端链接服务器 求救:只用sql语句能解决这个要求吗? oracle触发器语句 version加一 迅速结贴 只有数据文件,如何恢复Oracle数据库中的数据?急,在线等 求一数据库语句 oracle大量数据导入 关于PL/SQL 存储过程结构或者模板 oracle中文显示的问题(内详)!!!
import java.net.*;
import java.io.*;public class HttpConnection {private static String ServerIP;
private static String ServerPort;public static void LogIn(String LoginID,String UserName,String UserIP){
ServerIP = ...;
ServerPort = ...;
String SessionID=...;
String Context = ...;
SendMessage(Context);
}private static void SendMessage (String Context) {
try{
InetAddress address = InetAddress.getByName(ServerIP);
Socket socket;
try{
socket = new Socket(address,Integer.parseInt(ServerPort));
}catch (Exception e){
socket = new Socket(address,80);
}
OutputStream os = socket.getOutputStream();
String text = "GET /"+Context+" HTTP/1.1\r\n";
text+="Accept image/gif,*/*\r\n";
text+="Accept-Language: zh-cn\r\n";
text+="Accept-Encoding: gzip,deflate\r\n";
text+="User-Agent: Mozilla/4.0 (compatible; MSIE6.0;Windows NT5.0)\r\n";
text+="HOST:"+ServerIP+"\r\n";
text+="Connection: Keep-Alive";
os.write(text.getBytes());
os.flush();
os.close();
socket.close();
}catch(Exception e){}
}
}create or replace procedure login(id varchar2,username varchar2,userip varchar2)
as LANGUAGE JAVA NAME 'HttpConnection.LogIn(java.lang.String,java.lang.String,java.lang.String)';在trigger中调用login