Example usage for org.apache.ibatis.session SqlSession getMapper

Introduction

In this page you can find the example usage for org.apache.ibatis.session SqlSession getMapper.

Prototype

<T> T getMapper(Class<T> type);

Source Link

Document

Retrieves a mapper.

Usage

From source file:com.quancheng.mybatis.mapper.test.user.TestMap.java

License:Open Source License

/**
 * ??null/*from  www  .j a v  a 2s  . c o m*/
 */
//    @Test
public void testUpdateByPrimaryKeySelective() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        UserInfoMapMapper mapper = sqlSession.getMapper(UserInfoMapMapper.class);
        UserInfoMap userInfoMap = mapper.selectByPrimaryKey(1);
        Assert.assertNotNull(userInfoMap);
        userInfoMap.setUserType(null);
        userInfoMap.setRealName("liuzh");
        //?user_type
        Assert.assertEquals(1, mapper.updateByPrimaryKeySelective(userInfoMap));

        userInfoMap = mapper.selectByPrimaryKey(1);
        Assert.assertEquals("1", userInfoMap.getUserType());
        Assert.assertEquals("liuzh", userInfoMap.getRealName());
    } finally {
        sqlSession.close();
    }
}

From source file:com.quancheng.mybatis.mapper.test.user.TestUserLogin.java

License:Open Source License

/**
 * // w  w w  .  j a v  a  2  s .com
 */
@Test
public void testInsert() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        UserLoginMapper mapper = sqlSession.getMapper(UserLoginMapper.class);

        UserLogin userLogin = new UserLogin();
        userLogin.setUsername("abel533");
        userLogin.setLogindate(new Date());
        userLogin.setLoginip("192.168.123.1");

        Assert.assertEquals(1, mapper.insert(userLogin));

        Assert.assertNotNull(userLogin.getLogid());
        Assert.assertTrue(userLogin.getLogid() > 10);
        //?
        Assert.assertEquals(1, mapper.deleteByPrimaryKey(userLogin));
    } finally {
        sqlSession.close();
    }
}

From source file:com.quancheng.mybatis.mapper.test.user.TestUserLogin.java

License:Open Source License

/**
 * ?/*from w  w  w .j a  v  a  2  s .  c  o  m*/
 */
@Test
public void testDelete() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        UserLoginMapper mapper = sqlSession.getMapper(UserLoginMapper.class);
        //
        Assert.assertEquals(10, mapper.selectCount(new UserLogin()));
        //?
        Map<String, Object> key = new HashMap<String, Object>();
        key.put("logid", 1);
        key.put("username", "test1");
        UserLogin userLogin = mapper.selectByPrimaryKey(key);
        //?
        Assert.assertEquals(1, mapper.deleteByPrimaryKey(key));

        //
        Assert.assertEquals(9, mapper.selectCount(new UserLogin()));
        //?
        Assert.assertEquals(1, mapper.insert(userLogin));
    } finally {
        sqlSession.close();
    }
}

From source file:com.quancheng.mybatis.mapper.test.user.TestUserLogin.java

License:Open Source License

/**
 * /*from  w w w.j av  a 2 s  .  co m*/
 */
@Test
public void testSelect() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        UserLoginMapper mapper = sqlSession.getMapper(UserLoginMapper.class);
        UserLogin userLogin = new UserLogin();
        userLogin.setUsername("test1");
        List<UserLogin> userLogins = mapper.select(userLogin);
        Assert.assertEquals(5, userLogins.size());
    } finally {
        sqlSession.close();
    }
}

From source file:com.quancheng.mybatis.mapper.test.user.TestUserLogin.java

License:Open Source License

/**
 * ?/*from  w  ww .  j ava 2  s.c  o m*/
 */
@Test
public void testUpdateByPrimaryKey() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        UserLoginMapper mapper = sqlSession.getMapper(UserLoginMapper.class);
        Map<String, Object> key = new HashMap<String, Object>();
        key.put("logid", 2);
        key.put("username", "test1");
        UserLogin userLogin = mapper.selectByPrimaryKey(key);
        Assert.assertNotNull(userLogin);
        userLogin.setLoginip("1.1.1.1");
        userLogin.setLogindate(null);
        //?username
        Assert.assertEquals(1, mapper.updateByPrimaryKey(userLogin));

        userLogin = mapper.selectByPrimaryKey(userLogin);
        Assert.assertNull(userLogin.getLogindate());
        Assert.assertEquals("1.1.1.1", userLogin.getLoginip());
    } finally {
        sqlSession.close();
    }
}

