图片上传

图片上传测试：

1、pojo

package com.ssm.pojo;

public class NewsPic {
    /*
     * 
    新闻图片

CREATE TABLE NEWS_PIC(
    id BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT '图片id(编号)',
    categoryId BIGINT(20) NOT NULL COMMENT '图片的父id，属于哪个新闻的图(此处应该传过来一个新闻的id)',
    address VARCHAR(255) NOT NULL COMMENT '图片地址',
    NAME VARCHAR(255) NOT NULL COMMENT '图片名称(旧名称)',
    TXT VARCHAR(255) COMMENT '图片描述',
    created DATETIME DEFAULT NULL COMMENT '创建时间',
    updated DATETIME DEFAULT NULL COMMENT '修改时间',
    PRIMARY KEY(id)
)ENGINE=INNODB DEFAULT CHARSET=UTF8 COMMENT='新闻信息的图片，每一条新闻可能有一张或多张图片'
     */
    
    private long id;
    private long categoryId;
    private String address;
    private String name;
    private String text;
    private String created;
    private String updated;
    public long getId() {
        return id;
    }
    public void setId(long id) {
        this.id = id;
    }
    public long getCategoryId() {
        return categoryId;
    }
    public void setCategoryId(long categoryId) {
        this.categoryId = categoryId;
    }
    public String getAddress() {
        return address;
    }
    public void setAddress(String address) {
        this.address = address;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public String getText() {
        return text;
    }
    public void setText(String text) {
        this.text = text;
    }
    public String getCreated() {
        return created;
    }
    public void setCreated(String created) {
        this.created = created;
    }
    public String getUpdated() {
        return updated;
    }
    public void setUpdated(String updated) {
        this.updated = updated;
    }
    
    
}

2、mapper.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.ssm.dao.NewsPicMapper">
    <insert id="addNewsPic" parameterType="com.ssm.pojo.NewsPic">
        
        INSERT 
            INTO 
        NEWS_PIC(
            categoryId,
            address,
            name,
            text,
            created,
            updated    
        )VALUES(
            #{categoryId},
            #{address},
            #{name},
            #{text},
            #{created},
            #{updated}
        )
    </insert>
</mapper>

3、dao

package com.ssm.dao;

import javax.annotation.Resource;

import org.springframework.stereotype.Repository;

import com.ssm.pojo.NewsPic;

@Repository
public interface NewsPicMapper {
    
    /**
     * 
      *<p>Title: addNewsPic</p>  
      *<p>Description: 添加一张新闻图</p>  
    　 * @param newsPic
     */
    void addNewsPic(NewsPic newsPic);
    
}

4、serviceImpl

package com.ssm.service.Imp;

import javax.annotation.Resource;
import javax.transaction.Transactional;

import org.springframework.stereotype.Service;

import com.ssm.dao.NewsPicMapper;
import com.ssm.pojo.NewsPic;
import com.ssm.service.NewsPicService;
import com.utils.TouGuResult;
@Service
@Transactional
public class NewsPicServiceImpl implements NewsPicService{

    @Resource
    private NewsPicMapper picMapper;
    
    /**
     * 添加一张新闻图
     */
    @Override
    public TouGuResult addNewsPic(NewsPic newsPic) {
        picMapper.addNewsPic(newsPic);
        return TouGuResult.ok(newsPic);
    }

}

5、Controller

package com.ssm.controller;

import java.io.File;
import java.net.InetAddress;
import java.text.SimpleDateFormat;
import java.util.Date;

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

import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.multipart.MultipartFile;

import com.ssm.pojo.NewsPic;
import com.ssm.service.NewsPicService;
import com.utils.IDUtils;
import com.utils.PicUtils;
import com.utils.TouGuResult;

@Controller
@RequestMapping("/newsPic")
public class NewsPicController {
    
    @Resource
    private NewsPicService newsPicService;
    
    @RequestMapping("/add")
    @ResponseBody
    public TouGuResult addNewsPic(@RequestParam MultipartFile[] multipartFiles,String categoryId,HttpServletRequest request,HttpServletResponse response) throws Exception{
        if(multipartFiles.length !=0 && !multipartFiles.equals("")){    
            String newName = null;
            String pic_path = null;
            for (MultipartFile multipartFile : multipartFiles) {
                String oldName = multipartFile.getOriginalFilename();
                if(oldName != null && oldName.length() != 0){
                    newName = IDUtils.genImageName() + oldName;
                    pic_path = PicUtils.NEWS_PIC;
                    //写到内存中 
                    File file = new File(pic_path + "\" + newName);
                    //写到磁盘上
                    multipartFile.transferTo(file);
                    //构建存储在数据库中的地址
                    
                    InetAddress addr = InetAddress.getLocalHost();  
                    String ip=addr.getHostAddress().toString(); 
                    pic_path = request.getScheme() +"://"+ ip+":"+request.getServerPort()+PicUtils.NEWS_SQL_PIC+newName;
                    //存到数据库中
                    NewsPic newsPic = new NewsPic();
                    newsPic.setCategoryId(Long.valueOf(categoryId));
                    newsPic.setName(oldName);
                    newsPic.setAddress(pic_path);
                    SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
                    newsPic.setCreated(simpleDateFormat.format(new Date()));
                    newsPic.setUpdated(simpleDateFormat.format(new Date()));
                    newsPicService.addNewsPic(newsPic);
                    return TouGuResult.ok(newsPic);
                }else{
                    return TouGuResult.build(500, "文件名称不能为空");
                }
            }
            return TouGuResult.ok();
        }else{
            request.getRequestDispatcher("/null.jsp").forward(request, response);
            return null;
        }

        
    }
}

6、同一返回实体类TouGuResult

package com.utils;

import java.util.List;

public class EUDataGridResult {
    private long total;
    private List<?> rows;
    public long getTotal() {
        return total;
    }
    public void setTotal(long total) {
        this.total = total;
    }
    public List<?> getRows() {
        return rows;
    }
    public void setRows(List<?> rows) {
        this.rows = rows;
    }
}

7、图片存储地址工具类：

package com.utils;

public class PicUtils {
    
    /**
     * NEWS_PIC:新闻图在服务器上存储的地址
     */
    public static final String NEWS_PIC = "D:\AllImage\news";
    
    /**
     * NEWS_SQL_PIC:新闻图在数据库中存储的地址
     */
    public static final String NEWS_SQL_PIC = "/news/";
    
}

下一篇介绍图片上传时自动返回主键的方法