10951096109710981099110011011102110311041105
dao.insert(record); PkfieldsExample example = new PkfieldsExample(); example.createCriteria().andLastnameLike("J%"); int rows = dao.countByExample(example); assertEquals(1, rows); example.clear(); rows = dao.countByExample(example); assertEquals(2, rows);
10991100110111021103110411051106110711081109
example.createCriteria().andLastnameLike("J%"); int rows = dao.countByExample(example); assertEquals(1, rows); example.clear(); rows = dao.countByExample(example); assertEquals(2, rows); } catch (SQLException e) { fail(e.getMessage()); } }
273274275276277278279280281282283
.andFirstnameEqualTo("Fred") .andLastnameEqualTo("Jones") .andId1EqualTo(new Integer(3)) .andId2EqualTo(new Integer(4)); rows = dao.countByExample(example); assertEquals(1, rows); } catch (SQLException e) { fail(e.getMessage()); } }
318319320321322323324325326327328
.andFirstnameEqualTo("Fred") .andLastnameIsNull() .andId1EqualTo(new Integer(3)) .andId2EqualTo(new Integer(4)); rows = dao.countByExample(example); assertEquals(1, rows); } catch (SQLException e) { fail(e.getMessage()); } }
30263027302830293030303130323033303430353036
dao.insert(record); AwfulTableExample example = new AwfulTableExample(); example.createCriteria().andEMailLike("fred@%"); int rows = dao.countByExample(example); assertEquals(1, rows); example.clear(); rows = dao.countByExample(example); assertEquals(2, rows);
30303031303230333034303530363037303830393040
example.createCriteria().andEMailLike("fred@%"); int rows = dao.countByExample(example); assertEquals(1, rows); example.clear(); rows = dao.countByExample(example); assertEquals(2, rows); } catch (SQLException e) { fail(e.getMessage()); } }
20042005200620072008200920102011201220132014
record.setBlob2(generateRandomBlob()); dao.insert(record); FieldsblobsExample example = new FieldsblobsExample(); example.createCriteria().andFirstnameLike("S%"); int rows = dao.countByExample(example); assertEquals(1, rows); example.clear(); rows = dao.countByExample(example); assertEquals(2, rows);
20082009201020112012201320142015201620172018
example.createCriteria().andFirstnameLike("S%"); int rows = dao.countByExample(example); assertEquals(1, rows); example.clear(); rows = dao.countByExample(example); assertEquals(2, rows); } catch (SQLException e) { fail(e.getMessage()); } }
224225226227228229230231232233234
record.setIntegerfield(9); dao.insert(record); FieldsonlyExample example = new FieldsonlyExample(); example.createCriteria().andIntegerfieldGreaterThan(5); int rows = dao.countByExample(example); assertEquals(2, rows); example.clear(); rows = dao.countByExample(example); assertEquals(3, rows);
228229230231232233234235236237238
example.createCriteria().andIntegerfieldGreaterThan(5); int rows = dao.countByExample(example); assertEquals(2, rows); example.clear(); rows = dao.countByExample(example); assertEquals(3, rows); } catch (SQLException e) { fail(e.getMessage()); } }