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