=========================
MyBatis关联映射之添加用户
=========================

1 用户表

create table t_user(
    id int primary key auto_increment,
    username varchar(20) not null unique,
    password varchar(20) not null,
    realname varchar(20) not null,
    image varchar(100) not null
);

2 实体类

在pom.xml文件中添加：

<!-- Project Lombok -->
<dependency>
    <groupId>org.projectlombok</groupId>
    <artifactId>lombok</artifactId>
    <version>1.18.12</version>
    <scope>provided</scope>
</dependency>

在/src/main/java/cn.tedu.association.pojo目录下创建User.java文件：

@Data
@NoArgsConstructor
@AllArgsConstructor
@ToString
public class User {
    private int id;
    private String username;
    private String password;
    private String realname;
    private String image;
}

3 添加用户

3.1 定义接口

在/src/main/java/cn.tedu.association.dao目录下创建UserDao.java文件：

public interface UserDao {
    public int addUser(User user);
}

3.2 配置映射

在/src/main/resources/mappers目录下创建UserMapper.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="cn.tedu.association.dao.UserDao">
    <insert id="addUser" useGeneratedKeys="true" keyProperty="id">
        insert into t_user(username, password, realname, image)
        values(#{username}, #{password}, #{realname}, #{image})
    </insert>
</mapper>

在/src/main/resources/mybatis-config.xml文件中添加：

<configuration>
    ...
    <mappers>
        ...
        <mapper resource="mappers/UserMapper.xml" />
        ...
    </mappers>
    ...
</configuration>

3.3 单元测试

在pom.xml文件中添加：

<!-- JUnit -->
<dependency>
    <groupId>junit</groupId>
    <artifactId>junit</artifactId>
    <version>4.13.2</version>
    <scope>test</scope>
</dependency>

在/src/test/java/cn.tedu.association.dao目录下创建UserDaoTest.java文件：

public class UserDaoTest {
    @Test
    public void testAddUser() {
        UserDao userDao = MyBatisUtil.getMapper(UserDao.class);
        User user = new User(0, "zhangfei", "111111", "张飞", "001.jpg");
        assertEquals(1, userDao.addUser(user));
    }
}

运行测试用例。

例程：Association