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

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


Ïà¹ØÎÊ´ð£º

oracleÈçºÎɾ³ýÓû§µÄËùÓжÔÏ󣬱£ÁôÓû§

¸Õ¿ªÊ¼Ó㬲»Ì«»á£¬dropÔÙcreateµÄÇëÈÆÐÐ

SQL code:

select 'drop '||object_type||' ' || object_name ; '
from dba_objects
where owner = 'yourUser'

http://edu.codepub.com/2009/0616/6398.php
......

Ò»Ä깤×÷¾­Ñ飬ÊìϤoracleÖ麣ÕÒ.net¹¤×÷Òª¶àÉÙ¹¤×Ê£¿

ÎÒ´óרѧÀú£¬ÔÚÒ»¼Ǫ̀×Ê ¼¯ÍÅµÄ ·Ö¹«Ë¾ ×öÀ²Ò»Äê´óÐÍERPÈí¼þ¿ª·¢&ά»¤£¬ÏëÔÚÖ麣ÕÒ·Ý.netµÄ¹¤×÷£¬Òª¶àÉÙ¹¤×ʺÏÊÊ£¿
¿ªÊ¼²»ÒªÌ«¸ß£¬3K×óÓÒÓ¦¸ÃÊDZê×¼

Ö麣ÄDZßËÆºõûÉîÛÚºÃ.

Èç¹ûÊÇÎҵϰ,Ê×ÏÈÊÇÒª±ÈÏ ......

½èˮԴÈËÆø£¡oracle jobÎÊÌ⣡ÔÚÏßµÈ

ÎÒдµÄÒ»¸öJob
declare
  job1 integer;
begin
  dbms_job.submit(job1,
    'Sale_FinanceUseFee(4,null,null,null);',
    TRUNC(SYSDATE)+1.103, ......

oracle Êý¾Ý¿âÓÅ»¯£¬¸ßÊÖ½øÀ´¿´¿´

ÎÒÏÖÔÚÔÚ×öÒ»¸öÏîÄ¿£¬Õâ¸öÏîÄ¿µÄÊý¾ÝÁ¿ºÜ´ó£¬¶øÇÒ±íÒ²ºÜ´ó£¬×Ö¶ÎÒ²ºÜ¶à£¬²éѯÌõ¼þÒ²ÊǺܶàµÄ¡£ÏÖÔÚ²éѯÆðÀ´ºÜÂý£¬ÓÅ»¯sqlÓï¾äÊÇÒ»·½Ãæ¡£ÏÖÔÚÓ¦¸ÃÔõôÓÅ»¯oracleÊý¾Ý¿â°¡¡£ÎÒ°ÑÎÒµÄoracleÊý¾Ý¿âµÄһЩ²ÎÊý·¢³öÀ´¸ßÊÖ¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