ORACLE数据库JDBC连接

--建立驱动，使用SQL，通过传入 sql调用方法，获取结果集

public static ResultSet getResult(String sql){
    <pre name="code" class="java">        Connection con = getConnection();
     try{
            Statement stmt = con.createStatement() ;   
            ResultSet rs = stmt.executeQuery(sql) ;
            //con.close();
            return rs;
        }catch(SQLException e){
            // TODO Auto-generated catch block
        }
        return null;   
    }

   
private static Connection getConnection(){
        try{  
            Properties p = new Properties();
            InputStream in =null;
            String driver="";
            String username="";
            String password="";
            String url="";
            try{
                 in=new FileInputStream("WebContent/datasource.properties");
                 p.load(in);
                 driver=p.getProperty("jdbc.driverClassName");
                 url=p.getProperty("jdbc.url");
                 username=p.getProperty("jdbc.username");
                 password=p.getProperty("jdbc.password");
                 System.out.println(driver);
            }catch(FileNotFoundException e){
                // TODO Auto-generated catch block
                e.printStackTrace();
            }catch(IOException e){
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
            //加载oracle驱动
            Class.forName(driver);
            Connection con =    
                    DriverManager.getConnection(url , username , password ) ; 
            return con;
        }catch(ClassNotFoundException e){  
            System.out.println("找不到驱动程序类 ，加载驱动失败！");  
            e.printStackTrace() ;  
        }catch(SQLException e){
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return null;
    }

数据库配置文本内容datasource.properties
<p>jdbc.driverClassName=oracle.jdbc.driver.OracleDriver
url=jdbc:oracle:thin:@172.18.94.63/orcl
username=
password=