mysql静态操作类

public static void safeInsert(String username, String password) throws SQLException {
    String sql = "INSERT INTO users (username, password) VALUES (?, ?)";
    try (Connection conn = getConnection();
         PreparedStatement pstmt = conn.prepareStatement(sql)) {
        pstmt.setString(1, username);
        pstmt.setString(2, password);
        pstmt.executeUpdate();
    }
}

public static void closeConnection(Connection conn) {
    if (conn != null) {
        try {
            conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

// 配置连接池
HikariConfig config = new HikariConfig();
config.setJdbcUrl("jdbc:mysql://localhost:3306/mydb");
config.setUsername("user");
config.setPassword("password");
HikariDataSource dataSource = new HikariDataSource(config);

// 使用连接池获取连接
try (Connection conn = dataSource.getConnection()) {
    // 执行数据库操作
} catch (SQLException e) {
    e.printStackTrace();
}