새창 열림 G1123 KISTEP Only

K2Base - 과학기술정책지원서비스

K2Base 소개

OpenAPI

1. 제공기관 : KISTEP

2. 서비스유형 : REST

3. 원본 데이터 조회 주소 : http://www.k2base.re.kr/plan/plcy/plcyPlanNewList.do

4. 중장기 계획 목록 조회

중장기계획명 또는 주관부처명으로 검색을 하면 해당하는 중장기계획에 대한 중장기계획명, 주관부처명, 대분류, 세분류, 시작연도, 종료연도가 조회된다.
요청주소 : http://www.k2base.re.kr/openapi/plan/list.do
사용 예 ) http://www.k2base.re.kr/openapi/plan/list.do?apiKey=36자리 API키&planNm=우주기술&deptNm=미래창조과학부&pageSize=10&pageIndex=1

요청변수

목록조회

목록조회
항목명	샘플데이터	설명
API키	e72867dc-f6dc-4730-964e-b5b9192e7e06	API를 사용하기 위한 KEY
planNm	우주기술	중장기계획명
deptNm	미래창조과학부	주관부처명
pegeSize	10	페이지당 출력 개수
pageIndex	1	페이지 번호

출력결과

출력결과
항목명	샘플데이터	설명
planId	401	중장기계획 고유키
planNm	우주기술산업화전략	중장기계획명
deptNm	미래창조과학부	주관부처명
planFieldMain	우주/공공	대분류
planFieldSub	우주/공공	세분류
startYear	2013	시작연도
endYear	2017	종료연도

5. 중장기계획 상세 조회

자체심의기구명, 법정계획여부, 시행계획여부, 근거법령이 조회된다.
요청주소 : http://www.k2base.re.kr/openapi/plan/detail.do
사용 예 ) http://www.k2base.re.kr/openapi/plan/detail.do?apiKey=36자리 API키&planId=401

요청변수

요청변수
항목명	샘플데이터	설명
API키	e72867dc-f6dc-4730-964e-b5b9192e7e06	API를 사용하기 위한 KEY
planId	401	중장기계획 교유키

출력결과

출력결과
항목명	샘플데이터	설명
planId	401	중장기계획 고유키
planNm	우주기술산업화전략	중장기계획명
deptNm	미래창조과학부	주관부처명
planFieldMain	우주/공공	대분류
planFieldSub	우주/공공	세분류
startYear	2013	시작연도
endYear	2017	종료연도
lastSetOrgNm	장차관이하	최종확정기구
msipSetYn	Y	미래부확정여부
slfDlbrtOrgNm	국가우주위원회	자체심의기구명
crtPlanYn	N	법정계획여부
execPlanYn	Y	시행계획여부
grdLaw	우주개발 진흥법 제15조	근거법령

6. 샘플코드

@Controller
public class ApiExplorer {

	@RequestMapping(value="/openapi/plan/sample1.do")
	public String openApiSample() throws Exception {

		return "/openapi/openApiSample1";
	}

