User里面有三个字段:id,name,age,password
1. insert();
按条件插入,未设置字段为null。
User u = new user();
u.setName(“张三”);
insert(u);
相当于:
insert into tb_user (id,name,age,password) value (null,“张三”,null,null);
2. insertSelective();
按条件插入,过滤为空字段
User u = new user();
u.setName(“张三”);
insertSelective(u);
相当于:
insert into tb_user (id,name) value (null,“张三”);
3. deleteByExample();
根据条件删除多条。
Example example = new Example (User.class);
example .createCriteria().andEqualTo(“name”,“张三”);
UserMapper.deleteByExample(example);
相当于:
delete from tb_user where name = ‘张三’;
4. deleteByPrimaryKey();
根据主键删除单条。
UserMapper.deleteByPrimaryKey(1);
相当于:
delete from tb_user where id= 1;
5.updateByPrimaryKey();
按主键更新,未设置字段为null。
User u =new User();
u.setId(1);
u.setName(“张三”);
UserMapper.updateByPrimaryKey(u);
相当于:
update tb_user set name = ‘张三’ ,age = null,password = null where id = 1;
6.updateByPrimaryKeySelective();
按主键更新,过滤为空字段。
User u =new User();
u.setId(1);
u.setName(“张三”);
UserMapper.updateByPrimaryKeySelective(u);
相当于:
update tb_user set name = ‘张三’ where id = 1;
7. updateByExample();
按条件更新,未设置字段为null。
Example example = new Example(User.class);
example.createCriteria().andIn(“id”,1);
User u = new user()
u.setName(“张三”);
UserMapper.updateByExample(u,example );
相当于:
update tb_user set name = ‘张三’ ,age = null,password = null where id = 1;
8. updateByExampleSelective();
按条件更新,过滤为空字段。
Example example = new Example(User.class);
example.createCriteria().andIn(“id”,1);
User u = new user()
u.setName(“张三”);
UserMapper.updateByExampleSelective(u,example );
相当于:
update tb_user set name = ‘张三’ where id = 1;
9. select();
通过对象中传入的值为条件查出所有符合要求的所有条数,返回为list。
User u = new user();
u.setName(“张三”);
List< User > user = UserMapper.select(u);
相当于:
select * from tb_user where name = ‘张三’;
10. selectOne();
通过对象中传入的值为条件查出所有符合要求的一条,返回为对象。
User u = new user();
u.setId(1);
User user = UserMapper.selectOne(u);
相当于:
select * from tb_user where id = 1;
11. selectByPrimaryKey();
通过主键查询
UserMapper.selectByPrimaryKey(1);
select * from tb_user where id = 1;
12. selectByExample();
通过拼装条件,查出所有符合要求的所有条数,返回为list。
Example example = new Example (User.class);
example .createCriteria().andEqualTo(“id”,1).andEqualTo(“name”,“张三”);
List< User > user = UserMapper.selectByExample(example);
相当于:
select * from tb_user where id = 1 and name = ‘张三’;