Examples with AwfulTableDAO mbg.test.ib2j2.generated.flat.dao.AwfulTableDAO used on opensource projects

Example 11 with AwfulTableDAO

use of mbg.test.ib2j2.generated.flat.dao.AwfulTableDAO in project generator by mybatis.

the class AbstractFlatJava2Test method getAwfulTableDAO.

protected AwfulTableDAO getAwfulTableDAO() {
    AwfulTableDAOImpl dao = new AwfulTableDAOImpl();
    dao.setSqlMapClient(getSqlMapClient());
    return dao;
}

Example 12 with AwfulTableDAO

use of mbg.test.ib2j2.generated.flat.dao.AwfulTableDAO in project generator by mybatis.

the class FlatJava2Test method testAwfulTableUpdateByPrimaryKeySelective.

public void testAwfulTableUpdateByPrimaryKeySelective() {
    AwfulTableDAO dao = getAwfulTableDAO();
    try {
        AwfulTable record = new AwfulTable();
        record.seteMail("fred@fred.com");
        record.setEmailaddress("alsofred@fred.com");
        record.setFirstFirstName("fred1");
        record.setFrom("from field");
        record.setId1(new Integer(1));
        record.setId2(new Integer(2));
        record.setId5(new Integer(5));
        record.setId6(new Integer(6));
        record.setId7(new Integer(7));
        record.setSecondFirstName("fred2");
        record.setThirdFirstName("fred3");
        Integer generatedCustomerId = dao.insert(record);
        AwfulTable newRecord = new AwfulTable();
        newRecord.setCustomerId(generatedCustomerId);
        newRecord.setId1(new Integer(11));
        newRecord.setId2(new Integer(22));
        int rows = dao.updateByPrimaryKeySelective(newRecord);
        assertEquals(1, rows);
        AwfulTable returnedRecord = dao.selectByPrimaryKey(generatedCustomerId);
        assertEquals(generatedCustomerId, returnedRecord.getCustomerId());
        assertEquals(record.geteMail(), returnedRecord.geteMail());
        assertEquals(record.getEmailaddress(), returnedRecord.getEmailaddress());
        assertEquals(record.getFirstFirstName(), returnedRecord.getFirstFirstName());
        assertEquals(record.getFrom(), returnedRecord.getFrom());
        assertEquals(newRecord.getId1(), returnedRecord.getId1());
        assertEquals(newRecord.getId2(), returnedRecord.getId2());
        assertEquals(record.getId5(), returnedRecord.getId5());
        assertEquals(record.getId6(), returnedRecord.getId6());
        assertEquals(record.getId7(), returnedRecord.getId7());
        assertEquals(record.getSecondFirstName(), returnedRecord.getSecondFirstName());
        assertEquals(record.getThirdFirstName(), returnedRecord.getThirdFirstName());
    } catch (SQLException e) {
        fail(e.getMessage());
    }
}

Example 13 with AwfulTableDAO

use of mbg.test.ib2j2.generated.flat.dao.AwfulTableDAO in project generator by mybatis.

the class FlatJava2Test method testAwfulTableSelectByExampleLike.

