Loading SQL Resources Using Spring IO Resource Annotation

SpringJUnitIOResourceExampleTest.java

import org.junit.Before;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.core.io.Resource;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration({
  "/spring/applicationContext.xml", 
  "/springtest/applicationContext-testDataSource.xml"})
public class SpringJUnitIOResourceExampleTest {
  
  @Autowired
  private SomeDaoImpl someDaoImpl;

  @Autowired
  private Resource testDatabaseSetupScriptSmall;
  
  @Autowired
  private StatementLoader statementLoader;
  
  @Autowired
  private JdbcTemplate jdbcTemplate;
  
  @Before
  public void init() {
    statementLoader.executeStatements(testDatabaseSetupScriptSmall, jdbcTemplate);
  }

  ...
}