Java连接Oracle数据库

Java连接Oracle数据库

 

import java.sql.Connection;
import java.sql.DriverManager;

public class DbConnOracle {
	
	//添加驱动包D:\Oracle\product\11.2.0\client_1\jdbc\lib\ojdbc6.jar

	//Oracle连接信息
	private static String drivername = "oracle.jdbc.driver.OracleDriver";
	
	//连接方式一: 服务名方式，主机 + 服务名
	//private static String url = "jdbc:oracle:thin:@//rx62.computime.cn:1521/eimsrx62.computime.cn";
	
	//连接方式二: 实例名方式，主机 + 实例名
	//private static String url = "jdbc:oracle:thin:@rx62.computime.cn:1521:eims";
	
	//连接方式三: Tnsnames方式，tnsnames.ora
	private static String url = "jdbc:oracle:thin:@eimstest.world";
	private static String tns_path = "D:\\Oracle\\product\\11.2.0\\client_1\\network\\admin\\";

	private static String user = "itedev";
	private static String password = "******";
	private static Connection conn;
	
	public static Connection getConnection(){
		
		System.setProperty("oracle.net.tns_admin",tns_path);
		
		try {
			Class.forName(drivername);
			conn = DriverManager.getConnection(url, user, password);
		} catch (Exception e) {
			e.printStackTrace();
		}

		return conn;
	}
	
	
}