묻고답하기

안녕하세요.

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

 

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 남기남
벼리 기간별로 작성글 수 작성댓글을 구하려면 어떻게 해야할까요? [1] 2019.01.21 by LuisK
dd**** 글삭제 권한에 대하여 문의드려요. [1] 2019.01.21 by LuisK
리천 관리자 댓글 출력 수정 위치좀 알려주세요 [2] 2019.01.21 by 리천
오감 게시글 추천/비추천/신고가 안됩니다... [7] 2019.01.21 by 오감
코딩펀 게시판에서 <ul> <li> 태그가 안 먹히는 이유? [3] 2019.01.21 by 코딩펀
이건희 사이트맵 백지 현상 일어나네요 file  
디트리히A <load target="..."/> 관련 파일 경로가 어떻게 될까요?  
forgood 게시판 글에 아이디별 접근 권한 부여하기? [2] 2019.01.19 by sejin7940
allpcpc 게시판 사용자 정의를 너무 길게 넣었더니말이죠.. [1] 2019.01.19 by allpcpc
바키라 모바일에서 서 레이아웃 비정상 문의드려요  
알렉스서 메인, 즉 인텍스는 어디에 있나요? [2] 2019.01.18 by LuisK
anajo7 로그인과 관리자 페이지 오류(도와 주세요) [1] file 2019.01.18 by LuisK
xowl**** 설치된레이아웃 >기본레이아웃>메인레이아웃>설정후 이미지등록이안되요 ㅠ [1] 2019.01.17 by LuisK
풀발잡기 로그인 오류 [1] 2019.01.17 by 디자인클립
Bera 어느 순간부터 유튜브 링크를 걸었을 때 동영상이 자동으로 안뜨네요ㅠ [6] 2019.01.16 by Happiness
도토리묵 포인트 부족시 알림창 띄우기  
콜롬보 다른 회원정보 보기 권한 [4] 2019.01.16 by 콜롬보
오감 게시글에 댓글이 달릴시 이메일로 알람이 오게 하는 방법이 있을까요? [2] 2019.01.16 by 오감
댑펑 게시물 대량 이동을 DB 명령어로 가능한가요? [1] 2019.01.15 by sejin7940
별빛 특정그룹이나 회원에게 회원정보수정권한 주게 할 수 있나요? [3] 2019.01.15 by sejin7940
Happiness xe 1.11.2 로 업글후 로그인 안됩니다.  
밀가루 http 500 error 문제 [6] 2019.01.15 by 밀가루
totus**** 레이아웃 메뉴 수정하는 법? [4] file 2019.01.15 by totus****
davinchi121 xe 로컬로 설정하는 법 좀 알려주세요 [1] 2019.01.15 by LuisK
홈런볼11 게시글 내 특수문자 [1] 2019.01.15 by LuisK
대한국인 XE에서 SSL 설정하는 방법? [7] file 2019.01.13 by 세걸
마하수리 홈페이지가 느려졌을때...  
쾌걸이 고수님들~ 관리자 접속시 에러. 살려주세요 ㅜㅜ  
mgl**** 게시판에 문제 [2] 2019.01.13 by rail_man
홈런볼11 특정 계정 포워딩 [1] 2019.01.12 by 디자인클립