Connect To Oracle DB Via JDBC Driver
来源:互联网 发布:java导出excel并下载 编辑:程序博客网 时间:2024/05/22 07:51
Here’s an example to show you how to connect to Oracle database via JDBC driver.
1. Download Oracle JDBC Driver
Get Oracle JDBC driver here – ojdbcxxx.jar
2. Java JDBC connection example
Code snippets to use JDBC to connect a Oracle database.
Class.forName("org.postgresql.Driver");Connection connection = null;connection = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:mkyong","username","password");connection.close();
See a complete example below :
File : OracleJDBC.java
import java.sql.DriverManager;import java.sql.Connection;import java.sql.SQLException; public class OracleJDBC { public static void main(String[] argv) { System.out.println("-------- Oracle JDBC Connection Testing ------"); try { Class.forName("oracle.jdbc.driver.OracleDriver"); } catch (ClassNotFoundException e) { System.out.println("Where is your Oracle JDBC Driver?");e.printStackTrace();return; } System.out.println("Oracle JDBC Driver Registered!"); Connection connection = null; try { connection = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:mkyong", "username","password"); } catch (SQLException e) { System.out.println("Connection Failed! Check output console");e.printStackTrace();return; } if (connection != null) {System.out.println("You made it, take control your database now!");} else {System.out.println("Failed to make connection!");}} }
2. Run it
Assume OracleJDBC.java
is store in “C:\jdbc-test
” folder, together with Oracle JDBC driver (ojdbc6.jar), then run following commands :
C:\jdbc-test>javac OracleJDBC.java C:\jdbc-test>java -cp c:\jdbc-test\ojdbc6.jar;c:\jdbc-test OracleJDBC-------- Oracle JDBC Connection Testing ------------Oracle JDBC Driver Registered!You made it, take control your database now! C:\jdbc-test>
Done.
0 0
- Connect To Oracle DB Via JDBC Driver
- How to Connect to Oracle via JDBC
- JDBC connect to oracle
- sqoop could not load db driver class:oracle.jdbc.OracleDriver
- Cannot create JDBC driver of class 'oracle.jdbc.driver.OracleDriver' for connect URL ****
- Connect to an Oracle database with JDBC
- Connect to an Oracle database with JDBC
- Java connect to Oracle DB using two method
- registered the JDBC driver [oracle.jdbc.driver.OracleDriver] but failed to unregister it when the
- Tomcat报registered the JDBC driver [Oracle.jdbc.driver.OracleDriver] but failed to unregister it
- registered the JDBC driver [oracle.jdbc.driver.OracleDriver] but failed to unregister it when the
- Connect to Gmail via SSL commands
- spark集群 Failed to connect to driver!
- SSH框架Cannot create JDBC driver of class '' for connect URL 'jdbc:oracle:thin:@localhost:1521:你的数据库名'
- 循环依赖 导致 registered the JDBC driver [oracle.jdbc.OracleDriver] but failed to unregist
- SQLNestedException: Cannot load JDBC driver class 'oracle.jdbc.driver.Oracle ’
- JDBC Connect to DB2 代码
- Oracle JDBC URL和Driver
- 关于数组的几道面试题
- 【LeetCode】Find Minimum in Rotated Sorted Array 解题报告
- Distinct subsequence
- 第八周 项目五 定期存款利息计算器
- graycomatrix 计算(图像)灰度共生矩阵(CLCM)——matlab相关函数说明,很详细
- Connect To Oracle DB Via JDBC Driver
- 新手学习Maven子模块
- BPM Process Instances – Faults, Rollback & Recovery – Part 2
- 面向对象软件工程概念模型
- 行了!!!!
- ubuntu 下命令行播放器mplayer 使用详解
- 批量修改文件名
- 用lazarus开发Linux daemon程序及编写启动脚步
- BPM Process Instances – Faults, Rollback & Recovery – Part 3