springbootTestDao

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(classes = BaseTestBeanConfig.class)
@DirtiesContext(classMode = DirtiesContext.ClassMode.BEFORE_EACH_TEST_METHOD)
@TestExecutionListeners(listeners = {SpringBootDependencyInjectionTestExecutionListener.class,
    ServletTestExecutionListener.class, ClearDataBaseListener.class})
public abstract class BaseDaoTest {

  @Autowired
  protected DataSource dataSource;

  /**
   * Execute SQL directly, these SQL may be for test purpose only and should not be included in
   * mybatis sqlMapper configuration files.
   *
   * @param sql SQL statement to execute, variable binding is NOT supported for simplicity.
   */
  protected void execute(String sql) {
    try {
      dataSource.getConnection().createStatement().execute(sql);
    } catch (SQLException e) {
      throw new RuntimeException(e);
    }
  }
}