From source file:com.quancheng.mybatis.mapper.test.user.TestUserLogin.java

License:Open Source License

/**
 * ??null//from   w  ww  .j  a  v a  2s . co  m
 */
@Test
public void testUpdateByPrimaryKeySelective() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        UserLoginMapper mapper = sqlSession.getMapper(UserLoginMapper.class);

        Map<String, Object> key = new HashMap<String, Object>();
        key.put("logid", 1);
        key.put("username", "test1");

        UserLogin userLogin = mapper.selectByPrimaryKey(key);
        Assert.assertNotNull(userLogin);
        userLogin.setLogindate(null);
        userLogin.setLoginip("1.1.1.1");
        //?username
        Assert.assertEquals(1, mapper.updateByPrimaryKeySelective(userLogin));

        userLogin = mapper.selectByPrimaryKey(key);
        Assert.assertNotNull(userLogin.getLogindate());
        Assert.assertEquals("1.1.1.1", userLogin.getLoginip());
    } finally {
        sqlSession.close();
    }
}

From source file:com.quancheng.mybatis.mapper.test.user.TestUserLogin2.java

License:Open Source License

/**
 * /*from ww  w .  j  a v  a2 s.  c  o m*/
 */
@Test
public void testInsert() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        UserLogin2Mapper mapper = sqlSession.getMapper(UserLogin2Mapper.class);

        UserLogin2 userLogin = new UserLogin2();
        userLogin.setUsername("abel533");
        userLogin.setLogindate(new Date());
        userLogin.setLoginip("192.168.123.1");

        Assert.assertEquals(1, mapper.insert(userLogin));

        Assert.assertNotNull(userLogin.getLogid());
        Assert.assertTrue(userLogin.getLogid() > 10);
        //?
        Assert.assertEquals(1, mapper.deleteByPrimaryKey(userLogin));
    } finally {
        sqlSession.close();
    }
}

From source file:com.quancheng.mybatis.mapper.test.user.TestUserLogin2.java

License:Open Source License

/**
 * ?//  ww  w. j av  a2s. co m
 */
@Test
public void testDelete() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        UserLogin2Mapper mapper = sqlSession.getMapper(UserLogin2Mapper.class);
        //
        Assert.assertEquals(10, mapper.selectCount(new UserLogin2()));
        //?
        UserLogin2Key key = new UserLogin2();
        key.setLogid(1);
        key.setUsername("test1");
        UserLogin2 userLogin = mapper.selectByPrimaryKey(key);
        //?
        Assert.assertEquals(1, mapper.deleteByPrimaryKey(key));

        //
        Assert.assertEquals(9, mapper.selectCount(new UserLogin2()));
        //?
        Assert.assertEquals(1, mapper.insert(userLogin));
    } finally {
        sqlSession.close();
    }
}

From source file:com.quancheng.mybatis.mapper.test.user.TestUserLogin2.java

License:Open Source License

/**
 * /*from   w w w . j  a  va 2 s  . c  om*/
 */
@Test
public void testSelect() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        UserLogin2Mapper mapper = sqlSession.getMapper(UserLogin2Mapper.class);
        UserLogin2 userLogin = new UserLogin2();
        userLogin.setUsername("test1");
        List<UserLogin2> userLogins = mapper.select(userLogin);
        Assert.assertEquals(5, userLogins.size());
    } finally {
        sqlSession.close();
    }
}

From source file:com.quancheng.mybatis.mapper.test.user.TestUserLogin2.java

License:Open Source License

/**
 * ?/*w  w  w  .  j a  v a  2  s .co  m*/
 */
@Test
public void testUpdateByPrimaryKey() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        UserLogin2Mapper mapper = sqlSession.getMapper(UserLogin2Mapper.class);
        UserLogin2Key key = new UserLogin2();
        key.setLogid(2);
        key.setUsername("test1");
        UserLogin2 userLogin = mapper.selectByPrimaryKey(key);
        Assert.assertNotNull(userLogin);
        userLogin.setLoginip("1.1.1.1");
        userLogin.setLogindate(null);
        //?username
        Assert.assertEquals(1, mapper.updateByPrimaryKey(userLogin));

        userLogin = mapper.selectByPrimaryKey(userLogin);
        Assert.assertNull(userLogin.getLogindate());
        Assert.assertEquals("1.1.1.1", userLogin.getLoginip());
    } finally {
        sqlSession.close();
    }
}