rt
http://download.csdn.net/source/1930911
ÒýÓÃ
ÏÖÔڵĺ¢×ÓÔ½À´Ô½»áÒÂÀ´ÉìÊÖÁË£¬µ½ Oracle ÍøÕ¾ÉÏÈ¥ÕÒÕÒ²»¾ÍÓÐÁËô£¿
http://www.oracle.com/technology/global/cn/software/tech/java/sqlj_jdbc/index.html
½¨ÒéʹÓÃ×îеÄÇý¶¯£¬JDBC Çý¶¯Ò²ÓмæÈÝÐÔ£¬¾ßÌåµÄ¼æÈÝÐÔ¿ÉÒÔ¿´Õâ¸öÒ³Ãæ£º
http://www.oracle.com ......
ÎÒÓÃc#.netÏë°ÑͼƬֱ½Ó´æ´¢ÔÚoracleÊý¾Ý¿âÖУ¬ÏÖÔÚ¶Áд²Ù×÷²»ÖªµÀ¸ÃÔõôдÁË£¬
»¹ÓÐÏÖÔÚÔÚSqlServer ÖÐÓÐһЩÊý¾ÝÒ²ÊÇͼƬÀàÐÍ£¨image£©µÄÐèÒªµ¼µ½ oracleÊý¾Ý¿âÖУ¬
Çë¸÷λ¸ßÊÖ°ïæ
1.ÔÚoracleÊý¾Ý¿â½¨Á¢Ò»Ìõº¬blob×ֶεıí
2.ÔÚ±íÖвåÈëÒ»Ìõ¿ÕµÄ¼Ç¼,blob×Ö¶ÎÒª¸ø³öÒýÈëµã£¬ÓÃempty_blob()
3.ÓÃÁ÷¶ÔÕâ¸ö×Ö¶ÎÀ´½øÐж ......
±¾ÈËÏÖÔÚѧoracle ËãÊǸոÕÈëÒ»°ëÃÅ ÒÔºó»¹ÒªÑ§java ¸÷λ´óÏÀoracleºÃÈëÊÖ»¹ÊÇjavaºÃÈëÊÖ°¡ ÒÔºóÄǸö·½Ãæ·¢Õ¹»áºÃЩ
£¬ÎÒÔÝʱÓиöÏë·¨ÏëºÃºÃѧϰһÏÂÊý¾Ý¿âÒÔºóÍùÕâ·½±ã·¢Õ¹£¬±Ï¾¹Êý¾Ý¿â¸úл»´úûÓÐjavaÄÇô¿ì£¬²»Óþ³£Í¶ÈëѧϰÐµĶ«Î÷ÉÏ¡£»¹ÓоÍÊÇ´ýÓö·½Ãæ ¸Ð¾õÊý¾Ý¿âÒª¸ßÓÚÈí¼þ¿ª·¢¡£
ÓÐÁ˽âÊý¾Ý¿âµÄÅóÓѸøµã¿´·¨ Êý ......
C# code:
string StrConnection = "Server=127.0.0.1;Data Source=kagami;User ID=system;Password=kagami;";
string strCommand = "SELECT id as ²úÆ·±àºÅ, name as ²úÆ·Ãû×Ö from test";
OracleConnection OraCon = new OracleConnection(StrConnection);
......
ÎÒÊÇÏë°ÑÒ»ÕűíÀïµÄ¶àÌõ¼Ç¼µÄÈý¸ö×Ö¶ÎÐÞ¸ÄΪÁíÒ»ÕűíÀï¶àÌõ¼Ç¼¶ÔÓ¦µÄÈý¸ö×ֶΣ¬µ«Êǽá¹ûÈ´ÊDZ»Ð޸ĵıíÈý¸ö×ֶζàÌõ¼Ç¼Öж¼ÊÇһģһÑùµÄ¡£´æ´¢¹ý³Ì±àÒëûÓÐÎÊÌ⣬ÓαêÈ´ÔÚÔËÐÐʱδÓÐÒÆÏòÏÂÌõ¼Ç¼£¬ÎªÊ²Ã´ÄØ£¿³ÌÐòÈçÏ£º
create or replace procedure cust_update is
cursor v_cur is
select cust_id, ......
ÈçÌ⣬±¾ÈËÊÇoracleÐÂÊÖ£¬Çë¸ßÊÖÖ¸µãһϡ£
½¨ÒéÄãѧϰÏÂORacleÌåϵ½á¹¹°É
±í¿Õ¼äÊÇÂß¼¸ÅÄî,Ò»¸ö±í¿Õ¼ä¾ÍÊÇһƬ´ÅÅÌÇøÓò,ËûÓÖÒ»¸ö»òÕß¶à¸ö´ÅÅÌÎļþ×é³É,Ò»¸ö±í¿Õ¼ä¿ÉÒÔÈÝÄÉÐí¶à±í¡¢Ë÷Òý»òÕߴصÈ
¿ÉÒÔÕâÀïÀí½â
±í¿Õ¼ä¿ÉÒÔÓжà¸öÊý¾ÝÎļþ£¬Ò»¸öÊý¾ÝÎļþÖ»ÊôÓÚÒ»¸ö±í¿Õ¼ä£¬ÎÒ×Ô¼ºÀí½â±í¿Õ¼ä¾ÍÏ൱ÓÚsqlÒ»¸öÊý¾ ......