묻고답하기

안녕하세요.

현재 워드프레스를 사용중입니다.

 

XML 파일을 제공받아 재무정보 페이지를 가져오고 싶은데,

https://goo.gl/vsnZho

해당 페이지에서 예제2를 다운로드 해보니 jps 파일입니다.

 

해당파일의 소스가 아래와 같은데, 

혹시 이걸 워드프레스에서 사용할 수 있도록 하려면 어떻게 수정을 하면 될까요?

혹시 아시는분 계실까요.. 사례도 가능합니다 ㅜㅜ

 

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%<a href="//sir.kr/main/member/?mb_id=naver_0px4v5ok" class="mention_user_info" target="_blank">@page</a> import="java.beans.XMLEncoder"%>
<%@ page import="org.w3c.dom.*" %>
<%@ page import="org.xml.sax.*" %>
<%@ page import="java.util.*"%>
<%@ page import="java.io.*"%>
<%@ page import="java.net.*"%>
<%@ page import="javax.xml.parsers.*"%>
<%@ page import="javax.servlet.http.HttpServletResponse.*"%>
<%
    String geturl = "http://asp1.krx.co.kr/servlet/krx.asp.XMLJemu?code=099190";
    String gettime="";
    String DaeCha_ym[]= new String [6];
    String SonIk_ym[]= new String [6];
    String CashFlow_ym[]= new String [6];
    
    String DaeCha_data[][]= new String [10][10];
    String SonIk_data[][]= new String [6][10];
    String CashFlow_data[][]= new String [6][7];
    
    int daeCha_data_length = 0;
    int sonIk_data_length = 0;
    int cashFlow_data_length = 0;
    String line="";
    String xml = "";
    try{
        URL url = new URL(geturl);
        URLConnection conn = url.openConnection();
        HttpURLConnection httpConnection = (HttpURLConnection) conn;
        InputStream is = null;
        InputStreamReader isr = null;
        
        is =  new URL(geturl).openStream();
        isr = new InputStreamReader(is, "UTF-8");
        
        
        
        BufferedReader rd = new BufferedReader(isr,400);
        
        StringBuffer strbuf = new StringBuffer();
        
        
        while ((line = rd.readLine()) != null){
            
              strbuf.append(line);
        }
        
        //System.out.println("재무정보");
        //System.out.println(strbuf.toString());
        
        DocumentBuilderFactory docFact = DocumentBuilderFactory.newInstance();
        docFact.setNamespaceAware(true);
        DocumentBuilder docBuild = docFact.newDocumentBuilder();
        Document doc = docBuild.parse(new InputSource(new StringReader(strbuf.toString())));
        doc.getDocumentElement().normalize();
            
        Element root = doc.getDocumentElement();
        
        
        /*조회시각*/
        NodeList financialTotal = doc.getElementsByTagName("financialTotal");
        
        NamedNodeMap stockinfo = financialTotal.item(0).getAttributes();
        gettime = stockinfo.getNamedItem("querytime").getNodeValue();
        
        /*대차대조표*/
        
        NodeList TBL_DaeCha_ym = doc.getElementsByTagName("TBL_DaeCha");
        NamedNodeMap daeCha_ym = TBL_DaeCha_ym.item(0).getAttributes();
        
        DaeCha_ym[0] = daeCha_ym.getNamedItem("year0").getNodeValue();
        DaeCha_ym[1] = daeCha_ym.getNamedItem("month0").getNodeValue();
        DaeCha_ym[2] = daeCha_ym.getNamedItem("year1").getNodeValue();
        DaeCha_ym[3] = daeCha_ym.getNamedItem("month1").getNodeValue();
        DaeCha_ym[4] = daeCha_ym.getNamedItem("year2").getNodeValue();
        DaeCha_ym[5] = daeCha_ym.getNamedItem("month2").getNodeValue();
        
        NodeList TBL_DaeCha_data = doc.getElementsByTagName("TBL_DaeCha_data");
        daeCha_data_length = TBL_DaeCha_data.getLength();
        
        for(int i=0;i<daeCha_data_length;i++){
            
            NamedNodeMap daeCha_data = TBL_DaeCha_data.item(i).getAttributes();
            
            DaeCha_data[i][0] = daeCha_data.getNamedItem("hangMok"+i).getNodeValue();
            DaeCha_data[i][1] = daeCha_data.getNamedItem("year1Money"+i).getNodeValue();
            DaeCha_data[i][2] = daeCha_data.getNamedItem("year1GuSungRate"+i).getNodeValue();
            DaeCha_data[i][3] = daeCha_data.getNamedItem("year1JungGamRate"+i).getNodeValue();
            DaeCha_data[i][4] = daeCha_data.getNamedItem("year2Money"+i).getNodeValue();
            DaeCha_data[i][5] = daeCha_data.getNamedItem("year2GuSungRate"+i).getNodeValue();
            DaeCha_data[i][6] = daeCha_data.getNamedItem("year2JungGamRate"+i).getNodeValue();
            DaeCha_data[i][7] = daeCha_data.getNamedItem("year3Money"+i).getNodeValue();
            DaeCha_data[i][8] = daeCha_data.getNamedItem("year3GuSungRate"+i).getNodeValue();
            DaeCha_data[i][9] = daeCha_data.getNamedItem("year3JungGamRate"+i).getNodeValue();
            
        }
        
        /*손익계산서*/
        
        NodeList TBL_SonIk_ym = doc.getElementsByTagName("TBL_SonIk");
        NamedNodeMap sonIk_ym = TBL_SonIk_ym.item(0).getAttributes();
        
        SonIk_ym[0] = daeCha_ym.getNamedItem("year0").getNodeValue();
        SonIk_ym[1] = daeCha_ym.getNamedItem("month0").getNodeValue();
        SonIk_ym[2] = daeCha_ym.getNamedItem("year1").getNodeValue();
        SonIk_ym[3] = daeCha_ym.getNamedItem("month1").getNodeValue();
        SonIk_ym[4] = daeCha_ym.getNamedItem("year2").getNodeValue();
        SonIk_ym[5] = daeCha_ym.getNamedItem("month2").getNodeValue();
        
        NodeList TBL_SonIk_data = doc.getElementsByTagName("TBL_SonIk_data");
        
        sonIk_data_length = TBL_SonIk_data.getLength();
        
        for(int i=0;i<sonIk_data_length;i++){
            
            NamedNodeMap sonIk_data = TBL_SonIk_data.item(i).getAttributes();
            
            SonIk_data[i][0] = sonIk_data.getNamedItem("hangMok"+i).getNodeValue();
            SonIk_data[i][1] = sonIk_data.getNamedItem("year1Money"+i).getNodeValue();
            SonIk_data[i][2] = sonIk_data.getNamedItem("year1GuSungRate"+i).getNodeValue();
            SonIk_data[i][3] = sonIk_data.getNamedItem("year1JungGamRate"+i).getNodeValue();
            SonIk_data[i][4] = sonIk_data.getNamedItem("year2Money"+i).getNodeValue();
            SonIk_data[i][5] = sonIk_data.getNamedItem("year2GuSungRate"+i).getNodeValue();
            SonIk_data[i][6] = sonIk_data.getNamedItem("year2JungGamRate"+i).getNodeValue();
            SonIk_data[i][7] = sonIk_data.getNamedItem("year3Money"+i).getNodeValue();
            SonIk_data[i][8] = sonIk_data.getNamedItem("year3GuSungRate"+i).getNodeValue();
            SonIk_data[i][9] = sonIk_data.getNamedItem("year3JungGamRate"+i).getNodeValue();
            
        }
        
        /*현금흐름표*/
        
        NodeList TBL_CashFlow = doc.getElementsByTagName("TBL_CashFlow");
        NamedNodeMap cashFlow_ym = TBL_CashFlow.item(0).getAttributes();
        
        CashFlow_ym[0] = cashFlow_ym.getNamedItem("year0").getNodeValue();
        CashFlow_ym[1] = cashFlow_ym.getNamedItem("month0").getNodeValue();
        CashFlow_ym[2] = cashFlow_ym.getNamedItem("year1").getNodeValue();
        CashFlow_ym[3] = cashFlow_ym.getNamedItem("month1").getNodeValue();
        CashFlow_ym[4] = cashFlow_ym.getNamedItem("year2").getNodeValue();
        CashFlow_ym[5] = cashFlow_ym.getNamedItem("month2").getNodeValue();
        
        NodeList TBL_CashFlow_data = doc.getElementsByTagName("TBL_CashFlow_data");
        
        cashFlow_data_length = TBL_CashFlow_data.getLength();
        
        for(int i=0;i<cashFlow_data_length;i++){
            
            NamedNodeMap cashFlow_data = TBL_CashFlow_data.item(i).getAttributes();
            
            CashFlow_data[i][0] = cashFlow_data.getNamedItem("hangMok"+i).getNodeValue();
            CashFlow_data[i][1] = cashFlow_data.getNamedItem("year1Money"+i).getNodeValue();
            CashFlow_data[i][2] = cashFlow_data.getNamedItem("year1JungGamRate"+i).getNodeValue();
            CashFlow_data[i][3] = cashFlow_data.getNamedItem("year2Money"+i).getNodeValue();
            CashFlow_data[i][4] = cashFlow_data.getNamedItem("year2JungGamRate"+i).getNodeValue();
            CashFlow_data[i][5] = cashFlow_data.getNamedItem("year3Money"+i).getNodeValue();
            CashFlow_data[i][6] = cashFlow_data.getNamedItem("year3JungGamRate"+i).getNodeValue();
            
        }
    
    } catch(Exception e){
        
    }

