19571958195919601961196219631964196519661967
record.setBlob2(TestUtilities.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);
19611962196319641965196619671968196919701971
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()); } }
13851386138713881389139013911392139313941395
record.setBlob2(TestUtilities.generateRandomBlob()); dao.insert(record); PkblobsExample example = new PkblobsExample(); example.createCriteria().andIdLessThan(new Integer(4)); int rows = dao.countByExample(example); assertEquals(1, rows); example.clear(); rows = dao.countByExample(example); assertEquals(2, rows);
13891390139113921393139413951396139713981399
example.createCriteria().andIdLessThan(new Integer(4)); int rows = dao.countByExample(example); assertEquals(1, rows); example.clear(); rows = dao.countByExample(example); assertEquals(2, rows); } catch (SQLException e) { fail(e.getMessage()); } }
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()); } }
17701771177217731774177517761777177817791780
record.setBlob1(TestUtilities.generateRandomBlob()); dao.insert(record); PkfieldsblobsExample example = new PkfieldsblobsExample(); example.createCriteria().andId1NotEqualTo(new Integer(3)); int rows = dao.countByExample(example); assertEquals(1, rows); example.clear(); rows = dao.countByExample(example); assertEquals(2, rows);
17741775177617771778177917801781178217831784
example.createCriteria().andId1NotEqualTo(new Integer(3)); int rows = dao.countByExample(example); assertEquals(1, rows); example.clear(); rows = dao.countByExample(example); assertEquals(2, rows); } catch (SQLException e) { fail(e.getMessage()); } }