public void testAwfulTableSelectByExampleLike() {
    AwfulTableDAO dao = getAwfulTableDAO();
    try {
        AwfulTable record = new AwfulTable();
        record.seteMail("fred@fred.com");
        record.setEmailaddress("alsofred@fred.com");
        record.setFirstFirstName("fred1");
        record.setFrom("from field");
        record.setId1(new Integer(1));
        record.setId2(new Integer(2));
        record.setId5(new Integer(5));
        record.setId6(new Integer(6));
        record.setId7(new Integer(7));
        record.setSecondFirstName("fred2");
        record.setThirdFirstName("fred3");
        dao.insert(record);
        record = new AwfulTable();
        record.seteMail("wilma@wilma.com");
        record.setEmailaddress("alsoWilma@wilma.com");
        record.setFirstFirstName("wilma1");
        record.setFrom("from field");
        record.setId1(new Integer(11));
        record.setId2(new Integer(22));
        record.setId5(new Integer(55));
        record.setId6(new Integer(66));
        record.setId7(new Integer(77));
        record.setSecondFirstName("wilma2");
        record.setThirdFirstName("wilma3");
        dao.insert(record);
        record = new AwfulTable();
        record.seteMail("pebbles@pebbles.com");
        record.setEmailaddress("alsoPebbles@pebbles.com");
        record.setFirstFirstName("pebbles1");
        record.setFrom("from field");
        record.setId1(new Integer(111));
        record.setId2(new Integer(222));
        record.setId5(new Integer(555));
        record.setId6(new Integer(666));
        record.setId7(new Integer(777));
        record.setSecondFirstName("pebbles2");
        record.setThirdFirstName("pebbles3");
        dao.insert(record);
        record = new AwfulTable();
        record.seteMail("barney@barney.com");
        record.setEmailaddress("alsoBarney@barney.com");
        record.setFirstFirstName("barney1");
        record.setFrom("from field");
        record.setId1(new Integer(1111));
        record.setId2(new Integer(2222));
        record.setId5(new Integer(5555));
        record.setId6(new Integer(6666));
        record.setId7(new Integer(7777));
        record.setSecondFirstName("barney2");
        record.setThirdFirstName("barney3");
        dao.insert(record);
        record = new AwfulTable();
        record.seteMail("betty@betty.com");
        record.setEmailaddress("alsoBetty@betty.com");
        record.setFirstFirstName("betty1");
        record.setFrom("from field");
        record.setId1(new Integer(11111));
        record.setId2(new Integer(22222));
        record.setId5(new Integer(55555));
        record.setId6(new Integer(66666));
        record.setId7(new Integer(77777));
        record.setSecondFirstName("betty2");
        record.setThirdFirstName("betty3");
        dao.insert(record);
        record = new AwfulTable();
        record.seteMail("bammbamm@bammbamm.com");
        record.setEmailaddress("alsoBammbamm@bammbamm.com");
        record.setFirstFirstName("bammbamm1");
        record.setFrom("from field");
        record.setId1(new Integer(111111));
        record.setId2(new Integer(222222));
        record.setId5(new Integer(555555));
        record.setId6(new Integer(666666));
        record.setId7(new Integer(777777));
        record.setSecondFirstName("bammbamm2");
        record.setThirdFirstName("bammbamm3");
        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);
        assertEquals(11111, returnedRecord.getId1().intValue());
        assertEquals(22222, returnedRecord.getId2().intValue());
        returnedRecord = (AwfulTable) answer.get(2);
        assertEquals(111111, returnedRecord.getId1().intValue());
        assertEquals(222222, returnedRecord.getId2().intValue());
    } catch (SQLException e) {
        fail(e.getMessage());
    }
}

Example 14 with AwfulTableDAO

use of mbg.test.ib2j2.generated.flat.dao.AwfulTableDAO in project generator by mybatis.

the class FlatJava2Test method testAwfulTableSelectByExampleNotLike.

public void testAwfulTableSelectByExampleNotLike() {
    AwfulTableDAO dao = getAwfulTableDAO();
    try {
        AwfulTable record = new AwfulTable();
        record.seteMail("fred@fred.com");
        record.setEmailaddress("alsofred@fred.com");
        record.setFirstFirstName("fred1");
        record.setFrom("from field");
        record.setId1(new Integer(1));
        record.setId2(new Integer(2));
        record.setId5(new Integer(5));
        record.setId6(new Integer(6));
        record.setId7(new Integer(7));
        record.setSecondFirstName("fred2");
        record.setThirdFirstName("fred3");
        dao.insert(record);
        record = new AwfulTable();
        record.seteMail("wilma@wilma.com");
        record.setEmailaddress("alsoWilma@wilma.com");
        record.setFirstFirstName("wilma1");
        record.setFrom("from field");
        record.setId1(new Integer(11));
        record.setId2(new Integer(22));
        record.setId5(new Integer(55));
        record.setId6(new Integer(66));
        record.setId7(new Integer(77));
        record.setSecondFirstName("wilma2");
        record.setThirdFirstName("wilma3");
        dao.insert(record);
        record = new AwfulTable();
        record.seteMail("pebbles@pebbles.com");
        record.setEmailaddress("alsoPebbles@pebbles.com");
        record.setFirstFirstName("pebbles1");
        record.setFrom("from field");
        record.setId1(new Integer(111));
        record.setId2(new Integer(222));
        record.setId5(new Integer(555));
        record.setId6(new Integer(666));
        record.setId7(new Integer(777));
        record.setSecondFirstName("pebbles2");
        record.setThirdFirstName("pebbles3");
        dao.insert(record);
        record = new AwfulTable();
        record.seteMail("barney@barney.com");
        record.setEmailaddress("alsoBarney@barney.com");
        record.setFirstFirstName("barney1");
        record.setFrom("from field");
        record.setId1(new Integer(1111));
        record.setId2(new Integer(2222));
        record.setId5(new Integer(5555));
        record.setId6(new Integer(6666));
        record.setId7(new Integer(7777));
        record.setSecondFirstName("barney2");
        record.setThirdFirstName("barney3");
        dao.insert(record);
        record = new AwfulTable();
        record.seteMail("betty@betty.com");
        record.setEmailaddress("alsoBetty@betty.com");
        record.setFirstFirstName("betty1");
        record.setFrom("from field");
        record.setId1(new Integer(11111));
        record.setId2(new Integer(22222));
        record.setId5(new Integer(55555));
        record.setId6(new Integer(66666));
        record.setId7(new Integer(77777));
        record.setSecondFirstName("betty2");
        record.setThirdFirstName("betty3");
        dao.insert(record);
        record = new AwfulTable();
        record.seteMail("bammbamm@bammbamm.com");
        record.setEmailaddress("alsoBammbamm@bammbamm.com");
        record.setFirstFirstName("bammbamm1");
        record.setFrom("from field");
        record.setId1(new Integer(111111));
        record.setId2(new Integer(222222));
        record.setId5(new Integer(555555));
        record.setId6(new Integer(666666));
        record.setId7(new Integer(777777));
        record.setSecondFirstName("bammbamm2");
        record.setThirdFirstName("bammbamm3");
        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);
        assertEquals(11, returnedRecord.getId1().intValue());
        assertEquals(22, returnedRecord.getId2().intValue());
        returnedRecord = (AwfulTable) answer.get(2);
        assertEquals(111, returnedRecord.getId1().intValue());
        assertEquals(222, returnedRecord.getId2().intValue());
    } catch (SQLException e) {
        fail(e.getMessage());
    }
}

