SSM实现图片上传附带form表单数据并显示在页面（IDEA版）

最近在做一个项目时，遇到一个之前没接触过的问题，那就是如标题所述，关于图片文件上传已经附带form表单数据至数据库中，并可以在页面进行访问。

首先要搭建好ssm框架，这个我就不在详细描述了。
其次是，要想访问静态资源文件，必须设置虚拟路径，否则会访问不到，虚拟路径的设置有几种方法，我用的是设置tomcat的虚拟路径，在tomcat/config/路径下找到server.xml文件，
1、在Host标签下添加

 <Context path="/upload" docBase="E:\upload" reloadable="true" ></Context>

2、在IDEA中设置，如下图：

准备工作做好后，就开始编程了
1、创建实体类（Equipment.java）ps：因为我的项目是健身房管理系统，所以直接用器材实体类了：

package com.qinhua.gyg.bean;

import org.springframework.web.multipart.MultipartFile;

import java.util.Date;

public class Equipment {
   
    private Integer equipmentId;

    private String equipmentName;

    private String equipmentImage;

    private String equipmentPrice;

    private Date equipmentBuyTime;


    public Integer getEquipmentId() {
   
        return equipmentId;
    }

    public void setEquipmentId(Integer equipmentId) {
   
        this.equipmentId = equipmentId;
    }

    public String getEquipmentName() {
   
        return equipmentName;
    }

    public void setEquipmentName(String equipmentName) {
   
        this.equipmentName = equipmentName == null ? null : equipmentName.trim();
    }

    public String getEquipmentImage() {
   
        return equipmentImage;
    }

    public void setEquipmentImage(String equipmentImage) {
   
        this.equipmentImage = equipmentImage;
    }

    public String getEquipmentPrice() {
   
        return equipmentPrice;
    }

    public void setEquipmentPrice(String equipmentPrice) {
   
        this.equipmentPrice = equipmentPrice;
    }

    public Date getEquipmentBuyTime() {
   
        return equipmentBuyTime;
    }

    public void setEquipmentBuyTime(Date equipmentBuyTime) {
   
        this.equipmentBuyTime = equipmentBuyTime;
    }

}

2、在dao层创建EquipmentMapper.java

public interface EquipmentMapper{
   
	List<Equipment> selectByExample();

    int saveEquipment(Equipment equipment);
}

3、在resources目录下创建一个mapper文件夹，用来存放dao层各个mapper的映射文件。创建EquipmentMapper.xml

<select id="selectByExample" parameterType="com.qinhua.gyg.bean.EquipmentExample" resultMap="BaseResultMap">
    select * from tbl_equipment
  </select>

<insert id="saveEquipment" parameterType="com.qinhua.gyg.bean.Equipment">
    insert into tbl_equipment(equipment_id,equipment_name,equipment_price,equipment_buy_time,equipment_image)
    values (#{
   equipmentId},#{
   equipmentName},#{
   equipment_price},#{
   equipmentBuyTime},#{
   equipmentImage})
</insert>

4、然后是创建controller类EquipmentController.jave

@Autowired
    private EquipmentService equipmentService;

    @RequestMapping("/equipments")
    public String getEquipmentsWithJson(
            @RequestParam(value = "pn", defaultValue = "1") Integer pn, Model model) {
   
//        引入pageHelper分页插件
//        调用方法，传入页面，以及size
        PageHelper.startPage(pn,5);
//        startPage后面紧跟的这个查询就是一个分页查询
        List<Equipment> equipmentList =equipmentService.getAll();
//        使用pageInfo包装查询的结果,将page交给页面（封装了详细的分页信息，包括查询的结果）,并传入连续显示的页数
        PageInfo page = new PageInfo(equipmentList,5);
        model.addAttribute("pageInfo",page);
        return "equipmentList";
    }
@RequestMapping("/addEquipment")
    @ResponseBody
    public Msg addEquipment(@RequestParam(value = "equipmentImage",required = false)MultipartFile file,
                            String equipmentName,
                            String equipmentPrice,
                            String equipmentBuyTime,
                            HttpServletRequest request