Pictures and JSP & Mysql

[Khanjan]

Hi,



I have a Content Management Systeem, where you can put an article into the website. If the Admin wants to save an article with a picture, How can he do that?

I have hear somthing like this:

Make a file for the pictures on the server. Give the path as a HTML code, Like <a href>. And put this path into the article that you want to save.

When i want to see the article, the article is retrived from database with the path of the pictures. And you can see the pictures in your article.

Is this possible to do? If not, What is the easiest way to do this kind of things.

Thanx

 

[sedj]

Are you planning to store the pictures in the database as a BLOB or on the filesystem ?

 

[siberian]

I strongly recommend storing URL's to the images in the database rather then the image itself unless you have some deeper need to abuse your relational DB

 

[Khanjan]

I am not planning to to store the pictures in the database as a BLOB, but on the filesystem. I will make a file and upload all the pictures there. This file is not on the database.

How can i do this?

Should i upload the picture in his file and in JSP put the code <image.......>??????

Is there another way to do this??

 

[siberian]

Upload the file to the filestore.

Store the URL in the datastore

Use a JSP tag to load the image

Something like:

<img src="<jsp:getProperty YOUR PROPERTY>">