%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<script  src="http://code.jquery.com/jquery-latest.min.js"></script>
<script type="text/javascript" src="js/common.js"></script>
<link rel="stylesheet" type="text/css" href="css/financialInfo.css"/>
<title>재무정보</title>
</head>
<body>
    <div class="header-wrap">
    재무정보<span><span class="time_img"></span><%=gettime%> 기준</span>
    </div>
    <div class="body-wrap">
        <div class="data-lists">
            <dl>
                <dt><span></span>대차대조표</dt>
                <dd>
                    <table id="balance">
                        <tr>
                            <th rowspan="2">재무항목</th>
                            <%if(!DaeCha_ym[0].equals("")) {%>
                            <th colspan="3"><%=DaeCha_ym[0]%>년 <%=DaeCha_ym[1]%>월</th>
                            <th colspan="3"><%=DaeCha_ym[2]%>년 <%=DaeCha_ym[3]%>월</th>
                            <th colspan="3"><%=DaeCha_ym[4]%>년 <%=DaeCha_ym[5]%>월</th>
                            <%}%>
                        </tr>
                        <tr>
                            <th>금액</th>
                            <th>구성비</th>
                            <th>증감율</th>
                            <th>금액</th>
                            <th>구성비</th>
                            <th>증감율</th>
                            <th>금액</th>
                            <th>구성비</th>
                            <th>증감율</th>
                        </tr>
                        <%if(daeCha_data_length > 0){%>
                            <%for(int i=0;i<daeCha_data_length;i++){ %>
                            <tr>
                                <td><%=DaeCha_data[i][0]%></td>
                                <td><%=DaeCha_data[i][1]%></td>
                                <td><%=DaeCha_data[i][2]%></td>
                                <td><%=DaeCha_data[i][3]%></td>
                                <td><%=DaeCha_data[i][4]%></td>
                                <td><%=DaeCha_data[i][5]%></td>
                                <td><%=DaeCha_data[i][6]%></td>
                                <td><%=DaeCha_data[i][7]%></td>
                                <td><%=DaeCha_data[i][8]%></td>
                                <td><%=DaeCha_data[i][9]%></td>
                            </tr>
                            <%}%>
                        <%}%>
                    </table>
                </dd>
                <dt><span></span>손익계산서</dt>
                <dd>
                    <table id="income_statement">
                        <tr>
                            <th rowspan="2">재무항목</th>
                            <%if(!SonIk_ym[0].equals("")) {%>
                            <th colspan="3"><%=SonIk_ym[0]%>년 <%=SonIk_ym[1]%>월</th>
                            <th colspan="3"><%=SonIk_ym[2]%>년 <%=SonIk_ym[3]%>월</th>
                            <th colspan="3"><%=SonIk_ym[4]%>년 <%=SonIk_ym[5]%>월</th>
                            <%}%>
                        </tr>
                        <tr>
                            <th>금액</th>
                            <th>구성비</th>
                            <th>증감율</th>
                            <th>금액</th>
                            <th>구성비</th>
                            <th>증감율</th>
                            <th>금액</th>
                            <th>구성비</th>
                            <th>증감율</th>
                        </tr>
                        <%if(sonIk_data_length > 0){%>
                            <%for(int i=0;i<sonIk_data_length;i++){ %>
                            <tr>
                                <td><%=SonIk_data[i][0]%></td>
                                <td><%=SonIk_data[i][1]%></td>
                                <td><%=SonIk_data[i][2]%></td>
                                <td><%=SonIk_data[i][3]%></td>
                                <td><%=SonIk_data[i][4]%></td>
                                <td><%=SonIk_data[i][5]%></td>
                                <td><%=SonIk_data[i][6]%></td>
                                <td><%=SonIk_data[i][7]%></td>
                                <td><%=SonIk_data[i][8]%></td>
                                <td><%=SonIk_data[i][9]%></td>
                            </tr>
                            <%}%>
                        <%}%>
                    </table>
                </dd>
                <dt><span></span>현금흐름표</dt>
                <dd>
                    <table id="cash_flow">
                        <tr>
                            <th rowspan="2">재무항목</th>
                            <%if(!CashFlow_ym[0].equals("")) {%>
                            <th colspan="2"><%=CashFlow_ym[0]%>년 <%=CashFlow_ym[1]%>월</th>
                            <th colspan="2"><%=CashFlow_ym[2]%>년 <%=CashFlow_ym[3]%>월</th>
                            <th colspan="2"><%=CashFlow_ym[4]%>년 <%=CashFlow_ym[5]%>월</th>
                            <%}%>
                        </tr>
                        <tr>
                            <th>금액</th>
                            <th>증감액</th>
                            <th>금액</th>
                            <th>증감액</th>
                            <th>금액</th>
                            <th>증감액</th>
                        </tr>
                        <%if(cashFlow_data_length > 0){%>
                            <%for(int i=0;i<cashFlow_data_length;i++){ %>
                            <tr>
                                <td><%=CashFlow_data[i][0]%></td>
                                <td><%=CashFlow_data[i][1]%></td>
                                <td><%=CashFlow_data[i][2]%></td>
                                <td><%=CashFlow_data[i][3]%></td>
                                <td><%=CashFlow_data[i][4]%></td>
                                <td><%=CashFlow_data[i][5]%></td>
                                <td><%=CashFlow_data[i][6]%></td>
                            </tr>
                            <%}%>
                        <%}%>
                    </table>
                </dd>
            </dl>
        </div>
    </div>
    <div class="footer-wrap"></div>
