Oracleµ÷ÓÃJava´úÂë
OracleÖпÉÒÔµ÷ÓÃJavaµÄ´úÂ룬һ°ãͨ¹ýÁ½ÖÖ·½Ê½½øÐе÷Óã¬Ò»¸öÊÇÖ±½Ó½«Java´úÂëдÔÚOracleÄÚ²¿£¬ÁíÍâÒ»ÖÖÊǽ«±àÒëºÃµÄclassÎļþÔØÈëµ½OracleÖС£
-A-
1¡¢ÔÚSQLPlusÖд´½¨OracleÖеÄJavaÀàÓë·½·¨£¨·½·¨±ØÐëÊǾ²Ì¬¹«Óз½·¨£©
create or replace and compile java source named hello as
public class Hello {
public static String Message(String name) {
return "Hello, " + name;
}
}
2¡¢´´½¨º¯Êýµ÷ÓÃÔØÈëOracleÖеÄJava·½·¨¡£
create or replace function hello (name varchar2)
return varchar2
as
language java name 'Hello.Message(java.lang.String) return java.lang.String';
3¡¢Ö´Ðк¯Êý¼´¿É¿´µ½½á¹û......
select hello('world!') from dual
-B-
1¡¢´´½¨Òªµ÷ÓõÄJava´úÂ룬²¢±àÒë³ÉClassÎļþ¡£±»µ÷Óõķ½·¨ÒÀ¾É±ØÐëΪ¾²Ì¬¹«Óз½·¨
public class Number {
public static int getNumber() {
return 99;
}
}
2¡¢ÓÃloadjavaÃüÁîÔÚ¿ØÖÆÌ¨ÉϽ«classÎļþ¼ÓÔØµ½Oracle»·¾³ÖÐ
loadjava -u sys/sys@orcl -oci8 -verbose -grant scott -synonym -resolve -schema scott D:\Number.class
Èç¹ûÏëÒªÐ¶ÔØÒѾ¼ÓÔØµÄclassµÄ»°£¬Ê¹ÓÃdropjavaÃüÁî
dropjava -user sys/sys@orcl Number
Èç¹ûÌáʾÈçÏÂÐÅÏ¢£¬±íʾ¼ÓÔØ³É¹¦£¨£©
arguments: '-u' 'sys/sys@orcl' '-oci8' '-verbose' '-grant' 'scott' '-synonym' '-resolve' '-schema' 'scott' 'D:\Number.class'
identical: Number
granting : execute on class SCOTT.Number to scott
skipping : class SCOTT.Number
synonym : SCOTT.Number
Classes Loaded: 1
Resources Loaded: 0
Sources Loaded: 0
Published Interfaces: 0
Classes generated: 0
Classes skipped: 0
Synonyms Created: 1
Errors: 0
3¡¢´´½¨µ÷Ó÷½·¨µÄ·½Ê½Í¬A·½Ê½µÄµÚ2²½
4¡¢µ÷Ó÷½·¨µÄ·½Ê½Í¬A·½Ê½µÄµÚ3²½
Ïà¹ØÎĵµ£º
1¡¢Ò³Ãæ±àÂëÓëºǫ́Àà±àÂë²»Ò»Ö¡£
2¡¢ºǫ́ÀàÓëÊý¾Ý¿â½»»¥±£³ÖÊý¾Ýʱ²úÉúÂÒÂë¡£½â¾ö·½·¨£º¿ÉÒÔÔÚÇý¶¯µÄurl²ÎÊýÖÐÖ¸¶¨¡£
3¡¢¶ÁÎļþ/Á÷ʱ²úÉúÂÒÂë¡£½â¾ö·½·¨£º½¨ÒéʹÓÃFileReaderºÍFileWriterµÄ¸¸ÀࣺInputStreamReader/OutputStreamWriter£¬ËüÃÇÔÚ¹¹Ô캯ÊýÖпÉÒÔÖ¸¶¨±àÂëÀàÐÍ£ºInputStreamReader(InputStream in, Charset c ......
£¨´ËÌù½÷Ïò£¬²ËÄñ¼¶JAVA³ÌÐòÔ±Ìṩ±ãÀû£¬ºÇºÇ£¬£¬ÈôÓÐÐÒ¸ßÊÖ³öÏÖ£¬»¹Íû¶à¶àÖ¸µã¡£Ð¡µÜÉõ»¶£¡£©
×î½üæÓÚ¿ª·¢Ò»Ì×¼à¿ØÏµÍ³¡£
ÐèÒª±¨¾¯ÉùÒô¡£
ÔÚѰÇó½â¾ö·½°¸µÄʱºò£¬³öÏÖÁ½ÖÖ·½°¸¡£
Ò»¡¢ÓÃjavax.sound.sampled.*°ü£¬½øÐÐÉùÒô´¦Àí¡£
¶þ¡¢ÓÃsun.audio.AudioPlayer°ü£¬½øÐÐÉùÒô´¦Àí¡£
µÚÒ»ÖÖ·½°¸ÓÃÆðÀ´£¬»á¾³£ÐÔ³öÏÖ¿¨Ö ......
1.»ù±¾¸ÅÄîµÄÀí½â
¡¡¡¡¾ø¶Ô·¾¶£º¾ø¶Ô·¾¶¾ÍÊÇÄãµÄÖ÷Ò³ÉϵÄÎļþ»òĿ¼ÔÚÓ²ÅÌÉÏÕæÕýµÄ·¾¶£¬(URLºÍÎïÀí·¾¶)ÀýÈ磺
C:\xyz\test.txt ´ú±íÁËtest.txtÎļþµÄ¾ø¶Ô·¾¶¡£http://www.sun.com/index.htmÒ²´ú±íÁËÒ»¸ö
URL¾ø¶Ô·¾¶¡£
¡¡¡¡Ïà¶Ô·¾¶£ºÏà¶ÔÓëij¸ö»ù׼Ŀ¼µÄ·¾¶¡£°üº¬WebµÄÏà¶Ô·¾¶£¨HTMLÖеÄÏà¶ÔĿ¼£©£¬ÀýÈ磺ÔÚ
......
JavaÀï±ß½âÎöxmlÒ»°ãÓÐÈýÖÖ³£Óõļ¼Êõ£º
1¡¢ Document Object Model (DOM)£¬W3CÀï±ßÒ»ÖÖ³ÉÊìµÄ±ê×¼¡£Ä¿Ç°¹ã·ºÊ¹ÓõĽâÎö¹¤¾ß£ºJDOM DOM4J
2¡¢ Simple API for XML (SAX)£¬µÚÒ»ÖÖ±»¹ã·º½ÓÊܵÄXMLµÄAPI£¬³ÉΪÊÂʵÉϵıê×¼¡£
3¡¢ Streaming API for XML (StAX)£¬ÔÚJSR-173ÖÐÌáµ½µÄÒ»ÖÖºÜÓÐǰ;µÄÐÂÐͽâÎöÄ ......
ÔÚJavaÖУ¬Èç¹ûÔÚ¶ÔÒ»¸öList»òÕßMapÅÅÐò£¬¿ÉÒÔ²ÉÓÃCollectionsµÄ¼¯ºÏÀàÖеÄsort·½·¨À´¶ÔList½øÐÐÅÅÐò¡£ÖÁÓÚmap£¬¿ÉÒÔʹÓÃTreeMap×Ô¶¯ÅÅÐò¡£
µ«ÒÔÉÏÅÅÐò½ö½öÊǶÔÓ¢ÎÄÅÅÐòʱ£¬²Å»áÕýÈ·£¬Èô¹ûÊý¾ÝÀïÃæ´æÔÚÖÐÎĺÍÓ¢ÎÄʱ£¬ÄÇôÅÅÐò¾ÍÂÒÁË¡£
ÏÖÔÚÎÒʵÏֵķ½·¨Êǰ´ÕÕÖÐÎĵį´ÒôÀ´ÅÅÐò¡££¨ÍøÉÏ£¬»¹Óа´±Ê»ÅÅÐò£¬ÔÚÕâÀïÎҾͲ»Ò»Ò» ......