	@RequestMapping(value="/openapi/plan/sample2.do")
	public String openApiSample(@RequestParam(value="apiKey", required=true) String apiKey,
				@RequestParam(value="planNm", required=false) String planNm,
				@RequestParam(value="deptNm", required=false) String deptNm,
				@RequestParam(value="pageSize", defaultValue="10") int pageSize,
				@RequestParam(value="pageIndex", defaultValue="1") int pageIndex, Model model) throws Exception {

		StringBuilder urlBuilder = new StringBuilder("http://k2base.re.kr/openapi/plan/list.do"); /*URL*/
		urlBuilder.append("?" + URLEncoder.encode("apiKey","UTF-8") + "=" + URLEncoder.encode(apiKey, "UTF-8")); /*apiKey*/
		urlBuilder.append("&" + URLEncoder.encode("planNm","UTF-8") + "=" + URLEncoder.encode(planNm, "UTF-8")); /*계획명*/
		urlBuilder.append("&" + URLEncoder.encode("deptNm","UTF-8") + "=" + URLEncoder.encode(deptNm, "UTF-8")); /*부처명*/
		urlBuilder.append("&" + URLEncoder.encode("pageSize","UTF-8") + "=" + pageSize); /*페이지 출력 건수*/
		urlBuilder.append("&" + URLEncoder.encode("pageIndex","UTF-8") + "=" + pageIndex); /*페이지 번호*/

		URL url = new URL(urlBuilder.toString());
		HttpURLConnection conn = (HttpURLConnection) url.openConnection();
		conn.setRequestMethod("GET");
		conn.setRequestProperty("Content-type", "application/json");

		BufferedReader rd;

		if(conn.getResponseCode() >= 200 && conn.getResponseCode() <= 300) {
			rd = new BufferedReader(new InputStreamReader(conn.getInputStream()));
		} else {
			rd = new BufferedReader(new InputStreamReader(conn.getErrorStream()));
		}

		StringBuilder sb = new StringBuilder();
		String line;

		while ((line = rd.readLine()) != null) {
			sb.append(line);
		}
		rd.close();
		conn.disconnect();

		ArrayList<HashMap<String, String>> resultList = new ArrayList<HashMap<String, String>>();

		try{
			InputSource is = new InputSource(new StringReader(sb.toString()));
			Document document = DocumentBuilderFactory.newInstance().newDocumentBuilder().parse(is);

			// xpath 생성
			XPath  xpath = XPathFactory.newInstance().newXPath();

			String expression = "//*/planItem";

			NodeList  cols = (NodeList) xpath.compile(expression).evaluate(document, XPathConstants.NODESET);

			for( int idx=0; idx < cols.getLength(); idx++ ){

	    		HashMap<String, String> resultMap = new HashMap<String, String>();

				String resultId=cols.item(idx).getAttributes().item(0).getTextContent();
				resultMap.put("id",resultId);

				expression = "//*[@id="+resultId+"]/planNm";
				String resultPlanNm = xpath.compile(expression).evaluate(document);
				resultMap.put("planNm",resultPlanNm);

				expression = "//*[@id="+resultId+"]/deptNm";
				String resultDeptNm = xpath.compile(expression).evaluate(document);
				resultMap.put("deptNm",resultDeptNm);

				expression = "//*[@id="+resultId+"]/startYear";
				String resultStartYear = xpath.compile(expression).evaluate(document);
				resultMap.put("startYear",resultStartYear);

				expression = "//*[@id="+resultId+"]/endYear";
				String resultEndYear = xpath.compile(expression).evaluate(document);
				resultMap.put("endYear",resultEndYear);

				expression = "//*[@id="+resultId+"]/planFieldMain";
				String resultPlanFieldMain = xpath.compile(expression).evaluate(document);
				resultMap.put("planFieldMain",resultPlanFieldMain);

				expression = "//*[@id="+resultId+"]/planFieldSub";
				String resultPlanFieldSub = xpath.compile(expression).evaluate(document);
				resultMap.put("planFieldSub",resultPlanFieldSub);

				resultList.add(resultMap);
			}
		}catch(Exception e){
			e.printStackTrace();
		}

		model.addAttribute("resultList", resultList);

		return "/openapi/openApiSample2";
	}


