Examples of selectOne()

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

42
43
44
45
46
47
48
49
50
51
52
            assertEquals((Integer)2, person.getPets().get(1).getId());

            Pet pet = (Pet) sqlSession.selectOne("person namespace.selectPet", 1);
            assertEquals(Integer.valueOf(1), pet.getId());

            Pet pet2 = (Pet) sqlSession.selectOne("pet namespace.select", 3);
            assertEquals((Integer)3, pet2.getId());
            assertEquals((Integer)2, pet2.getOwner().getId());
        }
        finally {
            sqlSession.close();
View Full Code Here

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

60
61
62
63
64
65
66
67
68
69
70
    try {
      Map<String, String> map = new HashMap<String, String>();
      map.put("table", "users");
      map.put("column", "name");
      map.put("value", "User1");
      Integer count = sqlSession.selectOne("count", map);
      Assert.assertEquals(new Integer(1), count);
    } finally {
      sqlSession.close();
    }
  }
View Full Code Here

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

73
74
75
76
77
78
79
80
81
82
83
  public void shouldWorkWithAList() {
    SqlSession sqlSession = sqlSessionFactory.openSession();
    try {
      List<String> list = new ArrayList<String>();
      list.add("users");
      Integer count = sqlSession.selectOne("count2",list);
      Assert.assertEquals(new Integer(1), count);
    } finally {
      sqlSession.close();
    }
  }
View Full Code Here

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

52
53
54
55
56
57
58
59
60
61
62
      user.setAdministrator(true);

      sqlSession.insert("User.insert", user);

      //Retrieve User
      user = (User) sqlSession.selectOne("User.find", user.getId());

      assertNotNull(user.getId());

      sqlSession.rollback();
    } finally {
View Full Code Here

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

49
50
51
52
53
54
55
56
57
58
59
        Connection conn = configuration.getEnvironment().getDataSource().getConnection();
        initDb(conn);

        SqlSession sqlSession = sqlSessionFactory.openSession();
        try {
            Person person = (Person) sqlSession.selectOne("person namespace.select", 1);
            assertEquals((Integer)1, person.getId());
            assertEquals(2, person.getPets().size());
            assertEquals((Integer)2, person.getPets().get(1).getId());

            Pet pet = (Pet) sqlSession.selectOne("person namespace.selectPet", 1);
View Full Code Here

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

54
55
56
57
58
59
60
61
62
63
64
            Person person = (Person) sqlSession.selectOne("person namespace.select", 1);
            assertEquals((Integer)1, person.getId());
            assertEquals(2, person.getPets().size());
            assertEquals((Integer)2, person.getPets().get(1).getId());

            Pet pet = (Pet) sqlSession.selectOne("person namespace.selectPet", 1);
            assertEquals(Integer.valueOf(1), pet.getId());

            Pet pet2 = (Pet) sqlSession.selectOne("pet namespace.select", 3);
            assertEquals((Integer)3, pet2.getId());
            assertEquals((Integer)2, pet2.getOwner().getId());
View Full Code Here

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

57
58
59
60
61
62
63
64
65
66
67
            assertEquals((Integer)2, person.getPets().get(1).getId());

            Pet pet = (Pet) sqlSession.selectOne("person namespace.selectPet", 1);
            assertEquals(Integer.valueOf(1), pet.getId());

            Pet pet2 = (Pet) sqlSession.selectOne("pet namespace.select", 3);
            assertEquals((Integer)3, pet2.getId());
            assertEquals((Integer)2, pet2.getOwner().getId());
        }
        finally {
            sqlSession.close();
View Full Code Here

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

35
36
37
38
39
40
41
42
43
44
45
    SqlSessionFactory sqlMapper = builder.build(reader);
    assertNotNull(sqlMapper);

    final SqlSession sqlSession = sqlMapper.openSession();
    try {
      final Integer result = sqlSession.selectOne("org.apache.ibatis.submitted.includes.mapper.selectWithProperty");
      Assert.assertEquals(Integer.valueOf(1), result);
    } finally {
      sqlSession.close();
    }
  }
View Full Code Here

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

41
42
43
44
45
46
47
48
49
50
51
  @Test
  public void testCaseInsensitivity() throws Exception {
    SqlSession sqlSession = sqlSessionFactory.openSession();
    try {
      Brand brand = sqlSession.selectOne("org.apache.ibatis.submitted.column_prefix.MapperAutoMapping.selectBrandWithProducts", 1);
      assertEquals(Integer.valueOf(1), brand.getId());
      assertEquals(2, brand.getProducts().size());
      assertEquals(Integer.valueOf(10), brand.getProducts().get(0).getId());
      assertEquals("alpha", brand.getProducts().get(0).getName());
    } finally {
View Full Code Here

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

71
72
73
74
75
76
77
78
79
80
81
    SqlSession sqlSession = sqlSessionFactory.openSession();
    try {
      Assert.assertEquals(sqlSource, sqlSession.getConfiguration().getMappedStatement(statement).getSqlSource().getClass());
      String sql = sqlSession.getConfiguration().getMappedStatement(statement).getSqlSource().getBoundSql('?').getSql();
      Assert.assertEquals("select * from users where id = ?", sql);
      User user = sqlSession.selectOne(statement, 1);
      Assert.assertEquals("User1", user.getName());
    } 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.