Java连接Oracle数据库
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 }