	@RequestMapping(value="/openapi/plan/sample3.do")
	public String openApiDetailSample(@RequestParam(value="apiKey", required=true) String planId,
	@RequestParam(value="planId", required=true) int planId,
	Model model) throws Exception {

		StringBuilder urlBuilder = new StringBuilder("http://k2base.re.kr/openapi/plan/detail.do"); /*URL*/
		urlBuilder.append("?" + URLEncoder.encode("apiKey","UTF-8") + "=" + URLEncoder.encode(apiKey, "UTF-8")); /*apiKey*/
		urlBuilder.append("&" + URLEncoder.encode("planId","UTF-8") + "=" + planId); /*고유키*/

		URL url = new URL(urlBuilder.toString());
		HttpURLConnection conn = (HttpURLConnection) url.openConnection();
		conn.setRequestMethod("GET");
		conn.setRequestProperty("Content-type", "application/json");

		BufferedReader rd;

		if(conn.getResponseCode() >= 200 && conn.getResponseCode() <= 300) {
			rd = new BufferedReader(new InputStreamReader(conn.getInputStream()));
		} else {
			rd = new BufferedReader(new InputStreamReader(conn.getErrorStream()));
		}

		StringBuilder sb = new StringBuilder();
		String line;

		while ((line = rd.readLine()) != null) {
			sb.append(line);
		}

		rd.close();
		conn.disconnect();

		HashMap<String, String> resultMap = new HashMap<String, String>();

		try{
			InputSource is = new InputSource(new StringReader(sb.toString()));
			Document document = DocumentBuilderFactory.newInstance().newDocumentBuilder().parse(is);

			// xpath 생성
			XPath  xpath = XPathFactory.newInstance().newXPath();

			String expression = "//*/planDetail";

			NodeList  cols = (NodeList) xpath.compile(expression).evaluate(document, XPathConstants.NODESET);

			for( int idx=0; idx<cols.getLength(); idx++ ){

				String resultId=cols.item(idx).getAttributes().item(0).getTextContent();
				resultMap.put("id",resultId);

				expression = "//*[@id="+resultId+"]/planNm";
				String resultPlanNm = xpath.compile(expression).evaluate(document);
				resultMap.put("planNm",resultPlanNm);

				expression = "//*[@id="+resultId+"]/deptNm";
				String resultDeptNm = xpath.compile(expression).evaluate(document);
				resultMap.put("deptNm",resultDeptNm);

				expression = "//*[@id="+resultId+"]/startYear";
				String resultStartYear = xpath.compile(expression).evaluate(document);
				resultMap.put("startYear",resultStartYear);

				expression = "//*[@id="+resultId+"]/endYear";
				String resultEndYear = xpath.compile(expression).evaluate(document);
				resultMap.put("endYear",resultEndYear);

				expression = "//*[@id="+resultId+"]/planFieldMain";
				String resultPlanFieldMain = xpath.compile(expression).evaluate(document);
				resultMap.put("planFieldMain",resultPlanFieldMain);

				expression = "//*[@id="+resultId+"]/planFieldSub";
				String resultPlanFieldSub = xpath.compile(expression).evaluate(document);
				resultMap.put("planFieldSub",resultPlanFieldSub);

				expression = "//*[@id="+resultId+"]/lastSetOrgNm";
				String resultLastSetOrgNm = xpath.compile(expression).evaluate(document);
				resultMap.put("lastSetOrgNm",resultLastSetOrgNm);

				expression = "//*[@id="+resultId+"]/msipSetYn";
				String resultMsipSetYn = xpath.compile(expression).evaluate(document);
				resultMap.put("msipSetYn",resultMsipSetYn);

				expression = "//*[@id="+resultId+"]/slfDlbrtOrgNm";
				String resultSlfDlbrtOrgNm = xpath.compile(expression).evaluate(document);
				resultMap.put("slfDlbrtOrgNm",resultSlfDlbrtOrgNm);

				expression = "//*[@id="+resultId+"]/crtPlanYn";
				String resultCrtPlanYn = xpath.compile(expression).evaluate(document);
				resultMap.put("crtPlanYn",resultCrtPlanYn);

				expression = "//*[@id="+resultId+"]/execPlanYn";
				String resultExecPlanYn = xpath.compile(expression).evaluate(document);
				resultMap.put("execPlanYn",resultExecPlanYn);

				expression = "//*[@id="+resultId+"]/grdLaw";
				String resultGrdLaw = xpath.compile(expression).evaluate(document);
				resultMap.put("grdLaw",resultGrdLaw);

			}
		}catch(Exception e){
			e.printStackTrace();
		}

		model.addAttribute("resultMap", resultMap);

		return "/openapi/openApiSample3";
	}
}

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
<script>
	function listSearch(){
		var planNm = document.getElementById("planNm");
		var deptNm = document.getElementById("deptNm");
		var planNmValue = encodeURIComponent(planNm.value);
		var deptNmValue = deptNm.options[deptNm.selectedIndex].value;
		var pageSize = "10";
		var pageIndex = "1";

		location.href="/openapi/plan/sample2.do?planNm="+planNmValue+"&deptNm="+deptNmValue+"&pageSize="+pageSize+"&pageIndex="+pageIndex;
	}
