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

oracle´æ´¢¹ý³ÌÖд´½¨Ä¿Â¼

  ¸÷λ´óÏÀ£¬Ð¡µÜ½ñÌìÒª×öÒ»¸ö¹¦ÄÜÊÇ£ºÔÚ´æ´¢¹ý³ÌÖд´½¨¶à¼¶Ä¿Â¼¡£ÓÐûÓÐʲôºÃµÄ·½·¨°¡¡£
ÎÒÏÖÔÚÓõÄloadjava¡£ÓÃjavaʵÏÖ´´½¨£¬µ«ÊÇÖ´ÐеÄʱºò»áÅ×ȨÏÞÒì³££¬ËùÒÔ²»ÄÜ´´½¨¡£ÓÐûÓÐÆäËûµÄ·½·¨ÊµÏÖÄØ£¿
ÌùÉÏÎҵĴúÂë¡£Íû´óÏÀÖ¸µã£º
Java code:
import java.io.File;

public class CreatDir {
public static void main(String[] args) {
String str = CreatDir.mkDocDir("/home/oracle/upload/20091223/5");
System.out.println(str);

}
public static String mkDocDir(String filePath){
File f=new File(filePath);
f.mkdirs();
return filePath;
}
}




SQL code:
create or replace function mkdocdir(filepath in varchar2)

return varchar2
as
language java name 'CreatDir.mkDocDir(java.lang.String) return java.lang.String';

Â¥Ö÷Äã·¢µÄ²»ÊÇÎÊÌ⣬ÊǼÅį¡£

java²»Ì«¶®

Äã˵µÄĿ¼ÊÇOSÉÏÄÇÖÖĿ¼½á¹û»¹ÊÇORACLEÖеÄÄǸödirectory

http://blog.csdn.net/wh62592855/archive/2009/12/26/5083418.aspx

Õâ¸öÊÇORACLEĿ¼µÄʹÓà ²»ÖªµÀ¶ÔÄãÓаïÖúû

ÒýÓÃ
java²»Ì«¶®

Äã˵µÄĿ¼ÊÇOSÉÏÄÇÖÖĿ¼½á¹û»¹ÊÇORACLEÖеÄÄǸödirectory

http://blog.csdn.net/wh6259285


Ïà¹ØÎÊ´ð£º

oracle 10g webµÇ½EMµÄÎÊÌ⣿ - Oracle / »ù´¡ºÍ¹ÜÀí

°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿

1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......

¶à±í¹ØÁª²éѯµÄ sqlд·¨ - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ£¬ÎÒ×î½üά»¤Ò»¸öÏîÄ¿£¬100¶à¸ö±í
Ö»ÄÜÓÃjdbcÖ±Á¬
Óöµ½Á˶à¸ö±í ¹ØÁª ²éѯµÄÇé¿ö Çë´ó¼ÒÖ¸½Ì
±ÈÈç
student(studentid,classid)
class(classid,classname)
class_teacher(classid,teacherid)Õâ¸öÊÇÖмä±í ......

ORACLEÁ¬½Ó·½·¨ - VC/MFC / Êý¾Ý¿â

ÈçÏÂVC6²Ù×÷ORACLEÁ¬½Ó·½·¨Îª¿É±¨´í£º
_bstr_t connStr£»
connStr="Provider=OraOLEDB.Oracle;User ID=scott;Password=tiger;Data Source=192.168.0.120;";
m_SqlConn->Open(_bstr_t(connStr),(_b ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