ÒÔǰֻ֪µÀ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 ' ;
......
ÒÔǰֻ֪µÀ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 ' ;
......
¡¡¡¡
ÔÚÃæÏò¶ÔÏó±à³ÌÖУ¬¶ÔÓÚÀ࣬¶ÔÏ󣬷½·¨£¬±äÁ¿µÈ·½ÃæµÄÃüÃûÊǷdz£Óм¼Çɵġ£±ÈÈ磬´óСдµÄÇø·Ö£¬Ê¹Óò»Í¬
×Öĸ¿ªÍ·µÈµÈ¡£µ«¾¿Æä±¾£¬×·ÆäÔ´£¬ÔÚΪһ¸ö×ÊÔ´ÆäÃû³ÆµÄʱºò£¬Ó¦¸Ã±¾×ÅÃèÊöÐÔÒÔ¼°Î¨Ò»ÐÔÕâÁ½´óÌØÕ÷À´ÃüÃû£¬²ÅÄܱ£Ö¤×ÊÔ´Ö®¼ä²»³åÍ»£¬²¢ÇÒÿһ¸ö¶¼±ãÓÚ¼Ç
Òä¡£
°üµÄÃüÃû
¡¡
¡¡¡¡Java°üµÄÃû×Ö¶¼ÊÇÓÉСдµ¥´Ê×é³É¡£µ«ÊÇÓÉÓÚJavaÃæÏò¶ÔÏó±à³ÌµÄÌØ
ÐÔ£¬Ã¿Ò»ÃûJava³ÌÐòÔ±¶¼¿ÉÒÔ±àдÊôÓÚ×Ô¼ºµÄJava°ü£¬ÎªÁ˱£ÕÏÿ¸öJava°üÃüÃûµÄΨһÐÔ£¬ÔÚ×îеÄJava±à³Ì¹æ·¶ÖУ¬ÒªÇó³ÌÐòÔ±ÔÚ×Ô¼º¶¨ÒåµÄ°ü
µÄÃû³ÆÖ®Ç°¼ÓÉÏΨһµÄǰ׺¡£ÓÉÓÚ»¥ÁªÍøÉϵÄÓòÃû³ÆÊDz»»áÖØ¸´µÄ£¬ËùÒÔ³ÌÐòÔ±Ò»°ã²ÉÓÃ×Ô¼ºÔÚ»¥ÁªÍøÉϵÄÓòÃû³Æ×÷Ϊ×Ô¼º³ÌÐò°üµÄΨһǰ׺¡£
¡¡¡¡ÀýÈ磺
net.frontfree.javagroup
ÀàµÄÃüÃû
¡¡¡¡
ÀàµÄÃû×Ö±ØÐëÓÉ´óд×Öĸ¿ªÍ·¶øµ¥´ÊÖÐµÄÆäËû×Öĸ¾ùΪСд£»Èç¹ûÀàÃû³ÆÓɶà¸öµ¥´Ê×é³É£¬Ôòÿ¸öµ¥´ÊµÄÊ××Öĸ¾ùӦΪ´óдÀýÈçTestPage£»Èç¹ ......
·´Éä»úÖÆ
ÌØµã£º¶¯Ì¬»ñÈ¡ÀàÒÔ¼°ÀàÖгÉÔ±¡£
ͨ³£ÔÚ³ÌÐòÀ©Õ¹Ê±£¬»áʹÓø¸Àà»òÕß½Ó¿ÚÍê³É£¬Æäʵ¾ÍÊǶà̬¡£
ÔÚÕâÖÖÇé¿ö£¬ÔËÐÐʱ£¬»¹ÊÇÐèÒª¸øÆä´«µÝÒ»¸ö×Ô¶¨ÒåµÄ×ÓÀà¶ÔÏó¡£ÐèÒª×Ô¼ºnewÀ´Íê³É¡£
ËäÈ»Ð޸͝×÷ÒѾºÜÉÙÁË£¬µ«»¹ÊÇÐèÒªÐ޸IJ¿·Öϸ½Ú¡£
interface Inter{void show();}
class Demo{
void function(Inter in){
in.show();
}
}
main(){
Demo d = new Demo();
d.function(new InterImpl());//ÕâÀïÐèÒª´«ÈëÒ»¸öеĺóÆÚ×ÓÀà¶ÔÏó¡£
}
class InterImpl implements Inter{
public void show(){}
}
Äܲ»ÄÜÍêÈ«²»¸Ä¶¯Ô´³ÌÐò£¬¾Í¿ÉÒÔÔËÐкóÆÚ×ÓÀàÄÚÈÝÄØ£¿
ÎÒÃÇ¿ÉÒÔ¶ÔÍⱩ¶һ¸öÅäÖÃÎļþ£¬¸ÃÅäÖÃÎļþ¿ÉÒÔÊǼüÖµ¶ÔÐÎʽµÄ.iniÎļþ¡¢xmlÎļþ¡£
ͨ¹ý·´Éä»úÖÆ¶¯Ì¬»ñÈ¡×ÓÀà×Ö½ÚÂëÎļþ£¬²¢¶¯Ì¬´´½¨Æä¶ÔÏó¡£
main(){
Demo d = new Demo();
BufferdReader bufr = new BufferedReader(new FileReader("config.txt"));
String className = bufr.re ......
¶øÇÒjavaÌṩµÄÈÝÆ÷ÀàºÜ·½±ã£¬ÊÖ¹¤¹¹ÔìÁËÒ»¿Å¶à²æÊ÷¡£È»ºóÔٵݹé±éÀú¡£ÀàËÆÓÚÖÐÐò±éÀú°É¡£
Ê÷µÄ½ÚµãÀà:
Java´úÂë
package TestTwo;
import java.util.ArrayList;
import java.util.List;
//¶à²æÊ÷µÄ½Úµã
public class ManyTreeNode {
//½ÚµãµÄÄÚÈÝ
private NodeBean data ;
//½ÚµãÁбí
private List<ManyTreeNode> childList;
//¹¹Ô캯Êý
public ManyTreeNode(){
data = new NodeBean();
childList = new ArrayList<ManyTreeNode>(); &n ......
ѧÁ˼¯ºÏÀ࣬ÏëÓÃJavaµÄ¼¯ºÏÀà±àÒ»¸öͨѶ¼£¬¿ÉÊÇ·¢ÏÖÌâĿҪ¶ÔͨѶ¼ÖеÄÐÕÃûºÍ±àºÅ½øÐÐÅÅÐò¡£
²ËÄñ¸Õ¸ÕѧJava£¬±¾À´»¹Õæ²»ÖªµÀÓÐ±È½ÏÆ÷£¬ºÙºÙ£¬ÒÔΪJavaÊÇÈç´ËÇ¿´ó£¬¿ÉÒÔÖ±½Óµ÷ÓÃSort()·½·¨¾Í¿ÉÒÔ¶Ô¼¯ºÏÀàÖеĶÔÏó½øÐÐÅÅÐò£¬ºÙºÙ£¬ÓÚÊDZãÊÔÁËһϣ¬Ì«²»ºÃʹÁËѽ£¬ºÙºÙ£¬ÓÚÊÇÎÒ¿´ÁË¿´Ê飬µ½ÍøÉϲéÁ˲飬ÔÀ´ÒªÊµÏÖ±È½ÏÆ÷µÄ½Ó¿Ú£¬¶ø»ØÍ·ÔÙ¿´¿´sort()Õâ¸ö·½·¨ÓÐÒ»¸ö±ØÑ¡²ÎÊý£¬Ò»¸ö¿ÉÑ¡²ÎÊý£¬¶øÕâ¸ö¿ÉÑ¡²ÎÊý¾ÓÈ»ÊÇcomparatorµÄ¶ÔÏó¡£ÓÚÊÇÎÒѧУÁË±È½ÏÆ÷¡£ÏÂÃæ×ܽáһϡ£
±È½ÏÆ÷µÄʵÏÖÓÐÁ½¸ö·½·¨£º
1.½«Òª½øÐбȽϵĶÔÏóʵÏÖcomparable½Ó¿Ú£¬È»ºóÖØÐ´ÀïÃæµÄcompareTo(T o)·½·¨£¬¸ù¾Ý×Ô¼ºµÄÐèÒªÖØÐ´Õâ¸ö·½·¨¡£ÕâÀïµÄ·µ»ØÖµÊÇintÀàÐ͵ģ¬±È½Ï´Ë¶ÔÏóÓëÖ¸¶¨¶ÔÏóµÄ˳Ðò¡£Èç¹û¸Ã¶ÔÏóСÓÚ¡¢µÈÓÚ»ò´óÓÚÖ¸¶¨¶ÔÏó£¬Ôò·Ö±ð·µ»Ø¸ºÕûÊý¡¢Áã»òÕýÕûÊý¡£
×¢£ºÓôËÖÖ·½·¨µÄÀàÉú³ÉµÄ¶ÔÏóÔÙÅÅÐòµÄʱºòµ÷ÓÃsort()·½·¨µÄʱºò²»ÐèÒª´«ÈëÄǸöcomparator¶ÔÏóµÄ¿ÉÑ¡²ÎÊý¡£
2.ÖØÐÂдһ¸ö±È½ÏÆ÷µÄÀ࣬´ËÀàʵÏÖÁËcomparator½Ó¿Ú£¬ÖØÐ´ÆäÖеÄcompare(T o1,T o2)£¨±È½ÏÓÃÀ´ÅÅÐòµÄÁ½¸ö²ÎÊý¡£ËæµÚÒ»¸ö²ÎÊýСÓÚ¡¢µÈÓÚ»ò´óÓÚµÚ¶þ¸ö²ÎÊý¶ø·Ö±ð·µ»Ø¸ºÕûÊý¡¢Áã»òÕýÕûÊý¡££©,È»ºóÓôËÀàÉú³ÉÒ»¸ö¶ÔÏó£¬ÔÚµ÷ÓÃsort()·½ ......
µÚÒ»£ºÒªÉèÖÃSQL ServerµÄTCP/IP·þÎñ
1) ´ò¿ªSQL Server Configuration Manager”,Ë«»÷“SQL Server 2005ÍøÂçÅäÖÔ£¬µã»÷“*** µÄÐÒé” (×¢Ò⣺***´ú±íʵÀýÃüÃû£¬ÀýÈ磺accpDBµÄÐÒé)
2) Ñ¡ÔñÓұߴ°¿ÚÖеēTCP/IP”ÐÒ飬ÓÒ¼üµ¥»÷Ñ¡Ôñ“Æô¶¯”¡£
3) Ë«»÷“TCP/IP”½øÈëÊôÐÔÉèÖã¬ÔÚ“IP µØÖ·”À¿ÉÒÔÅäÖÓIPAll”ÖеēTCP ¶Ë¿Ú”£¬Ä¬ÈÏΪ1433£¬½«IPµØÖ·ÖеēÒÑÆôÓÔÉèΪ“ÊÇ”¡£
4) ÖØÐÂÆô¶¯SQL Server
µÚ¶þ£ºÁ½ÖÖÁ¬½Ó·½Ê½
µÚÒ»ÖÖ£ºodbc·½Ê½£º
»ù±¾²½ÖèºÍÁ¬½ÓSQL 2000Ïàͬ£¬ÓÐÒÔÏÂÇø±ðµã£º
µÚ¶þÖÖ£º´¿Á¬½Ó·½Ê½
SQL Server2000·½Ê½£ºµ¼Èëmsbase.jar¡¢mssqlserver.jar¡¢msutil.jar
Çý¶¯×Ö·û´®£ºcom.microsoft.jdbc.sqlserver.SQLServerDriver
URL×Ö·û´®£º
jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Êý¾Ý¿âà ......
µÚÒ»£ºÒªÉèÖÃSQL ServerµÄTCP/IP·þÎñ
1) ´ò¿ªSQL Server Configuration Manager”,Ë«»÷“SQL Server 2005ÍøÂçÅäÖÔ£¬µã»÷“*** µÄÐÒé” (×¢Ò⣺***´ú±íʵÀýÃüÃû£¬ÀýÈ磺accpDBµÄÐÒé)
2) Ñ¡ÔñÓұߴ°¿ÚÖеēTCP/IP”ÐÒ飬ÓÒ¼üµ¥»÷Ñ¡Ôñ“Æô¶¯”¡£
3) Ë«»÷“TCP/IP”½øÈëÊôÐÔÉèÖã¬ÔÚ“IP µØÖ·”À¿ÉÒÔÅäÖÓIPAll”ÖеēTCP ¶Ë¿Ú”£¬Ä¬ÈÏΪ1433£¬½«IPµØÖ·ÖеēÒÑÆôÓÔÉèΪ“ÊÇ”¡£
4) ÖØÐÂÆô¶¯SQL Server
µÚ¶þ£ºÁ½ÖÖÁ¬½Ó·½Ê½
µÚÒ»ÖÖ£ºodbc·½Ê½£º
»ù±¾²½ÖèºÍÁ¬½ÓSQL 2000Ïàͬ£¬ÓÐÒÔÏÂÇø±ðµã£º
µÚ¶þÖÖ£º´¿Á¬½Ó·½Ê½
SQL Server2000·½Ê½£ºµ¼Èëmsbase.jar¡¢mssqlserver.jar¡¢msutil.jar
Çý¶¯×Ö·û´®£ºcom.microsoft.jdbc.sqlserver.SQLServerDriver
URL×Ö·û´®£º
jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Êý¾Ý¿âà ......