public interface MarkDAO {
    public Mark insertMark(Mark mark);
    public Mark getMarkById(long markId);
}

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations = "classpath:spring/test-context.xml")
@TransactionConfiguration(transactionManager = "transactionManager")
@Transactional
public class MarkDaoJdbcImplTest {

    @Autowired
    private MarkDAO markDAO;

    @Test
    public void testInsertMark(){
        Mark expectedMark=createTestMark();
        expectedMark=markDAO.insertMark(expectedMark);

        Mark factMark=markDAO.getMarkById(expectedMark.getId());
        assertMarksEquals(expectedMark,factMark);
    }

    @Test
    public void testGetMarkById(){
        Mark expectedMark=createTestMark();
        expectedMark=markDAO.insertMark(expectedMark);

        Mark factMark=markDAO.getMarkById(expectedMark.getId());
        assertMarksEquals(expectedMark,factMark);
    }

    private Mark createTestMark(){
        Mark mark=new Mark();
        mark.setName("Test mark");
        return mark;
    }

    public void assertMarksEquals(Mark expected,Mark fact){
        assertEquals(expected.getName(),fact.getName());
    }
}

    public void testGetMarkById(){
        Mark expectedMark=createTestMark();
        String sql="INSERT INTO MARK....";
        KeyHolder keyHolder......
        jdbcTemplate.query(sql,createParamsMap(expectedMark),keyHolder,new String[]{"MARK_ID"});
        expectedMark.setId(keyHolder.getLongValue());
        Mark factMark=markDAO.getMarkById(expectedMark.getId());
        assertMarksEquals(expectedMark,factMark);
    }