使用Mybatis向Mysql数据库中插入数据,并返回自增的id

首先,在mysql数据库的仓库中,新增一张project_case表,来存储测试用例的相关信息,如下图所示:

1.在pom.xml中将依赖的包导入进来

<!--MyBatis驱动包-->
<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
<dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis</artifactId>
    <version>3.4.6</version>
</dependency>

<!-- Mysql驱动包 -->
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.13</version>
</dependency>

2.新建一个ProjectCase类,里面存放新增一条用例需要的参数和方法

public class ProjectCase {
    private Integer id;
    private String sign;
    private String name;
    private Integer projectid;
    private  Integer moduleid;
    private  Integer projectindex;
    private Date time;
    private String operationer;
    private Integer casetype;
    private String remark;
    private Integer failcontinue;

    public Integer getId() {
        return id;
    }

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

    public String getSign() {
        return sign;
    }

    public void setSign(String sign) {
        this.sign = sign;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public Integer getProjectid() {
        return projectid;
    }

    public void setProjectid(Integer projectid) {
        this.projectid = projecti