TKmybatis的用法

mapper接口中的方法解析

pom引入

        <dependency>
            <groupId>tk.mybatis</groupId>
            <artifactId>mapper-spring-boot-starter</artifactId>
            <version>2.1.5</version>
        </dependency>

只要extends tk.mybatis.mapper.common.Mapper就拥有了通用Mapper中所有方法

public interface BaseMapper extends tk.mybatis.mapper.common.Mapper {
}

    public void test(EsOrder esOrder){
        Example example =  new Example(EsOrder.class);
        Example.Criteria criteria = example.createCriteria();
        criteria.andEqualTo("id", esOrder.getId());
       
        -------查询 - -----  
        //按条件计数
        int i = orderMapper.selectCountByExample(example);
        //计数
        int i1 = orderMapper.selectCount(esOrder);
        //按条件查询一条记录
        EsOrder esOrder1 = orderMapper.selectOneByExample(example);
        //通过对象查询一条数据
        EsOrder esOrder2 = orderMapper.selectOne(esOrder);
        //按主键查询一条数据
        EsOrder esOrder3 = orderMapper.selectByPrimaryKey(esOrder.getId());
        //按条件查询 多条数据
        List<EsOrder> esOrderList = orderMapper.selectByExample(example);

		------------更新-------------
        //按主键更新值不为null的字段
        orderMapper.updateByPrimaryKey(esOrder);
        //按条件更新
        orderMapper.updateByExample(esOrder,example);
        //按条件更新值不为null的字段
        orderMapper.updateByExampleSelective(esOrder, example);

		-----------插入-----------
        //插入数据，返回值是ID
        orderMapper.insert(esOrder);
        //批量插入数据(所有数据都会插入，没有设值得null字段也会插入)
        orderMapper.insertList(esOrderList);
        //选择性插入(只会插入设过值得字段，如果没有给值，则不插入)
        orderMapper.insertSelective(esOrder);
		
		------------删除------------
        //按主键删除
        orderMapper.deleteByPrimaryKey(esOrder.getId());
        //按条件删除
        orderMapper.deleteByExample(example);





    }