</script>
</head>
<body>
	<span>계획명</span>
	<input type="text" id="planNm" name="planNm" value=""/>
	<span>부처명</span>
	<select id="deptNm" name="deptNm">
		<option value="">전체</option>
		<option value="고용노동부">고용노동부</option>
		<option value="공정거래위원회">공정거래위원회</option>
		<option value="교육부">교육부</option>
		<option value="국무조정실">국무조정실</option>
		<option value="국방부">국방부</option>
		<option value="국토교통부">국토교통부</option>
		<option value="기상청">기상청</option>
		<option value="기획재정부">기획재정부</option>
		<option value="농림축산식품부">농림축산식품부</option>
		<option value="농촌진흥청">농촌진흥청</option>
		<option value="문화재청">문화재청</option>
		<option value="문화체육관광부">문화체육관광부</option>
		<option value="미래창조과학부">미래창조과학부</option>
		<option value="방위사업청">방위사업청</option>
		<option value="법무부">법무부</option>
		<option value="법제처">법제처</option>
		<option value="보건복지부">보건복지부</option>
		<option value="산림청">산림청</option>
		<option value="산업통상자원부">산업통상자원부</option>
		<option value="소방방재청">소방방재청</option>
		<option value="식품의약품안전처">식품의약품안전처</option>
		<option value="안전행정부">안전행정부</option>
		<option value="여성가족부">여성가족부</option>
		<option value="외교부">외교부</option>
		<option value="원자력안전위원회">원자력안전위원회</option>
		<option value="중소기업청">중소기업청</option>
		<option value="통일부">통일부</option>
		<option value="해양경찰청">해양경찰청</option>
		<option value="해양수산부">해양수산부</option>
		<option value="행정중심복합도시건설청">행정중심복합도시건설청</option>
		<option value="환경부">환경부</option>
		<option value="특허청">특허청</option>
		<option value="새만금청">새만금청</option>
		<option value="경찰청">경찰청</option>
		<option value="국민안전처">국민안전처</option>
		<option value="인사혁신처">인사혁신처</option>
		<option value="행정자치부">행정자치부</option>
		<option value="범부처사업">범부처사업</option>
	</select>
	<a title="조회" onclick="javascript:listSearch();" href="#">조회</a>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="spring" uri="http://www.springframework.org/tags"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
<script>
	function detailSearch(id){
		location.href="/openapi/plan/sample3.do?planId="+id;
	}
</script>
</head>
<body>
	<table>
		<tr>
			<th>ID</th>
			<th>계획명</th>
			<th>주관부처</th>
			<th>대분류</th>
			<th>세분류</th>
			<th>시작연도</th>
			<th>종료연도</th>
		</tr>
		<c:forEach items="${resultList}" var="item" varStatus="status">
		<tr>
			<td>${item.id }</td>
			<td><a title="상세조회" onclick="javascript:detailSearch('${item.id}');" href="#">${item.planNm }</td>
			<td>${item.deptNm }</td>
			<td>${item.planFieldMain }</td>
			<td>${item.planFieldSub }</td>
			<td>${item.startYear }</td>
			<td>${item.endYear }</td>
		</tr>
		</c:forEach>
	</table>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="spring" uri="http://www.springframework.org/tags"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
	<table>
		<tr>
			<th>ID</th>
			<td>${resultMap.id }</td>
		</tr>
		<tr>
			<th>계획명</th>
			<td>${resultMap.planNm }</td>
		</tr>
		<tr>
			<th>주관부처</th>
			<td>${resultMap.deptNm }</td>
		</tr>
		<tr>
			<th>대분류</th>
			<td>${resultMap.planFieldMain }</td>
		</tr>
		<tr>
			<th>세분류</th>
			<td>${resultMap.planFieldSub }</td>
		</tr>
		<tr>
			<th>시작연도</th>
			<td>${resultMap.startYear }</td>
		</tr>
		<tr>
			<th>종료연도</th>
			<td>${resultMap.endYear }</td>
		</tr>
		<tr>
			<th>최종확정기구</th>
			<td>${resultMap.lastSetOrgNm }</td>
		</tr>
		<tr>
			<th>미래부확정여부</th>
			<td>${resultMap.msipSetYn }</td>
		</tr>
		<tr>
			<th>자체심의기구명</th>
			<td>${resultMap.slfDlbrtOrgNm }</td>
		</tr>
		<tr>
			<th>법정계획여부</th>
			<td>${resultMap.crtPlanYn }</td>
		</tr>
		<tr>
			<th>시행계획여부</th>
			<td>${resultMap.execPlanYn }</td>
		</tr>
		<tr>
			<th>근거법령</th>
			<td>${resultMap.grdLaw }</td>
		</tr>
	</table>
