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);
&
Ïà¹ØÎĵµ£º
--´´½¨Óû§
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;
--¸ø´´½¨µ ......
¾ßÌå²½Öè¾Í²»¶à˵ÁË £¬Òªµ¼³öµÄSQLSERVER±í½Ð LDJCUS£¬Ö÷¼ü Uid (int ×Ô¶¯Ôö³¤ÁÐ)£¬µ¼Èëµ½Oracle×ܱ¨´í£º¶ÔÏóÃûÎÞЧ £¬È¥µôÖ÷¼üÁоͿÉÒÔ£¬²»ÖªµÀΪʲô£¿ÄѵÀ×Ô¶¯Ôö³¤µÄÖ÷¼üÁоͲ»Äܵ¼Èëµ½OracleÖУ¿£¿£¿Òɻ󡣡£¡£¡£ ......
OracleÄÚ´æ½á¹¹ÓëʵÀý¼°Æä¹ÜÀí
1¡¢ ÄÚ´æ½á¹¹£º
OracleÊý¾Ý¿âµÄ×ÜÌå½á¹¹ÈçÏÂͼ£º
ÿ¸öOracleÊý¾Ý¿â¶¼ÊÇÓÉOracle Instance£¨ÊµÀý£©ÓëÊý¾Ý¿â£¨Êý¾ÝÎļþ£¬¿ØÖÆÎļþ¡¢ÖØ×öÈÕÖ¾Îļþ£©×é³É£¬ÆäÖÐËùνʵÀý¾ÍÊÇÓû§Í¬Êý¾Ý¿â½»»¥µÄý½é£¬Óû§Í¨¹ýÓÚÒ»¸öʵÀýÏàÁ¬À´²Ù×÷Êý¾Ý¿â¡£¶øÊµÀýÓÖÊÇÓÉͳһµÄÄÚ´æ½á¹¹£¨SGA£¬PGA£¬UGA£©ºÍ ......
Ò»
.
Óû§¹ÜÀí
1.1
½¨Á¢Óû§£¨Êý¾Ý¿âÑéÖ¤£©
CREATE
USER
DAVE
IDENTIFIED
BY
pwd
DEFAULT
TABLESPACE
users
TEMPORARY
TABLESPACE  ......
OracleʵÏÖ×ÔÔöÖ÷¼ü
oracleûÓÐORACLE×ÔÔö×Ö¶ÎÕâÑùµÄ¹¦ÄÜ£¬µ«ÊÇͨ¹ý´¥·¢Æ÷(trigger)ºÍÐòÁÐ(sequence)¿ÉÒÔʵÏÖ¡£
create table t_client (id number(4) primary key,
pid number(4) not null,
name varchar2(30) not null,
client_id varchar2(10),
client_level char(3),
bank_acct_no varchar2(30),
contact_tel&n ......