import org.springframework.test.context.junit4.SpringRunner;

import javax.transaction.Transactional;
import java.util.List;

@TestPropertySource(properties = {
        "spring.profiles.active=mysql",
        "spring.datasource.username=root",
        "spring.datasource.password=Vienna1683"})
@RunWith(SpringRunner.class)
@SpringBootTest
@Transactional
public class SearchShowcase {

    @Autowired
    private NamedParameterJdbcTemplate template;

    @Test
    public void test() {
        MapSqlParameterSource params = new MapSqlParameterSource();
        String query = "select * from cars where car_id = 1";
        List li = template.queryForList(query, params);
    }
}