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

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

88
89
90
91
92
93
94
95
96
97
98
            assertEquals(record.getFloatfield(), new Double(33.44));
            assertEquals(record.getIntegerfield(), new Integer(5));
           
            example.clear();
            example.createCriteria().andIntegerfieldEqualTo(new Integer(8));
            answer = dao.selectByExample(example);
            assertEquals(1, answer.size());
            record = (Fieldsonly) answer.get(0);
            assertEquals(record.getDoublefield(), new Double(99));
            assertEquals(record.getFloatfield(), new Double(66.77));
            assertEquals(record.getIntegerfield(), new Integer(8));
View Full Code Here
97
98
99
100
101
102
103
104
105
106
107
            assertEquals(record.getFloatfield(), new Double(66.77));
            assertEquals(record.getIntegerfield(), new Integer(8));
           
            example.clear();
            example.createCriteria().andIntegerfieldEqualTo(new Integer(9));
            answer = dao.selectByExample(example);
            assertEquals(1, answer.size());
            record = (Fieldsonly) answer.get(0);
            assertEquals(record.getDoublefield(), new Double(99));
            assertEquals(record.getFloatfield(), new Double(100.111));
            assertEquals(record.getIntegerfield(), new Integer(9));
View Full Code Here
140
141
142
143
144
145
146
147
148
149
150
            int rows = dao.updateByExample(record, example);
            assertEquals(1, rows);

            example.clear();
            example.createCriteria().andIntegerfieldEqualTo(new Integer(22));
            List answer = dao.selectByExample(example);
            assertEquals(1, answer.size());
            record = (Fieldsonly) answer.get(0);
            assertNull(record.getDoublefield());
            assertNull(record.getFloatfield());
            assertEquals(record.getIntegerfield(), new Integer(22));
View Full Code Here
570
571
572
573
574
575
576
577
578
579
580
            int rows = dao.deleteByPrimaryKey(new Integer(2), new Integer(1));
            assertEquals(1, rows);

            PkfieldsExample example = new PkfieldsExample();
            List answer = dao.selectByExample(example);
            assertEquals(0, answer.size());
        } catch (SQLException e) {
            fail(e.getMessage());
        }
    }
View Full Code Here
597
598
599
600
601
602
603
604
605
606
607
            record.setId2(new Integer(4));

            dao.insert(record);

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

            example.clear();
            example.createCriteria().andLastnameLike("J%");
            int rows = dao.deleteByExample(example);
View Full Code Here
606
607
608
609
610
611
612
613
614
615
616
            example.createCriteria().andLastnameLike("J%");
            int rows = dao.deleteByExample(example);
            assertEquals(1, rows);

            example.clear();
            answer = dao.selectByExample(example);
            assertEquals(1, answer.size());
        } catch (SQLException e) {
            fail(e.getMessage());
        }
    }
View Full Code Here
693
694
695
696
697
698
699
700
701
702
703
            dao.insert(record);

            PkfieldsExample example = new PkfieldsExample();
            example.createCriteria().andFirstnameLike("B%");
            example.setOrderByClause("ID1, ID2");
            List answer = dao.selectByExample(example);
            assertEquals(3, answer.size());
            Pkfields returnedRecord = (Pkfields) answer.get(0);
            assertEquals(2, returnedRecord.getId1().intValue());
            assertEquals(1, returnedRecord.getId2().intValue());
            returnedRecord = (Pkfields) answer.get(1);
View Full Code Here
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
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.