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. ʹÓÃ%TYPE
¡¡¡¡ÔÚÐí¶àÇé¿öÏ£¬PL/SQL±äÁ¿¿ÉÒÔÓÃÀ´´æ´¢ÔÚÊý¾Ý¿â±íÖеÄÊý¾Ý¡£ÔÚÕâÖÖÇé¿öÏ£¬±äÁ¿Ó¦¸ÃÓµÓÐÓë±íÁÐÏàͬµÄÀàÐÍ¡£ÀýÈ磬students±íµÄfirst_nameÁеÄÀàÐÍΪVARCHAR2(20),ÎÒÃÇ¿ÉÒÔ°´ÕÕÏÂÊö·½Ê½ÉùÃ÷Ò»¸ö±äÁ¿£º
¡¡¡¡DECLARE
¡¡¡¡ v_FirstName VARCHAR2(20);
¡¡
¡¡µ«ÊÇÈç¹ûfirst_nameÁеĶ¨Òå¸Ä±äÁ ......
PL/SQL-FOR UPDATE Óë FOR UPDATE OFµÄÇø±ð
url:http://hi.baidu.com/1413/blog/item/a521251f7e5993c4a686696b.html
Êý¾Ý¿â oracle for update of ºÍ for updateÇø±ð
select * from TTable1 for update Ëø¶¨±íµÄËùÓÐÐУ¬Ö»ÄܶÁ²»ÄÜд
2 select * from TTable1 wher ......
ÔÚÎÒ¿ª·¢BS½á¹¹³ÌÐòÖУ¬ÓÉÓÚ¾³£ÐèÒªÔÚORACLEÖд¦ÀíһЩÈÝÁ¿½Ï´óµÄÎı¾Êý¾Ý£¬ËùÒÔ¾¹ý·´¸´²âÊÔÖÕÓÚÓÃASP³É¹¦½â
¾öÁË´óÎı¾Êý¾ÝÔÚORACLEÏ´æÈ¡ÎÊÌâ¡£
¡¡¡¡
¡¡¡¡Ò»¡¢ÔËÐл·¾³£º
¡¡¡¡1¡¢Microsoft Windows 2000 Server + IIS 5.0
2¡¢Oracle8iÖÐÎıê×¼°æ
¡¡¡¡
¡¡¡¡¶þ¡¢½¨Á¢Êý¾Ý±í£º
¡¡¡¡CREATE TABLE SYSTEM.TEST(
B ......
Ê×ÏÈÄãÒªÓÐtomcat,»¹ÒªÓÐoracle jdbcµÄjarµµµÈ»·¾³.
µÚÒ»²½: дJSP
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@(des ......