package com.unis.crk;

import com.unis.crk.common.mapper.BillnonewgjjMapper;
import com.unis.crk.common.service.IBillnonewgjjService;
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.test.context.junit4.SpringRunner;

import javax.annotation.Resource;
import java.sql.SQLException;
import java.util.List;
import java.util.Map;

@RunWith(SpringRunner.class)
@SpringBootTest
public class CrkApplicationTests {
	@Autowired
	IBillnonewgjjService billnonewgjjService;
	@Resource
	BillnonewgjjMapper billnonewgjjMapper;
	@Test
	public void contextLoads() {
		billnonewgjjService.deleteYw("11","DATA_CRKYW_RKCM_DEFAULT");
		List<Map<String, Object>> list = billnonewgjjMapper.findBySql("SELECT id as \"id\" FROM ods_up_lsrkjsxxjk_final where bizNo = '111' ");
		System.out.println(list.size());

	}

}
