Testjdbc

最新推荐文章于 2021-02-23 21:44:15 发布

原创最新推荐文章于 2021-02-23 21:44:15 发布 · 336 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#null #jdbc #import #oracle #string #class

本文提供了一个使用Java通过JDBC连接并查询Oracle数据库的具体示例。代码展示了如何加载Oracle驱动、建立数据库连接、执行SQL查询及处理结果集。

import java.sql.*;

public class TestJDBC {

public static void main(String[] args) {
  ResultSet rs = null;
  Statement stmt = null;
  Connection conn = null;
  try {
   Class.forName("oracle.jdbc.driver.OracleDriver");
   //new oracle.jdbc.driver.OracleDriver();
   conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.1:1521:SXT", "scott", "tiger");
   stmt = conn.createStatement();
   rs = stmt.executeQuery("select * from dept");
   while(rs.next()) {
    System.out.println(rs.getString("deptno"));
    System.out.println(rs.getInt("deptno"));
   }
  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException e) {
   e.printStackTrace();
  } finally {
   try {
    if(rs != null) {
     rs.close();
     rs = null;
    }
    if(stmt != null) {
     stmt.close();
     stmt = null;
    }
    if(conn != null) {
     conn.close();
     conn = null;
    }
   } catch (SQLException e) {
    e.printStackTrace();
   }
  }
}