oracle sql developer (java的)
PL/SQL Developer
toad for oracle
navicat for oracle
等等
PL/SQL Developer使用 InstantClient,连接Oracle版本:
•1. 下载32位Oracle InstantClient,并展开到某目录,例如C:\instantclient-basic-nt-11.2.0.2.0;
•2. 将系统的tnsnames.ora拷贝到该目录下;
•3. 在PLSQL Developer中设置Oracle_Home和OCI Library:
ToolsPreferencesOracleConnection:
Oracle_Home: C:\instantclient-basic-nt-11.2.0.2.0
OCI Library: C:\instantclient-basic-nt-11.2.0.2.0\oci.dll
•4. 在PLSQL Developer目录下新建如下bat文件,替换其快捷方式,启动PLSQL Developer:
@echo off
set path=C:\instantclient-basic-nt-11.2.0.2.0
set ORACLE_HOME=C:\instantclient-basic-nt-11.2.0.2.0
set TNS_ADMIN=C:\instantclient-basic-nt-11.2.0.2.0
set NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
start plsqldev.exe
将classes12.jar或者ojdbc14.jar 放到项目里面
你将SbDBConnect.class 放到java_home(如:C:\Program Files\Java\jdk1.6.0_19\bin\)目录下
C:\>cd C:\Program Files\Java\jdk1.6.0_19\bin\
C:\Program Files\Java\jdk1.6.0_19\bin>java SbDBConnect
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)