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);
&
Ïà¹ØÎĵµ£º
´æ´¢¹ý³Ì °üº¬Èý²¿·Ö£º ÉùÃ÷£¬Ö´Ðв¿·Ö£¬Òì³£¡£
¿ÉÒÔÓÐÎÞ²ÎÊý³ÌÐòºÍ´ø²ÎÊý´æ´¢¹ý³Ì¡£
Î޲γÌÐòÓï·¨
1 create or replace procedure NoParPro
2 as ;
3 begin
4&n ......
--´´½¨Óû§
create user iagent identified by ia
--profile default
default tablespace users
temporary tablespace temp;
--account unlock;
--ɾ³ýÓû§
drop user iagent cascade;
--ÐÞ¸ÄÓû§ÃÜÂë
alter user iagent identified by ia;
--¸ø´´½¨µ ......
GSD global services daemon (GSD)
ÓëracµÄ¹ÜÀí¹¤¾ßdbca srvctl
oem½øÐн»»¥£¬ÓÃÀ´Íê³ÉʵÀýµÄÆô¶¯¹Ø±ÕµÈ¹ÜÀíÈÎÎñ¡£
ΪÁ˱£Ö¤ÕâЩ¹ÜÀí¹¤¾ßÔËÐÐÕý³£±ØÐëÔÚËùÓеĽڵãÉÏÏÈstart
gsd,²¢ÇÒÒ»¸öGSD½ø³ÌÖ§³ÖÔÚ
Ò»¸ö½ÚµãµÄ¶à¸örac.gsd½ø³ÌλÓÚ$ORACLE_HOME/binĿ¼Ï£¬ÆälogÎļþ
Ϊ$oracle_home
/srvm/log/gsdaemon.log
À ......
OracleÄÚ´æ½á¹¹ÓëʵÀý¼°Æä¹ÜÀí
1¡¢ ÄÚ´æ½á¹¹£º
OracleÊý¾Ý¿âµÄ×ÜÌå½á¹¹ÈçÏÂͼ£º
ÿ¸öOracleÊý¾Ý¿â¶¼ÊÇÓÉOracle Instance£¨ÊµÀý£©ÓëÊý¾Ý¿â£¨Êý¾ÝÎļþ£¬¿ØÖÆÎļþ¡¢ÖØ×öÈÕÖ¾Îļþ£©×é³É£¬ÆäÖÐËùνʵÀý¾ÍÊÇÓû§Í¬Êý¾Ý¿â½»»¥µÄý½é£¬Óû§Í¨¹ýÓÚÒ»¸öʵÀýÏàÁ¬À´²Ù×÷Êý¾Ý¿â¡£¶øʵÀýÓÖÊÇÓÉͳһµÄÄÚ´æ½á¹¹£¨SGA£¬PGA£¬UGA£©ºÍ ......
¾³£ÓÃoracleµÄÈ˶ÔÏÂÃæµÄÕâÌõÐÅÏ¢¿Ï¶¨²»»áÄ°Éú£º“¼àÌý³ÌÐòµ±Ç°ÎÞ·¨Ê¶±ðÁ´½ÓÃèÊö·ûÖÐÇëÇóµÄ·þÎñ”¡£Æäʵ²úÉúÕâ¸öÎÊÌâµÄ¸ù±¾ÔÒò²»ÊǼàÌýûÓÐÆðÀ´£¬¶øÊǼàÌýûÓмàÌýÄãÒªÁ¬½ÓµÄoracleʵÀý¡£
´ó¼Ò¶¼Ã÷°×£¬oracleÖ»ÓÐÁ½Õ߼汸²ÅÄÜÏòÍâ½çÌṩ·þÎñ£ºÒ»¸öÊǼàÌý£¬ÓÃÓÚ½Ó ......