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 Ô¼ÊøÃû³Æ Ôö¼ÓµÄÔ¼ÊøÀàÐÍ £¨ÁÐÃû£©
À ......
¡¡
¡¡¡¡1. ʹÓÃ%TYPE
¡¡¡¡ÔÚÐí¶àÇé¿öÏ£¬PL/SQL±äÁ¿¿ÉÒÔÓÃÀ´´æ´¢ÔÚÊý¾Ý¿â±íÖеÄÊý¾Ý¡£ÔÚÕâÖÖÇé¿öÏ£¬±äÁ¿Ó¦¸ÃÓµÓÐÓë±íÁÐÏàͬµÄÀàÐÍ¡£ÀýÈ磬students±íµÄfirst_nameÁеÄÀàÐÍΪVARCHAR2(20),ÎÒÃÇ¿ÉÒÔ°´ÕÕÏÂÊö·½Ê½ÉùÃ÷Ò»¸ö±äÁ¿£º
¡¡¡¡DECLARE
¡¡¡¡ v_FirstName VARCHAR2(20);
¡¡
¡¡µ«ÊÇÈç¹ûfirst_nameÁеĶ¨Òå¸Ä±äÁ ......
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 ......
begin
for item in (select * from user_constraints a where a.constraint_type = 'R') loop
execute immediate 'alter table ' || item.table_name || ' disable constraint ' || item.constraint_name;
end loop;
end;
/ ......