I want to upload the file to the database using jsp mysql ?

Question

If i choose file and select the category(there are 4 category i thee drop down box), the file should save in the selected particular category in the server and save that file name and file path to the mysql database. And i have to fetch that stored file from database to the front-end.

my questions are how to create folder in server for each drop down category.?

How to save the file ame and file path to the database ?

Khaja Moizuddin · Answer

After uploading & selecting imagesend the bimary data to Service and check whether the object contains binary data if binary data exists then convert the binary data to an image  Create a folder in the server and save the image to that folder Once the image is saved then take the image folder and send it to the database and save it. While getting only take the image from the imagepath Example : D:\Imageafolder\image1.jpg From the above path just take image1.jpg and convert this to binary data and send it to the UI to display. Hope you get this.