oracleÁ´½ÓÎÊÌâ
ÎÒÔÚ¿ª·¢µçÄÔÉϲâÊÔûÓÐÒ»µãÎÊÌ⣬µ«ÊÇÔÚÐÞ¸ÄÎļþÖеÄÊý¾Ý¿âIPµØÖ·ÒԺ󣬽«warÎļþ·ÅÉϿͻ§µÄµçÄÔÉÏÒÔºóÀÏÊÇ´´½¨Á¬½Óʧ°Ü£¬´íÎóÐÐÔÚ50ÐС£
´´½¨Á¬½Ó´úÂëÈçÏ£º
String proPath = this.getClass().getResource("").getPath().toString();
String path = proPath.substring(0,proPath.indexOf("classes"))+"/classes/DB.properties";
String driver = "";
String url = "";
String username = "";
String password = "";
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
private static Properties p = new Properties();
private void loadProperty(){ //´ÓÎļþ»ñµÃÊý¾Ý¿âÁ´½ÓÐÅÏ¢
try {
p.load(new FileInputStream(path));
} catch (FileNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
driver = p.getProperty("driver");
url = p.getProperty("url");
username = p.getProperty("username");
password = p.getProperty("password");
}
public Connection getCon(){ //´´½¨Á¬½Ó
loadProperty();
try {
Class.forName(driver); //µÚÎåÊ®ÐÐ
con = DriverManager.getConnection(url, username, password);
} catch (ClassNotFoundE
Ïà¹ØÎÊ´ð£º
ÎÒ°²×°Ò»Ì¨redhat linux5+oracle 10gµÄ·þÎñÆ÷£¬±Ê¼Ç±¾£¨XPϵͳ£©°²×°ÁËoracle 10g¿Í»§¶Ë,½á¹ûÀÏÊdzö12560µÄ´íÎó£¬Çë¸ßÊÖÖ¸µãÒ»¶þ£¬
-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dpor ......
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......
1.OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?
2.OracleתÂëʱ,Èç¹û¿Í»§¶ËΪ×Ó¼¯(UASCII)·þÎñ¶ËΪ³¬¼¯(AL32UTF8).
ÄÇÑϸñµÄ½²ÊÇ×Ó¼¯×ª³¬¼¯, ¿ÉÒÔתµÄͨ.
²éѯµÄʱºò³¬¼¯×ª×Ó¼¯ÄDz»¾Í³öÎÊÌâÁËô?
Äĸö»Ø¸öÌ ......
3-5ÈË£¬¹¤×÷µØµãÉϺ£ÆÖ¶«Èí¼þÔ°£¬2-3Äê¾Ñ飬ӢÎÄÁ÷Àû£¬ÓÐÒâÕßÇëÁªÏµ38954510-1355£¬15821699737£¬y.ming@live.cn
×Ô¼º¶¥¡£¡£¡£
ûÓÐORACLE ERPµÄ¾Ñé,ÓÐÓÃÓѺÍTIPTOP¾Ñé,Ó¢Óï˵²»ºÃ,¿´»¹ÊÇ¿ÉÒÔ!
²»ÖªµÀÓÐûÓÐ ......
¸Õ¿ªÊ¼Ó㬲»Ì«»á£¬dropÔÙcreateµÄÇëÈÆÐÐ
SQL code:
select 'drop '||object_type||' ' || object_name ; '
from dba_objects
where owner = 'yourUser'
http://edu.codepub.com/2009/0616/6398.php
......