学习过程 | SSM框架实现基本的文件上传下载功能

(只用看image相关的文件，paper和user不用)

1.项目结构

   

 

项目结构内容解释（按照构建顺序）

1.pojo：存放项目涉及得到实体类，实体的属性和setter，getter方法

package com.pojo;

public class Image {
    private int id;


    private String content;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getContent() {
        return content;
    }

    public void setContent(String content) {
        this.content = content;
    }

}

2.dao：存放对数据库操作的接口

package com.dao;

import com.pojo.Image;

import java.util.List;

public interface ImageDao {
    int add(String content);

    int deleteById(int id);

    List<Image> queryAllImage();

    String queryImageById(int id);
}

3.service：存放对pojo实体类的操作接口，与dao接口相对应

package com.service;

import com.pojo.Image;

import java.util.List;

public interface ImageService {
    List<Image> queryAllImage();

    int add(Image image);

    int deleteById(int id);

    String queryImageById(int id);

}

4.service下的impl包：存放service下接口的实现类，每个方法返回对dao中接口方法的调用，注意注解不要丢了

package com.service.impl;

import com.dao.ImageDao;
import com.pojo.Image;
import com.service.ImageService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;
@Service
public class ImageServiceImpl implements ImageService {
    @Autowired
    private ImageDao imageDao;
    @Override
    public int add(Image image) {
        return imageDao.add(image.getContent());
    }

    @Override
    public int deleteById(int id) {
        return imageDao.deleteById(id);
    }

    @Override
    public List<Image> queryAllImage() {
        return imageDao.queryAllImage();
    }

    public String queryImageById(int id) {
        return imageDao.queryImageById(id);
    }
}

5.mapper：对dao中方法的实现，对数据库进行增删改除操作，具体细节可以查看MyBatis教程

<?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.dao.ImageDao">
    <resultMap type="Image" id="imageResultMap" >
        <!--property是类中的属性，column是数据库中的列-->
        <id property="id" column="image_id"/>
        <result property="content" column="image_content"/>
    </resultMap>
    <insert id="add" parameterType="Image">
        INSERT INTO image(image_content)
        VALUES (#{content})

    </insert>

    <delete id="deleteById" parameterType="int">
        delete from image where image_id = #{id}
    </delete>

    <select id="queryAllImage" resultMap="imageResultMap">
        select image_id,image_content from image
    </select>

    <select id="queryImageById" resultType="String" parameterType="int">
        select image_content from image where image_id=#{id};
    </select>
</mapper>

6.配置文件

spring-dao.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
    http://www.springframework.org/schema/beans/spring-beans.xsd
    http://www.springframework.org/schema/context
    http://www.springframework.org/schema/context/spring-context.xsd">
    <!-- 配置整合mybatis过程 -->
    <!-- 1.配置数据库相关参数properties的属性：${url} -->
    <context:property-placeholder location="classpath:jdbc.properties"/>

    <!-- 2.数据库连接池 -->
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <!-- 配置连接池属性 -->
        <property name="driverClass" value="${jdbc.driver}"/>
        <property name="jdbcUrl" value="${jdbc.url}"/>
        <property name="user" value="${jdbc.username}"/>
        <property name="password" value