</body>
</html>

 

글쓴이 제목 최종 글
XE 공지 글 쓰기,삭제 운영방식 변경 공지 [16] 2019.03.05 by 남기남
sunny7 게시판 글 보기시 다른 게시판의 내용을 참조할 수 있는 방법이 궁금합니다. [1] file 2019.08.19 by 제이와이엔소프트
railman 게시판 파일 크기 제한에서 파일크기를 늘리고자 합니다. [3] file 2019.08.19 by SimpleCode
럽송 '단독 웹 호스팅' 중 트래픽 관련해서 좀 알려주세요ㅠㅠ [1] file 2019.08.18 by 기진곰
김환국 운영자님 헬로피플 사기꾼 처단해주십시요 [2] 2019.08.17 by 시나브로
sunny7 게시판 소스에 내용과 관련된 갤러리형 게시판을 삽입하는 방법을 알려주세요 [2] 2019.08.16 by sunny7
프리뷰 경로좀 알고싶습니다 부탁드림니다 고수님들 [2] 2019.08.15 by 프리뷰
포뇨 [카페24 무료 개발자 세미나]에 초청합니다! (아이패드 경품추첨)  
AimJin 네이버검색에 검색하면 주소가 다음과 같이 나오네요. [2] 2019.08.14 by AimJin
아랑이 마이그레이션이 데이터 들여오기가 안됩니다. [4] 2019.08.13 by 아랑이
디트리히A 독립된 php 에서 sitemaplite 만 갱신시키기  
처음부터끝까지 xe3 는 워드프레스와 다른 차이가 있나요? [2] 2019.08.13 by 플레이웹
이오육 XE 를 사용해 홈페이지를 만들려고 하는데요. [5] 2019.08.13 by 플레이웹
aucti**** xe로 쇼핑몰을 만들수 잇나요? [2] 2019.08.13 by 플레이웹
railman 웹마스터도구에서 타이틀, 타이틀설명 등 파일명, 위치? [1] 2019.08.12 by 제이와이엔소프트
sillyrose 팝업관련 [3] 2019.08.12 by 제이와이엔소프트
홍찬 Admin Theme 애드온 적용시 레이아웃 설정에서 사진업로드가 안되는 문제  
홍찬 버튼 글자 lang 못불러옴 문제(위젯에 메뉴 설정시) file  
도리 SCM Music Player에 대해 질문해봅니다. [2] 2019.08.10 by 랩퍼투혼
yu**** SEO 모듈만으로 모든페이지 메타태그 다 다르게 어떻게 하는지요..  
orangehome content 위젯에 document_srl 이용해서 글을 뽑아오려면요? [2] 2019.08.07 by orangehome
현님v HTTP 500 내부 서버 오류 또는 404 에러 문제 [7] 2019.08.07 by 현님v
에이치엔컴퍼니 게시판에서 날짜에 마우스 갖다대면 몇시간전 뜨는데 없앨 수 있나요? file  
미박 스킨 문제일까요? XE코어 문제일까요? file  
빈터 [질문]위젯 등 코드에서 “\” 자동 생성되는 오류 [3] 2019.08.06 by 미박
마꼬꼬 IWNV와 라이트세일 써보신 분 계신가요? [1] 2019.08.06 by HowtoXE
정경준 스트리밍 서버 구축관련해서 문의드립니다 ㅠㅠㅠㅠ [5] 2019.08.05 by 토리스
손주사랑 게시판 글쓰기 폰트 사이즈 질문 드림니다 [6] file 2019.08.05 by 손주사랑
피엔 갑자기 초기화되어 급하게 질문드립니다 ㅜ [4] 2019.08.05 by 피엔
프리뷰 모바일사용 편의성 이 오류나요 도와주세요 [4] 2019.08.05 by 프리뷰
xe초보의삶 로그인 폼 수정 방법 (사진포함) [2] file 2019.08.02 by xe초보의삶