(5)编写测试类
Demo.java
public class Demo {
public static void main(String[] args) throws IOException {
// 获取配置文件输入流
InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml");
// 创建 SqlSessionFactory
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
// 获取 SqlSession
SqlSession sqlSession = sqlSessionFactory.openSession();
// 获取 Mapper 接口
UserDao userDao = sqlSession.getMapper(UserDao.class);
// 新增一个用户
User newUser = new User();
newUser.setUsername("new-user");
newUser.setNickName("新建的用户(修改前)");
newUser.setPassword("123123");
newUser.setPhone("13900001111");
newUser.setCreateTime("2022-07-14 16:00:00");
userDao.insert(newUser);
// 根据用户名获取用户信息
User user = userDao.findByUsername("new-user");
System.out.println("########## 修改前用户信息 ##########");
System.out.println(new Gson().toJson(user));
// 修改用户信息
user.setUsername("update-user");
user.setNickName("新建的用户(修改后)");
userDao.update(user);
user = userDao.findByUsername("update-user");
System.out.println("########## 修改后用户信息 ##########");
System.out.println(new Gson().toJson(user));
// 删除用户
userDao.deleteById(user.getId());
}
}
输出结果:
########## 修改前用户信息 ##########
{"id":5,"username":"new-user","nickName":"新建的用户(修改前)","password":"123123","phone":"13900001111","createTime":"2022-07-14 16:00:00"}
########## 修改后用户信息 ##########
{"id":5,"username":"update-user","nickName":"新建的用户(修改后)","password":"123123","phone":"13900001111","createTime":"2022-07-14 16:00:00"}