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

Ãâ°²×°Oracle¿Í»§¶ËÈí¼þ ʹÓÃpl/sqlÅäÖõǽ

ËäÈ»ÕâÊÇÎÒÕÒµ½×îÏêϸµÄÅäÖÃÃèÊö£¬µ«Êdz¢ÊÔ»¹ÊÇûÓгɹ¦¡£
 
1.ÏÂÔØOracle Client Package
.
´Ó
http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html
ÏÂÔØ
Instant
Client Package – Basic
°ü
(

±ê×¢
:All files
required to run OCI, OCCI, and JDBC-OCI applications)
ÕâÀïÏÂÔØµÄÊÇ
Version 11.1.0.7
2.±¾µØ±£´æOracle Client
Package:
´´
½¨Îļþ¼Ð
,
±ÈÈç
oracle_client,
½«
ÏÂÔØµÄÎļþ¼ÓѹËõµ½´ËÎļþ¼ÐÀï
.(
±ÊÕßĿ¼
:
D:\oracle_client\instantclient_10_2)
3.
ÔÚµ±Ç°Ä¿Â¼ÏÂ
,н¨Á¢Á½¸öÎļþ£¬sqlnet.oraºÍtnsnames.oraÈ»ºóÔÙ
ÊÖ¶¯ÅäÖÃ
sqlnet.ora
ºÍ
tnsnames.ora
±ÈÈçÕâÀïÊÇ
:
sqlnet.ora
ÎļþÄÚÈÝ
:
SQLNET.AUTHENTICATION_SERVICES=
(NTS)
NAMES.DIRECTORY_PATH=
(TNSNAMES, EZCONNECT)
 
tnsnames.ora
ÎļþÄÚÈÝ
(
бÌå±íʾÐèÒªÌæ»»µÄÄÚÈÝ
):
orcl
=
(DESCRIPTION =
   
(ADDRESS_LIST
=
     
(ADDRESS
= (PROTOCOL = TCP)(HOST = 192.168.1.103
)(PORT =
1521))
   
)
   
(CONNECT_DATA
=
     
(SERVICE_NAME
= orcl
)
   
)
)
 
4.
ÅäÖû·¾³±äÁ¿
±äÁ¿Ãû
:
TNS_ADMIN
±äÁ¿Öµ
:

D:\oracle_client\instantclient_10_2
·ñÔò³öÏÖ
:ORA-12154: TNS:could not resolve
the connect identifier specified´íÎó
 
 
Èç¹û֮ǰ
°²×°ÁË
Oracle
ÓÖÐ¶ÔØ
,
»áÒÅÁô
NLS_LANG=NA
µÄ¼üÖµ
.
ÊäÈë
RegEdit
´ò¿ª×¢²á±í
HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE.
ÔÚÓÒÃæÕÒµ½
NLS_LANG=NA
²¢É¾³ýµô
·ñÔò»á±¨
ORA-12705:
Cannot access NLS data files or invalid
´íÎó
.
 
5.
°²×°
pl/sqlÈí¼þ(¹ý³ÌÂÔ)
6.ÅäÖÃpl/sqlµÄOracleÁ¬½Ó²ÎÊý:
Ñ¡Ôñ
pl/sql
µÄ¹¤¾ß
/
Ê×Ñ¡Ïî
(too/
preference/
)
ÀïµÄÁ¬½Ó
,
ÔÚÓÒÃæÉèÖÃ
Oracle
Ö÷Ŀ¼Ãû
(
¼´°²×°Ä¿Â¼
)
ºÍ
OCI
¿â
.
Oracle
Ö÷Ŀ¼
Ãû
:
D:\oracle_client\instantclient_10_2
OCI
¿â
:
D:\oracle_client\instantclient_10_2\oci.dll
7.
怫
pl/sql
²âÊԳɹ¦


Ïà¹ØÎĵµ£º

Oracle 10g R2 RACÔÚVMWAREÉϵݲװ

