storing images in database and retreiving it

[salamath ahamed]

hello
how to store an image in database and how to retrieive it ,please help

[Lasse Koskela]

There are two approaches:
1) Store the image file into a BLOB field
2) Keep the image in the filesystem and only store the location into the database

[Gregg Bolinger]

My Opinion. Go with Lasse's 2nd option of storing the image on the file system and storing the location in the database. DB Performance can really decrease when storing Binary data in a table.
However, if you would prefer to store the image itself in the database...

InputStream inputStream = new BufferedInputStream(new FileInputStream("someimage.jpg"));
preparedStatement.setBinaryStream(1, inputStream, inputStream.available());
preparedStatement.executeUpdate();
preparedStatement.close();
inputStream.close();

Here is how you retrieve the image from the database
ResultSet resultSet = statement.executeQuery("select image from myTable where id=whatever");
InputStream inputStream = new BufferedInputStream(resultSet.getBinaryStream(1));
OutputStream outputStream = new BufferedOutputStream(new FileOutputStream("myimage.jpg"));
int b = -1;
while ((b = inputStream.read()) != -1) outputStream.write(b);
inputStream.close();
outputStream.close();

I don't know if this is syntactically correct. But in escense I believe the thoery is correct. I just kind of threw this together.