android数据库MYSQL

// 添加依赖
dependencies {
    implementation 'mysql:mysql-connector-java:8.0.23'
}

// 数据库连接类
public class DatabaseHelper {
    private static final String URL = "jdbc:mysql://your_mysql_host:3306/your_database";
    private static final String USER = "your_username";
    private static final String PASSWORD = "your_password";

    public static Connection getConnection() throws SQLException {
        return DriverManager.getConnection(URL, USER, PASSWORD);
    }
}

// 数据操作示例
public void insertData(String name, int age) {
    String sql = "INSERT INTO users (name, age) VALUES (?, ?)";
    try (Connection conn = DatabaseHelper.getConnection();
         PreparedStatement pstmt = conn.prepareStatement(sql)) {
        pstmt.setString(1, name);
        pstmt.setInt(2, age);
        pstmt.executeUpdate();
    } catch (SQLException e) {
        e.printStackTrace();
    }
}

// 使用HikariCP连接池
HikariConfig config = new HikariConfig();
config.setJdbcUrl("jdbc:mysql://your_mysql_host:3306/your_database");
config.setUsername("your_username");
config.setPassword("your_password");
config.addDataSourceProperty("cachePrepStmts", "true");
config.addDataSourceProperty("prepStmtCacheSize", "250");
config.addDataSourceProperty("prepStmtCacheSqlLimit", "2048");

HikariDataSource ds = new HikariDataSource(config);

// 数据操作示例
public void insertData(String name, int age) {
    String sql = "INSERT INTO users (name, age) VALUES (?, ?)";
    try (Connection conn = ds.getConnection();
         PreparedStatement pstmt = conn.prepareStatement(sql)) {
        pstmt.setString(1, name);
        pstmt.setInt(2, age);
        pstmt.executeUpdate();
    } catch (SQLException e) {
        e.printStackTrace();
    }
}