android直接连接mysql数据库

const express = require('express');
const mysql = require('mysql');
const app = express();

const db = mysql.createConnection({
  host: 'your_database_host',
  user: 'your_username',
  password: 'your_password',
  database: 'your_database_name'
});

db.connect((err) => {
  if (err) throw err;
  console.log('Connected to MySQL database!');
});

app.use(express.json());

app.get('/users', (req, res) => {
  db.query('SELECT * FROM users', (err, results) => {
    if (err) return res.status(500).send(err);
    res.json(results);
  });
});

app.listen(3000, () => {
  console.log('Server is running on port 3000');
});

public interface ApiService {
    @GET("users")
    Call<List<User>> getUsers();
}

// 在Activity或Fragment中调用
Retrofit retrofit = new Retrofit.Builder()
    .baseUrl("http://your_server_address:3000/")
    .addConverterFactory(GsonConverterFactory.create())
    .build();

ApiService apiService = retrofit.create(ApiService.class);
Call<List<User>> call = apiService.getUsers();
call.enqueue(new Callback<List<User>>() {
    @Override
    public void onResponse(Call<List<User>> call, Response<List<User>> response) {
        if (response.isSuccessful()) {
            List<User> users = response.body();
            // 处理用户数据
        }
    }

    @Override
    public void onFailure(Call<List<User>> call, Throwable t) {
        // 处理错误
    }
});