How to connect Android App with Oracle Database

You can not directly access the Oracle database from android Application. you need to create webservices in PHP, .net or in Java to make connection with Oracle Database. After creating this webservice , you need to connect your application with the webservice.

Or, use a Virtual JDBC Driver that uses a three-tier architecture: your JDBC code is sent through HTTP to a remote Servlet that filters the JDBC code.

This is the simplest way of connecting with Oracle Database. 

To connect oracle database using JDBC you need to download and sync ojdbc14.jar.

you can review my following post.

How to add a jar in External Libraries in android studio

Now apply following code to connect oracle database.

XML:

<?xml version="1.0" encoding="utf-8"?>

<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"

    xmlns:app="http://schemas.android.com/apk/res-auto"

    xmlns:tools="http://schemas.android.com/tools"

    android:layout_width="match_parent"

    android:layout_height="match_parent"

    android:orientation="vertical"

    tools:context="com.example.administrator.connect_ora.MainActivity">

    <TextView

        android:id="@+id/hello"

        android:layout_width="match_parent"

        android:layout_height="wrap_content"

        android:text="TextView" />

</LinearLayout>

JAVA

package com.example.administrator.connect_ora;

import android.os.StrictMode;

import android.support.v7.app.AppCompatActivity;

import android.os.Bundle;

import android.util.Log;

import android.widget.TextView;

import android.widget.Toast;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import static oracle.net.aso.C12.e;

public class MainActivity extends AppCompatActivity {

    private static final String DEFAULT_DRIVER = "oracle.jdbc.driver.OracleDriver";

    private static final String DEFAULT_URL = "jdbc:oracle:thin:@192.168.2.32:1521:dev";

    private static final String DEFAULT_USERNAME = "scott";

    private static final String DEFAULT_PASSWORD = "tiger";

    private Connection connection;

    @Override

    protected void onCreate(Bundle savedInstanceState) {

        super.onCreate(savedInstanceState);

        setContentView(R.layout.activity_main);

        if (android.os.Build.VERSION.SDK_INT > 9) {

            StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();

            StrictMode.setThreadPolicy(policy);

        }

        TextView tv = (TextView) findViewById(R.id.hello);

        try {

            this.connection = createConnection();

            Toast.makeText(MainActivity.this, "Connected",

                    Toast.LENGTH_SHORT).show();

            Statement stmt=connection.createStatement();

            StringBuffer stringBuffer = new StringBuffer();

            ResultSet rs=stmt.executeQuery("select * from cat");

            while(rs.next()) {

                stringBuffer.append( rs.getString(1)+"\n");

            }

            tv.setText(stringBuffer.toString());

            connection.close();

        }

        catch (Exception e) {

            Toast.makeText(MainActivity.this, ""+e,

                    Toast.LENGTH_SHORT).show();

            e.printStackTrace();

        }

    }

    public static Connection createConnection(String driver, String url, String username, String password) throws ClassNotFoundException, SQLException {

        Class.forName(driver);

        return DriverManager.getConnection(url, username, password);

    }

    public static Connection createConnection() throws ClassNotFoundException, SQLException {

        return createConnection(DEFAULT_DRIVER, DEFAULT_URL, DEFAULT_USERNAME, DEFAULT_PASSWORD);

    }

}