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