weblogic连接oracle配置文件,配置weblogic连接oracle的数据源

Name:JDBC-DEV1

JNDI Name:jdbc.datasource.DS1

AdminServer

Row Prefetch Size:  48

Stream Chunk Size:256

URL:jdbc:oracle:thin:@192.168.0.118:1521:AAT

Driver Class Name:oracle.jdbc.OracleDriver

连接oracle及postgresql的连接字符串

package com.lwf.eus.util;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.SQLException;

import java.sql.Statement;

import javax.naming.Context;

import javax.naming.InitialContext;

import javax.naming.NamingException;

import javax.sql.DataSource;

public class ConnectionManager {

public static Connection getConnectionOracle(){

Connection conn = null;

String url = "jdbc:oracle:thin:@192.168.0.118:1521:AAT";

String userName = "xxx";

String pwd = "xxx";

try {

Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();

conn = DriverManager.getConnection(url,userName,pwd);

} catch (SQLException e) {

e.printStackTrace();

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (InstantiationException e) {

e.printStackTrace();

} catch (IllegalAccessException e) {

e.printStackTrace();

} catch (Exception e){

e.printStackTrace();

}

return conn;

}

public static Connection getConnection(){

Connection conn = null;

String url = "jdbc:postgresql://192.168.0.180/getseus";

String userName = "xxx";

String pwd = "xxx";

try {

Class.forName("org.postgresql.Driver").newInstance();

conn = DriverManager.getConnection(url,userName,pwd);

} catch (SQLException e) {

e.printStackTrace();

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (InstantiationException e) {

e.printStackTrace();

} catch (IllegalAccessException e) {

e.printStackTrace();

} catch (Exception e){

e.printStackTrace();

}

return conn;

}

public static Connection getConnectionFromDS(){

Connection conn = null;

Context ctx = null;

try {

ctx = new InitialContext();

DataSource ds = (DataSource)ctx.lookup("JNDIPG");

conn = ds.getConnection();

} catch (NamingException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return conn;

}

public static Connection getConnectionFromDSofOracle(){

Connection conn = null;

Context ctx = null;

try {

ctx = new InitialContext();

DataSource ds = (DataSource)ctx.lookup("JNDIORACLE");

conn = ds.getConnection();

} catch (NamingException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return conn;

}

public static Statement createStatement(Connection conn){

Statement st = null;

try {

st = conn.createStatement();

} catch (SQLException e) {

e.printStackTrace();

}

return st;

}

}