java存储数据库
‘壹’ 濡备綍鍦∣racle鏁版嵁搴扑腑浣跨敤java瀛桦偍杩囩▼
銆銆链鏂囦互Oracle涓轰緥 浠嬬粛涓涓媕ava瀛桦偍杩囩▼镄勫叿浣撶敤娉
銆銆
銆銆
銆銆 涓 濡备綍鍒涘缓java瀛桦偍杩囩▼锛
銆銆阃氩父链変笁绉嶆柟娉曟潵鍒涘缓java瀛桦偍杩囩▼
銆銆
銆銆 浣跨敤Oracle镄剆ql璇鍙ユ潵鍒涘缓
銆銆
銆銆e g 浣跨敤create or replace and pile java source named as
銆銆钖庤竟璺熶笂java婧愮▼搴 瑕佹眰绫荤殑鏂规硶蹇呴’鏄痯ublic static镄 镓嶈兘鐢ㄤ簬瀛桦偍杩囩▼
銆銆
銆銆sql> create or replace and pile java source named javademo
銆銆 as
銆銆 import java sql *;
銆銆 public class JavaDemo
銆銆 {
銆銆 public static void main(String[] argv)
銆銆 {
銆銆 System out println( hello java demo );
銆銆 }
銆銆 }
銆銆 /
銆銆
銆銆Java 宸插垱寤
銆銆
銆銆SQL> show errors java source javademo
銆銆娌℃湁阌栾
銆銆
銆銆SQL> create or replace procere javademo
銆銆 as
銆銆 language java name JavaDemo main(java lang String[]) ;
銆銆 /
銆銆
銆銆杩囩▼宸插垱寤
銆銆
銆銆SQL> set serveroutput on
銆銆SQL> call javademo ();
銆銆
銆銆璋幂敤瀹屾垚
銆銆
銆銆SQL> call dbms_java set_output( );
銆銆
銆銆璋幂敤瀹屾垚
銆銆
銆銆SQL> call javademo ();
銆銆hello java demo
銆銆
銆銆璋幂敤瀹屾垚
銆銆
銆銆SQL> call javademo ();
銆銆hello java demo
銆銆璋幂敤瀹屾垚
銆銆 浣跨敤澶栭儴class鏂囦欢𨱒ヨ呰浇鍒涘缓
銆銆e g 杩欓噷镞㈢劧鐢ㄥ埌浜嗗栭儴鏂囦欢 蹇呯劧瑕佸皢class鏂囦欢鏀惧埌oracle Server镄勬煇涓鐩褰曚笅杈
銆銆
銆銆public class OracleJavaProc
銆銆{
銆銆public static void main(String[] argv)
銆銆{
銆銆System out println( It s a Java Oracle procere );
銆銆}
銆銆}
銆銆
銆銆
銆銆SQL> grant create any directory to scott;
銆銆
銆銆鎺堟潈鎴愬姛
銆銆
銆銆SQL> conn scott/tiger@iihero oracledb
銆銆宸茶繛鎺
銆銆SQL> create or replace directory test_dir as d:oracle ;
銆銆
銆銆鐩褰曞凡鍒涘缓
銆銆
銆銆SQL> create or replace java class using bfile(test_dir OracleJavaProc CLASS )
銆銆 /
銆銆
銆銆Java 宸插垱寤
銆銆
銆銆SQL> create or replace procere testjavaproc as language java name OracleJavaProc main(java lang String[]) ;
銆銆 /
銆銆
銆銆杩囩▼宸插垱寤
銆銆
銆銆SQL> call testjavaproc();
銆銆
銆銆璋幂敤瀹屾垚
銆銆
銆銆SQL> execute testjavaproc;
銆銆
銆銆PL/SQL 杩囩▼宸叉垚锷熷畬鎴
銆銆
銆銆SQL> set serveroutput on size
銆銆SQL> call dbms_java set_output( );
銆銆
銆銆璋幂敤瀹屾垚
銆銆
銆銆SQL> execute testjavaproc;
lishixin/Article/program/Oracle/201311/17720