</body>
</html>

1. 제공기관 : KISTEP

2. 서비스유형 : REST

3. 원본 데이터 조회 주소 : http://www.k2base.re.kr/kistepReport/list.do

4. 연구보고서 목록 조회

연구보고서명으로 검색을 하면 해당하는 연구보고서에 대한 보고서 고유키, 보고서 고유키2, 연도, 보고서명, 연구책임자명, 첨부파일명이 조회된다.
요청주소 : http://www.k2base.re.kr/openapi/kistepReport/list.do
사용 예 ) http://www.k2base.re.kr/openapi/kistepReport/list.do?apiKey=36자리 API키&nttSj=과학기술&pageSize=10&pageIndex=1

요청변수

목록조회

목록조회
항목명	샘플데이터	설명
API키	f54f0aff-f715-403a-ba82-f04ad9a8fea7	API를 사용하기 위한 KEY
nttSj	과학기술	보고서명
pageSize	10	페이지당 출력 개수
pageIndex	1	페이지 번호

출력결과

출력결과
항목명	샘플데이터	설명
nttId	1	보고서 고유키
nttId2	13	보고서 고유키2
stanYy	2011	연도
nttSj	Asian Research Policy 발간을 위한 기획연구	보고서명
officer	오동훈	연구책임자명
atchFileId	FILE_000000000000001	첨부파일Id

5. 연구보고서 상세 조회

사업명, 과제명, 보고서명, 보고서유형, 연구책임자명, 연구시작연도, 종료연도가 조회된다.
요청주소 : http://www.k2base.re.kr/openapi/kistepReport/detail.do
사용 예 ) http://www.k2base.re.kr/openapi/kistepReport/detail.do?apiKey=36자리 API키&nttId=1&nttId2=13

요청변수

요청변수
항목명	샘플데이터	설명
API키	f54f0aff-f715-403a-ba82-f04ad9a8fea7	API를 사용하기 위한 KEY
nttId	1	보고서 고유키
nttId2	13	보고서 고유키2

출력결과

출력결과
항목명	샘플데이터	설명
nttId	1	보고서 고유키
nttId2	13	보고서 고유키2
bzNm	글로벌기획평가네트워크역량강화사업	사업명
pjNm	Asian Research Policy 발간을 위한 기획연구	과제명
nttSj	Asian Research Policy 발간을 위한 기획연구	보고서명
officer	오동훈	연구책임자명
strtYy	2011-01-01	연구시작
endYy	2011-12-31	연구종료
stanYy	2011	연도
reportType	최종보고서	보고서 유형
bzType	기관고유사업	사업구분
reportPart	성과확산	보고서구분
atchFileID	FILE_000000000000001	첨부파일Id

6. 샘플코드

@Controller
public class ApiExplorer {

	@RequestMapping(value="/openapi/kistepReport/sample1.do")
    public String openApiSample() throws Exception {

		return "/openapi/openApiSample1";
    }

