OracleÓαêʹÓÃ×ܽá
Óα꣨CURSOR£©Ò²½Ð¹â±ê£¬ÔÚ¹ØϵÊý¾Ý¿âÖо³£Ê¹Óã¬ÔÚPL/SQL³ÌÐòÖпÉÒÔÓÃCURSORÓëSELECTÒ»Æð¶Ô±í»òÕßÊÓͼ
ÖеÄÊý¾Ý½øÐвéѯ²¢ÖðÐжÁÈ¡¡£
OracleÓαê·ÖΪÏÔʾÓαêºÍÒþʽÓαꡣ
ÏÔʾÓα꣨Explicit Cursor£©:ÔÚPL/SQL³ÌÐòÖж¨ÒåµÄ¡¢ÓÃÓÚ²éѯµÄÓαê³Æ×÷ÏÔʾÓαꡣ
ÒþʽÓα꣨Implicit Cursor£©:ÊÇÖ¸·ÇPL/SQL³ÌÐòÖж¨ÒåµÄ¡¢¶øÇÒÊÇÔÚPL/SQLÖÐʹÓÃUPDATE/DELETEÓï¾äʱ£¬Oracleϵͳ×Ô¶¯·ÖÅäµÄÓαꡣ
Ò».ÏÔʾÓαê
1.ʹÓò½Öè
(1)¶¨Òå (2)´ò¿ª (3)ʹÓà (4)¹Ø±Õ
2.ʹÓÃÑÝʾ
Ê×ÏÈ´´½¨²âÊÔÓñíSTUDENT£¬½Å±¾ÈçÏ£º
CREATE TABLE "STUDENT" (
"STUNAME" VARCHAR2(10 BYTE),
"STUNO" VARCHAR2(4 BYTE),
"AGE" NUMBER,
"GENDER" VARCHAR2(2 CHAR)
)
(1).ʹÓÃWHILEÑ»·´¦ÀíÓαê
create or replace PROCEDURE PROC_STU1 AS
BEGIN
--ÏÔʾÓαêʹÓã¬Ê¹ÓÃwhileÑ»·
declare
--1.¶¨ÒåÓα꣬Ãû³ÆΪcur_stu
cursor cur_stu is
select stuno,stuname from student order by stuno;
--¶¨Òå±äÁ¿£¬´æ·ÅÓαêÈ¡³öµÄÊý¾Ý
v_stuno varchar(4);
v_stuname varchar(20);
begin
--2.´ò¿ªÓαêcur_stu
open cur_stu;
--3.½«ÓαêµÄµ±Ç°ÐÐÈ¡³ö´æ·Åµ½±äÁ¿ÖÐ
fetch cur_stu into v_stuno,v_stuname;
while cur_stu%found --ÓαêËùÖ¸»¹ÓÐÊý¾ÝÐУ¬Ôò¼ÌÐøÑ»·
loop
--´òÓ¡½á¹û
dbms_output.PUT_LINE(v_stuno||'->'||v_stuname);
--¼ÌÐø½«ÓαêËùÖ¸µÄµ±Ç°ÐÐÈ¡³ö·Åµ½±äÁ¿ÖÐ
fetch cur_stu into v_stuno,v_stuname;
end loop;
close cur_stu; --4.¹Ø±ÕÓ
Ïà¹ØÎĵµ£º
ACCESSÊý¾Ý¿â
1:CodeSmithÑ¡ÖÐÁ´½ÓÀàÐÍÊÇ£ºADOXSchema
2:ÎÞÃÜÂëµÄAccessÁ´½ÓΪ£º
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\hh\db.mdb;
3:ÓÐÃÜÂëµÄAccessÁ´½Ó£º
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\hh\db.mdb;
Jet OLEDB:Database Password=1111
SqlÊý¾Ý¿â
server=192.1.1.14;User ID=test; ......
ÔÚÎÒ¿ª·¢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 ......
ÏîÄ¿ÖÐÓÐÉæ¼°´æ´¢¹ý³Ì¶Ô×Ö·û´®µÄ´¦Àí£¬ËùÒԾͽ«ÔÚÍøÉϲéÕÒµ½µÄ×ÊÁÏ»ã×Ü£¬×öÒ»¸öÐÅϢƴ½ÓʽµÄ×ܽᡣ
ÒÔÏÂÐÅÏ¢¾ùÀ´×Ô»¥ÁªÍø£¬Ìù³öÀ´Ò»Ôò×Ô¼º±£´æÒÔ´ýÒÔºóʹÓã¬Ò»Ôò¹©´ó¼Ò·ÖÏí¡£
×Ö·ûº¯Êý——·µ»Ø×Ö·ûÖµ
ÕâЩº¯ÊýÈ«¶¼½ÓÊÕµÄÊÇ×Ö·û×åÀàÐ͵IJÎÊý(CHR³ýÍâ)²¢ÇÒ·µ»Ø×Ö·ûÖµ.
³ýÁËÌرð˵Ã÷µÄÖ®Íâ,ÕâЩº¯Êý´ó²¿·Ö·µ» ......
´Óoracle8µ½oracle10£¬JDBCĿ¼ÏµÄÇý¶¯°ü¶¼¸÷Óв»Í¬¡£¿´ÁËÒ»ÏÂoracleµÄÎĵµËµÃ÷£¬Á˽âÁËÒ»ÏÂËüÃǵÄÓÃ;£¬ÏàÐÅ´ó¼ÒÓÐʱºòÒ²ºÜÃÔ»ó£¬Ð´³öÀ´¹²Ïíһϡ£
ÕâЩÊÇoracle10gϵÄÇý¶¯°üµÄÃû³ÆºÍËüÃǵÄ×÷Óã¬ÆäËû°æ±¾µÄoracle»ù±¾ÀàËÆ¡£
Ö§³ÖËùÓÐƽ̨µÄJDBC ThinÇý¶¯
classes12.jar (1,417,089 bytes) - JDK 1.2 ºÍ JDK 1.3ÏÂÊ¹Ó ......