SpringMVC 实现文件上传(一:实现静态数据的添加)

背景说明：

实现项目中图片的上传，

将用户选择的图片上传到本地磁盘中，

将上传后本地存储的静态路径存放在数据库

 

一、数据库

/*
Navicat MySQL Data Transfer

Source Server         : new
Source Server Version : 50515
Source Host           : localhost:3306
Source Database       : businfo

Target Server Type    : MYSQL
Target Server Version : 50515
File Encoding         : 65001

Date: 2021-06-08 15:35:34
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `busimg`
-- ----------------------------
DROP TABLE IF EXISTS `busimg`;
CREATE TABLE `busimg` (
  `busid` int(11) NOT NULL AUTO_INCREMENT,
  `busnumber` varchar(255) DEFAULT NULL,
  `busimg` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`busid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of busimg
-- ----------------------------
INSERT INTO `busimg` VALUES ('1', '湘A235FH', 'D:\\test.jpg');

二、entity

package com.entity;

public class busImg {
	private int busid;
	private String busnumber;
	private String busimg;

	public int getBusid() {
		return busid;
	}

	public void setBusid(int busid) {
		this.busid = busid;
	}

	public String getBusnumber() {
		return busnumber;
	}

	public void setBusnumber(String busnumber) {
		this.busnumber = busnumber;
	}

	public String getBusimg() {
		return busimg;
	}

	public void setBusimg(String busimg) {
		this.busimg = busimg;
	}

	@Override
	public String toString() {
		return "busImg [busid=" + busid + ", busnumber=" + busnumber
				+ ", busimg=" + busimg + "]";
	}

	public busImg() {
	}

	public busImg(int busid, String busnumber, String busimg) {
		super();
		this.busid = busid;
		this.busnumber = busnumber;
		this.busimg = busimg;
	}

}

三、mapper

1、接口

package com.mapper;

import com.entity.busImg;

public interface busImgMapper {
  public int addBus(busImg bus);
}

2、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.mapper.busImgMapper">
   <insert id="addBus">
   INSERT INTO `busimg`(busnumber,busimg) 
   VALUES(#{busnumber},#{busimg});
   </insert>
</mapper>

四、service

1、接口

package com.service;

import com.entity.busImg;

public interface busImgService {
	public int addBus(busImg bus);
}

2、实现类

package com.service;

import javax.annotation.Resource;

import org.springframework.stereotype.Service;

import com.entity.busImg;
import com.mapper.busImgMapper;

@Service
public class busImgServiceImpl implements busImgService{
    
	@Resource
	private busImgMapper dao;

	@Override
	public int addBus(busImg bus) {
		// TODO Auto-generated method stub
		return dao.addBus(bus);
	}

}

五、controller

package com.controller;

import java.io.File;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.util.UUID;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;

import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.multipart.commons.CommonsMultipartFile;

import com.entity.busImg;
import com.service.busImgService;

@Controller
@RequestMapping("test")
public class Test_Controller {

	@Resource
	private busImgService service;

	@RequestMapping("/login")
	@ResponseBody
	public String dologin() {
		return "index";
	}

	
	@RequestMapping("/busadd")
	@ResponseBody
	public String busadd() {
		busImg bus = new busImg();
		bus.setBusimg("test");
		bus.setBusnumber("1234");
		return "index:" + service.addBus(bus);
	}



}

六、测试

http://localhost:8080/ssmdemo02/test/busadd