Jdbc连接Oracle数据库_con链接oracle数据库-优快云博客

本文链接：https://blog.youkuaiyun.com/love_Sophie/article/details/7022110

本文演示了如何使用Java语言连接Oracle数据库，并通过Statement对象执行SQL查询来获取数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

import java.sql.*;

public class JavaConOracle {

/**
* @param args
*/
public static void main(String[] args) {
  // TODO Auto-generated method stub
  Connection con = null;
  Statement st = null;
  ResultSet rs = null;
  try {
   Class.forName("oracle.jdbc.driver.OracleDriver");
   con = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl","scott","tiger");
   st = con.createStatement();
   rs = st.executeQuery("select * from emp");
   while (rs.next()) {
    String ename = rs.getString("ENAME");
    Double sal = (Double)rs.getDouble("SAL");
    System.out.println(ename + " 的工资是 " + sal);
   }

  } catch (Exception e) {
   e.printStackTrace();
  } finally {
   try {
    rs.close();
   } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }
   try {
    st.close();
   } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }
   try {
    con.close();
   } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }
  }
}

}