calendar.set(Calendar.MINUTE, 15);
record.setDatefield(calendar.getTime());
record.setTimefield(calendar.getTime());
mapper.insert(record);
PkfieldsExample example = new PkfieldsExample();
example.createCriteria().andDatefieldEqualTo(calendar.getTime());
example.setOrderByClause("ID1, ID2");
List<Pkfields> answer = mapper.selectByExample(example);
assertEquals(1, answer.size());
example.clear();
example.createCriteria().andDatefieldLessThan(calendar.getTime());
answer = mapper.selectByExample(example);
assertEquals(5, answer.size());
calendar.set(Calendar.MINUTE, 12);
example.clear();
example.createCriteria().andTimefieldEqualTo(calendar.getTime());
answer = mapper.selectByExample(example);
assertEquals(1, answer.size());
example.clear();
example.createCriteria().andTimefieldGreaterThan(calendar.getTime());
answer = mapper.selectByExample(example);
assertEquals(3, answer.size());
} finally {
sqlSession.close();
}