java oracle connection

最新推荐文章于 2024-08-13 08:47:02 发布

转载最新推荐文章于 2024-08-13 08:47:02 发布 · 1.2k 阅读

文章标签：

#oracle #java #string #import #exception #service

JAVA 同时被 2 个专栏收录

21 篇文章

订阅专栏

Oracle

1 篇文章

订阅专栏

本文介绍了一个Java应用程序中用于管理数据库连接的实用类DBManage。该类提供了两种获取数据库连接的方法：一种是通过JNDI查找数据源，另一种是直接使用Oracle数据源建立连接。文章涉及了连接池的配置及异常处理。

package com.mitech.developer;

import javax.sql.DataSource;
import javax.naming.*;
import java.sql.*;
import java.util.*;

public class DBManage {

public static Connection getConn() {
//  Connection con = null;
//  DataSource ds = null;
//  try {
//   Context initContext = new InitialContext();
//   Context envContext = (Context) initContext.lookup("java:/comp/env");
//   ds = (DataSource) envContext.lookup("jdbc/myoracle");
//  } catch (NamingException ne) {
//   System.err.println("NamingException Error:" + ne);
//  }
//
//  try {
//   con = ds.getConnection();
//  } catch (SQLException e) {
//   System.err.println(e);
//  }
//  return con;

  return getConn4Class();

}

public static Connection getConn4Class() {
  Connection conn = null;
  Hashtable pathProp = MultiDesign.getResourcePath();
  String url = (String)pathProp.get("conn_string");
  //"jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.171.2.131)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = odb) ) )";
  //String url = "jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = odb.micike.com)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = odb) ) )";

  try {
   oracle.jdbc.pool.OracleDataSource ds = new oracle.jdbc.pool.OracleDataSource();
   ds.seturl(http://www.blog007.com/url);
   conn = ds.getConnection((String)pathProp.get("conn_username"), (String)pathProp.get("conn_password"));
   //conn = ds.getConnection("username", "password");
  } catch (Exception e) {
   System.out.println(e);
  }
  return conn;
}

}