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

java jdbc µ÷Óà oracle´æ´¢¹ý³Ì ·µ»ØÓαê

1.´´½¨²âÊÔ±í
create table users(
userid int primary key,
username varchar2(20),
userpwd  varchar2(20)
);
insert into users values(1,'test','test');
insert into users values(2,'test','test');
insert into users values(3,'test','test');
insert into users values(4,'test','test');
insert into users values(5,'test','test');
insert into users values(6,'test','test');
insert into users values(7,'test','test');
2.´´½¨´æ´¢¹ý³Ì
´´½¨°ü
create or replace package pkg_test
as
  type cursor0 is ref cursor;
  procedure get(p_id int,p_rc out cursor0);
end pkg_test;
 
´´½¨°üµÄÄÚÈÝ
create or replace package body pkg_test as
  procedure get(p_id int, p_rc out cursor0) is
  begin
    dbms_output.put_line(p_id);
    open p_rc for
      select userid, username, userpwd from users;
  end get;
end pkg_test;
3.javaµ÷ÓÃ
package com.wei;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
/***
 *
 * ²âÊÔ jdbc Á¬½Ó oracle ´æ´¢¹ý³Ì ·µ»ØÓαê
 *
 * @author wei
 *
 */
public class Main {
 public static void main(String[] args) {
  try {
   DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
   Class.forName("oracle.jdbc.driver.OracleDriver");
   String url = "jdbc:oracle:thin:@127.0.0.1:1521:wei";
   String username = "test";
   String password = "admin";
   Connection conn = DriverManager.getConnection(url, username,
     password);
   String sql = "{call pkg_test.get(?,?)}";
   CallableStatement cstmt = conn.prepareCall(sql);
   cstmt.setInt(1, 1);
   cstmt.registerOutParameter(2, oracle.jdbc.OracleTypes.CURSOR);
  &


Ïà¹ØÎĵµ£º

Oracle Êý¾Ý¿â¼àÌýÅäÖÃ

Ò»¡¢¼àÌýÆ÷(LISTENER)
¡¡¡¡¼àÌýÆ÷ÊÇOracle»ùÓÚ·þÎñÆ÷¶ËµÄÒ»ÖÖÍøÂç·þÎñ£¬Ö÷ÒªÓÃÓÚ¼àÌý¿Í»§¶ËÏòÊý¾Ý¿â·þÎñÆ÷¶ËÌá³öµÄÁ¬½ÓÇëÇó¡£¼ÈÈ»ÊÇ»ùÓÚ·þÎñÆ÷¶ËµÄ·þÎñ£¬ÄÇôËüÒ²Ö»´æÔÚÓÚÊý¾Ý¿â·þÎñÆ÷¶Ë£¬½øÐмàÌýÆ÷µÄÉèÖÃÒ²ÊÇÔÚÊý¾Ý¿â·þÎñÆ÷¶ËÍê³ÉµÄ¡£
 
¶þ¡¢±¾µØ·þÎñÃû(Tnsname)
¡¡¡¡Oracle¿Í»§¶ËÓë·þÎñÆ÷¶ËµÄÁ¬½ÓÊÇͨ¹ý¿Í»§¶Ë· ......

oracle°üºÍREF CURSOR

     Ê×ÏÈ£¬ÐèÒªÖØÐÂÕûÀíÒ»ÏÂÏà¹Ø¸ÅÄoracleÊý¾Ý¿âÖк¯ÊýµÄ×÷Óã¬ÊÇÖ»Äܱ»±ðÈ˵÷Ó㬴洢¹ý³Ì¿ÉÒÔµ¥¶ÀÖ´ÐУ¬²¢ÇÒ¿ÉÒÔµ÷Óô洢¹ý³Ì£¬¶ø°üµÄ×÷Óðü¿ÉÒÔ½«ÈκγöÏÖÔÚ¿éÉùÃ÷µÄÓï¾ä ( ¹ý³Ì , º¯Êý , Óαê , Óαê , ÀàÐÍ , ±äÁ¿ ) ·ÅÓÚ°üÖÐ , Ï൱ÓÚÒ»¸öÈÝÆ÷ . ½«ÉùÃ÷Óï¾ä·ÅÈë°üÖеĺô¦ÊÇ : Óû§¿ÉÒÔ´ÓÆäË ......

oracle ÅäÖø߼¶¸´ÖÆ»·¾³Óöµ½µÄÎÊÌâ

1¡¢ÔÚ±¾»ú69ÉÏ´´½¨Êý¾Ý¿âorcl £¬global_name=orcl£¬Ê¹ÓÃÓï¾ä
alter database rename global_name to orcl.us.oracle.com ÐÞ¸ÄÊý¾Ý¿âµÄÈ«¾ÖÊý¾Ý¿âÃûΪorcl.us.oracle.com
2¡¢ÔÚÐé»ú188ÉÏ´´½¨Êý¾Ý¿âviotest£¬global_name=viotest£¬Ê¹ÓÃÓï¾ä
alter database rename global_name to viotest.us.oracle.com ÐÞ¸ÄÊý¾Ý¿âµÄÈ«¾ÖÊ ......

Oracle Óû§¼°½ÇÉ« ½éÉÜ

Ò»
.
Óû§¹ÜÀí
1.1
½¨Á¢Óû§£¨Êý¾Ý¿âÑéÖ¤£©
    
CREATE
 
USER
  
DAVE  
IDENTIFIED 
BY
  
pwd
    
DEFAULT
TABLESPACE 
users
    
TEMPORARY
  
TABLESPACE  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