DongTaiMapper.xml
1 2 5 6 78 9 10 11 19 20 21 37 38 39 50 51 52 53 64 65 66 67 73 74 75 81 82 83 84 85 86 90 91 92 9387 88 89
TestDongTai.java
1 package DongTai; 2 3 import bean.User; 4 import org.apache.ibatis.io.Resources; 5 import org.apache.ibatis.session.SqlSession; 6 import org.apache.ibatis.session.SqlSessionFactory; 7 import org.apache.ibatis.session.SqlSessionFactoryBuilder; 8 import org.junit.*; 9 10 import java.io.IOException; 11 import java.io.Reader; 12 import java.util.ArrayList; 13 import java.util.List; 14 15 /* 16 * 使用mybatis举例，使用动态SQL举例 17 * */ 18 public class TestDongTai { 19 String resource = "mybatis-config-dongtai.xml"; 20 SqlSessionFactory sqlSessionFactory = null; 21 SqlSession session = null; 22 23 // if标签:只要test中的表达式为true，就会执行if标签中的条件 24 @Test 25 public void testSelectByIf() { 26 // 接口自动实例化 27 UserDaoDT userDao = session.getMapper(UserDaoDT.class); 28 User user = new User(); 29 user.setName("Tom"); 30 user.setAge("25"); 31 System.out.println("查询对象：" + user); 32 // 执行sql 33 List listUser = userDao.selectByIf(user); 34 System.out.println(listUser); 35 } 36 37 // choose标签:多个选项中选择一个 38 @Test 39 public void testSelectByChoose() { 40 // 接口自动实例化 41 UserDaoDT userDao = session.getMapper(UserDaoDT.class); 42 User user = new User(); 43 // user.setName("Tom"); 44 user.setAge("2"); 45 System.out.println("查询对象：" + user); 46 // 执行sql 47 List listUser = userDao.selectByChoose(user); 48 System.out.println(listUser); 49 } 50 51 // trim标签：替换关键字 52 @Test 53 public void testsSelectByTrim() { 54 // 接口自动实例化 55 UserDaoDT userDao = session.getMapper(UserDaoDT.class); 56 User user = new User(); 57 // user.setName("Tom"); 58 user.setAge("2"); 59 System.out.println("查询对象：" + user); 60 // 执行sql 61 List listUser = userDao.selectByTrim(user); 62 System.out.println(listUser); 63 } 64 65 // where标签：自动判断是否需要加上"where"关键字和去掉"and"关键字 66 @Test 67 public void testSelectByWhere() { 68 // 接口自动实例化 69 UserDaoDT userDao = session.getMapper(UserDaoDT.class); 70 User user = new User(); 71 user.setName("Tom"); 72 user.setAge("25"); 73 System.out.println("查询对象：" + user); 74 // 执行sql 75 List listUser = userDao.selectByWhere(user); 76 System.out.println(listUser); 77 } 78 79 // foreach标签：处理传参为List的情况 80 @Test 81 public void testSelectByList() { 82 // 接口自动实例化 83 UserDaoDT userDao = session.getMapper(UserDaoDT.class); 84 List idList = new ArrayList(); 85 idList.add(1); 86 idList.add(2); 87 idList.add(3); 88 System.out.println("查询List：" + idList); 89 // 执行sql 90 List listUser = userDao.selectByList(idList); 91 System.out.println(listUser); 92 } 93 94 // foreach标签：处理传参为数组的情况 95 @Test 96 public void testSelectByArray() { 97 // 接口自动实例化 98 UserDaoDT userDao = session.getMapper(UserDaoDT.class); 99 Integer[] ids = {1, 2, 3};100 System.out.println("查询数组：" + ids);101 // 执行sql102 List listUser = userDao.selectByArray(ids);103 System.out.println(listUser);104 }105 106 107 @Before108 public void before() {109 // System.out.println("Before");110 try {111 Reader read = Resources.getResourceAsReader(resource);112 // 创建工厂113 sqlSessionFactory = new SqlSessionFactoryBuilder().build(read);114 // 创建session对象115 session = sqlSessionFactory.openSession();116 } catch (IOException e) {117 e.printStackTrace();118 }119 }120 121 @After122 public void close() {123 session.close();124 // System.out.println("After");125 }126 127 }
UserDaoDT.java
1 package DongTai; 2 3 import bean.User; 4 5 import java.util.List; 6 7 8 /* 9 * Mybatis使用动态SQL举例10 * */11 public interface UserDaoDT {12 13 public List selectByIf(User user);14 15 public List selectByChoose(User user);16 17 public List selectByWhere(User user);18 19 public List selectByTrim(User user);20 21 public List selectByList(List list);22 23 public List selectByArray(Integer[] ids);24 25 }