tk.mybatis的Mapper接口的方法使用

tk.mybatis的Mapper提供了一些增删改查的方法，懒化了我们写代码的习惯，但是，，很香，，，

• 实体entity

//简化后
public class UserPo implements Serializable {
   
    @Id
    @Column(name = "NAME")
    private String name;
    @Column(name = "AGE")
    private Integer age;
    @Column(name = "SEX")
    private String sex;
    @Column(name = "LENGTH")
    private String length;
}

• ======================= Maper 之 增加insert ==================
  //接口请求参数userPo

	{
   
	    "name":"pt001",
	    "age":14,
	    "length":"144cm"
	}

• [1] insertSelective()

    mapper.insertSelective(userPo): 
	//后台打印日志如下
	Preparing: INSERT INTO user ( NAME,AGE,LENGTH ) VALUES( ?,?,? ) 
	Parameters: pt001(String), 14(Integer), 144cm(String)
	Updates: 1

• [2] insert()

	mapper.insert(userPo)
	//后台打印日志如下:
	Preparing: INSERT INTO user ( NAME,AGE,SEX,LENGTH ) VALUES( ?,?,?,? ) 
	Parameters: pt001(String), 14(Integer), null, 144cm(String)
	Updates: 1

• =============== Maper 之 查询 select =====================

{
   
    "name":"pt002",
     "age":14,
    "sex":"男",
    "length":"134cm"
}

–查询前数据库数据

-------mapper的提供的查询方法比较多，下面按照返回参数划分------
1.返回list集合：

• [1] select()

	mapper.select(userPo):
	//打印日志如下
	Preparing: SELECT NAME,AGE,SEX,LENGTH FROM user WHERE NAME = ? AND AGE = ? AND SEX = ? AND LENGTH = ? 
	Parameters: pt002(String), 14(Integer), 男(String), 134cm(String)
	Total: 0

• [2] selectByExample()