mybatis中一些自带常用的方法

最新推荐文章于 2026-05-01 07:05:20 发布

转载最新推荐文章于 2026-05-01 07:05:20 发布 · 7.4k 阅读

myBatis 专栏收录该内容

5 篇文章

订阅专栏

本文介绍了使用 MyBatis 框架进行常见的数据库操作，包括查询、更新、插入和删除等基本操作，并提供了具体的代码示例。

① selectByPrimaryKey()

User user = userDAO.selectByPrimaryKey(100); 相当于select * from user where id = 100

② selectByExample() 和 selectByExampleWithBLOGs()

UserExample example = new UserExample();
Criteria criteria = example.createCriteria();
criteria.andUsernameEqualTo("joe");
criteria.andUsernameIsNull();
example.setOrderByClause("username asc,email desc");
List<?>list = userDAO.selectByExample(example);
相当于：select * from user where username = 'joe' and username is null order by username asc,email desc

注：在iBator 生成的文件UserExample.java中包含一个static 的内部类 Criteria ，在Criteria中有很多方法，主要是定义SQL 语句where后的查询条件。

③ insert()

User user = new User();
user.setId(101);
user.setUsername("test");
user.setPassword("123")
user.setEmail("");
userDAO.insert(user);
相当于：insert into user(ID,username,password,email) values(101,'test','123','');

④ updateByPrimaryKey() 和 updateByPrimaryKeySelective()

User user =new User();
user.setId(101);
user.setUsername("joe");
user.setPassword("joe");
user.setEmail("");
userDAO.updateByPrimaryKey(user);
相当于：update user set username='joe',password='joe',email='' where id=101

User user = new User();
user.setId(101);
user.setPassword("joe");
userDAO.updateByPrimaryKeySelective(user);
相当于：update user set password='joe' where id=101

⑤updateByExample() 和 updateByExampleSelective()

UserExample example = new UserExample();
Criteria criteria = example.createCriteria();
criteria.andUsernameEqualTo("joe");
User user = new User();
user.setPassword("123");
userDAO.updateByPrimaryKeySelective(user,example);
相当于：update user set password='123' where username='joe'

⑥deleteByPrimaryKey()

userDAO.deleteByPrimaryKey(101); 相当于：delete from user where id=101

⑦ deleteByExample()

UserExample example = new UserExample();
Criteria criteria = example.createCriteria();
criteria.andUsernameEqualTo("joe");
userDAO.deleteByExample(example);
相当于：delete from user where username='joe'

⑧ countByExample()

UserExample example = new UserExample();
Criteria criteria = example.createCriteria();
criteria.andUsernameEqualTo("joe");
int count = userDAO.countByExample(example);
相当于：select count(*) from user where username='joe'