How to Connecting to Oracle using Java JDBC?

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

    }

}