Java»ñÈ¡Oracle´æ´¢¹ý³ÌÖÐÖ´Ðвéѯ·µ»ØµÄ½á¹û¼¯
ͨ¹ýJAVAµ÷ÓÃORACLEµÄ´æ´¢¹ý³Ì£¬ÔÚORACLEµÄ´æ´¢¹ý³ÌÄÚ²¿×öÁËÒ»¸ö²éѯÔÚJAVAÖлñÈ¡¸Ã²éѯ½á¹û£¬Õâ¸öºÍSYBASE¡¢SQLSERVERµÄ»ñÈ¡²»Ò»Ñù£¬µÈÎÒµÄÏÂһƪÎÄÕÂÎÒ»á½éÉÜÈçºÎ»ñÈ¡SYBASE¡¢SQLSERVERÔÚ´æ´¢¹ý³ÌÖÐÖ´ÐÐÁ˲éѯºóÈçºÎ»ñÈ¡Æä½á¹û¼°´æ´¢¹ý³ÌµÄ±àд¡£
ÔÚOracleÖÐÐèÒª·µ»Ø²éѯ½á¹û¼¯£¬±ØÐ뽫ÆäÒÔÓαêµÄÐÎʽ·µ»Ø£¬µ«ÓαêÓÖ²»ÊÇ»ù´¡ÀàÐÍ£¬Òò¶ø²»Äܹ»Ïñ·µ»Ø×Ö·ûÀàÐÍÒ»ÑùÖ±½Ó¿ÉÒÔ·µ»Ø£¬ÈçÎÒÃǶ¨ÒåÒ»°ãµÄ´æ´¢¹ý³ÌÈçÏ£º
CREATE OR REPLACE PROCEDURE simpleProc
(
outpara OUT VARCHAR2
)
AS
BEGIN
outpara:='¼òµ¥¹ý³Ì';
return;
END;
¶¨Òå·µ»Ø½á¹û¼¯µÄ´æ´¢¹ý³Ì£¬²»Äܹ»¶¨Òå³ÉÈçÏ·½Ê½£º
procedure testQuery
(
return_rs out CURSOR --CURSORÖ»ÊÇÒ»¸ö¹Ø¼ü×Ö£¬µ«²¢²»ÊÇÒ»ÖÖÀàÐÍ£¬ËùÒÔÔÚ´æ´¢¹ý³ÌÖÐÕâÑùд»á±¨"CURSORÀàÐÍ´ò²»µ½"µÄ´íÎó
)
as
begin
--......
end;
ÎÒÃÇÐèÒª½«¹ý³Ì¶¨Òåµ½°üÖУ¬ÔÚ°üÀïÃæÏȶ¨ÒåÓαêÒýÓã¬È»ºó²ÅÄܹ»ÔÚ¹ý³ÌµÄÊä³ö²ÎÊýÖÐÒýÓøÃÀàÐÍ£¬ÈçÏ£º
CREATE OR REPLACE PACKAGE TestQueryPkg
IS
--¶¨ÒåÓαêÒýÓ㬺óÃæ¾Í¿ÉÒÔÔÚÊä³ö²ÎÊýÖж¨ÒåΪ¸ÃÀàÐÍÊä³ö
TYPE cur_rs IS ref CURSOR;
PROCEDURE testQuery(return_rs OUT cur_rs);
END;
CREATE OR REPLACE PACKAGE BODY TestQueryPkg
IS
procedure testQuery
(
return_rs out cur_rs
)
as
begin
open return_rs for
select username from pcmc_user;
return;
end;
END;
»ñÈ¡Êä³ö½á¹ûµÄJAVA´úÂëÈçÏ·½·¨£º
/**
* Ö´ÐÐORACLE´æ´¢¹ý³Ì£¬»ñÈ¡ÔÚ¹ý³ÌÖÐÊä³öµÄ²éѯ½á¹û¼¯
*
*/
public static void doTestQuery(){
Function function=new Function();
//»
Ïà¹ØÎĵµ£º
³ÌÐòÊǺܼòÒ׵ġ£È»¶ø£¬ÔÚ±à³ÌÈËÔ±ÃæÇ°£¬¶àÏ̳߳ÊÏÖ³öÁËÒ»×éеÄÄÑÌ⣬Èç¹ûûÓб»Ç¡µ±µÄ½â¾ö£¬½«µ¼ÖÂÒâÍâµÄÐÐΪÒÔ¼°Ï¸Î¢µÄ¡¢ÄÑÒÔ·¢ÏֵĴíÎó¡£
ÔÚ±¾ÆªÎÄÕÂÖУ¬ÎÒÃÇÕë¶ÔÕâЩÄÑÌâÖ®Ò»£ºÈçºÎÖжÏÒ»¸öÕýÔÚÔËÐеÄÏ̡߳£
& ......
ÔÚCSDNÖп´µ½Á˸öÓйØjava¼¼ÇɵÄÌû×Ó£¬¾õµÃ·Ç³£ÓÐÓ㬿ÉÒÔ±ÜÃ⿪·¢¹ý³ÌÖвúÉúµÄһЩµÍ¼¶µÄ´íÎó£¬Ìû×Ó±¾ÉíÒѾ½øÐÐÁË×ܽᣬÎÒÌô³öÁËÆäÖÐһЩ¸öÈ˾õµÃƽʱ¿ª·¢¹ý³ÌÖÐÓÐÓõIJ¿·Ö£¬ÔÙ¼ÓÉÏ×Ô¼ºÔÚ¹¤×÷ÖÐѧµ½µÄ¼¼ÇÉ£¬ÕûÀíÔÚ±¾ÎÄÖУ¬²¢Ëæ×Åʱ¼äʵʱ¸üÐÂ
1¡¢Ð´ºÃ×¢ÊÍ¡£ÊäÈë²ÎÊý¡¢Êä³öÀàÐÍ¡¢·½·¨¹¦ÄÜ£¬°ÑÕâÈýµãÃè ......
http://school.itzcn.com/special-spid-50.html
Òì³£¸úÆÕͨµÄ¾¯¸æµÈÓÐÒ»¶¨µÄÇø±ð¡£µ±Ó¦ÓóÌÐò·¢ÉúÒ쳣ʱ£¬»áÖжÏÕýÔÚÖ´ÐеijÌÐòµÄÕý³£Ö¸ÁîÁ÷¡£Ò²¾ÍÊÇ˵£¬·¢ÉúÒì³£ºóÃæµÄ´úÂ뽫µÃ²»µ½ÕýÈ·µÄÖ´ÐС£ÉõÖÁ»¹»á´¥·¢Êý¾Ý¿âµÄ»ØÍ˲Ù×÷¡£
¡¡¡¡ÔÚJava¿ª·¢Æ½Ì¨ÖУ¬Òì³£°üÀ¨Ô¤¶¨ÒåÒì³£Óë×Ô¶¨ÒåÒì³£¡£ÕâÁ½ÖÖÒì³£µÄÀàÐÍ»¥Îª²¹³ä¡£×÷Ϊһ ......