Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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Àý³Ì.
 


Ïà¹ØÎĵµ£º

Oracle PL/SQLÖÐÈçºÎʹÓÃ%TYPEºÍ%ROWTYPE

¡¡
¡¡¡¡1. ʹÓÃ%TYPE
¡¡¡¡ÔÚÐí¶àÇé¿öÏ£¬PL/SQL±äÁ¿¿ÉÒÔÓÃÀ´´æ´¢ÔÚÊý¾Ý¿â±íÖеÄÊý¾Ý¡£ÔÚÕâÖÖÇé¿öÏ£¬±äÁ¿Ó¦¸ÃÓµÓÐÓë±íÁÐÏàͬµÄÀàÐÍ¡£ÀýÈ磬students±íµÄfirst_nameÁеÄÀàÐÍΪVARCHAR2(20),ÎÒÃÇ¿ÉÒÔ°´ÕÕÏÂÊö·½Ê½ÉùÃ÷Ò»¸ö±äÁ¿£º
¡¡¡¡DECLARE
¡¡¡¡ v_FirstName VARCHAR2(20);
¡¡
¡¡µ«ÊÇÈç¹ûfirst_nameÁеĶ¨Òå¸Ä±äÁ ......

oracle PL/SQL FOR UPDATE Óë FOR UPDATE OFµÄÇø±ð

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 ......

Oracle´óÎı¾ÔÚASPÖдæÈ¡ÎÊÌâµÄ½â¾ö


ÔÚÎÒ¿ª·¢BS½á¹¹³ÌÐòÖУ¬ÓÉÓÚ¾­³£ÐèÒªÔÚORACLEÖд¦ÀíһЩÈÝÁ¿½Ï´óµÄÎı¾Êý¾Ý£¬ËùÒÔ¾­¹ý·´¸´²âÊÔÖÕÓÚÓÃASP³É¹¦½â
¾öÁË´óÎı¾Êý¾ÝÔÚORACLEÏ´æÈ¡ÎÊÌâ¡£
¡¡¡¡
¡¡¡¡Ò»¡¢ÔËÐл·¾³£º
¡¡¡¡1¡¢Microsoft Windows 2000 Server + IIS 5.0
2¡¢Oracle8iÖÐÎıê×¼°æ
¡¡¡¡
¡¡¡¡¶þ¡¢½¨Á¢Êý¾Ý±í£º
¡¡¡¡CREATE TABLE SYSTEM.TEST(
B ......

jspÁ¬½ÓoracleÊý¾Ý¿â

Ê×ÏÈÄãÒªÓÐ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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