使用JDBC鏈接Oracle代碼

    public class OracleJdbcTest

    {

        String driverClass = "oracle.jdbc.driver.OracleDriver";


    Connection con;    

    public void init(FileInputStream fs) throws ClassNotFoundException, SQLException, FileNotFoundException, IOException    
    {    
        Properties props = new Properties();    
        props.load(fs);    
        String url = props.getProperty("db.url");    
        String userName = props.getProperty("db.user");    
        String password = props.getProperty("db.password");    
        Class.forName(driverClass);    

        con=DriverManager.getConnection(url, userName, password);    
    }    

    public void fetch() throws SQLException, IOException    
    {    
        PreparedStatement ps = con.prepareStatement("select SYSDATE from dual");    
        ResultSet rs = ps.executeQuery();    

        while (rs.next())    
        {    
            // do the thing you do    
        }    
        rs.close();    
        ps.close();    
    }    

    public static void main(String[] args)    
    {    
        OracleJdbcTest test = new OracleJdbcTest();    
        test.init();    
        test.fetch();    
    }    
}   

</pre>