How? upload multiple files with jsp and save then in a mysql database

[JochenKlein]

I want to upload multiple files from a jsp and save these files into a mysql database.
I'm relatively new to java. So what do I have to do?

Can anyone help me?

[graviton]

use the fileupload-api from apache.

[JochenKlein]

Thanks for the answer,

Please, can you post a sample? I don't know how to use the fileupload api.
And what do I have to do to save uploaded files to a database?

Thanks in advance

[graviton]

If you just want to store the data in the database, have a look at my extensions to the fileupload api, which contain a utility class, that will provide you the formdata as a map:
http://narcanti.keyboardsamurais.de/...leuploads.html

[JochenKlein]

Which code has to be in my servlet?

[graviton]

Map parameters = ServletRequestUtil.readParameters(httpRequest);
//reading a file
byte [] filedata = (byte []) parameters.get("file");
// read a normal parameter
String param = (String) parameters.get("name");

[JochenKlein]

Isn't it possible to iterate through the map and save the filename and the file itself to the database?

[graviton]

of course you can iterate through the map, by using mymap.keySet().iterator(). this will give you the keys of the map, which you can use to get the corresponding values.
my example extensions don't support for filename lookup. the data is mapped to the name of the fileupload control. however, you can modify the Util class and put the data into the map by using the filenames. they are stored in the getName() method of the fileitems. but be aware: a user can upload multiple files with exact the same filename, what results in overwriting the data in the map.

[JochenKlein]

Thanks so far.

I tried to store the files as blob in a mysql Database, but I don't know how the objects in the map become blobs.

Please, can you help me