android增删改查mysql

// 假设我们有一个 User 类
public class User {
    private int id;
    private String name;
    private String email;

    // 省略构造函数和 getter/setter 方法
}

// 在 Activity 中进行添加操作
public void addUser(User user) {
    String url = "jdbc:mysql://your_mysql_server:3306/your_database";
    String username = "your_username";
    String password = "your_password";

    try (Connection conn = DriverManager.getConnection(url, username, password)) {
        String sql = "INSERT INTO users (name, email) VALUES (?, ?)";
        try (PreparedStatement pstmt = conn.prepareStatement(sql)) {
            pstmt.setString(1, user.getName());
            pstmt.setString(2, user.getEmail());
            pstmt.executeUpdate();
        }
    } catch (SQLException e) {
        e.printStackTrace();
    }
}

public List<User> getUsers() {
    List<User> users = new ArrayList<>();
    String url = "jdbc:mysql://your_mysql_server:3306/your_database";
    String username = "your_username";
    String password = "your_password";

    try (Connection conn = DriverManager.getConnection(url, username, password)) {
        String sql = "SELECT * FROM users";
        try (Statement stmt = conn.createStatement();
             ResultSet rs = stmt.executeQuery(sql)) {
            while (rs.next()) {
                User user = new User();
                user.setId(rs.getInt("id"));
                user.setName(rs.getString("name"));
                user.setEmail(rs.getString("email"));
                users.add(user);
            }
        }
    } catch (SQLException e) {
        e.printStackTrace();
    }
    return users;
}