	@RequestMapping(value="/openapi/kistepReport/sample2.do")
    public String openApiSample(@RequestParam(value="apiKey", required=true) String apiKey,
    		@RequestParam(value="nttSj", required=false) String nttSj,
			@RequestParam(value="bzType", required=false) String bzType,
			@RequestParam(value="pageSize", defaultValue="10") int pageSize,
			@RequestParam(value="pageIndex", defaultValue="1") int pageIndex, Model model) throws Exception {
        StringBuilder urlBuilder = new StringBuilder("http://k2base.re.kr/openapi/kistepReport/list.do"); /*URL*/
        urlBuilder.append("?apiKey=f54f0aff-f715-403a-ba82-f04ad9a8fea7"); /*apiKey*/
        urlBuilder.append("&" + URLEncoder.encode("nttSj","UTF-8") + "=" + URLEncoder.encode(nttSj, "UTF-8")); /*보고서명*/
        urlBuilder.append("&" + URLEncoder.encode("bzType","UTF-8") + "=" + URLEncoder.encode(bzType, "UTF-8")); /*사업구분*/
        urlBuilder.append("&" + URLEncoder.encode("pageSize","UTF-8") + "=" + pageSize); /*페이지 출력 건수*/
        urlBuilder.append("&" + URLEncoder.encode("pageIndex","UTF-8") + "=" + pageIndex); /*페이지 번호*/
        URL url = new URL(urlBuilder.toString());

        HttpURLConnection conn = (HttpURLConnection) url.openConnection();
        conn.setRequestMethod("GET");
        conn.setRequestProperty("Content-type", "application/json");
        BufferedReader rd;
        if(conn.getResponseCode() >= 200 && conn.getResponseCode() <= 300) {
            rd = new BufferedReader(new InputStreamReader(conn.getInputStream()));
        } else {
            rd = new BufferedReader(new InputStreamReader(conn.getErrorStream()));
        }
        StringBuilder sb = new StringBuilder();
        String line;
        while ((line = rd.readLine()) != null) {
            sb.append(line);
        }
        rd.close();
        conn.disconnect();

        ArrayList<HashMap<String, String>> resultList = new ArrayList<HashMap<String, String>>();

        try{
        	InputSource is = new InputSource(new StringReader(sb.toString()));
        	Document document = DocumentBuilderFactory.newInstance().newDocumentBuilder().parse(is);

        	// xpath 생성
        	XPath  xpath = XPathFactory.newInstance().newXPath();

        	String expression = "//*/ReportItem";

        	NodeList  cols = (NodeList) xpath.compile(expression).evaluate(document, XPathConstants.NODESET);

        	XPathExpression expr = xpath.compile("//*/reportTotalCnt/text()");

        	int totalCnt = Integer.parseInt((String)expr.evaluate(document, XPathConstants.STRING), 10);

        	XPathExpression expr2 = xpath.compile("//*/statusCode/text()");
        	String sCode = (String)expr2.evaluate(document, XPathConstants.STRING); // 100:정상 호출, 200:apiKey 에러
        	if(totalCnt > 0){
        		for( int idx=0; idx<cols.getLength(); idx++ ){
        			HashMap<String, String> resultMap = new HashMap<String, String>();

        			String resultId=cols.item(idx).getAttributes().item(0).getTextContent();
        			resultMap.put("id",resultId);

        			expression = "//*[@id="+resultId+"]/nttId";
    				String resultNttId = xpath.compile(expression).evaluate(document);
    				resultMap.put("nttId",resultNttId);
    				expression = "//*[@id="+resultId+"]/nttId2";
    				String resultNttId2 = xpath.compile(expression).evaluate(document);
    				resultMap.put("nttId2",resultNttId2);
    				expression = "//*[@id="+resultId+"]/stanYy";
    				String resultStanYy = xpath.compile(expression).evaluate(document);
    				resultMap.put("stanYy",resultStanYy);
    				expression = "//*[@id="+resultId+"]/nttSj";
    				String resultNttSj = xpath.compile(expression).evaluate(document);
    				resultMap.put("nttSj",resultNttSj);
    				expression = "//*[@id="+resultId+"]/officer";
    				String resultOfficer = xpath.compile(expression).evaluate(document);
    				resultMap.put("officer",resultOfficer);
    				expression = "//*[@id="+resultId+"]/atchFileId";
    				String resultAtchFileId = xpath.compile(expression).evaluate(document);
    				resultMap.put("atchFileId",resultAtchFileId);
        			resultList.add(resultMap);
        		}
        	}
        }catch(Exception e){
        	System.err.println(e);
        }
        model.addAttribute("resultList", resultList);
		return "/openapi/openApiSample2";
    }

