how to store and retrieve an image to database using in struts

[Julie Jacob]

Hi all,

How to store and retrieve an image in MySql using with struts. Anyone to know this please give me the solutions

thanks

[Kerry Wilson]

First, the column type should be BLOB.
Second, your form property should be of type org.apache.struts.upload.FormFile
Third, in your action (assuming upload is name of property)

 
InputStream uploadIn = upload.getInputStream();
java.awt.Image image = javax.imageio.ImageIO.read(uploadIn);
 
// Convert image to buffered image
java.awt.image.BufferedImage imageBuffer = new java.awt.image.BufferedImage(image.getWidth(null),image.getHeight(null),BufferedImage.TYPE_INT_RGB);
java.awt.Graphics imgGraphics = imageBuffer.getGraphics();
imgGraphics.drawImage(image,0,0,null);
imgGraphics.dispose();
    
// Write to byte array output stream
ByteArrayOutputStream out = new ByteArrayOutputStream();
ImageIO.write(imageBuffer,"jpg",out);

// Setup stream for blob
byte[] buffer = out.toByteArray();
ByteArrayInputStream inStream = new ByteArrayInputStream(buffer);
    
Connection conn = getConnection();
PreparedStatement ps = conn.prepareStatement(SAVE_QUERY,PreparedStatement.RETURN_GENERATED_KEYS);

ps.setBinaryStream( 1, inStream, inStream.available() );
 
ps.executeUpdate();