How to make android connect directly to mysql

Question

I want to use android built-in java.sql to drive html: https://developer.android.com/reference/java/sql/package-summary, But there is no way to access My code:

    public class MainActivity extends AppCompatActivity {
    private static final String DB_URL = "jdbc:mysql://127.0.0.1/pcDB";
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        String query = "SELECT * FROM gpstable";
        try {
            Class.forName("java.sql.Driver");
            Connection connection = DriverManager.getConnection(DB_URL,"koer3740","password");

            Toast.makeText(this,"Successful Connection",Toast.LENGTH_LONG).show();

        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

In addition, according to this teaching html: http://seotoolzz.com/android/android-dynamic-listview-mysql-jdbc.php, using the external jdbc, found that DriverManager.class is not in jdbc

My English is not good, sorry.

Hi...Android provides SQLite already, why are you trying to use MySQL? — robot_alien, Jul 03 '18 at 11:38
you can use this code:https://stackoverflow.com/questions/19217835/can-an-android-app-connect-directly-to-an-online-mysql-database — Prajapati Mahesh, Jul 03 '18 at 11:40
If you want to use MySql, you have to developpe an api (REST for example ) between your app and server to handle requests (using Volley API for example) — E.Abdel, Jul 03 '18 at 12:03

score 1 · Accepted Answer · edited Feb 02 '22 at 00:21

1

Although it is not recommended for Android to connect with mysql directly, you can possibly do so. I actually found another stack overflow link that explains why it is not recommended (in first answer) and also gives answer of your original query (in second answer). Please have a look:

Can we connect remote MySQL database in Android using JDBC?

edited Feb 02 '22 at 00:21

Geraldo Neto

3,670
1
30
33

answered Jul 03 '18 at 14:05

waterbyte

241
1
16

How to make android connect directly to mysql

1 Answers1