android与mysql数据库

# 在MySQL配置文件中添加或修改以下设置
[mysqld]
bind-address = 0.0.0.0 # 允许所有IP地址连接
wait_timeout = 28800 # 设置连接超时时间为8小时

// 在Android应用中使用JDBC连接MySQL数据库
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DatabaseHelper {
    private static final String DB_URL = "jdbc:mysql://your_mysql_server:3306/your_database";
    private static final String USER = "your_username";
    private static final String PASS = "your_password";

    public static Connection getConnection() throws SQLException {
        return DriverManager.getConnection(DB_URL, USER, PASS);
    }

    public static void main(String[] args) {
        try (Connection conn = getConnection()) {
            System.out.println("Connected to the database!");
        } catch (SQLException e) {
            System.err.println("Connection failed: " + e.getMessage());
        }
    }
}