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²½
Ïà¹ØÎĵµ£º
http://51jsp.cn/post/23.html
ÏÖÔÚ×öÍøÕ¾Ê×ÏÈ¿¼ÂÇÒ»µã¾ÍÊDz»ÄÜÔÚ×Ô¼ºµÄÍøÕ¾ÖгöÏÖ·Ç·¨µÄ¶«Î÷£¬°üÀ¨Ò»Ð©Ãô¸ÐµÄ´Ê¡£ÏÖÔÚÎÒÃǾÍÀ´¼òµ¥µÄʵÏÖËü£¬ÎªÁ˲éÕҵĿìËÙÔÚÕâÓÃtxtÀ´±£´æÕâЩ·Ç·¨µÄ¹Ø¼ü´Ê¡£Õâ¸öTXTÎĵµÊÇÔÚÍøÉÏÕÒµ½£¬ÏÖÔÚ´«ÉÏÀ´200907261131128065.rar
ÓÃJAVA³ÌÐòʵÏÖ¼òµ¥µÄÌí¼ÓÑéÖ¤¹Ø¼ü´Ê£¬Èç¹û´ó¼ÒҪʵ¼ÊÖÐʹÓã¬Ìí ......
Java³ÉÔ±µÄĬÈÏ·ÃÎÊ¿ØÖÆ
ÎÒ¶¥¶ÔÓÚÒ»¸öClassµÄ³ÉÔ±±äÁ¿»ò³ÉÔ±º¯Êý£¬Èç¹û²»ÓÃpublic, protected, privateÖеÄÈκÎÒ»¸öÐÞÊΣ¬ÄÇô¸Ã³ÉÔ±»ñµÃ“ĬÈÏ·ÃÎÊ¿ØÖÆ”¼¶±ð£¬¼´package access £¨°ü·ÃÎÊ£©¡£
ÊôÓÚpackage accessµÄ³ÉÔ±¿ÉÒÔ±»Í¬Ò»¸ö°üÖеÄÆäËûÀà·ÃÎÊ£¬µ«²»Äܱ»ÆäËû°üµÄÀà·ÃÎÊ¡£
° ......
£¨´ËÌù½÷Ïò£¬²ËÄñ¼¶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ÖУ¬Èç¹ûÔÚ¶ÔÒ»¸öList»òÕßMapÅÅÐò£¬¿ÉÒÔ²ÉÓÃCollectionsµÄ¼¯ºÏÀàÖеÄsort·½·¨À´¶ÔList½øÐÐÅÅÐò¡£ÖÁÓÚmap£¬¿ÉÒÔʹÓÃTreeMap×Ô¶¯ÅÅÐò¡£
µ«ÒÔÉÏÅÅÐò½ö½öÊǶÔÓ¢ÎÄÅÅÐòʱ£¬²Å»áÕýÈ·£¬Èô¹ûÊý¾ÝÀïÃæ´æÔÚÖÐÎĺÍÓ¢ÎÄʱ£¬ÄÇôÅÅÐò¾ÍÂÒÁË¡£
ÏÖÔÚÎÒʵÏֵķ½·¨ÊÇ°´ÕÕÖÐÎĵÄÆ´ÒôÀ´ÅÅÐò¡££¨ÍøÉÏ£¬»¹Óа´±Ê»ÅÅÐò£¬ÔÚÕâÀïÎҾͲ»Ò»Ò» ......