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 }
