File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Servlets and the fly likes servlets and images??? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of JavaScript Promises Essentials this week in the JavaScript forum!
JavaRanch » Java Forums » Java » Servlets
Bookmark "servlets and images???" Watch "servlets and images???" New topic
Author

servlets and images???

Andres Gonzalez
Ranch Hand

Joined: Nov 27, 2001
Posts: 1561
Hi guys.
I've been searching these forums and haven't found any useful yet.
what I want to achieve is to store an image (jpeg or gif) in a MySQL database (3.23.49) using servlets.
1o.) First of all, I don't know how the field in the mysql database should be declared. i.e:
EXP_DATE not null,
image longblob,
does it have to be longblob? what are the possibles data types?
2o.) How do I retrive the image and put it in a bean property so I can access it with a 'getProperty' tag in a JSP page?
thanks in advance


I'm not going to be a Rock Star. I'm going to be a LEGEND! --Freddie Mercury
sing
Ranch Hand

Joined: Nov 29, 2001
Posts: 121
You can try to convert the file to byte and store into database as byte data type.
I usually store image path into database and save image to server. I get the path and search the image when i want to retrieve the image.
Steffy
SCJP2
Andres Gonzalez
Ranch Hand

Joined: Nov 27, 2001
Posts: 1561
thanks steffy...
so, you store inthe database something like this:
../images/this.jpeg
in a text field in the database? did I get you right?
If I did, one thing comes to my mind. What happens if you don't have the image available in that folder, How do I handle that? If I have the image stored in a database, I can ask if the image field was null or something like that, and put a message like "photo not available"
Anyway, that was a good suggestion, never thought about it. How do I convert the file to abyte?
any other ideas??
sing
Ranch Hand

Joined: Nov 29, 2001
Posts: 121
I always stored only file name into database and the image path i declared in a properties file. For example in properties file, you can declare a variable RELATIVEPATH=/retrieveimg/img/
When i want to retrieve image i can combine RELATIVEPATH and image file name.
You can validate the image by 2 ways. The first you can validate the file name that retrieve from database.
For example,
String filename = rs.getString("imagename");
if (filename == null)
// Display message "Photo not available"
The second validate is check whether is the image file in the server.
String ABSOLUTEIMG="D:/IBM/VisualAge for Java/ide/project_resources/IBM WebSphere Test Environment/hosts/default_host/default_app/web/builder/wbuilder/img/";
java.io.File thumbnailDir=new java.io.File(ABSOLUTEIMG);
String[] list = thumbnailDir.list();
for (int i = 0; i<list.length-1;i++)
{
if (list[i].equals("home.gif"))
System.out.println("home.gif");

}
I never use servlet for my application but JSP. Hope this can answer your question.
Please refer to this site :
http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_15_0
http://www.bitbybit.dk/mysqlfaq/faq.html#ch14_1_0
Steffy
SCJP2
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: servlets and images???