安卓调用mysql数据库代码

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

String url = "jdbc:mysql://数据库服务器IP地址:端口号/数据库名";
String username = "数据库用户名";
String password = "数据库密码";

try {
    Connection connection = DriverManager.getConnection(url, username, password);
} catch (SQLException e) {
    e.printStackTrace();
}

String query = "SELECT * FROM 表名";
try {
    Statement statement = connection.createStatement();
    ResultSet resultSet = statement.executeQuery(query);
    
    while (resultSet.next()) {
        // 处理查询结果
        String column1 = resultSet.getString("列名1");
        String column2 = resultSet.getString("列名2");
        // ...
    }
    
    resultSet.close();
    statement.close();
} catch (SQLException e) {
    e.printStackTrace();
}

String query = "INSERT INTO 表名 (列名1, 列名2) VALUES ('值1', '值2')";
try {
    Statement statement = connection.createStatement();
    int rowsAffected = statement.executeUpdate(query);
    statement.close();
} catch (SQLException e) {
    e.printStackTrace();
}

try {
    connection.close();
} catch (SQLException e) {
    e.printStackTrace();
}