record.setSecondFirstName("fred22");
record.setThirdFirstName("fred33");
dao.insert(record);
AwfulTableExample example = new AwfulTableExample();
List<AwfulTable> answer = dao.selectByExample(example);
assertEquals(2, answer.size());
example = new AwfulTableExample();
example.createCriteria().andEMailLike("fred@%");
int rows = dao.deleteByExample(example);
assertEquals(1, rows);
example.clear();
answer = dao.selectByExample(example);
assertEquals(1, answer.size());
} catch (SQLException e) {
fail(e.getMessage());
}