java使用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();  
    }  
}