Package org.apache.ibatis.session

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

73
74
75
76
77
78
79
80
81
82
83
      Parameter parameter = new Parameter();
      parameter.setEnabled(true);
      parameter.setSchema("ibtest");
      parameter.setIds(ids);

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

      assertTrue(answer.size() == 3);
    } finally {
      sqlSession.close();
    }
View Full Code Here
94
95
96
97
98
99
100
101
102
103
104
      Parameter parameter = new Parameter();
      parameter.setEnabled(true);
      parameter.setSchema("ibtest");
      parameter.setIds(ids);

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

      assertTrue(answer.size() == 3);
    } finally {
      sqlSession.close();
    }
View Full Code Here
107
108
109
110
111
112
113
114
115
116
117
  @Test
  public void testSelectLike() {
    SqlSession sqlSession = sqlSessionFactory.openSession();
    try {

      List<Map<String, Object>> answer = sqlSession.selectList("org.apache.ibatis.submitted.dynsql.selectLike", "Ba");

      assertTrue(answer.size() == 2);
      assertEquals(new Integer(4), answer.get(0).get("ID"));
      assertEquals(new Integer(6), answer.get(1).get("ID"));
View Full Code Here
122
123
124
125
126
127
128
129
130
131
132
  @Test
  public void testNumerics() {
    SqlSession sqlSession = sqlSessionFactory.openSession();
    try {
      List<NumericRow> answer = sqlSession.selectList("org.apache.ibatis.submitted.dynsql.selectNumerics");

      assertTrue(answer.size() == 1);

      NumericRow row = answer.get(0);
      assertEquals(1, (int) row.getId());
View Full Code Here
147
148
149
150
151
152
153
154
155
156
157
  @Test
  public void testOgnlStaticMethodCall() {
    SqlSession sqlSession = sqlSessionFactory.openSession();
    try {
      List<Map<String, Object>> answer = sqlSession.selectList("org.apache.ibatis.submitted.dynsql.ognlStaticMethodCall", "Rock 'n Roll");
      assertTrue(answer.size() == 1);
      assertEquals(new Integer(7), answer.get(0).get("ID"));

    } finally {
      sqlSession.close();
View Full Code Here
85
86
87
88
89
90
91
92
93
94
95
    } finally {
      sqlSession.close();
    }

    sqlSession = sqlSessionFactory.openSession();
    List<User> users = sqlSession.selectList("select");
    Assert.assertTrue(users.size() == 2);
  }

  public void testJdbc3Support() throws Exception {
    Connection conn = sqlSessionFactory.getConfiguration().getEnvironment().getDataSource().getConnection();
View Full Code Here
72
73
74
75
76
77
78
79
80
81
82
      criterion.setValue("Fred");
      Parameter parameter = new Parameter();
      parameter.setCriterion(criterion);

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

      assertEquals(1, answer.size());
    } finally {
      sqlSession.close();
    }
View Full Code Here
53
54
55
56
57
58
59
60
61
62
63
  @Test
  public void shouldNotOverwriteCollectionOnNestedResultMap() {
    SqlSession session = factory.openSession();
    try {
    List<Author> authors = session.selectList("getAllAuthors");
    assertEquals(1, authors.size());
    assertEquals(4, authors.get(0).getPosts().size());
    } finally {
      session.close();
    }
View Full Code Here
66
67
68
69
70
71
72
73
74
75
76
  @Ignore // issue #75 nested selects overwrite collections
  @Test
  public void shouldNotOverwriteCollectionOnNestedQuery() {
    SqlSession session = factory.openSession();
    try {
    List<Author> authors = session.selectList("getAllAuthorsNestedQuery");
    assertEquals(1, authors.size());
    assertEquals(4, authors.get(0).getPosts().size());
    } finally {
      session.close();
    }
View Full Code Here
127
128
129
130
131
132
133
134
135
136
    } finally {
      sqlSession.close();
    }

    sqlSession = sqlSessionFactory.openSession();
    List<User> users = sqlSession.selectList("selectIdentity");
    Assert.assertTrue(users.size() == 2);
  }

}
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.