½¨Á¢sshÐÅÈΣ¬racµÄ°²×°ÒªÓÃsshºÍscpÀ´¿½±´°²×°Îļþ¡£
ÔÚËùÓеĽڵãÉÏÔËÐУº
mkdir ~/.ssh
chmod 700 ~/.ssh
ssh-keygen -t rsa
ssh-keygen -t dsa
ÔÚrdb1½ÚµãÉÏÖ´ÐУº
ssh rdb1 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
ssh rdb1 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys
ssh rdb2 ......

JDBCÁ¬½ÓOracleµÄ¼òµ¥Àý×Ó

 1import java.sql.*;
 2import java.util.logging.Level;
 3import java.util.logging.Logger;
 4
 5/** *//**
 6 * Title: JDBCÁ¬½ÓÊý¾Ý¿â
 7 * Description: ±¾ÊµÀýÑÝʾÈçºÎʹÓÃJDBCÁ¬½ÓOracleÊý¾Ý¿â£¬²¢ÑÝʾÌí¼ÓÊý¾ÝºÍ²éѯÊý¾Ý.
 8 */
 9public class JDBCExampl ......

Ò»¸ö¼òµ¥µÄhibernateÁ¬½ÓoracleÊý¾Ý¿âÀý×Ó£¡

Ò»¡¢ Hibernate½éÉÜ
    HibernateÊÇ»ùÓÚ¶ÔÏó/¹ØÏµÓ³É䣨ORM£¬Object/Relational Mapping£©µÄÒ»¸ö½â¾ö·½°¸¡£ORM·½°¸µÄ˼ÏëÊǽ«¶ÔÏóÄ£ÐͱíʾµÄ¶ÔÏóÓ³Éäµ½¹ØÏµÐÍÊý¾Ý¿âÖУ¬»òÕß·´Ö®¡£HibernateĿǰÊÇORM˼ÏëÔÚJavaÖÐ×î³É¹¦¡¢×îÇ¿´óµÄʵÏÖ¡£ËüÓÚ2001ÄêµÄÄêÄ©·¢²¼µÚÒ»¸ö°æ±¾£¬Á¢¼´ÒýÆðÁ˹㷺µÄ×¢Òâ¡£2003Äê6Ô£ ......

ibatisÁ¬½ÓoracleÀý×Ó£¡

Ò»¸öʹÓÃibatis¶ÔÊý¾Ý¿âÔöɾ¸Ä²éµÄÀý×Ó:
ÕâÀïÓõĿª·¢»·¾³ÊÇ:Eclipse3.2+mysql5.0.20,ibatis°üÊÇibatis-common-2.jar,
ibatis-dao-2.jar,ibatis-sqlmap-2.jar,mysql°üÊÇmysql-connector-java-5.0.3-bin.jar.
²½Öè:
1.´´½¨Êý¾Ý¿â:
 create database itcast;
 use itcast;
´´½¨±í£º
 create table stu ......

SQL Á¬½Ó²éѯ£¨ÄÚÁ´½Ó ÍâÁ¬½Ó£©


Á¬½Ó²éѯ 
¡¡¡¡Í¨¹ýÁ¬½ÓÔËËã·û¿ÉÒÔʵÏÖ¶à¸ö±í²éѯ¡£Á¬½ÓÊǹØÏµÊý¾Ý¿âÄ£Ð͵ÄÖ÷ÒªÌØµã£¬Ò²ÊÇËüÇø±ðÓÚÆäËüÀàÐÍÊý¾Ý¿â¹ÜÀíϵͳµÄÒ»¸ö±êÖ¾¡£ 
¡¡¡¡ÔÚ¹ØÏµÊý¾Ý¿â¹ÜÀíϵͳÖУ¬±í½¨Á¢Ê±¸÷Êý¾ÝÖ®¼äµÄ¹ØÏµ²»±ØÈ·¶¨£¬³£°ÑÒ»¸öʵÌåµÄËùÓÐÐÅÏ¢´æ·ÅÔÚÒ»¸ö±íÖС£µ±¼ìË÷Êý¾Ýʱ£¬Í¨¹ýÁ¬½Ó²Ù×÷²éѯ³ö´æ·ÅÔÚ¶à¸ö±íÖеIJ»Í¬ÊµÌåµÄ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