安卓app访问mysql数据库文件

// 使用Retrofit库进行网络请求
public interface ApiService {
    @GET("get_data")
    Call<List<DataModel>> getData();
}

// 在Activity中调用API
public class MainActivity extends AppCompatActivity {
    private ApiService apiService;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        Retrofit retrofit = new Retrofit.Builder()
            .baseUrl("https://yourserver.com/api/")
            .addConverterFactory(GsonConverterFactory.create())
            .build();

        apiService = retrofit.create(ApiService.class);

        Call<List<DataModel>> call = apiService.getData();
        call.enqueue(new Callback<List<DataModel>>() {
            @Override
            public void onResponse(Call<List<DataModel>> call, Response<List<DataModel>> response) {
                if (response.isSuccessful()) {
                    List<DataModel> data = response.body();
                    // 处理数据
                } else {
                    // 处理错误
                }
            }

            @Override
            public void onFailure(Call<List<DataModel>> call, Throwable t) {
                // 处理失败情况
            }
        });
    }
}

# 使用Flask框架处理API请求
from flask import Flask, jsonify
import mysql.connector

app = Flask(__name__)

@app.route('/get_data', methods=['GET'])
def get_data():
    conn = mysql.connector.connect(user='user', password='password', host='host', database='database')
    cursor = conn.cursor(dictionary=True)
    cursor.execute("SELECT * FROM table")
    data = cursor.fetchall()
    cursor.close()
    conn.close()
    return jsonify(data)

if __name__ == '__main__':
    app.run(host='0.0.0.0', port=5000)