1. 查询操作 select
1.1 根据各属性来查询用户
- 在
UserDao
中添加对应方法:
/**
* @param name 用户名
* @return 对应用户名的用户对象
* @description 根据用户名获取用户
* @date 2020/7/14 14:52
* @author cunyu1943
* @version 1.0
*/
User getUserByName(String name);
/**
* @param password 密码
* @return 对应密码的用户对象
* @description 根据用户密码获取用户对象
* @date 2020/7/14 14:57
* @author cunyu1943
* @version 1.0
*/
User getUserByPassword(String password);
- 接着在
UserMapper.xml
中添加Select
语句。其中各属性含义如下:
- id:对应接口中的 方法名;
- resultType:SQL 语句执行的返回值;
- parameterType:参数类型;
<select id="getUserById" resultType="com.cunyu.pojo.User">
select * from user where id=#{id}
</select>
<select id="getUserByName" resultType="com.cunyu.pojo.User">
select * from user where name=#{name}
</select>
<select id="getUserByPassword" resultType="com.cunyu.pojo.User">
select * from user where password=#{password}
</select>
- 在测试类中测试即可;
@Test
public void testGetUserById() {
// 执行 SQL 语句
UserDao mapper = sqlSession.getMapper(UserDao.class);
User user = mapper.getUserById(2);
System.out.println(user);
// 关闭 SqlSession
sqlSession.close();
}
@Test
public void testGetUserByName() {
UserDao mapper = sqlSession.getMapper(UserDao.class);
User user = mapper.getUserByName("村雨遥");
System.out.println(user);
sqlSession.close();
}
@Test
public void testGetUserByPassword(){
UserDao mapper = sqlSession.getMapper(UserDao.class);
User user=mapper.getUserByPassword("123456");
System.out.println(user);
sqlSession.close();
}
2. 插入操作 insert
- 首先在
UserDao
接口中添加对应方法
/**
* @description 添加用户
* @param user 待添加的用户对象
* @return
* @date 2020/7/14 15:50
* @author cunyu1943
* @version 1.0
*/
int addUser(User user);
- 在
UserMapper.xml
中添加Insert
语句;
<insert id="addUser" parameterType="com.cunyu.pojo.User">
insert into user(id, name, password) values (#{id},#{name},#{password})
</insert>
- 测试方法中测试;
@Test
public void testAddUser() {
UserDao mapper = sqlSession.getMapper(UserDao.class);
User user = new User(5, "小雨", "6543210");
int i = mapper.addUser(user);
System.out.println(i);
// 提交事务到数据库
sqlSession.commit();
System.out.println("添加用户成功");
sqlSession.close();
}
![4e359c512c08d0c1328cbe18e4f08046.png](https://i-blog.csdnimg.cn/blog_migrate/88298845b2e5246640eb3753e223b3c9.png)
3. 修改操作 update
- 在
UserDao
添加对应接口;
/**
* @description 根据 id 修改用户
* @param user 待修改的用户对象
* @return
* @date 2020/7/14 16:04
* @author cunyu1943
* @version 1.0
*/
int updateUser(User user);
- 在
UserMapper.xml
中添加update
语句;
<update id="updateUser" parameterType="com.cunyu.pojo.User">
update user set name=#{name},password=#{password} where id=#{id}
</update>
- 测试类中测试;
@Test
public void testUpdateUser(){
// 获取 SqlSession 对象
SqlSession sqlSession = MybatisUtils.getSqlSession();
UserDao mapper = sqlSession.getMapper(UserDao.class);
User user = mapper.getUserById(1);
user.setPassword("7891011");
int i = mapper.updateUser(user);
sqlSession.commit();
System.out.println("更新数据成功");
sqlSession.close();
}
![bfc6249a11b715dc27a6ae5c83e81f1d.png](https://i-blog.csdnimg.cn/blog_migrate/124aacbd720fc3bc027ab9e5ecfd4dff.png)
4. 删除操作 delete
- 在
userDao
中添加接口;
/**
* @description 删除用户
* @param user 待删除的用户
* @return
* @date 2020/7/14 16:21
* @author cunyu1943
* @version 1.0
*/
int deleteUserById(User user);
- 在
UserMapper.xml
中添加delete
语句;
<delete id="deleteUserById" parameterType="com.cunyu.pojo.User">
delete from user where id=#{id}
</delete>
- 在测试类中测试;
@Test
public void testDeleteUser(){
// 获取 SqlSession 对象
SqlSession sqlSession = MybatisUtils.getSqlSession();
UserDao mapper = sqlSession.getMapper(UserDao.class);
User user = mapper.getUserById(5);
int i = mapper.deleteUserById(user);
sqlSession.commit();
System.out.println("删除数据成功");
sqlSession.close();
}
![407ca52ff80f26830870cea07cfa125b.png](https://i-blog.csdnimg.cn/blog_migrate/7a627d241093b520ced78268871f6721.png)
![5814b4b70d982cce9b08d47ad8cfa7ca.png](https://i-blog.csdnimg.cn/blog_migrate/7c00d23b0a206a0384610ad8f258dd84.jpeg)