oracle¾ÓÈ»Äܵ÷ÓÃjava³ÌÐò
ÒÔǰֻ֪µÀjavaÄܵ÷ÓÃoracle´æ´¢¹ý³ÌºÍº¯Êý£¬µ«½ñÌìÎÒ·¢ÏÖÔÀ´oracleÒ²¿ÉÒÔµ÷ÓÃjava
²âÊÔ»·¾³oracle 10g
call dbms_java.set_output(5000);
--Ê×ÏÈÔÚoracleÖбàÒëjavaÎļþ ÒÔÏÂÊǸö¼òµ¥µÄ
create or replace and compile java source named helloworld as
public class helloworld {
static public String Message(String name) {
return " Hello, " + name;
}
}
--È»ºóÓú¯Êýµ÷ÓÃjava
create or replace function hello (name VARCHAR2 ) return VARCHAR2
as language java name
' Hello.Message (java.lang.String) return java.lang.String ' ;
--µ÷Óú¯Êý
select hello( ' world! ' ) from dual;
À©Õ¹£º
1¡£ oracle±àÒëjava ÐèÒªclassÎļþÂ𣿠ÔÚµçÄÔÖÐËÑË÷ûÓÐÕÒµ½¡£ ºÜÉñÆæ£¬ ûÓÐclass JVMÈçºÎµ÷ÓÃjavaµÄ£¿£¿
2¡£ Èç¹ûjava³ÌÐòÒª·µ»Ø¼¯ºÏÔõô°ì£¿
3¡£ oracle ±àÒëjava ±¨´íÂ𣬠¿ÉÒÔÒì³£´¦ÀíÂð£¿
Ïà¹ØÎĵµ£º
select * from (select pro_id, sum(decode(month, '01', summ)) one,
sum(decode(month, '02', summ)) two,
&nb ......
ÔÚʹÓà Java™ ÓïÑԵķºÐÍʱ£¬Í¨Åä·û·Ç³£ÁîÈËÀ§»ó£¬²¢ÇÒ×î³£¼ûµÄÒ»¸ö´íÎó¾ÍÊÇÔÚʹÓÃÓнçͨÅä·ûµÄÁ½ÖÖÐÎʽµÄÆäÖÐÖ®Ò»£¨“? super T” ºÍ “? extends T”£©Ê±³öÏÖ´íÎó¡£Äú³ö´íÁËÂ𣿱ð¾ÚÉ¥£¬¼´Ê¹ÊÇר¼ÒÒ²»á·¸ÕâÖÖ´íÎ󣬱¾Ô Brian Goetz ½«Õ¹Ê¾ÈçºÎ±ÜÃâÕâ¸ö´íÎó¡£
ÔÚ Java ÓïÑÔÖУ¬Êý×éÊÇбäµÄ£¨ ......
תÌûthisµÄÓ÷¨·½±ã×Ô¼ºÒÔºó²é¿´
±ØÐëÓÃthis¹Ø¼ü×ÖµÄÈýÖÖÇé¿ö:
1¡¢ÎÒÃÇÏëͨ¹ý¹¹Ôì·½·¨½«Íⲿ´«ÈëµÄ²ÎÊý¸³Öµ¸øÀàµÄ³ÉÔ±±äÁ¿£¬¹¹Ôì·½·¨µÄÐÎʽ²ÎÊýÃû³ÆÓëÀàµÄ³ÉÔ±±äÁ¿ÃûÏàͬ¡£ÀýÈ磺
class Person
.. ......
TomcatÊÇÒ»¸ö¿ª·ÅÔ´´úÂë¡¢ÔËÐÐservletºÍJSP WebÓ¦ÓÃÈí¼þµÄ»ùÓÚJavaµÄWebÓ¦ÓÃÈí¼þÈÝÆ÷¡£TomcatÓÉApache-Jakarta×ÓÏîĿ֧³Ö²¢ÓÉÀ´×Ô¿ª·ÅÐÔÔ´´úÂëJavaÉçÇøµÄÖ¾Ô¸Õß½øÐÐά»¤¡£Tomcat ServerÊǸù¾ÝservletºÍJSP¹æ·¶½øÐÐÖ´Ðеģ¬Òò´ËÎÒÃǾͿÉÒÔ˵Tomcat ServerҲʵÐÐÁËApache-Jakarta¹æ·¶ÇұȾø´ó¶àÊýÉÌÒµÓ¦ÓÃÈí¼þ·þÎñÆ÷ÒªºÃ¡£×öÎ ......
1.н¨ÁËÒ»¸öHelloWorldµÄJAVA Project 2.Ô´Îļþ·ÅÔÚSRCĿ¼Ï£¬µ«Êǽ«Í¼Æ¬Îļþ XX.GIF ·ÅÈë¸ÃĿ¼ÏÂÔÚÔ´ÎļþÖÐÈ´²»ÄÜʹÓÃÏà¶Ô·¾¶£¬Ö»Äܽ«Í¼Æ¬Îļþ·ÅÔÚHelloWorld Ŀ¼ÏÂÃæ²Å¿É£¡¿ÉÔÚÀàÖÐÀàËÆÊ¹Óà ImageIO.read(new File("XX.GIF")); ......