在JAVA中连接Oracle数据库(例子)_java连接oracle数据库并读取数据-优快云博客

本文提供了一个使用 JDBC 连接 Oracle 数据库的示例程序，演示了如何加载驱动、建立连接及执行 SQL 查询。

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

     * TODO 要更改此生成的文件的模板，请转至
       * 窗口－首选项－ Java －代码样式－代码模板
       */
      package person.fane.test;

      import java.sql.*;
      /**
       * A JDBC test application for Oracle
       * @author Fane
       * @version 1.0.0
       * @since JDK1.4
       */
      public class OracleTest {
          private final String oracleDriverName =
      "oracle.jdbc.driver.OracleDriver";

          //以下使用的Test就是Oracle里的表空间
          private final String oracleUrlToConnect
      ="jdbc:oracle:thin:@192.168.0.36:1521:Test";
          private Connection myConnection = null;
          /**
           * To load the jdbc driver
           *
           */
          public OracleTest()
          {
              try
              {
                  Class.forName(oracleDriverName);
              }catch(ClassNotFoundException ex)
              {
                  System.out.println(getErrorMessage(ex,"The Driver loaded
      error,please contact to your Software Designer!").toString());
              }
          }

          public StringBuffer getErrorMessage(Exception ex,String alarmMessage)
          {
              StringBuffer errorStringBuffer = new StringBuffer();
              errorStringBuffer.append(alarmMessage);
              errorStringBuffer.append(ex.getMessage());
              return errorStringBuffer;
          }

          /**
           * getConnection method
           * @return Connection
           */
          public Connection getConnection()
          {
              try
              {
                  this.myConnection =
      DriverManager.getConnection(oracleUrlToConnect,"Fane","201");

              }catch(Exception ex)
              {
                  System.out.println(getErrorMessage(ex,"Can not get
      connection,please contact to your Software Designer!").toString());
              }

              return this.myConnection;

          }

          /**
           * @param args
           */
          public static void main(String[] args) {
              OracleTest myOracleTest = new OracleTest();
              try
              {
                  Connection myConnection = myOracleTest.getConnection();

                  System.out.println("Now begin to excute.............");

                  PreparedStatement myPreparedStatement =
      myConnection.prepareStatement("select area_id,
      area_name,ip_address,tel,area_type,pc_id from c_area_info");
                  //myPreparedStatement.setInt(1,2);
                  ResultSet myResultSet = myPreparedStatement.executeQuery();
                  StringBuffer myStringBuffer = new StringBuffer();

                  while(myResultSet.next())
                  {

                      myStringBuffer.append(myResultSet.getInt("area_id")+" ");
                      myStringBuffer.append(myResultSet.getString("area_name")+"
       ");

      myStringBuffer.append(myResultSet.getString("ip_address")+" ");
                      myStringBuffer.append(myResultSet.getString("tel")+" ");
                      myStringBuffer.append(myResultSet.getInt("area_type")+"
      ");
                      myStringBuffer.append(myResultSet.getInt("pc_id")+"/n");
                  }
                  System.out.println(myStringBuffer.toString());
                  //System.out.println(new
      String(myStringBuffer.toString().getBytes("ISO-8859-1"),"GBK"));
              }catch(Exception ex)
              {

      System.out.println(myOracleTest.getErrorMessage(ex,"Application
      error,please contact to your Software Designer!").toString());
              }