how to insert/retrieve jpg img format from MSAccess???

[vrk]

Hi all!

Here is my query...how to insert a jpg image into MSAccess database and also retrive from it in an image format using jsp...

Thanks in advance!
vrk.

[RamyaSivakanth]

1.I have declared the image datatype as OLE
2.Inserting the image code
--------------------------
PreparedStatement psmnt = con.prepareStatement("INSERT INTO IMAGESTORAGE(IMAGE) VALUES(?)");
File image = new File("Sunset.jpg");
FileInputStream fis = new FileInputStream(image)
psmnt.setBinaryStream(1, (InputStream)fis, (int)(image.length()));
int insertCount= psmnt.executeUpdate();
System.out.println(insertCount);
-------------------------------
3.retreival
Here iam reading and putting the image in a new file called "SunsetImageRead.jpg"
psmnt = con.prepareStatement("SELECT IMAGE FROM IMAGESTORAGE");
ResultSet rs = psmnt.executeQuery();
if(rs.next())
{
InputStream fis1;
FileOutputStream fos;
try
{
fis1 = rs.getBinaryStream("image");
fos = new FileOutputStream(new File("SunsetImageRead.jpg"));
int c;
while ((c = fis1.read()) != -1)
{
fos.write(c);
}
fis1.close();
fos.close();
}catch(Exception ex)
{
System.out.println(ex);
}//try-c

[OrangeDog]

Simplest way is to use a BLOB - Binary Long OBject. Check the API docs for the Java object and the SQL type of the same name.

[vrk]

Thanks for ur reply! i got it!