01-JavaSE (2).zip

package com.itheima.mybatis.test; import com.itheima.mybatis.domain.Order; import com.itheima.mybatis.domain.User; import com.itheima.mybatis.mapper.UserMapper; import org.apache.ibatis.io.Resources; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import org.apache.ibatis.session.SqlSessionFactoryBuilder; import org.junit.Test; import java.io.IOException; import java.io.InputStream; import java.util.List; public class MybatisTest { @Test public void findOrderInfo() throws IOException { // 1、加载全局配置文件获取SqlSessionFactory对象 InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml"); SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(inputStream); // 2、通过SqlSessionFactory对象获取SqlSession对象 SqlSession sqlSession = sessionFactory.openSession(); // 3、通过SqlSession获取代理对象 UserMapper userMapper = sqlSession.getMapper(UserMapper.class); Order order = userMapper.queryOrderAndUserById(101L); String username = order.getUser().getUsername(); System.out.println(username); // 4、释放资源 sqlSession.close(); } @Test public void findAll() throws IOException { // 1、加载全局配置文件获取SqlSessionFactory对象 InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml"); SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(inputStream); // 2、通过SqlSessionFactory对象获取SqlSession对象 SqlSession sqlSession = sessionFactory.openSession(); // 3、通过SqlSession获取代理对象 UserMapper userMapper = sqlSession.getMapper(UserMapper.class); List<User> users = userMapper.selectAll() ; users.forEach( s -> System.out.println(s) ); // 4、释放资源 sqlSession.close(); } @Test public void findByUserIdCache() throws IOException { // 1、加载全局配置文件获取SqlSessionFactory对象 InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml"); SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(inputStream); // 2、通过SqlSessionFactory对象获取SqlSession对象,然后获取Mapper代理对象，进而进行查询 SqlSession sqlSession = sessionFactory.openSession(); // 3、通过SqlSessionFactory对象获取SqlSession对象,然后获取Mapper代理对象，进而进行查询 UserMapper userMapper1 = sqlSession.getMapper(UserMapper.class); UserMapper userMapper2 = sqlSession.getMapper(UserMapper.class); // 根据id进行查询 User user1 = userMapper1.findByUserId(1); User user2 = userMapper2.findByUserId(1); // 输出 System.out.println(user1); System.out.println(user2); } @Test public void findByUserId() throws IOException { // 1、加载全局配置文件获取SqlSessionFactory对象 InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml"); SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(inputStream); // 2、通过SqlSessionFactory对象获取SqlSession对象,然后获取Mapper代理对象，进而进行查询 SqlSession sqlSession1 = sessionFactory.openSession(); UserMapper userMapper1 = sqlSession1.getMapper(UserMapper.class); User user1 = userMapper1.findByUserId(1); sqlSession1.close(); // 关闭会话，此时数据一级缓存中的数据才会转移到二级缓存中 // 3、通过SqlSessionFactory对象获取SqlSession对象,然后获取Mapper代理对象，进而进行查询 SqlSession sqlSession2 = sessionFactory.openSession(); UserMapper userMapper2 = sqlSession2.getMapper(UserMapper.class); User user2 = userMapper2.findByUserId(1); sqlSession2.close(); // 输出 System.out.println(user1); System.out.println(user2); } @Test public void saveUser() throws IOException { // 1、加载全局配置文件获取SqlSessionFactory对象 InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml"); SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(inputStream); // 2、通过SqlSessionFactory对象获取SqlSession对象 SqlSession sqlSession = sessionFactory.openSession(); // 3、通过SqlSession获取代理对象 UserMapper userMapper = sqlSession.getMapper(UserMapper.class); // 创建User对象 User user = new User(); user.setUsername("itcast"); user.setPassword("1234"); user.setGender("男"); user.setAddr("北京"); userMapper.saveUser(user); // 提交事务 sqlSession.commit(); // 4、释放资源 sqlSession.close(); } @Test public void updateUser() throws IOException { // 1、加载全局配置文件获取SqlSessionFactory对象 InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml"); SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(inputStream); // 2、通过SqlSessionFactory对象获取SqlSession对象 SqlSession sqlSession = sessionFactory.openSession(); // 3、通过SqlSession获取代理对象 UserMapper userMapper = sqlSession.getMapper(UserMapper.class); // 创建User对象 User user = new User(); user.setId(8); user.setUsername("itheima"); user.setPassword("3456"); user.setGender("女"); user.setAddr("上海"); userMapper.updateUser(user); // 提交事务 sqlSession.commit(); // 4、释放资源 sqlSession.close(); } @Test public void deleteById() throws IOException { // 1、加载全局配置文件获取SqlSessionFactory对象 InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml"); SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(inputStream); // 2、通过SqlSessionFactory对象获取SqlSession对象 SqlSession sqlSession = sessionFactory.openSession(); // 3、通过SqlSession获取代理对象 UserMapper userMapper = sqlSession.getMapper(UserMapper.class); // 根据id删除数据 userMapper.deleteById(8); // 提交事务 sqlSession.commit(); // 4、释放资源 sqlSession.close(); } @Test public void query() throws IOException { // 1、加载全局配置文件获取SqlSessionFactory对象 InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml"); SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(inputStream); // 2、通过SqlSessionFactory对象获取SqlSession对象 SqlSession sqlSession = sessionFactory.openSession(); // 3、通过SqlSession获取代理对象 UserMapper userMapper = sqlSession.getMapper(UserMapper.class); // 根据id删除数据 List<User> userList = userMapper.query("%ith%", "%京%"); userList.forEach( s -> System.out.println(s) ); // 4、释放资源 sqlSession.close(); } }