根据实际情况填写，格式为
对于非RAC数据库：jdbc:oracle:thin:@10.137.31.147:1521:showtibco
对于RAC数据库：：jdbc:oracle:thin:@(DESCRIPTION = (ENABLE=BROKEN) (LOAD_BALANCE=OFF) (FAILOVER=ON) (ADDRESS_LIST= (ADDRESS = (PROTOCOL = TCP)(HOST = 10.71.166.180 )(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.71.166.181 )(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = esbora ) (FAILOVER_MODE= (TYPE=SELECT) (METHOD=BASIC) ) ) )
http://www.blogjava.net/DyEnigma/articles/352773.html CREATE PROCEDURE restockPro(IN init INT, IN loop_time INT)
BEGIN
DECLARE Var INT;
DECLARE ID INT;
SET Var = 0;
SET ID = init;
WHILE Var < loop_time DO
INSERT INTO news VALUES(ID, '今天天气好晴朗');
SET ID = ID + 1;
SET Var = Var + 1;
END WHILE;
END;
http://www.blogjava.net/rongxh7/archive/2008/11/29/243456.html