用Java中mybatis框架实现帖子列表，帖子回复小案例

所需数据库：


所需依赖：
pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>com.xx</groupId>
    <artifactId>mybatisapp</artifactId>
    <version>1.0-SNAPSHOT</version>
    <packaging>war</packaging>
    <dependencies>
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>javax.servlet-api</artifactId>
            <version>3.1.0</version>
            <scope>provided</scope>
        </dependency>

        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper</artifactId>
            <version>5.1.3</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.6</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.6</version>
        </dependency>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.13</version>
        </dependency>
        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.12</version>
        </dependency>
        <dependency>
            <groupId>com.fasterxml.jackson.core</groupId>
            <artifactId>jackson-databind</artifactId>
            <version>2.9.8</version>
        </dependency>
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>jsp-api</artifactId>
            <version>2.0</version>
            <scope>provided</scope>
        </dependency>
    </dependencies>


    <build>
        <plugins>
            <!-- tomcat插件控制 -->
            <plugin>
                <groupId>org.apache.tomcat.maven</groupId>
                <artifactId>tomcat7-maven-plugin</artifactId>
                <version>2.2</version>
                <configuration>
                    <!-- 端口控制 -->
                    <port>8080</port>
                    <!--项目路径控制意味着http://localhost:8080/abc-->
                    <path>/</path>
                    <!--编码-->
                    <uriEncoding>UTF-8</uriEncoding>
                </configuration>
            </plugin>
        </plugins>
    </build>

</project>

Invitation.java

import java.io.Serializable;
import java.util.Date;

public class Invitation implements Serializable {
   
    private Integer id;

    private String title;

    private String summary;

    private String author;

    private Date createdate;

    public Integer getId() {
   
        return id;
    }

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

    public String getTitle() {
   
        return title;
    }

    public void setTitle(String title) {
   
        this.title = title == null ? null : title.trim();
    }

    public String getSummary() {
   
        return summary;
    }

    public void setSummary(String summary) {
   
        this.summary = summary == null ? null : summary.trim();
    }

    public String getAuthor() {
   
        return author;
    }

    public void setAuthor(String author) {
   
        this.author = author == null ? null : author.trim();
    }

    public Date getCreatedate() {
   
        return createdate;
    }

    public void setCreatedate(Date createdate) {
   
        this.createdate = createdate;
    }

    @Override
    public String toString() {
   
        return "Invitation{" +
                "id=" + id +
                ", title='" + title + '\'' +
                ", summary='" + summary + '\'' +
                ", author='" + author + '\'' +
                ", createdate=" + createdate +
                '}';
    }

    public Invitation() {
   
    }

    public Invitation(Integer id, String title, String summary, String author, Date createdate) {
   

        this.id = id;
        this.title = title;
        this.summary = summary;
        this.author = author;
        this.createdate = createdate;
    }
}

ReplyDetail.java

import java.io.Serializable;
import java.util.Date;

public class ReplyDetail implements Serializable {
   
    private Integer id;

    private Integer invid;

    private String content;

    private String author;

    private Date createdate;

    public Integer getId() {
   
        return id;
    }

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

    public Integer getInvid() {
   
        return invid;
    }

    public void setInvid(Integer invid) {
   
        this.invid = invid;
    }

    public String getContent() {
   
        return content;
    }

    public void setContent(String content) {
   
        this.content = content == null ? null : content.trim();
    }

    public String getAuthor() {
   
        return author;
    }

    public void setAuthor(String author) {
   
        this.author = author == null ? null : author.trim();
    }

    public Date getCreatedate() {
   
        return createdate;
    }

    public void setCreatedate(Date createdate) {
   
        this.createdate = createdate;
    }

    @Override
    public String toString() {
   
        return "ReplyDetail{" +
                "id=" + id +
                ", invid=" + invid +
                ", content='" + content + '\'' +
                ", author='" + author + '\'' +
                ", createdate=" + createdate +
                '}';
    }

    public ReplyDetail() {
   
    }

    public ReplyDetail(Integer id, Integer invid, String content, String author, Date createdate) {
   

        this.id = id;
        this.invid = invid;
        this.content = content;
        this.author = author;
        this.createdate = createdate;
    }
}

InvitationMapper.java

import com.xx.domain.Invitation;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface InvitationMapper {
   
    int deleteByPrimaryKey(Integer id);

    int insert(Invitation record);

    int insertSelective(Invitation record);

    Invitation selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(Invitation record);

    int updateByPrimaryKey(Invitation record);

    List<Invitation> find(@Param("title") String title);
}

ReplyDetailMapper.java

import com.xx.domain.ReplyDetail;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface ReplyDetailMapper {
   
    int deleteByPrimaryKey(Integer id);

    int insert(ReplyDetail record);

    int insertSelective(ReplyDetail record);

    ReplyDetail selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(ReplyDetail record);

    int updateByPrimaryKey(ReplyDetail record);

    @Select("select * from reply_detail where invid = #{id}")
    List<ReplyDetail> findByInvitationId(