如何从mysql数据库中获取图片，用java保存为blob格式，并用jsp在浏览器中显示。

String url = "jdbc:mysql://localhost:3306/database_name";
String username = "username";
String password = "password";

Connection connection = DriverManager.getConnection(url, username, password);

String sql = "SELECT image_data FROM images WHERE id = ?";
int imageId = 1; // 图片的ID

PreparedStatement statement = connection.prepareStatement(sql);
statement.setInt(1, imageId);

ResultSet resultSet = statement.executeQuery();
if (resultSet.next()) {
    Blob imageBlob = resultSet.getBlob("image_data");
    // 处理图片数据
}

InputStream inputStream = imageBlob.getBinaryStream();
ByteArrayOutputStream outputStream = new ByteArrayOutputStream();

byte[] buffer = new byte[4096];
int bytesRead = -1;
while ((bytesRead = inputStream.read(buffer)) != -1) {
    outputStream.write(buffer, 0, bytesRead);
}

byte[] imageBytes = outputStream.toByteArray();

<%
    byte[] imageBytes = ...; // 图片的字节数组
    String base64Image = Base64.getEncoder().encodeToString(imageBytes);
%>

<img src="data:image/jpeg;base64,<%= base64Image %>" alt="Image">