oracleÖÐjdbcÇý¶¯°üµÄ˵Ã÷
´Óoracle8µ½oracle10£¬JDBCĿ¼ÏµÄÇý¶¯°ü¶¼¸÷Óв»Í¬¡£¿´ÁËÒ»ÏÂoracleµÄÎĵµËµÃ÷£¬Á˽âÁËÒ»ÏÂËüÃǵÄÓÃ;£¬ÏàÐÅ´ó¼ÒÓÐʱºòÒ²ºÜÃÔ»ó£¬Ð´³öÀ´¹²Ïíһϡ£
ÕâЩÊÇoracle10gϵÄÇý¶¯°üµÄÃû³ÆºÍËüÃǵÄ×÷Óã¬ÆäËû°æ±¾µÄoracle»ù±¾ÀàËÆ¡£
Ö§³ÖËùÓÐÆ½Ì¨µÄJDBC ThinÇý¶¯
classes12.jar (1,417,089 bytes) - JDK 1.2 ºÍ JDK 1.3ÏÂʹÓÃ
classes12_g.jar (1,794,418 bytes) - ºÍclasses12.jarÏàͬ, µ«ÊǰüÖеÄÀàʹÓÃ"javac -g"ÃüÁî±àÒ룬°üº¬µ÷ÊÔÐÅÏ¢.
classes12dms.jar (1,424,743 bytes) - ºÍclasses12.jarÏàͬ, µ«Êǰüº¬Ò»Ð©¸½¼ÓµÄ´úÂëÖ§³ÖOracle Dynamic Monitoring Service.
classes12dms_g.jar (1,802,368 bytes) - ºÍ classes12dms.jarÏàͬ£¬µ«ÊǰüÖеÄÀàʹÓÃ"javac -g"±àÒ룬°üº¬µ÷ÊÔÐÅÏ¢.
ojdbc14.jar (1,352,918 bytes) - JDK 1.4ÏÂʹÓÃ
ojdbc14_g.jar (1,691,855 bytes) - ºÍojdbc14.jarÏàͬ,µ«ÊǰüÖеÄÀàʹÓÃ"javac -g"±àÒ룬°üº¬µ÷ÊÔÐÅÏ¢.
ocrs12.jar (54,030 bytes) - ÒýÈëÁËjavax.sql.rowset½Ó¿Ú, ÈçCachedRowSet ºÍ WebRowSet. ¿ÉÒÔÔÚ JDK 1.2, 1.3, ºÍ 1.4ÏÂʹÓÃ.
orai18n.jar (5,018,093 bytes) - ʹÓÃÔÚJDK 1.2, 1.3 ºÍ 1.4ϵÄNLS(National Language Support,¹ú¼ÒÓïÑÔÖ§³Ö)Àà.Õâ¸öjar°üÌæ»»ÁËÀϵÄnls_charset jar/zip Îļþ.
demo.tar (532,480 bytes) - °üº¬Ò»Ð©JDBCÀý³Ì.
Ïà¹ØÎĵµ£º
ÒÔϼ¸ÖÖÔ¼Êø ¡¢²¢ Ò»Ò»Áо٣º
1.Ö÷¼üÔ¼Êø£º
Òª¶ÔÒ»¸öÁмÓÖ÷¼üÔ¼ÊøµÄ»°£¬ÕâÁоͱØÐëÒªÂú×ãµÄÌõ¼þ¾ÍÊÇ·Ö¿Õ
ÒòΪÖ÷¼üÔ¼Êø£º¾ÍÊǶÔÒ»¸öÁнøÐÐÁËÔ¼Êø£¬Ô¼ÊøÎª£¨·Ç¿Õ¡¢²»Öظ´£©
ÒÔÏÂÊÇ´úÂë Òª¶ÔÒ»¸öÁмÓÖ÷¼ü£¬ÁÐÃûΪid,±íÃûΪemp
¸ñʽΪ£º
alter table ±í¸ñÃû³Æ add constraint Ô¼ÊøÃû³Æ Ôö¼ÓµÄÔ¼ÊøÀàÐÍ £¨ÁÐÃû£©
À ......
¸ü¸Äoracle Listener ÅäÖãºD:\Oracle\moon\product\11.1.0\db_1\NETWORK\ADMIN Ŀ¼֮Ï£ºListener.oraÎļþ½øÐÐÅäÖãº
# listener.ora Network Configuration File: d:\Oracle\moon\product\11.1.0\db_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SI ......
1¡¢´´½¨±í£º
create table stud(
sid int,
sname varchar2(50)
)
²¢²åÈëÒ»ÌõÊý¾Ý
&n ......
1¡¢´´½¨±í
create table stud(
sid int,
sname varchar2(50),
age number,
score number(4,2))
²¢²åÈëһЩÊý¾Ý£¨×Ô¼ºÊÖ¶¯²åÈëһЩ°É£©
2¡¢´´½¨º¯Êý
create or replace function fun_getScores(
v_age in stud.age%type
)
return number
is ......