如何使用Kotlin将我电脑中托管的MySQL连接到安卓应用程序

implementation 'mysql:mysql-connector-java:8.0.26'

import java.sql.Connection
import java.sql.DriverManager

fun createConnection(): Connection {
    val url = "jdbc:mysql://your_mysql_host:your_mysql_port/your_database_name"
    val username = "your_mysql_username"
    val password = "your_mysql_password"
    
    return DriverManager.getConnection(url, username, password)
}

import java.sql.Connection
import java.sql.Statement
import java.sql.ResultSet

fun executeQuery(connection: Connection, query: String): ResultSet {
    val statement = connection.createStatement()
    return statement.executeQuery(query)
}

fun executeUpdate(connection: Connection, update: String): Int {
    val statement = connection.createStatement()
    return statement.executeUpdate(update)
}

import android.os.AsyncTask
import java.sql.Connection

class DatabaseTask : AsyncTask<Void, Void, Void>() {
    private lateinit var connection: Connection

    override fun doInBackground(vararg params: Void?): Void? {
        connection = createConnection()
        
        // 执行SQL查询和更新操作
        val resultSet = executeQuery(connection, "SELECT * FROM your_table")
        while (resultSet.next()) {
            // 处理查询结果
        }
        
        executeUpdate(connection, "INSERT INTO your_table VALUES (...)")

        return null
    }
}