Example 15 with AwfulTableDAO

use of mbg.test.ib2j2.generated.flat.dao.AwfulTableDAO in project generator by mybatis.

the class HierarchicalJava2Test method testAwfulTableSelectByExampleIn.

public void testAwfulTableSelectByExampleIn() {
    AwfulTableDAO dao = getAwfulTableDAO();
    try {
        AwfulTable record = new AwfulTable();
        record.seteMail("fred@fred.com");
        record.setEmailaddress("alsofred@fred.com");
        record.setFirstFirstName("fred1");
        record.setFrom("from field");
        record.setId1(new Integer(1));
        record.setId2(new Integer(2));
        record.setId5(new Integer(5));
        record.setId6(new Integer(6));
        record.setId7(new Integer(7));
        record.setSecondFirstName("fred2");
        record.setThirdFirstName("fred3");
        dao.insert(record);
        record = new AwfulTable();
        record.seteMail("wilma@wilma.com");
        record.setEmailaddress("alsoWilma@wilma.com");
        record.setFirstFirstName("wilma1");
        record.setFrom("from field");
        record.setId1(new Integer(11));
        record.setId2(new Integer(22));
        record.setId5(new Integer(55));
        record.setId6(new Integer(66));
        record.setId7(new Integer(77));
        record.setSecondFirstName("wilma2");
        record.setThirdFirstName("wilma3");
        dao.insert(record);
        record = new AwfulTable();
        record.seteMail("pebbles@pebbles.com");
        record.setEmailaddress("alsoPebbles@pebbles.com");
        record.setFirstFirstName("pebbles1");
        record.setFrom("from field");
        record.setId1(new Integer(111));
        record.setId2(new Integer(222));
        record.setId5(new Integer(555));
        record.setId6(new Integer(666));
        record.setId7(new Integer(777));
        record.setSecondFirstName("pebbles2");
        record.setThirdFirstName("pebbles3");
        dao.insert(record);
        record = new AwfulTable();
        record.seteMail("barney@barney.com");
        record.setEmailaddress("alsoBarney@barney.com");
        record.setFirstFirstName("barney1");
        record.setFrom("from field");
        record.setId1(new Integer(1111));
        record.setId2(new Integer(2222));
        record.setId5(new Integer(5555));
        record.setId6(new Integer(6666));
        record.setId7(new Integer(7777));
        record.setSecondFirstName("barney2");
        record.setThirdFirstName("barney3");
        dao.insert(record);
        record = new AwfulTable();
        record.seteMail("betty@betty.com");
        record.setEmailaddress("alsoBetty@betty.com");
        record.setFirstFirstName("betty1");
        record.setFrom("from field");
        record.setId1(new Integer(11111));
        record.setId2(new Integer(22222));
        record.setId5(new Integer(55555));
        record.setId6(new Integer(66666));
        record.setId7(new Integer(77777));
        record.setSecondFirstName("betty2");
        record.setThirdFirstName("betty3");
        dao.insert(record);
        record = new AwfulTable();
        record.seteMail("bammbamm@bammbamm.com");
        record.setEmailaddress("alsoBammbamm@bammbamm.com");
        record.setFirstFirstName("bammbamm1");
        record.setFrom("from field");
        record.setId1(new Integer(111111));
        record.setId2(new Integer(222222));
        record.setId5(new Integer(555555));
        record.setId6(new Integer(666666));
        record.setId7(new Integer(777777));
        record.setSecondFirstName("bammbamm2");
        record.setThirdFirstName("bammbamm3");
        dao.insert(record);
        List ids = new ArrayList();
        ids.add(new Integer(1));
        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());
        returnedRecord = (AwfulTable) answer.get(1);
        assertEquals(11, returnedRecord.getId1().intValue());
        assertEquals(22, returnedRecord.getId2().intValue());
    } catch (SQLException e) {
        fail(e.getMessage());
    }
}