/** 查询 */
@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();
}
}
