Display image on JSP page using mySql

Question

Please help me in displaying image in a particular section on a JSP page which is stored in mySql database and also tell me that can we store image in any datatype?

You would not typically store the image in the table, but instead store the path/filename of the image. Storing the actual image is problematic for many reasons. It makes it harder to render to a page is the biggest reason not to do it. — Sloan Thrasher, Apr 14 '17 at 17:39

score 0 · Answer 1 · answered Apr 14 '17 at 17:37

add this servlet to your project like this :

package com.app.meservlets;

import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.annotation.MultipartConfig;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.Part;

import com.app.upload.UploadPicture;

/**
 * 
 * @author user-sqli date: 12/05/2016 17:42
 */
@WebServlet(urlPatterns = "/upload", loadOnStartup = 1)
@MultipartConfig(fileSizeThreshold = 1024 * 1024 * 2, // 2MB
maxFileSize = 1024 * 1024 * 10, // 10MB
maxRequestSize = 1024 * 1024 * 50)
// 50MB
public class ControllerUploadPicture extends HttpServlet {

    private static final long serialVersionUID = 1L;

    @Override
    protected void doPost(HttpServletRequest request,
            HttpServletResponse response) throws ServletException, IOException {
        String appPath = request.getServletContext().getRealPath("");

        Part part = request.getPart("file");
        UploadPicture.createNewInstance().TranseferPicture(part, appPath);

        getServletContext().getRequestDispatcher("/show.jsp").forward(request,
                response);
    }

}

and add this classto your project :

package com.app.upload;

import java.io.File;
import java.io.IOException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.logging.Level;
import java.util.logging.Logger;

import javax.servlet.http.Part;

/**
 * 
 * @author user-sqli date: 12/05/2016 17:30
 */
public class UploadPicture {
    private static final String EXTENSION = ".";
    public static final String SAVE_DIR = "uploadImage";
    private static UploadPicture uploadPicture = null;
    private static final Logger LOGGER = Logger.getLogger(UploadPicture.class
            .getName());

    private UploadPicture() {
    }

    public String TranseferPicture(Part part, String appPath) {
        String savePath = appPath + File.separator + SAVE_DIR;
        File fileSaveDir = new File(savePath);
        if (!fileSaveDir.exists()) {
            fileSaveDir.mkdir();
        }

        String fileName = new SimpleDateFormat("yyyyMMdd_HHmmss")
                .format(new Date());
        String nameImage = fileName + EXTENSION + getExtensionImage(part);
        try {
            part.write(savePath + File.separator + nameImage);
            LOGGER.log(Level.FINE, "Upload  Picture to {0} ", savePath
                    + File.separator + nameImage);

        } catch (IOException ex) {
            LOGGER.log(Level.SEVERE, ex.toString(), ex);
        }
        return nameImage;
    }

    private String getExtensionImage(Part part) {

        return part.getContentType().split("/")[1];
    }

    public static UploadPicture createNewInstance() {
        if (uploadPicture == null) {
            uploadPicture = new UploadPicture();
        }
        return uploadPicture;
    }
}

in your jsp like this :

<!DOCTYPE html >
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Upload file</title>
</head>
<body>
    <form method="post" action="upload" enctype="multipart/form-data">
        <input type="file" name="file" /><br /> <input type="submit"
            value="Upload" />
    </form>

</body>
</html>

and for shoing this image :

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<%@taglib  uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<!DOCTYPE html >
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>

 uploaded image sucess.
<%-- <img  width="100px" height="100px"  src="<c:url   value="/uploadImage/${name}" />"> --%>
</body>
</html>

this example require servlet >=3.1

score 0 · Accepted Answer · answered Apr 14 '17 at 17:39

0

Web pages display images from URLs.

You can either encode the image in a data: URI, or write server-side code to serve it in response to some URL.

answered Apr 14 '17 at 17:39

SLaks

868,454
176
1,908
1,964

Display image on JSP page using mySql

2 Answers2