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; } }