Package mbg.test.ib2j2.generated.hierarchical.dao

Examples of mbg.test.ib2j2.generated.hierarchical.dao.PkonlyDAO.selectByExample()

758
759
760
761
762
763
764
765
766
767
768
            dao.insert(record);

            PkfieldsExample example = new PkfieldsExample();
            example.createCriteria().andFirstnameNotLike("B%");
            example.setOrderByClause("ID1, ID2");
            List answer = dao.selectByExample(example);
            assertEquals(3, answer.size());
            Pkfields returnedRecord = (Pkfields) answer.get(0);
            assertEquals(1, returnedRecord.getId1().intValue());
            assertEquals(1, returnedRecord.getId2().intValue());
            returnedRecord = (Pkfields) answer.get(1);
View Full Code Here
826
827
828
829
830
831
832
833
834
835
836
            example.createCriteria().andFirstnameLike("B%").andId2EqualTo(
                    new Integer(3));
            example.or(example.createCriteria().andFirstnameLike("Wi%"));

            example.setOrderByClause("ID1, ID2");
            List answer = dao.selectByExample(example);
            assertEquals(2, answer.size());
            Pkfields returnedRecord = (Pkfields) answer.get(0);
            assertEquals(1, returnedRecord.getId1().intValue());
            assertEquals(2, returnedRecord.getId2().intValue());
            returnedRecord = (Pkfields) answer.get(1);
View Full Code Here
900
901
902
903
904
905
906
907
908
909
910
            PkfieldsExample example = new PkfieldsExample();
            example.createCriteria().andId2In(ids).andStringbooleanNotIn(bools);

            example.setOrderByClause("ID1, ID2");
            List answer = dao.selectByExample(example);
            assertEquals(4, answer.size());
            Pkfields returnedRecord = (Pkfields) answer.get(0);
            assertEquals(1, returnedRecord.getId1().intValue());
            assertEquals(1, returnedRecord.getId2().intValue());
            returnedRecord = (Pkfields) answer.get(1);
View Full Code Here
970
971
972
973
974
975
976
977
978
979
980
            PkfieldsExample example = new PkfieldsExample();
            example.createCriteria().andId2Between(new Integer(1),
                    new Integer(3));

            example.setOrderByClause("ID1, ID2");
            List answer = dao.selectByExample(example);
            assertEquals(6, answer.size());
        } catch (SQLException e) {
            fail(e.getMessage());
        }
    }
View Full Code Here
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
            PkfieldsExample example = new PkfieldsExample();
            example.createCriteria();

            example.setOrderByClause("ID1, ID2");
            List answer = dao.selectByExample(example);
            assertEquals(6, answer.size());
        } catch (SQLException e) {
            fail(e.getMessage());
        }
    }
View Full Code Here
1095
1096
1097
1098
1099
1100
1101
1102
1103
1104
1105
            PkfieldsExample example = new PkfieldsExample();
            example.createCriteria().andWierdFieldLessThan(new Integer(40))
                    .andWierdFieldIn(values);

            example.setOrderByClause("ID1, ID2");
            List answer = dao.selectByExample(example);
            assertEquals(2, answer.size());
        } catch (SQLException e) {
            fail(e.getMessage());
        }
    }
View Full Code Here
268
269
270
271
272
273
274
275
276
277
278
            key.setId(new Integer(1));
            key.setSeqNum(new Integer(3));
            dao.insert(key);

            PkonlyExample example = new PkonlyExample();
            List answer = dao.selectByExample(example);
            assertEquals(1, answer.size());

            Pkonly returnedRecord = (Pkonly) answer.get(0);
            assertEquals(key.getId(), returnedRecord.getId());
            assertEquals(key.getSeqNum(), returnedRecord.getSeqNum());
View Full Code Here
294
295
296
297
298
299
300
301
302
303
304
            key.setId(new Integer(5));
            key.setSeqNum(new Integer(6));
            dao.insert(key);

            PkonlyExample example = new PkonlyExample();
            List answer = dao.selectByExample(example);
            assertEquals(2, answer.size());

            int rows = dao.deleteByPrimaryKey(new Integer(5), new Integer(6));
            assertEquals(1, rows);
View Full Code Here
300
301
302
303
304
305
306
307
308
309
310
            assertEquals(2, answer.size());

            int rows = dao.deleteByPrimaryKey(new Integer(5), new Integer(6));
            assertEquals(1, rows);

            answer = dao.selectByExample(example);
            assertEquals(1, answer.size());
        } catch (SQLException e) {
            fail(e.getMessage());
        }
    }
View Full Code Here
332
333
334
335
336
337
338
339
340
341
342
            example.createCriteria().andIdGreaterThan(new Integer(4));
            int rows = dao.deleteByExample(example);
            assertEquals(2, rows);

            example.clear();
            List answer = dao.selectByExample(example);
            assertEquals(1, answer.size());
        } catch (SQLException e) {
            fail(e.getMessage());
        }
    }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.