First time to create JDBC connection to ORACLE SQL

最新推荐文章于 2021-04-14 01:11:14 发布

原创最新推荐文章于 2021-04-14 01:11:14 发布 · 893 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #jdbc #myeclipse #service #download #table

Oracle 专栏收录该内容

23 篇文章

订阅专栏

本文介绍如何使用 Oracle JDBC 驱动 ojdbc6.jar 连接 Oracle 11g 数据库，包括配置环境、编写 Java 代码实现连接、创建表及数据操作等步骤。

MyEclipse 8.6.1, Oracle 11.1g standard edition, jdk1.6.0_31 are already installed.

1) Locate the JDBC driver provided by ORACLE under [ORACLE_HOME]\jdbc\lib\ojdbc6.jar or download the drivers from oracle site.

http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-111060-084321.html

2) Read the Readme.txt under [ORACLE_HOME]\jdbc\, we can find some valuable information.

3) Copy ojdbc6.jar to your project lib dir, or add this jar by configuring the build path, adding the external jar file.

4) Compile the source code.

import java.sql.*;

public class JDBCTest {
public static void main(String args[])
{
      Connection conn = null;
      // System.setProperty("jdbc.drivers", "oracle.jdbc.driver.OracleDriver");

      try
      {
          Class.forName("oracle.jdbc.driver.OracleDriver");
      }
      catch (ClassNotFoundException ex)
      {
          ex.printStackTrace();
      }


      try
      {
          conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl", "abc", "abc123");
          Statement stat = conn.createStatement();
          stat.executeUpdate("CREATE TABLE Greetings (Message VARCHAR(20))");
          stat.executeUpdate("INSERT INTO Greetings VALUES('Hello world!')");
          ResultSet result = stat.executeQuery("SELECT * FROM Greetings");
          if (result.next())
          {
              System.out.println(result.getString(1));
          }
          result.close();
          stat.executeUpdate("DROP TABLE Greetings");
      }
      catch (SQLException ex)
      {
          for (Throwable t: ex)
          {
              t.printStackTrace();
          }
      }
      finally
      {
          if (conn != null)
          {
              try
              {
                  conn.close();
              }
              catch (SQLException ex)
              {
                  for (Throwable t: ex)
                  {
                      t.printStackTrace();
                  }
              }
          }
      }
}
}