oracleµ÷ÓÃjava·½·¨µÄÀý×Ó

ÔÚoracleÖе÷ÓÃjava³ÌÐò,×¢Òâ:java·½·¨±ØÐëÊÇstaticÀàÐ͵Ä,Èç¹ûÏëÔÚJAVAÖÐʹÓÃsystem.out/errÊä³ölog.
ÐèÒªÔÚoracle ÖÐÖ´ÐÐ"call dbms_java.set_output(5000);".
Ò»¡¢helloWord
1 ±àдJAVA³ÌÐò,Ò²ÊÇÔÚSQL/PLUSÖÐд,²¢Ö´ÐÐ.
create or replace and compile java source named hello as
public     class   Hello    {
         static    public    String Message(String name)    {
            return     " Hello,   "    +    name;
        }
}
/
2 ·¢²¼JAVA³ÌÐò
create or replace function hello (name VARCHAR2 )   return    VARCHAR2
      as language java name
       ' Hello.Message (java.lang.String) return java.lang.String ' ;
/
3 ʹÓ÷¢ÃæµÄJAVA³ÌÐò
select hello( ' world! ' ) from dual;
HELLO( ' world! ' )
-- -------------
Hello world!
    
¶þ¡¢ÔÚJAVA³ÌÐòÖÐʹÓÃSQL
1 ±àдJAVA³ÌÐò
create or replace and compile java source named test as
import java.sql. * ;
import java. text .DateFormat;
import java. text .SimpleDateFormat;
import java.util. * ;
import java.util.Date;
import com.ccit.wcsmp.comm.vo.daovo.MBTResultVO;
import oracle.sql.ARRAY;
import oracle.sql.ArrayDescriptor;
public class Test
{
   static public String   message(String name) {
        String sql = " select sysdate as dd from dual";
        String tmpStr = null ;
        PreparedStatement pstmt = null ;
        ResultSet rs = null ;
        Connection conn = null ;
         try