	@RequestMapping(value="/openapi/kistepReport/sample3.do")
    public String openApiDetailSample(@RequestParam(value="apiKey", required=true) String apiKey,
    		@RequestParam(value="nttId", required=true) String nttId,
    		@RequestParam(value="nttId2", required=true) String nttId2,
			Model model) throws Exception {
        StringBuilder urlBuilder = new StringBuilder("http://k2base.re.kr/openapi/kistepReport/detail.do"); /*URL*/
        urlBuilder.append("?apiKey=f54f0aff-f715-403a-ba82-f04ad9a8fea7"); /*apiKey*/
        urlBuilder.append("&" + URLEncoder.encode("nttId","UTF-8") + "=" + nttId); /*고유키*/
        urlBuilder.append("&" + URLEncoder.encode("nttId2","UTF-8") + "=" + nttId2); /*고유키2*/
        URL url = new URL(urlBuilder.toString());
        HttpURLConnection conn = (HttpURLConnection) url.openConnection();
        conn.setRequestMethod("GET");
        conn.setRequestProperty("Content-type", "application/json");
        BufferedReader rd;
        if(conn.getResponseCode() >= 200 && conn.getResponseCode() <= 300) {
            rd = new BufferedReader(new InputStreamReader(conn.getInputStream()));
        } else {
            rd = new BufferedReader(new InputStreamReader(conn.getErrorStream()));
        }
        StringBuilder sb = new StringBuilder();
        String line;
        while ((line = rd.readLine()) != null) {
            sb.append(line);
        }
        rd.close();
        conn.disconnect();

        ArrayList<HashMap<String, String>> resultList = new ArrayList<HashMap<String, String>>();
        try{
        	InputSource is = new InputSource(new StringReader(sb.toString()));
        	Document document = DocumentBuilderFactory.newInstance().newDocumentBuilder().parse(is);

        	// xpath 생성
        	XPath  xpath = XPathFactory.newInstance().newXPath();

        	String expression = "//*/reportDetail";

        	NodeList  cols = (NodeList) xpath.compile(expression).evaluate(document, XPathConstants.NODESET);

        	for( int idx=0; idx<cols.getLength(); idx++ ){

				String resultId=cols.item(idx).getAttributes().item(0).getTextContent();
				resultMap.put("id",resultId);

				expression = "//*[@id="+resultId+"]/bzNm";
				String resultBzNm = xpath.compile(expression).evaluate(document);
				resultMap.put("bzNm",resultBzNm);

				expression = "//*[@id="+resultId+"]/pjNm";
				String resultPjNm = xpath.compile(expression).evaluate(document);
				resultMap.put("pjNm",resultPjNm);

				expression = "//*[@id="+resultId+"]/nttSj";
				String resultNttSj = xpath.compile(expression).evaluate(document);
				resultMap.put("nttSj",resultNttSj);

				expression = "//*[@id="+resultId+"]/officer";
				String resultOfficer = xpath.compile(expression).evaluate(document);
				resultMap.put("officer",resultOfficer);

				expression = "//*[@id="+resultId+"]/strtYy";
				String resultStrtYy = xpath.compile(expression).evaluate(document);
				resultMap.put("strtYy",resultStrtYy);

				expression = "//*[@id="+resultId+"]/endYy";
				String resultEndYy = xpath.compile(expression).evaluate(document);
				resultMap.put("endYy",resultEndYy);

				expression = "//*[@id="+resultId+"]/stanYy";
				String resultStanYy = xpath.compile(expression).evaluate(document);
				resultMap.put("stanYy",resultStanYy);

				expression = "//*[@id="+resultId+"]/reportType";
				String resultReportType = xpath.compile(expression).evaluate(document);
				resultMap.put("reportType",resultReportType);

				expression = "//*[@id="+resultId+"]/bzType";
				String resultBzType = xpath.compile(expression).evaluate(document);
				resultMap.put("bzType",resultBzType);
				
				expression = "//*[@id="+resultId+"]/reportPart";
				String resultReportPart = xpath.compile(expression).evaluate(document);
				resultMap.put("reportPart",resultReportPart);

				expression = "//*[@id="+resultId+"]/atchFileId";
				String resultAtchFileId = xpath.compile(expression).evaluate(document);
				resultMap.put("atchFileId",resultAtchFileId);
 		   }
        }catch(Exception e){
        	System.err.println(e);
        }
        model.addAttribute("resultMap", resultMap);
		return "/openapi/openApiSample3";
    }
}

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
<script>
	function listSearch(){
		var nttSj = document.getElementById("nttSj");
		var nttSjValue = encodeURIComponent(nttSj.value);
		var bzTypeValue = bzType.options[bzType.selectedIndex].value;
		var pageSize = "10";
		var pageIndex = "1";

		location.href="/openapi/kistepReport/sample2.do?nttSj="+nttSjValue+"&bzType="+bzTypeValue+"&pageSize="+pageSize+"&pageIndex="+pageIndex;
	}
