目录
5、在资源文件夹mapper中新建DAO对应的MsgBoardMapper.xml
7、在Service层新建MsgBoardServiceImpl接口实现类
9、工具类PageData、returnInfoUtil、UUidUtil、DatetimeUtil
1、新建一个Boot项目
对项目结构完善一下(其中service中下还有子包impl,将配置文件格式改为yml,方便阅读,也是官方比较推荐的做法)
2、准备一张数据表
3、新建一个数据表对应的MsgBoard实体类
package com.snow.otraveler.entity;
/**
* 留言板实体类
*/
public class MsgBoard {
private String id;
//昵称
private String name;
//邮箱
private String email;
//留言
private String remark;
//创建时间
private String create_time;
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public String getRemark() {
return remark;
}
public void setRemark(String remark) {
this.remark = remark;
}
public String getCreate_time() {
return create_time;
}
public void setCreate_time(String create_time) {
this.create_time = create_time;
}
@Override
public String toString() {
return "{" + "id:" + id + ",name:" + name + ",email:" + email + ",remark:" + remark + ",create_time:" + create_time + "}";
}
}
这里重写toString方法是为了接口返回实体类时给出的是一个json格式。
4、在DAO层中新建MsgBoardMapper
package com.snow.otraveler.mapper;
import com.snow.otraveler.entity.MsgBoard;
import org.springframework.stereotype.Repository;
import java.util.List;
/**
* DAO层-留言板
*/
@Repository
public interface MsgBoardMapper {
/**
* 添加留言
*
* @param msgBoard
*
* @return
*/
int insert(MsgBoard msgBoard);
/**
* 删除留言
*
* @param ids 被删除id集合
*
* @return
*/
int delete(List<String> ids);
/**
* 修改留言
*
* @param msgBoard
*
* @return
*/
int update(MsgBoard msgBoard);
/**
*查询留言
*
* @param msgBoard
* @return
*/
List<MsgBoard> select(MsgBoard msgBoard);
}
5、在资源文件夹mapper中新建DAO对应的MsgBoardMapper.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.snow.otraveler.mapper.MsgBoardMapper">
<sql id="msgboard">
msgboard
</sql>
<!--添加-->
<insert id="insert" parameterType="MsgBoard">
insert into <include refid="msgboard"/> (id,name,email,remark,create_time) values
(#{id},#{name},#{email},#{remark},#{create_time})
</insert>
<!--批量删除-->
<delete id="delete">
delete from <include refid