(只用看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