1     package com.db;   2        3     import java.sql.Connection;   4     import java.sql.DriverManager;   5     import java.sql.PReparedStatement;   6     import java.sql.ResultSet;   7        8     public class DBConnection {   9         // 連接Oracle數據庫  10         public void OracleConnection() {  11             Connection con = null;  12             PreparedStatement pre = null;  13             ResultSet rs = null;  14       15             try {  16                 // 1. 加載Oracle驅動程序  17                 Class.forName("oracle.jdbc.driver.OracleDriver");  18                   19                 // 2. 設置Oracle數據庫基本信息  20                 String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";  21                 String user = "scott";  22                 String passWord = "goodluck";  23       24                 // 2. 獲取連接  25                 con = DriverManager.getConnection(url, user, password);  26                 System.out.println("----> Connection Success！");  27       28                 // 3. 執行SQL語句  29                 String sql = "SELECT * FROM EMP";  30                 pre = con.prepareStatement(sql);  31       32                 // 4. 獲取結果集  33                 rs = pre.executeQuery();  34                 while (rs.next()) {  35                     System.out.println("編號：" + rs.getString("empno")   36                                     + "；姓名：" + rs.getString("ename")  37                                     + "; 工作:" + rs.getString("job")  38                                     + "; 領導:" + rs.getString("mgr")  39                                     + "; 雇傭日期:" + rs.getString("hiredate")  40                                     + "; 工資:" + rs.getString("sal")  41                                     + "; 獎金:" + rs.getString("comm")  42                                     + "; 部門:" + rs.getString("deptno"));  43                 }  44             } catch (Exception e) {  45                 e.printStackTrace();  46             } finally {  47                 try {  48                     if (rs != null)  49                         rs.close();  50                     if (pre != null)  51                         pre.close();  52                     if (con != null)  53                         con.close();  54                     System.out.println("----> Connection End <-----");  55                 } catch (Exception e) {  56                     e.printStackTrace();  57                 }  58             }  59         }  60       61         public static void main(String[] args) {  62             DBConnection db = new DBConnection();  63             db.OracleConnection();  64         }  65     }