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;  

    }  

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

引入jar包：ojdbc