Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÔõôÓÃjdbcͬʱÁ¬½Ó¶à¸öoracleÊý¾Ý¿â£¡

ÎÒÏÖÔÚÓÐÒ»¸öÖÐÐÄ¶Ë ÊÇoracleÊý¾Ý¿â¡£
ÏÖÔÚÖÐÐÄÏë¸üпͻ§¶ËµÄoracleÊý¾Ý¿âÖеÄij¸ö±í¡£ÏÖÔÚÓкܶà¸ö¿Í»§¶Ë£¬¿Í»§¶ËµÄip¶ÎÊÇ192.168.1.0-192.168.1.255
Ôõô²ÅÄÜʵÏÖÕâÑùµÄÒ»¸ö¹¦Äܰ¡£¿
ÎÒÏÖÔÚÏëÁËÒ»¸ö×î²»ºÃµÄ·½·¨¡£
¾ÍÊÇ
Java code:

public static Connection getConnections(String ip) {
// 1.
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
// 2.
Connection con = DriverManager.getConnection(
"jdbc:oracle:thin:@"+ip+":1521:orcl","scott","tiger");
// 3.
return con;
} catch (Exception e) {
// TODO: handle exception
return null;
}
}

ÕâÊÇÒ»¸ö¹¤¾ßÀ࣬Õâ¸ö·½·¨¾ÍÊÇ·µ»ØÒ»¸öConnection
ÎÒ»¹ÓÐÒ»¸öÖ÷·½·¨µÄÀà
Java code:

for (int i = 0; i <= 255; i++) {
String ip = "192.168.1."+i;
try {
Statement stmt = Util.getConnections(ip).createStatement();
//½øÐвÙ×÷ ¡­¡­
} catch (Exception e) {
// TODO Auto-generated catch block
System.out.println(ip);
continue;
}
}


Ïà¹ØÎÊ´ð£º

oracleµ¼Èë»Ø¹ö - Oracle / ¿ª·¢

abnormal end of export file
IMP-00028: partial import of previous table rolled back: 3828 rows rolled back
  
ÓÐûÓÐÒ»ÖÖ·½·¨Èõ¼Èë¼ÌÐø½øÐжø²»Òì³£Ìø³ö»Ø¹ö£¿
ignore=y

Äã² ......

oracleÊý¾Ý¿â »º³å³Ø - Oracle / »ù´¡ºÍ¹ÜÀí

ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£

²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿

ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ

ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......

OracleÖа󶨱äÁ¿µÄÎÊÌâ

ÔÚ´¥·¢Æ÷µÄÓï·¨ÖУ¬create trigger trg¡­¡­when £¨new.id>3£© ÔÚÅж¨Ìõ¼þÖУ¬newÇ°Ãæ²»¼ÓðºÅ£¬¹â±È½ÏÁ½¸öÊýµÄÒýÓþͿÉÒÔÅжϴóСÁËÂð£¿ÄѵÀ²»ÊÇÓ¦¸Ã±È½ÏÖ¸ÏòµÄÖµÂð£¿
...²»ÊǺÜÃ÷°×Â¥Ö÷µÄÒâ˼
oracle ¹æ¶¨ÔÚ´¥ ......

oracle ÊÔͼÎÊÌ⣬Çë¸ßÊÖ°ïæ£¬ÔÚÏßµÈ.....

ÎÊÌâÃèÊö£º
1¡¢¼ÙÉèÓбí
t1±í£¬°üº¬ËÄÁÐ
 s1 a b c
 1 a a a
 2 b b b 
.........
t2±í£¬°üº¬2ÁÐ
s2 ff
1 77
2 88
............
ÈçºÎÉú³ÉÕâÑùµÄºÏ²¢Ê ......

oracleºº×ÖתƴÒô

Çë¸÷λ¸ßÊÖ°ïæ oracleºº×ÖתƴÒô
±ÈÈçÏÖÔÚÓиöÁÐ ÀïÃæµÄºº×ÖΪÄãºÃ ÎÒÏë²é³öÀ´µÄÊÇN ÇëÎʸ÷λ¸ßÊÖÈçºÎʵÏÖ ¸ø¸öÏêϸµÄ¿´¿´ лÁË
ÓÐÖªµÀµÄ¸æËßÒ»Éù ллÁË


ûÕÒµ½°¡ Äܸø·¢Ò»¸öÂð

ÄÄλ˧¸çÄܸøÏêϸµÄËµÒ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