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²½
Ïà¹ØÎĵµ£º
JavaÖÐÒì³£Ò»°ã·ÖΪ3À࣬ϱ߽éÉÜÏ£¬½ö½öÊǸöÈËÀí½â¡£
µÚÒ»ÖÖÊDZàÒëÆÚÒì³££¬»òÕß½Ðcheck Exception¡£
±àÒëÆÚÒì³£µÄÌØµã£º
1.ϵͳҪÇó±ØÐëÔÚ³ÌÐòÀï×ö³ö´¦Àí£¬·ñÔò±¨±àÒë´íÎ󣬱àÒëÎÞ·¨Í¨¹ý£¬Ò²¾ÍÊÇËµÏµÍ³Ç¿ÖÆÒªÇó´¦Àí£¬¶ÔÓÚ´¦Àí·½Ê½£¬²»ÍâºõÖ±½Ócatch´¦ÀíºÍÅ׳öµ½Íâ²ã£¬µ«ÊÇ×îÖÕ»¹ÊÇÒª´¦ÀíµÄ¡£
2.Óû§×Ô¶¨ÒåÒ»¸ö±àÒëÆÚÒ ......
1¡¢ Java¶ÔÏó¸³Öµ
Java´úÂë
Employee e1=
new
Employee(
"Àî"
);
//EmployeeÊÇÒ»¸ö×Ô¶¨ÒåÀà
Employee e2=e1; //¸³Öµ¶ÔÏó
e2.setName("Íõ"
);
//¸Ä±ä¶ÔÏóe2µÄÃû×Ö
System.out.println(e1.getName ......
1.¼ÆËãijһÔ·ݵÄ×î´óÌìÊý
Calendar time=Calendar.getInstance();
time.clear();
time.set(Calendar.YEAR,year); //year Ϊ int
time.set(Calendar.MONTH,i-1);//×¢Òâ,Calendar¶ÔÏóĬÈÏÒ»ÔÂΪ0
int day=time.getActualMaximum(Calendar.DAY_OF_MONTH) ......
ͻ񻣼
±¾ÎÄÕë¶Ôjava³õѧÕß»òÕßannotation³õ´ÎʹÓÃÕßÈ«ÃæµØËµÃ÷ÁËannotationµÄʹÓ÷½·¨¡¢¶¨Ò巽ʽ¡¢·ÖÀà¡£³õѧÕß¿ÉÒÔͨ¹ýÒÔÉϵÄ˵Ã÷ÖÆ×÷¼òµ¥µÄannotation³ÌÐò£¬µ«ÊǶÔÓÚһЩ¸ß¼¶µÄannotationÓ¦Óã¨ÀýÈçʹÓÃ×Ô¶¨ÒåannotationÉú³ÉjavabeanÓ³ÉäxmlÎļþ£©»¹ÐèÒª½øÒ»²½µÄÑо¿ºÍ̽ÌÖ¡£Éæ¼°µ½ÉîÈëannotationµÄÄÚÈÝ£¬×÷Õß½«ÔÚºóÎÄ¡ ......
ÔÚJavaÖУ¬Èç¹ûÔÚ¶ÔÒ»¸öList»òÕßMapÅÅÐò£¬¿ÉÒÔ²ÉÓÃCollectionsµÄ¼¯ºÏÀàÖеÄsort·½·¨À´¶ÔList½øÐÐÅÅÐò¡£ÖÁÓÚmap£¬¿ÉÒÔʹÓÃTreeMap×Ô¶¯ÅÅÐò¡£
µ«ÒÔÉÏÅÅÐò½ö½öÊǶÔÓ¢ÎÄÅÅÐòʱ£¬²Å»áÕýÈ·£¬Èô¹ûÊý¾ÝÀïÃæ´æÔÚÖÐÎĺÍÓ¢ÎÄʱ£¬ÄÇôÅÅÐò¾ÍÂÒÁË¡£
ÏÖÔÚÎÒʵÏֵķ½·¨Êǰ´ÕÕÖÐÎĵį´ÒôÀ´ÅÅÐò¡££¨ÍøÉÏ£¬»¹Óа´±Ê»ÅÅÐò£¬ÔÚÕâÀïÎҾͲ»Ò»Ò» ......