springboot单元测试

1.idea在 file settings plugins中下载插件 junitGenerate2.0

2.test包设置为绿色

3.测试的文件跟@SpringBootApplication在同一个包下 新建包

4.测试

package com.cssoc;

import com.cssoc.mapper.LicenceMapper;
import com.cssoc.model.Licence;
import com.cssoc.model.Station;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.dao.EmptyResultDataAccessException;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
import org.springframework.util.StringUtils;

import java.util.List;
import java.util.Map;

/**
 * @author yangwencai
 * @description
 * @date 2021/3/25
 */

@RunWith(SpringJUnit4ClassRunner.class)
@SpringBootTest
public class licenceTest {

    @Autowired
    private JdbcTemplate jdbcTemplate;

    @Autowired
    private LicenceMapper licenceMapper;

//    @Test
    public void queryDetail() throws Exception {
        String sql = "SELECT s_id,certificate,price FROM b_station WHERE certificate IS NOT NULL AND certificate <>''";
        List< Map<String, Object>> list = jdbcTemplate.queryForList(sql);
        list.stream().forEach(o->{
           if(!StringUtils.isEmpty(o.get("certificate"))){
               Licence licence = new Licence();
               licence.setName(o.get("certificate").toString());
               licence.setStationId(Integer.valueOf(o.get("s_id").toString()));
               if(!StringUtils.isEmpty(o.get("price"))){
                   licence.setPrice((float)o.get("price"));
               }
               licenceMapper.insertSelective(licence);
           }
   });






    }

}