Java 连接 Oracle

最新推荐文章于 2023-04-20 10:14:06 发布

lc_x

最新推荐文章于 2023-04-20 10:14:06 发布

阅读量463

点赞数

CC 4.0 BY-SA版权

分类专栏： java 文章标签： java jdbc database oracle import properties

本文链接：https://blog.youkuaiyun.com/lychaox/article/details/6605521

java 专栏收录该内容

29 篇文章

订阅专栏

本文提供了在使用Oracle JDBC驱动时的一些实用提示。包括导入必要的JDBC类、创建OracleDataSource实例、设置连接属性、打开数据库连接等关键步骤。确保了在不同环境下正确配置连接URL，以实现本地或远程连接。

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

Some Useful Hints In Using the JDBC Drivers
-------------------------------------------

Please refer to "JDBC Developer's Guide and Reference" for details
regarding usage of Oracle's JDBC Drivers. This section only offers
useful hints. These hints are not meant to be exhaustive.

These are a few simple things that you should do in your JDBC program:

1. Import the necessary JDBC classes in your programs that use JDBC.
    For example:

      import java.sql.*;
      import java.math.*; // if needed

    To use OracleDataSource, you need to do:
      import oracle.jdbc.pool.OracleDataSource;

2. Create an OracleDataSource instance.

      OracleDataSource ods = new OracleDataSource();

3. set the desired properties if you don't want to use the
    default properties. Different connection URLs should be
    used for different JDBC drivers.

      ods.setUser("my_user");
      ods.setPassword("my_password");

    For the JDBC OCI Driver:
      To make a bequeath connection, set URL as:
      ods.setURL("jdbc:oracle:oci:@");

      To make a remote connection, set URL as:
      ods.setURL("jdbc:oracle:oci:@<database>");

      where <database> is either a TNSEntryName
      or a SQL*net name-value pair defined in tnsnames.ora.

    For the JDBC Thin Driver, or Server-side Thin Driver:
      ods.setURL("jdbc:oracle:thin:@<database>");

      where <database> is either a string of the form
      //<host>:<port>/<service_name>, or a SQL*net name-value pair,
      or a TNSEntryName.

    For the JDBC Server-side Internal Driver:
      ods.setURL("jdbc:oracle:kprb:");

      Note that the trailing ':' is necessary. When you use the
      Server-side Internal Driver, you always connect to the
      database you are executing in. You can also do this:

      Connection conn =
        new oracle.jdbc.OracleDriver().defaultConnection();

4. Open a connection to the database with getConnection()
    methods defined in OracleDataSource class.

      Connection conn = ods.getConnection();

-----------------------------------------------------------------------