tk.mybatis中常用方法的使用,一看就会!!!

int insertSelective(T var1);
int insert(T var1);
System.out.println("----以上为所有方法-------华丽分割线------一下为常用方法的测试-----");
User user = new User(1,"测试",18);
int i = userMapper.insertSelective(user);

int deleteByPrimaryKey(Object var1);
int delete(T var1);
System.out.println("----以上为所有方法-------华丽分割线------一下为常用方法的测试-----");
User user = new User();
user.setId(1);
int delete = userMapper.deleteByPrimaryKey(user);//根据主键删除数据

List<T> selectAll();
T selectByPrimaryKey(Object var1);
int selectCount(T var1);
List<T> select(T var1);
T selectOne(T var1);
System.out.println("----以上为所有方法-------华丽分割线------一下为常用方法的测试-----");
User user = new User();
user.setId(1);
User user1 = userMapper.selectByPrimaryKey(user);//根据主键查询出一条
List<User> users = userMapper.selectAll();//查询表中所有的数据

int updateByPrimaryKey(T var1);
int updateByPrimaryKeySelective(T var1);
System.out.println("----以上为所有方法-------华丽分割线------一下为常用方法的测试-----");
User user = new User(1,"测试",18);
int update = userMapper.updateByPrimaryKey(user);//根据主键去更新数据

int deleteByExample(Object var1);
List<T> selectByExample(Object var1);
int selectCountByExample(Object var1);
T selectOneByExample(Object var1);
int updateByExample(@Param("record") T var1, @Param("example") Object var2);
int updateByExampleSelective(@Param("record") T var1, @Param("example") Object var2);
System.out.println("----以上为所有方法-------华丽分割线------一下为常用方法的测试-----");
Example example = new Example(User.class);
Example.Criteria criteria = example.createCriteria();
criteria.andEqualTo("name","王小二");//相当于 where name = "王小二"
List<User> users1 = userMapper.selectByExample(example);//查询name为王小二的所有数据
Example example1 = new Example(User.class);
Example.Criteria criteria1 = example.createCriteria();
criteria1.andEqualTo("id","1");//相当于 where id = "1"
User user1 = new User(1,"王小二",20);
userMapper.updateByExampleSelective(user1,example1);//把id为1的数据都更新为user1的数据