Springboot框架实现图片上传显示并保存地址到数据库

1.在application.properties.xml中配置

# SpringBoot框架实现图片上传显示并保存地址到数据库#spring boot上传文件大小限制spring.http.multipart.max-file-size=200MBspring.http.multipart.max-request-size=200MB

2.创建物品实体类productModel

package com.lyancafe.material.model;/** * @author scy 2018/8/22 */public class ProductModel {    private Integer id;    private String image;    public Integer getId() {        return id;    }    public void setId(Integer id) {        this.id = id;    }    public String getImage() {        return image;    }    public void setImage(String image) {        this.image = image;    }    @Override    public String toString() {        return "ProductModel{" +                "id=" + id +                ", image='" + image + '\'' +                '}';    }}

3.创建ProductController

package com.lyancafe.material.controller;import com.lyancafe.material.bo.ProductService;import com.lyancafe.material.model.ProductModel;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Controller;import org.springframework.ui.Model;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.multipart.MultipartFile;import java.io.File;import java.io.IOException;import java.util.List;import java.util.UUID;/** * @author scy 2018/8/22 */@Controller@RequestMapping("product")public class ProductController {    @Autowired    private ProductService productService;    @RequestMapping("list")    public String list(Model model) {        List<ProductModel> productList = productService.list();        model.addAttribute("productList", productList);        return "list";    }    @RequestMapping("index")    public String index() {        return "index";    }    @RequestMapping("addProduct")    public String fileUpload(MultipartFile file, ProductModel productModel) throws IOException {        /**         * 上传图片         */        //图片上传成功后，将图片的地址写到数据库        //保存图片的路径（这是存在我项目中的images下了，你们可以设置路径）        String filePath = "F:\\test_myself\\suncystudy\\lyancafe-material\\material\\src\\main\\webapp\\images";        //获取原始图片的拓展名        String originalFilename = file.getOriginalFilename();        //新的文件名字        String newFileName = UUID.randomUUID() + originalFilename;        //封装上传文件位置的全路径        File targetFile = new File(filePath, newFileName);        //把本地文件上传到封装上传文件位置的全路径        file.transferTo(targetFile);        productModel.setImage(newFileName);        /**         * 保存商品         */        productService.save(productModel);        return "redirect:/product/list";    }}

4.创建接口ProductService

package com.lyancafe.material.service;import com.lyancafe.material.model.ProductModel;import java.util.List;/** * @author scy 2018/8/22 */public interface ProductService {    /**     *查询商品     *@return     */    List<ProductModel> list();    /**     *保存商品     * @param productModel     */    void save(ProductModel productModel);}

5.创建实现类ProductServiceImpl

package com.lyancafe.material.service;import com.lyancafe.material.dao.ProductDao;import com.lyancafe.material.model.ProductModel;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import java.util.List;/** * @author scy 2018/8/22 */@Servicepublic class ProductServiceImpl implements ProductService {    @Autowired    private ProductDao productDao;    @Override    public List<ProductModel> list() {        return productDao.list();    }    @Override    public void save(ProductModel productModel) {        productDao.save(productModel);    }}

6.创建ProductDao接口

package com.lyancafe.material.dao;import com.lyancafe.material.model.ProductModel;import java.util.List;/** * @author scy 2018/8/22 */public interface ProductDao {    /**     *查询商品     *@return     */    List<ProductModel> list();    /**     *保存商品     * @param productModel     */    void save(ProductModel productModel);}

7.创建ProductDao.xml

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" ><mapper namespace="com.lyancafe.material.dao.ProductDao">    <!--查询所有-->    <select id="list" resultType="com.lyancafe.material.model.ProductModel">        SELECT * FROM product    </select>    <!--保存所有-->    <insert id="save" parameterType="com.lyancafe.material.dao.ProductDao">        INSERT INTO product(image) VALUES (#{image})    </insert></mapper>

8.首页index.jsp

<%@ page language="java" import="java.util.*" pageEncoding="utf-8" %><%    String path = request.getContextPath();    String basePath = request.getScheme() + "://"            + request.getServerName() + ":" + request.getServerPort()            + path + "/";%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html lang="en"><head>    <base href="<%=basePath%>>">    <meta charset="UTF-8">    <title>Title</title></head><body><form action="<%=path%>product/addProduct" method="post" enctype="multipart/form-data">    图片：<input type="file" name="file">    <input type="submit" value="提交"></form></body></html>

9.显示列表list.jsp

<%@ page language="java" import="java.util.*" pageEncoding="utf-8" %><%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %><%    String path = request.getContextPath();    String basePath = request.getScheme() + "://"            + request.getServerName() + ":" + request.getServerPort()            + path + "/";%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html lang="en"><head>    <base href="<%=basePath%>>">    <meta charset="UTF-8">    <title>查询商品</title>    <link rel="stylesheet" type="text/css" href="<%=path%>css/allUser.css">    <script src="<%=path%>js/allUser.js"></script>    <style type="text/css">        #images {            width: 100px;            height: 100px;        }    </style></head><body><div id="login_frame">    <p id="image_logo"><img src="<%=path%>images/lyancafe.png"></p>    <table border="1">        <tbody>        <tr>            <th>序号</th>            <th>图片</th>        </tr>        <c:if test="${empty productList}">            <li>暂无商品</li>        </c:if>        <c:if test="${!empty productList}">            <c:forEach items="${productList}" var="product">                <tr>                    <th>${product.id}</th>                    <th>                        <c:if test="${product.image !=null }">                            <img id="images" alt="" src="<%=path%>images/${product.image }">                        </c:if>                    </th>                </tr>            </c:forEach>        </c:if>        </tbody>    </table></div></body></html>