很長時間沒用Oracle數據庫了,今天在公司的電腦上裝了一個Oracle11g,安裝完成后,順便寫了個簡單的Jdbc連接Oracle的例子,現在記錄一下,方便以后查看:
例子很簡單,直接上代碼:
(注意:在測試之前要先把Oracle的驅動jar放到你建立的工程的lib下)
一:JdbcUtil.java
package cn.gov.csrc.base.util;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;public class JdbcUtils {private static final String driverUrl = "oracle.jdbc.driver.OracleDriver";private static final String url = "jdbc:oracle:thin:@localhost:1521:ORCL";private static final String username = "CSRC";private static final String password = "CSRC";public static Connection getConnection(){Connection connection = null;try {Class.forName(driverUrl);connection = DriverManager.getConnection(url, username, password);connection.close();} catch (ClassNotFoundException e) {e.printStackTrace();} catch (SQLException e) {e.printStackTrace();}return connection;}// 測試Oracle連接是否成功public static void main(String[] args) {Connection connection = JdbcUtils.getConnection();System.out.println("連接成功:"+connection);}}
連接成功:oracle.jdbc.driver.T4CConnection@481adc30