mysql存byte数组

CREATE TABLE images (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255),
    data LONGBLOB
);

INSERT INTO images (name, data) VALUES ('example.jpg', LOAD_FILE('/path/to/example.jpg'));

byte[] imageBytes = ...; // 获取byte数组
String sql = "INSERT INTO images (name, data) VALUES (?, ?)";
try (PreparedStatement pstmt = connection.prepareStatement(sql)) {
    pstmt.setString(1, "example.jpg");
    pstmt.setBytes(2, imageBytes);
    pstmt.executeUpdate();
} catch (SQLException e) {
    e.printStackTrace();
}

String sql = "SELECT data FROM images WHERE id = ?";
try (PreparedStatement pstmt = connection.prepareStatement(sql)) {
    pstmt.setInt(1, imageId);
    ResultSet rs = pstmt.executeQuery();
    if (rs.next()) {
        byte[] imageBytes = rs.getBytes("data");
        // 使用imageBytes
    }
} catch (SQLException e) {
    e.printStackTrace();
}