List of selectByExample() Examples

Examples of selectByExample()

Examples of mbg.test.mb3.generated.annotated.flat.mapper.AwfulTableMapper.selectByExample()

            mapper.insert(record);


            AwfulTableExample example = new AwfulTableExample();
            example.createCriteria().andFirstFirstNameLike("b%");
            example.setOrderByClause("\"A_CuStOmEr iD\"");
            List<AwfulTable> answer = mapper.selectByExample(example);
            assertEquals(3, answer.size());
            AwfulTable returnedRecord = answer.get(0);
            assertEquals(1111, returnedRecord.getId1().intValue());
            assertEquals(2222, returnedRecord.getId2().intValue());
            returnedRecord = answer.get(1);

View Full Code Here

Examples of mbg.test.mb3.generated.annotated.flat.mapper.FieldsblobsMapper.selectByExample()

            record.setBlob1(generateRandomBlob());
            record.setBlob2(generateRandomBlob());
            mapper.insert(record);


            FieldsblobsExample example = new FieldsblobsExample();
            List<Fieldsblobs> answer = mapper.selectByExample(example);
            assertEquals(2, answer.size());


            example = new FieldsblobsExample();
            example.createCriteria().andFirstnameLike("S%");
            int rows = mapper.deleteByExample(example);

View Full Code Here

Examples of mbg.test.mb3.generated.annotated.flat.mapper.FieldsonlyMapper.selectByExample()

            mapper.insert(record);


            FieldsonlyExample example = new FieldsonlyExample();
            example.createCriteria().andIntegerfieldEqualTo(5);


            List<Fieldsonly> answer = mapper.selectByExample(example);
            assertEquals(1, answer.size());


            Fieldsonly returnedRecord = answer.get(0);
            assertEquals(record.getIntegerfield(), returnedRecord
                    .getIntegerfield());

View Full Code Here

Examples of mbg.test.mb3.generated.annotated.flat.mapper.PkblobsMapper.selectByExample()

            record.setBlob1(generateRandomBlob());
            record.setBlob2(generateRandomBlob());
            mapper.insert(record);


            PkblobsExample example = new PkblobsExample();
            List<Pkblobs> answer = mapper.selectByExample(example);
            assertEquals(1, answer.size());


            int rows = mapper.deleteByPrimaryKey(3);
            assertEquals(1, rows);

View Full Code Here

Examples of mbg.test.mb3.generated.annotated.flat.mapper.PkfieldsMapper.selectByExample()


            int rows = mapper.deleteByPrimaryKey(2, 1);
            assertEquals(1, rows);


            PkfieldsExample example = new PkfieldsExample();
            List<Pkfields> answer = mapper.selectByExample(example);
            assertEquals(0, answer.size());
        } finally {
            sqlSession.close();
        }
    }

View Full Code Here

Examples of mbg.test.mb3.generated.annotated.flat.mapper.PkfieldsblobsMapper.selectByExample()

            record.setLastname("Jones");
            record.setBlob1(generateRandomBlob());
            mapper.insert(record);


            PkfieldsblobsExample example = new PkfieldsblobsExample();
            List<Pkfieldsblobs> answer = mapper
                    .selectByExample(example);
            assertEquals(2, answer.size());


            int rows = mapper.deleteByPrimaryKey(5, 6);
            assertEquals(1, rows);

View Full Code Here

Examples of mbg.test.mb3.generated.annotated.flat.mapper.PkonlyMapper.selectByExample()

            key.setId(1);
            key.setSeqNum(3);
            mapper.insert(key);


            PkonlyExample example = new PkonlyExample();
            List<Pkonly> answer = mapper.selectByExample(example);
            assertEquals(1, answer.size());


            Pkonly returnedRecord = answer.get(0);
            assertEquals(key.getId(), returnedRecord.getId());
            assertEquals(key.getSeqNum(), returnedRecord.getSeqNum());

View Full Code Here

Examples of mbg.test.mb3.generated.annotated.hierarchical.Immutable.Mapper.FieldsblobsMapper.selectByExample()


            record = new FieldsblobsWithBLOBs("Scott", "Jones", generateRandomBlob(), generateRandomBlob(), null);
            mapper.insert(record);


            FieldsblobsExample example = new FieldsblobsExample();
            List<Fieldsblobs> answer = mapper.selectByExample(example);
            assertEquals(2, answer.size());


            example = new FieldsblobsExample();
            example.createCriteria().andFirstnameLike("S%");
            int rows = mapper.deleteByExample(example);

View Full Code Here

Examples of mbg.test.mb3.generated.annotated.hierarchical.Immutable.Mapper.FieldsonlyMapper.selectByExample()

            mapper.insert(record);


            FieldsonlyExample example = new FieldsonlyExample();
            example.createCriteria().andIntegerfieldEqualTo(5);


            List<Fieldsonly> answer = mapper.selectByExample(example);
            assertEquals(1, answer.size());


            Fieldsonly returnedRecord = answer.get(0);
            assertEquals(record.getIntegerfield(), returnedRecord
                    .getIntegerfield());

View Full Code Here

Examples of mbg.test.mb3.generated.annotated.hierarchical.Immutable.Mapper.PkblobsMapper.selectByExample()

                    "Long String 2");
            mapper.insert(record);


            PkblobsExample example = new PkblobsExample();
            example.createCriteria().andIdGreaterThan(4);
            List<PkblobsKey> answer = mapper.selectByExample(example);


            assertEquals(1, answer.size());


            PkblobsKey key = answer.get(0);
            assertFalse(key instanceof PkblobsWithBLOBs);

View Full Code Here

0 1 2 3 4 5 6 7 8 9 10

TOP

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.