</script>
</head>
<body>
	<span>보고서명</span>
	<input type="text" id="nttSj" name="nttSj" value=""/>
	<select id="bzType" name="bzType">
		<option value="">전체</option>
		<option value="기관고유사업">기관고유사업</option>
		<option value="일반사업">일반사업</option>
		<option value="수탁사업">수탁사업</option>
	</select>
	<a title="조회" onclick="javascript:listSearch();" href="#">조회</a>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="spring" uri="http://www.springframework.org/tags"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
<script>
	function detailSearch(id,id2){
		location.href="/openapi/kistepReport/sample3.do?nttId="+id+"&nttId2="+id2;
	}
</script>
</head>
<body>
	<table>
		<tr>
			<th>보고서 고유키</th>
			<th>보고서 고유키2</th>
			<th>연도</th>
			<th>보고서명</th>
			<th>연구책임자명</th>
			<th>첨부파일Id</th>
		</tr>
		<c:forEach items="${resultList}" var="item" varStatus="status">
		<tr>
			<td>${item.nttId }</td>
			<td>${item.nttId2 }</td>
			<td>${item.stanYy }</td>
			<td><a title="상세조회" onclick="javascript:detailSearch('${item.nttId}','${item.nttId2}');" href="#">${item.nttSj }</td>
			<td>${item.officer }</td>
			<td>${item.atchFileId }</td>
		</tr>
		</c:forEach>
	</table>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="spring" uri="http://www.springframework.org/tags"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
	<table>
		<tr>
			<th>보고서 고유키</th>
			<td>${resultMap.nttId }</td>
		</tr>
		<tr>
			<th>보고서 고유키2</th>
			<td>${resultMap.nttId2 }</td>
		</tr>
		<tr>
			<th>사업명</th>
			<td>${resultMap.bzNm }</td>
		</tr>
		<tr>
			<th>과제명</th>
			<td>${resultMap.pjNm }</td>
		</tr>
		<tr>
			<th>보고서명</th>
			<td>${resultMap.nttSj }</td>
		</tr>
		<tr>
			<th>연구책임자명</th>
			<td>${resultMap.officer }</td>
		</tr>
		<tr>
			<th>연구시작연도</th>
			<td>${resultMap.strtYy }</td>
		</tr>
		<tr>
			<th>연구종료연도</th>
			<td>${resultMap.endYy }</td>
		</tr>
		<tr>
			<th>연도</th>
			<td>${resultMap.stanYy }</td>
		</tr>
		<tr>
			<th>보고서 유형</th>
			<td>${resultMap.reportType }</td>
		</tr>
		<tr>
			<th>사업구분</th>
			<td>${resultMap.bzType }</td>
		</tr>
		<tr>
			<th>첨부파일 Id</th>
			<td>${resultMap.atchFileId }</td>
		</tr>
	</table>
</body>
</html>

충청북도 음성군 맹동면 원중로 1339 (우:27740) | 대표전화:043-750-2300