Spring单元测试，SQL数据准备

在测试中，一般的数据库数据Mock是不可少的。在前文的基础上，我们写读取脚本把数据写入数据库的工具类。

package com.jje.travel.provider;import com.jje.common.utils.JaxbUtils;import com.jje.common.utils.VirtualDispatcherService;import com.jje.dto.travel.line.LineDto;import com.jje.travel.esb.dto.EnvelopeDto;import com.jje.travel.esb.facade.LineEsb;import com.jje.travel.journey.domain.Journey;import com.jje.travel.line.domain.Line;import com.jje.travel.reservation.JourneyMaker;import com.jje.travel.reservation.LineMaker;import org.jboss.resteasy.mock.MockHttpRequest;import org.jboss.resteasy.mock.MockHttpResponse;import org.junit.Assert;import org.junit.Ignore;import org.junit.Test;import org.junit.runner.RunWith;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Component;import org.springframework.test.annotation.Rollback;import org.springframework.test.context.ContextConfiguration;import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;import org.springframework.transaction.annotation.Transactional;import javax.ws.rs.core.MediaType;import javax.ws.rs.core.Response.Status;import java.io.UnsupportedEncodingException;import java.net.URISyntaxException;import java.util.ArrayList;import java.util.List;import static com.natpryce.makeiteasy.MakeItEasy.*;@Componentpublic class LineSyncTest extends SqlDataPrepareUtil{@Test    @Rollback(true)    public void should_return_XXX_when_given_xx(){    }}