通用 mapper 接口使用简介

1、引入 mapper 相关 jar 包

<dependency>
      <groupId>tk.mybatis</groupId>
      <artifactId>mapper</artifactId>
      <version>3.1.2</version>
</dependency>

2、sqlConfig.xml 文件中配置插件属性

<plugins>
     <plugin interceptor="tk.mybatis.mapper.mapperhelper.MapperInterceptor">
          <!-- 指定当前通用mapper接口使用的是哪一个-->
          <property name="mappers" value="tk.mybatis.mapper.common.Mapper"/>
     </plugin>
</plugins>

3、实体类

@Table(name = "user")
public class User implements Serializable {

    @Id // 对应的注解 id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Integer id;

    private String username;

    public Integer getId() {
        return id;
    }

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

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", username='" + username + '\'' +
                '}';
    }
}

4、定义接口类

public interface IUserMapper extends Mapper<User> {

}

5、测试类

public class TestMapperCommonUtil{

    private SqlSessionFactory sqlSessionFactory;

    private IUserMapper userMapper;

    @Before
    public void before() throws IOException {
        String path = "SqlConfig.xml";
        InputStream inputStream = Resources.getResourceAsStream(path);
        sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        SqlSession session = sqlSessionFactory.openSession();
        userMapper = session.getMapper(IUserMapper.class);
    }

    @Test
    public void test(){
        // 方式一
        User paramUser = new User();
        paramUser.setId(1);
        User user = userMapper.selectOne(paramUser);
        System.out.println(user);

        // 方式二
        Example example = new Example(User.class);
        example.createCriteria().andEqualTo("id",1);
        List<User> userList = userMapper.selectByExample(example);
        for(User user1:userList){
            System.out.println(user1);
        }

    }
}