Package org.apache.ibatis.session

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

12
13
14
15
16
17
18
19
20
21
22
    this.sqlSessionFactory = sqlSessionFactory;
  }

  public List<Author> getAuthors() {
    SqlSession session = sqlSessionFactory.openSession();
    List<Author> authors = session.selectList("Author.getAllAuthors");
    session.close();
    return authors;
  }

  public void setSqlSessionFactory(SqlSessionFactory sqlSessionFactory) {
View Full Code Here
49
50
51
52
53
54
55
56
57
58
59
  @SuppressWarnings("unchecked")
  @Test
  public void testIt() {
    SqlSession sqlSession = sqlSessionFactory.openSession();
    try {
      List<Map<String, Object>> list = sqlSession.selectList("org.apache.ibatis.submitted.quotedcolumnnames.Map.doSelect");
      printList(list);
      assertColumnNames(list);
    } finally {
      sqlSession.close();
    }
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
  @SuppressWarnings("unchecked")
  @Test
  public void testItWithResultMap() {
    SqlSession sqlSession = sqlSessionFactory.openSession();
    try {
      List<Map<String, Object>> list = sqlSession.selectList("org.apache.ibatis.submitted.quotedcolumnnames.Map.doSelectWithResultMap");
      printList(list);
      assertColumnNames(list);
    } finally {
      sqlSession.close();
    }
View Full Code Here
69
70
71
72
73
74
75
76
77
78
79
      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
58
59
60
61
62
63
64
65
66
67
68
      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
79
80
81
82
83
84
85
86
87
88
89
      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
91
92
93
94
95
96
97
98
99
100
101
  @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
58
59
60
61
62
63
64
65
66
67
68
      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
62
63
64
65
66
67
68
69
70
71
72
  @Test
  public void testIt() {
    SqlSession sqlSession = sqlSessionFactory.openSession();
    try {
      List<Map<String, Object>> list = sqlSession.selectList("org.apache.ibatis.submitted.quotedcolumnnames.Map.doSelect");
      printList(list);
      assertColumnNames(list);
    } finally {
      sqlSession.close();
    }
View Full Code Here
74
75
76
77
78
79
80
81
82
83
84
  @Test
  public void testItWithResultMap() {
    SqlSession sqlSession = sqlSessionFactory.openSession();
    try {
      List<Map<String, Object>> list = sqlSession.selectList("org.apache.ibatis.submitted.quotedcolumnnames.Map.doSelectWithResultMap");
      printList(list);
      assertColumnNames(list);
    } finally {
      sqlSession.close();
    }
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.