java获取Oracle数据库连接的两种方式案例

java获取Oracle数据库的连接有两种方式，一种是我们最常用的

public static Connection getConnection(){Connection conn = null;         String Driver = "oracle.jdbc.OracleDriver";         String URL = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";         String USER = "scott";         String Password = "tiger";try {Class.forName(Driver);conn =  DriverManager.getConnection(URL, USER, Password);} catch (ClassNotFoundException e) {e.printStackTrace();} catch (SQLException e) {e.printStackTrace();}return conn;}

另一种方式是通过OracleDataSource    数据源的方式

public static Connection getConnectiontoo(){Connection conn = null;try {OracleDataSource ods = new OracleDataSource();String url = "jdbc:oracle:thin:@//127.0.0.1:1521/orcl"; ods.setURL(url);ods.setUser("scott");ods.setPassword("tiger");conn = ods.getConnection();} catch (SQLException e) {e.printStackTrace();}return conn;}

这两种方法都能够获得到数据库连接

作者：杨静（YangJing）
出处： [杨静の专栏]   (博文连接)