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
输出控制台,连接成功
最后
- 由于博主水平有限,不免有疏漏之处,欢迎读者随时批评指正,以免造成不必要的误解!