import java.sql.*;
class a {
  public static void main (String[] args)
                           throws SQLException {
    // 裝入oracle jdbc驅(qū)動程序
    DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
    // 連接數(shù)據(jù)庫
    Connection conn = DriverManager.getConnection (
             "jdbc:oracle:thin:@166.111.7.247:1521:o8i1" , "student151" , "java");
    // 創(chuàng)建執(zhí)行語句
    Statement stmt = conn.createStatement ();
    // 從EMP 表中取得ENAME
    ResultSet rset = stmt.executeQuery ("select ENAME from EMP");
    // 在結(jié)果集中迭代，打印所有員工姓名
    while (rset.next ())
      System.out.println (rset.getString (1));
    // 關(guān)閉結(jié)果集
    rset.close();
    // 關(guān)閉執(zhí)行語句
    stmt.close();
    // 關(guān)閉連接
    conn.close();   
  }
}