Package org.apache.ibatis.session

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

114
115
116
117
118
119
120
121
122
123
124
      for (Name n : answer) {
        assertTrue(n.getLastName() == null);
      }

      p = new Parameter(false, "Rub");
      answer = sqlSession.selectList("selectNamesWithExpressions", p);
      assertEquals(2, answer.size());
      for (Name n : answer) {
        assertTrue(n.getLastName() == null);
      }
View Full Code Here
133
134
135
136
137
138
139
140
141
142
143
    try {

      int[] ids = { 2, 4, 5 };
      Map<String, Object> param = new HashMap<String, Object>();
      param.put("ids", ids);
      List<Name> answer = sqlSession.selectList("selectNamesWithIteration", param);
      assertEquals(3, answer.size());
      for (int i = 0; i < ids.length; i++) {
        assertEquals(ids[i], answer.get(i).getId());
      }
View Full Code Here
149
150
151
152
153
154
155
156
157
158
159
  @Test
  public void testLangRaw() {
    SqlSession sqlSession = sqlSessionFactory.openSession();
    try {
      Parameter p = new Parameter(true, "Fli%");
      List<Name> answer = sqlSession.selectList("selectRaw", p);
      assertEquals(3, answer.size());
      for (Name n : answer) {
        assertEquals("Flintstone", n.getLastName());
      }
    } finally {
View Full Code Here
164
165
166
167
168
169
170
171
172
173
174
  @Test
  public void testLangRawWithInclude() {
    SqlSession sqlSession = sqlSessionFactory.openSession();
    try {
      Parameter p = new Parameter(true, "Fli%");
      List<Name> answer = sqlSession.selectList("selectRawWithInclude", p);
      assertEquals(3, answer.size());
      for (Name n : answer) {
        assertEquals("Flintstone", n.getLastName());
      }
    } finally {
View Full Code Here
178
179
180
181
182
183
184
185
186
187
188
  @Test
  public void testLangRawWithIncludeAndCData() {
    SqlSession sqlSession = sqlSessionFactory.openSession();
    try {
      Parameter p = new Parameter(true, "Fli%");
      List<Name> answer = sqlSession.selectList("selectRawWithIncludeAndCData", p);
      assertEquals(3, answer.size());
      for (Name n : answer) {
        assertEquals("Flintstone", n.getLastName());
      }
    } finally {
View Full Code Here
193
194
195
196
197
198
199
200
201
202
203
  @Test
  public void testLangXmlTags() {
    SqlSession sqlSession = sqlSessionFactory.openSession();
    try {
      Parameter p = new Parameter(true, "Fli%");
      List<Name> answer = sqlSession.selectList("selectXml", p);
      assertEquals(3, answer.size());
      for (Name n : answer) {
        assertEquals("Flintstone", n.getLastName());
      }
    } finally {
View Full Code Here
83
84
85
86
87
88
89
90
91
92
93
      names.add(name);

      Parameter parameter = new Parameter();
      parameter.setNames(names);

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

      assertTrue(answer.size() == 2);
    } finally {
      sqlSession.close();
    }
View Full Code Here
41
42
43
44
45
46
47
48
49
50
51
    public void testSelectListWithNestedResultMap() throws Exception {
        String xmlConfig = "org/apache/ibatis/submitted/custom_collection_handling/MapperConfig.xml";
        SqlSessionFactory sqlSessionFactory = getSqlSessionFactoryXmlConfig(xmlConfig);
        SqlSession sqlSession = sqlSessionFactory.openSession();
        try {
            List<Person> list = sqlSession.selectList("org.apache.ibatis.submitted.custom_collection_handling.PersonMapper.findWithResultMap");
            assertEquals(2, list.size());
            assertEquals(2, list.get(0).getContacts().size());
            assertEquals(1, list.get(1).getContacts().size());
            assertEquals("3 Wall Street", list.get(0).getContacts().get(1).getAddress());
        } finally {
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
    public void testSelectListWithNestedSelect() throws Exception {
        String xmlConfig = "org/apache/ibatis/submitted/custom_collection_handling/MapperConfig.xml";
        SqlSessionFactory sqlSessionFactory = getSqlSessionFactoryXmlConfig(xmlConfig);
        SqlSession sqlSession = sqlSessionFactory.openSession();
        try {
            List<Person> list = sqlSession.selectList("org.apache.ibatis.submitted.custom_collection_handling.PersonMapper.findWithSelect");
            assertEquals(2, list.size());
            assertEquals(2, list.get(0).getContacts().size());
            assertEquals(1, list.get(1).getContacts().size());
            assertEquals("3 Wall Street", list.get(0).getContacts().get(1).getAddress());
        }
View Full Code Here
54
55
56
57
58
59
60
61
62
63
64
  @Test
  public void shouldGetAUser() {
    SqlSession sqlSession = sqlSessionFactory.openSession();
    try {
      List<Map> results = sqlSession.selectList("getUser");
      for (Map r : results) {
          Assert.assertEquals(String.class, r.get("a1").getClass());
          Assert.assertEquals(String.class, r.get("a2").getClass());
      }
    } finally {
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.