使用JDBC链接Oracle，jdbc链接oracle,public class

使用JDBC链接Oracle，jdbc链接oracle,public class

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