Package mbg.test.ib2j2.generated.flat.dao

Examples of mbg.test.ib2j2.generated.flat.dao.PkfieldsDAO.selectByExample()

975
976
977
978
979
980
981
982
983
984
985
            dao.insert(record);
   
            AwfulTableExample example = new AwfulTableExample();
            example.createCriteria().andFirstFirstNameLike("b%");
            example.setOrderByClause("\"A_CuStOmEr iD\"");
            List answer = dao.selectByExample(example);
            assertEquals(3, answer.size());
            AwfulTable returnedRecord = (AwfulTable) answer.get(0);
            assertEquals(1111, returnedRecord.getId1().intValue());
            assertEquals(2222, returnedRecord.getId2().intValue());
            returnedRecord = (AwfulTable) answer.get(1);
View Full Code Here
1082
1083
1084
1085
1086
1087
1088
1089
1090
1091
1092
            dao.insert(record);
   
            AwfulTableExample example = new AwfulTableExample();
            example.createCriteria().andFirstFirstNameNotLike("b%");
            example.setOrderByClause("\"A_CuStOmEr iD\"");
            List answer = dao.selectByExample(example);
            assertEquals(3, answer.size());
            AwfulTable returnedRecord = (AwfulTable) answer.get(0);
            assertEquals(1, returnedRecord.getId1().intValue());
            assertEquals(2, returnedRecord.getId2().intValue());
            returnedRecord = (AwfulTable) answer.get(1);
View Full Code Here
1190
1191
1192
1193
1194
1195
1196
1197
1198
1199
1200
   
            AwfulTableExample example = new AwfulTableExample();
            example.or().andFirstFirstNameLike("b%").andId2EqualTo(new Integer(222222));
            example.or().andFirstFirstNameLike("wi%");
            example.setOrderByClause("\"A_CuStOmEr iD\"");
            List answer = dao.selectByExample(example);
            assertEquals(2, answer.size());
            AwfulTable returnedRecord = (AwfulTable) answer.get(0);
            assertEquals(11, returnedRecord.getId1().intValue());
            assertEquals(22, returnedRecord.getId2().intValue());
            returnedRecord = (AwfulTable) answer.get(1);
View Full Code Here
1298
1299
1300
1301
1302
1303
1304
1305
1306
1307
1308
            ids.add(new Integer(11));
   
            AwfulTableExample example = new AwfulTableExample();
            example.createCriteria().andId1In(ids);
            example.setOrderByClause("\"A_CuStOmEr iD\"");
            List answer = dao.selectByExample(example);
           
            assertEquals(2, answer.size());
            AwfulTable returnedRecord = (AwfulTable) answer.get(0);
            assertEquals(1, returnedRecord.getId1().intValue());
            assertEquals(2, returnedRecord.getId2().intValue());
View Full Code Here
1402
1403
1404
1405
1406
1407
1408
1409
1410
1411
1412
            record.setThirdFirstName("bammbamm3");
            dao.insert(record);
   
            AwfulTableExample example = new AwfulTableExample();
            example.createCriteria().andId1Between(new Integer(1), new Integer(1000));
            List answer = dao.selectByExample(example);
            assertEquals(3, answer.size());
        } catch (Exception e) {
            fail(e.getMessage());
        }
    }
View Full Code Here
1501
1502
1503
1504
1505
1506
1507
1508
1509
1510
1511
   
            AwfulTableExample example = new AwfulTableExample();
            example.createCriteria();
            example.setOrderByClause("\"A_CuStOmEr iD\" desc");
           
            List answer = dao.selectByExample(example);
            assertEquals(6, answer.size());
            AwfulTable returnedRecord = (AwfulTable) answer.get(0);
            assertEquals(111111, returnedRecord.getId1().intValue());
            returnedRecord = (AwfulTable) answer.get(1);
            assertEquals(11111, returnedRecord.getId1().intValue());
View Full Code Here
165
166
167
168
169
170
171
172
173
174
175
   
            int rows = dao.deleteByPrimaryKey(generatedCustomerId);
            assertEquals(1, rows);
   
            AwfulTableExample example = new AwfulTableExample();
            List answer = dao.selectByExample(example);
            assertEquals(0, answer.size());
        } catch (Exception e) {
            fail(e.getMessage());
        }
    }
View Full Code Here
269
270
271
272
273
274
275
276
277
278
279
            record.setThirdFirstName("fred33");
   
            dao.insert(record);
   
            AwfulTableExample example = new AwfulTableExample();
            List answer = dao.selectByExample(example);
            assertEquals(2, answer.size());
   
            example = new AwfulTableExample();
            example.createCriteria().andEMailLike("fred@%");
            int rows = dao.deleteByExample(example);
View Full Code Here
88
89
90
91
92
93
94
95
96
97
98
            dao.insert(record);
   
            FieldsonlyExample example = new FieldsonlyExample();
            example.createCriteria();
   
            List answer = dao.selectByExample(example);
            assertEquals(3, answer.size());
        } catch (Exception e) {
            fail(e.getMessage());
        }
    }
View Full Code Here
52
53
54
55
56
57
58
59
60
61
62
            dao.insert(record);
   
            FieldsonlyExample example = new FieldsonlyExample();
            example.createCriteria().andIntegerfieldGreaterThan(new Integer(5));
   
            List answer = dao.selectByExample(example);
            assertEquals(2, answer.size());
   
            example = new FieldsonlyExample();
            answer = dao.selectByExample(example);
            assertEquals(3, answer.size());
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.