/** 根据主键全更新 */
@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();
}
}
/** 主要测试删除 */
@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();
}
}
