Android連接遠程MySQL資料庫

環境

Android Studio
Android SDK
JDK 14
mysql-connector-java-5.1.39-bin.jar

匯入JDBC

到MySQL Downloads下載合適的JDBC連接驅動，并匯入Android專案中

activity_main.xml

src/main/res/layout/activity_main.xml

<?xml version="1.0" encoding="utf-8"?>
<android.support.constraint.ConstraintLayout 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"
    tools:context=".MainActivity">

    <Button
        android:id="@+id/button"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="Connect to MySQL"
        app:layout_constraintBottom_toBottomOf="parent"
        app:layout_constraintLeft_toLeftOf="parent"
        app:layout_constraintRight_toRightOf="parent"
        app:layout_constraintTop_toTopOf="parent" />

</android.support.constraint.ConstraintLayout>

MainActivity.java

src/main/java/com/demo/mysqltest/MainActivity.java

package com.demo.mysqltest;

import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class MainActivity extends AppCompatActivity {
	// host name 為MySQL資料庫公網IP
	// port 為埠號
	// database name 為資料庫名
    private static final String HOST = "jdbc:mysql://<host name>:<port>/<database name>?useSSL=false";
    // 用戶名
    private static final String USER = "<user name>";
    // 密碼
    private static final String PASSWORD = "<password>";
    // Java資料庫連接JDBC驅動
    private static final String DRIVER = "com.mysql.jdbc.Driver";
    private Connection connection;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        Button button = (Button) findViewById(R.id.button);
        // 設定按鈕監聽器
        button.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
            	// 新建執行緒連接資料庫
                new Thread() {
                    @Override
                    public void run() {
                        try {
                            Class.forName(DRIVER).newInstance();
                            connection = DriverManager.getConnection(HOST, USER, PASSWORD);
                            System.out.println("Database connected successfully!");
                        } catch (ClassNotFoundException e) {
                            System.out.println(e);
                        } catch (SQLException e) {
                            System.out.println(e);
                        } catch (Exception e) {
                            System.out.println(e);
                        }
                    }
                }.start();
            }
        });
    }
}

AndroidManifest.xml

src/main/AndroidManifest.xml
添加下列陳述句以授權互聯網訪問權限

<uses-permission android:name="android.permission.ACCESS_NETWORK_STATE" />
<uses-permission android:name="android.permission.INTERNET" />

<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
    package="com.demo.mysqltest">

    <uses-permission android:name="android.permission.ACCESS_NETWORK_STATE" />
    <uses-permission android:name="android.permission.INTERNET" />

    <application
        android:allowBackup="true"
        android:icon="@mipmap/ic_launcher"
        android:label="@string/app_name"
        android:roundIcon="@mipmap/ic_launcher_round"
        android:supportsRtl="true"
        android:theme="@style/AppTheme">
        <activity android:name=".MainActivity">
            <intent-filter>
                <action android:name="android.intent.action.MAIN" />

                <category android:name="android.intent.category.LAUNCHER" />
            </intent-filter>
        </activity>
    </application>

</manifest>

運行結果

點擊連接MySQL

輸出控制臺，連接成功

最后

• 由于博主水平有限，不免有疏漏之處，歡迎讀者隨時批評指正，以免造成不必要的誤解！