/** 查询 */
@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();
}
}
/** 新增 */
@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();
}
}
/** 根据主键全更新 */
@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();
}
}
