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 ......
String s = new Date().toString();¿ÉÒÔÖ±½Ó´´½¨ÍêжÔÏóºó¾ÍÁ¢¼´ÓÃÆäµÄ·½·¨¡£
Ò»¸ö¶ÔÏó±äÁ¿²¢Ã»ÓÐʵ¼Ê°üº¬Ò»¸ö¶ÔÏ󣬶øÊǽö½öÒýÓÃÒ»¸ö¶ÔÏó¡£
GregorianCalendarÀà
javaÉè¼ÆÕß¾ö¶¨°Ñ±£´æÊ±¼äÓë¸øÊ±¼äµãÃüÃû·Ö¿ªÀ´£¬ÕâÑù¾ÍÓÐÁ½¸öÀà,dateºÍGregorianCalendar.Ò»¸öÓÃÀ´±íʾʱ¼äµã£¬Ò»¸öÓÃÀ´±íʾ´ó¼ÒÊìϤµÄÈÕÀú±íʾ·¨¡£ÊÂ浃 ......
µ¥Ôª²âÊÔ
1.
DBUnit
DBunitÊÇÒ»¸ö»ùÓÚjunitÀ©Õ¹µÄÊý¾Ý¿â²âÊÔ¿ò¼Ü¡£ËüÌṩÁË´óÁ¿µÄÀà¶ÔÓëÊý¾Ý¿âÏà¹ØµÄ²Ù×÷½øÐÐÁ˳éÏóºÍ·â×°¡£
2.MOckito
MockitoÊÇÒ»¸öÕë¶ÔJavaµÄmocking¿ò¼Ü¡£Äã¿ÉÒÔʹÓüò½àµÄAPI±àд³öƯÁÁµÄ²âÊÔ¡£
3.Hamcrest Matchers
Hamcrest ÊÇÒ»¸ö²âÊÔ¸¨Öú¹¤¾ß£¬ÌṩÁËÒ»Ì×ͨÓÃµÄÆ¥Åä·û Matcher£¬Áé»îʹÓÃÕâÐ ......
ÎÒÃÇ´ó¼Ò¶¼ÖªµÀ£¬¶ÔÓÚ¾²Ì¬±äÁ¿¡¢¾²Ì¬³õʼ»¯¿é¡¢±äÁ¿¡¢³õʼ»¯¿é¡¢¹¹ÔìÆ÷£¬ËüÃǵijõʼ»¯Ë³ÐòÒÀ´ÎÊÇ£¨¾²Ì¬±äÁ¿¡¢¾²Ì¬³õʼ»¯¿é£©>£¨±äÁ¿¡¢³õʼ»¯¿é£©>¹¹ÔìÆ÷¡£ÎÒÃÇÒ²¿ÉÒÔͨ¹ýÏÂÃæµÄ²âÊÔ´úÂëÀ´ÑéÖ¤ÕâÒ»µã£º
Java´úÂë
public class InitialOrderTest {
......
JavaÒ»¶¨ÒªÕÆÎյļ¼Êõ
-------------------------------------------------------------------------------
jvmÓÅ»¯
jvmÏ̵߳÷¶ÈÐòÁÐ
java gc»úÖÆ
java gcËã·¨
Java gcÔÀí
java ÄÚ´æ¹ÜÀí
ÈçºÎÖ÷¶¯Í¨Öªjvm½ø³ÌÀ¬»ø»ØÊÕ
Òì³£»úÖÆ|javaµÄÒì³£´¦Àí
Ïß³Ì|Ï̵߳ÄʵÏÖ
¼¯ºÏÀà¿ò¼Ü
java.io
·þÎñÆ÷£ºSquid¡¢Lighttpd¡¢ ......