Package org.apache.ibatis.session

Examples of org.apache.ibatis.session.SqlSession.selectList()

72
73
74
75
76
77
78
79
80
81
82
      name.setLastName("Flintstone");
      Parameter parameter = new Parameter();
      parameter.addName(name);

      List<Map<String, Object>> answer =
          sqlSession.selectList("org.apache.ibatis.submitted.nested.Mapper.simpleSelect", parameter);

      assertEquals(3, answer.size());
    } finally {
      sqlSession.close();
    }
View Full Code Here
89
90
91
92
93
94
95
96
97
98
99
      Map<String, Object> parameter = new HashMap<String, Object>();
      int[] array = new int[] {1, 3, 5};
      parameter.put("ids", array);

      List<Map<String, Object>> answer =
          sqlSession.selectList("org.apache.ibatis.submitted.nested.Mapper.simpleSelectWithPrimitives", parameter);

      assertEquals(3, answer.size());
    } finally {
      sqlSession.close();
    }
View Full Code Here
122
123
124
125
126
127
128
129
130
131
132
      Parameter parameter = new Parameter();
      parameter.addName(name);

      List<Map<String, Object>> answer =
          sqlSession.selectList("org.apache.ibatis.submitted.nested.Mapper.nestedSelect", parameter);

      assertEquals(2, answer.size());
    } finally {
      sqlSession.close();
    }
View Full Code Here
148
149
150
151
152
153
154
155
156
157
158
      name.setLastName("Rubble");
      name.addFirstName("Betty");
      parameter.addName(name);

      List<Map<String, Object>> answer =
          sqlSession.selectList("org.apache.ibatis.submitted.nested.Mapper.nestedSelect", parameter);

      assertEquals(3, answer.size());
    } finally {
      sqlSession.close();
    }
View Full Code Here
37
38
39
40
41
42
43
44
45
46
47
  public void testSelectList() throws Exception {
    String xmlConfig = "org/apache/ibatis/submitted/result_handler_type/MapperConfig.xml";
    SqlSessionFactory sqlSessionFactory = getSqlSessionFactoryXmlConfig(xmlConfig);
    SqlSession sqlSession = sqlSessionFactory.openSession();
    try {
      List<Person> list = sqlSession
          .selectList("org.apache.ibatis.submitted.result_handler_type.PersonMapper.doSelect");
      assertEquals(list.size(), 2);
      assertEquals("java.util.LinkedList", list.getClass().getCanonicalName());
    } finally {
      sqlSession.close();
View Full Code Here
69
70
71
72
73
74
75
76
77
78
79
  public void testDynamicSelectWithPropertyParams() {
    SqlSession sqlSession = sqlSessionFactory.openSession();
    try {

      Parameter p = new Parameter(true, "Fli%");
      List<Name> answer = sqlSession.selectList("selectNames", p);
      assertEquals(3, answer.size());
      for (Name n : answer) {
        assertEquals("Flintstone", n.getLastName());
      }
View Full Code Here
76
77
78
79
80
81
82
83
84
85
86
      for (Name n : answer) {
        assertEquals("Flintstone", n.getLastName());
      }

      p = new Parameter(false, "Fli%");
      answer = sqlSession.selectList("selectNames", p);
      assertEquals(3, answer.size());
      for (Name n : answer) {
        assertTrue(n.getLastName() == null);
      }
View Full Code Here
83
84
85
86
87
88
89
90
91
92
93
      for (Name n : answer) {
        assertTrue(n.getLastName() == null);
      }

      p = new Parameter(false, "Rub%");
      answer = sqlSession.selectList("selectNames", p);
      assertEquals(2, answer.size());
      for (Name n : answer) {
        assertTrue(n.getLastName() == null);
      }
View Full Code Here
100
101
102
103
104
105
106
107
108
109
110
  public void testDynamicSelectWithExpressionParams() {
    SqlSession sqlSession = sqlSessionFactory.openSession();
    try {

      Parameter p = new Parameter(true, "Fli");
      List<Name> answer = sqlSession.selectList("selectNamesWithExpressions", p);
      assertEquals(3, answer.size());
      for (Name n : answer) {
        assertEquals("Flintstone", n.getLastName());
      }
View Full Code Here
107
108
109
110
111
112
113
114
115
116
117
      for (Name n : answer) {
        assertEquals("Flintstone", n.getLastName());
      }

      p = new Parameter(false, "Fli");
      answer = sqlSession.selectList("selectNamesWithExpressions", p);
      assertEquals(3, answer.size());
      for (Name n : answer) {
        assertTrue(n.getLastName() == null);
      }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.