隨筆-204 
評(píng)論-90 
文章-8 
trackbacks-0

          
	

          

          
	
					


          
	
	
		
          
		
          
		
          在oracle中調(diào)用java程序
          一、helloWord
          1 編寫(xiě)JAVA程序 
          
		
          
		
          
		
          
				
				create
				?
				or
				?
				replace
				?
				and
				?compile?java?source?named?hello?
				as
				
						
          
						?          
				public
				???class??Hello???{
          ????????static???          
				public
				??String?Message(String?name)???{
          ???????????          
				return
				???"?Hello,??"???
				+
				??name;
          ???????}?
          }?
          ?          
				/
				?
          
		
          
		
          2 發(fā)布JAVA程序
          
		
          
		
          
		
          
				
				create
				?
				or
				?
				replace
				?
				function
				?hello?(name?
				VARCHAR2
				)??
				return
				??
				VARCHAR2
				
						
          
						?????          
				as
				?language?java?name
          ??????          
				'
				?Hello.Message?(java.lang.String)?return?java.lang.String?
				'
				?;
          ?          
				/
				?
          
		
          
		
          3 使用發(fā)面的JAVA程序
          
		
          
				
				select
				?hello(
				'
				world!
				'
				)?
				from
				?dual;
          HELLO(          
				'
				world!
				'
				)
          
				--
				-------------
				
						
          
						
				          
				Hello?world!
          
		
          
		
          ???? 
          二、在JAVA程序中使用SQL
          1 編寫(xiě)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
          ????????{
          ?????????????conn?          
				=
				?DriverManager.getConnection("jdbc:
				default
				:connection:");
          ?????????????pstmt?          
				=
				?conn.prepareStatement(sql);
          ?????????????rs?          
				=
				?pstmt.executeQuery();
          ?????????????
          ?????????????          
				if
				(rs.
				next
				())
          ??????????tmpStr?          
				=
				?rs.getString("dd");
          ????????          
				else
				
						
          
						??????????tmpStr?          
				=
				?name;
          ?????????}
          ????????catch(SQLException?e)
          ????????{
          ????????????System.err.println(e.getMessage());
          ????????}
          ????????finally
          ????????{
          ????????????try
          ????????????{
          ????????????????rs.          
				close
				();
          ????????????????pstmt.          
				close
				();
          ????????????????          
				
				
						/*
						if((conn!=null)||!conn.isClosed())
          ????????????????????conn.close();          
						*/
				          
				
						
          
						????????????}
          ????????????catch(SQLException?e)
          ????????????{
          ????????????????System.err.println(e.getMessage());
          ????????????}
          ????????}
          ???????          
				return
				?tmpStr;
          ???}
          }
          
				/
				
						
          
						
						
          
						
				          
		
          
		
          2 發(fā)布JAVA程序
          
		
          
				
				create
				?
				or
				?
				replace
				?
				function
				?test?(name?
				varchar2
				)?
				return
				?
				varchar2
				
						
          
						?          
				as
				?language?java?name
          
				'
				Test.message(java.lang.String)?return?java.lang.String
				'
				;
          
				/
				
						
          
						
				          
		
          
		
          3 使用發(fā)面的JAVA程序
          
		
          
				
				?
				select
				??test(?
				'
				?xx?
				'
				?)??
				from
				??dual?;

          TEST(?          
				'
				?XX?
				'
				?)
          ?          
				--
				?------------------------------------------------------------------------------?
				
						
          
						
				          
				?
				2006
				?
				-
				?
				07
				?
				-
				?
				14
				???
				14
				?:?
				37
				?:?
				40.0
				?
          
		
          

	
          posted on 2006-07-14 14:54 一凡 閱讀(1251) 評(píng)論(0)  編輯  收藏  所屬分類(lèi): DATABASE 
          

          







          
	    
    




          








          

				

          







    







          
        
	




主站蜘蛛池模板：
肥乡县|
保靖县|
德令哈市|
霍州市|
隆尧县|
肇庆市|
肇源县|
永顺县|
临漳县|
乐陵市|
黎城县|
兰州市|
富锦市|
桃江县|
枣庄市|
清新县|
托里县|
行唐县|
平顺县|
繁昌县|
吉木乃县|
常山县|
静安区|
牙克石市|
新河县|
都江堰市|
中西区|
伊川县|
长宁县|
资兴市|
拉孜县|
兖州市|
二连浩特市|
竹山县|
罗平县|
太湖县|
辉县市|
红原县|
英吉沙县|
密山市|
池州市|