카테고리
공부한것들을 정리하는 블로그 입니다.
jqgrid XML 데이터 불러오기 본문
반응형
XML 데이터 불러오기
실행화면
Project Explorer
index.jsp
<%@ 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> </head> <link href="resources/jquery-ui/jquery-ui.css" rel="stylesheet" type="text/css" /> <link href="resources/jqGrid/css/ui.jqgrid.css" rel="stylesheet" type="text/css" /> <script src="resources/jqGrid/js/jquery-1.11.0.min.js"></script> <script src="resources/jquery-ui/jquery-ui.js"></script> <script src="resources/jqGrid/js/i18n/grid.locale-kr.js"></script> <script src="resources/jqGrid/js/jquery.jqGrid.min.js"></script> <body> <table id="list1"></table> <div id="pager1"></div> <script type="text/javascript"> jQuery().ready(function (){ jQuery("#list1").jqGrid({ url:'hodu.xml', datatype: "xml", colNames:['Inv No','Date', 'Client', 'Amount','Tax','Total','Notes'], colModel:[ {name:'id',index:'id', width:75}, {name:'invdate',index:'invdate', width:90}, {name:'name',index:'name', width:100}, {name:'amount',index:'amount', width:80, align:"right"}, {name:'tax',index:'tax', width:80, align:"right"}, {name:'total',index:'total', width:80,align:"right"}, {name:'note',index:'note', width:150, sortable:false} ], rowNum:10, autowidth: true, rowList:[10,20,30], pager: jQuery('#pager1'), sortname: 'id', viewrecords: true, sortorder: "desc", caption:"XML Example" }).navGrid('#pager1',{edit:false,add:false,del:false}); }); </script> </body> </html>
hodu.xml
<?xml version="1.0" encoding="utf-8"?> <rows> <row id='1'> <cell>13</cell> <cell>2007-10-06</cell> <cell><![CDATA[Client 3]]></cell> <cell>1000.00</cell> <cell>0.00</cell> <cell>1000.00</cell> <cell><![CDATA[]]></cell> </row> <row id='2'> <cell>12</cell> <cell>2007-10-06</cell> <cell><![CDATA[Client 2]]></cell> <cell>700.00</cell> <cell>140.00</cell> <cell>840.00</cell> <cell><![CDATA[]]></cell> </row> <row id='3'> <cell>11</cell> <cell>2007-10-06</cell> <cell><![CDATA[Client 1]]></cell> <cell>600.00</cell> <cell>120.00</cell> <cell>720.00</cell> <cell><![CDATA[]]></cell> </row> <row id='4'> <cell>10</cell> <cell>2007-10-06</cell> <cell><![CDATA[Client 2]]></cell> <cell>100.00</cell> <cell>20.00</cell> <cell>120.00</cell> <cell><![CDATA[]]></cell> </row> <row id='5'> <cell>9</cell> <cell>2007-10-06</cell> <cell><![CDATA[Client 1]]></cell> <cell>200.00</cell> <cell>40.00</cell> <cell>240.00</cell> <cell><![CDATA[]]></cell> </row> <row id='6'> <cell>8</cell> <cell>2007-10-06</cell> <cell><![CDATA[Client 3]]></cell> <cell>200.00</cell> <cell>0.00</cell> <cell>200.00</cell> <cell><![CDATA[]]></cell> </row> <row id='7'> <cell>7</cell> <cell>2007-10-05</cell> <cell><![CDATA[Client 2]]></cell> <cell>120.00</cell> <cell>12.00</cell> <cell>134.00</cell> <cell><![CDATA[]]></cell> </row> <row id='8'> <cell>6</cell> <cell>2007-10-05</cell> <cell><![CDATA[Client 1]]></cell> <cell>50.00</cell> <cell>10.00</cell> <cell>60.00</cell> <cell><![CDATA[]]></cell> </row> <row id='9'> <cell>5</cell> <cell>2007-10-05</cell> <cell><![CDATA[Client 3]]></cell> <cell>100.00</cell> <cell>0.00</cell> <cell>100.00</cell> <cell><![CDATA[no tax at all]]></cell> </row> <row id='10'> <cell>4</cell> <cell>2007-10-04</cell> <cell><![CDATA[Client 3]]></cell> <cell>150.00</cell> <cell>0.00</cell> <cell>150.00</cell> <cell><![CDATA[no tax]]></cell> </row> <row id='11'> <cell>13</cell> <cell>2007-10-06</cell> <cell><![CDATA[Client 3]]></cell> <cell>1000.00</cell> <cell>0.00</cell> <cell>1000.00</cell> <cell><![CDATA[]]></cell> </row> <row id='12'> <cell>12</cell> <cell>2007-10-06</cell> <cell><![CDATA[Client 2]]></cell> <cell>700.00</cell> <cell>140.00</cell> <cell>840.00</cell> <cell><![CDATA[]]></cell> </row> <row id='13'> <cell>11</cell> <cell>2007-10-06</cell> <cell><![CDATA[Client 1]]></cell> <cell>600.00</cell> <cell>120.00</cell> <cell>720.00</cell> <cell><![CDATA[]]></cell> </row> <row id='14'> <cell>10</cell> <cell>2007-10-06</cell> <cell><![CDATA[Client 2]]></cell> <cell>100.00</cell> <cell>20.00</cell> <cell>120.00</cell> <cell><![CDATA[]]></cell> </row> <row id='15'> <cell>9</cell> <cell>2007-10-06</cell> <cell><![CDATA[Client 1]]></cell> <cell>200.00</cell> <cell>40.00</cell> <cell>240.00</cell> <cell><![CDATA[]]></cell> </row> <row id='16'> <cell>8</cell> <cell>2007-10-06</cell> <cell><![CDATA[Client 3]]></cell> <cell>200.00</cell> <cell>0.00</cell> <cell>200.00</cell> <cell><![CDATA[]]></cell> </row> <row id='17'> <cell>7</cell> <cell>2007-10-05</cell> <cell><![CDATA[Client 2]]></cell> <cell>120.00</cell> <cell>12.00</cell> <cell>134.00</cell> <cell><![CDATA[]]></cell> </row> <row id='18'> <cell>6</cell> <cell>2007-10-05</cell> <cell><![CDATA[Client 1]]></cell> <cell>50.00</cell> <cell>10.00</cell> <cell>60.00</cell> <cell><![CDATA[]]></cell> </row> <row id='19'> <cell>5</cell> <cell>2007-10-05</cell> <cell><![CDATA[Client 3]]></cell> <cell>100.00</cell> <cell>0.00</cell> <cell>100.00</cell> <cell><![CDATA[no tax at all]]></cell> </row> <row id='20'> <cell>4</cell> <cell>2007-10-04</cell> <cell><![CDATA[Client 3]]></cell> <cell>150.00</cell> <cell>0.00</cell> <cell>150.00</cell> <cell><![CDATA[no tax]]></cell> </row> <row id='21'> <cell>13</cell> <cell>2007-10-06</cell> <cell><![CDATA[Client 3]]></cell> <cell>1000.00</cell> <cell>0.00</cell> <cell>1000.00</cell> <cell><![CDATA[]]></cell> </row> <row id='22'> <cell>12</cell> <cell>2007-10-06</cell> <cell><![CDATA[Client 2]]></cell> <cell>700.00</cell> <cell>140.00</cell> <cell>840.00</cell> <cell><![CDATA[]]></cell> </row> <row id='23'> <cell>11</cell> <cell>2007-10-06</cell> <cell><![CDATA[Client 1]]></cell> <cell>600.00</cell> <cell>120.00</cell> <cell>720.00</cell> <cell><![CDATA[]]></cell> </row> <row id='24'> <cell>10</cell> <cell>2007-10-06</cell> <cell><![CDATA[Client 2]]></cell> <cell>100.00</cell> <cell>20.00</cell> <cell>120.00</cell> <cell><![CDATA[]]></cell> </row> <row id='25'> <cell>9</cell> <cell>2007-10-06</cell> <cell><![CDATA[Client 1]]></cell> <cell>200.00</cell> <cell>40.00</cell> <cell>240.00</cell> <cell><![CDATA[]]></cell> </row> <row id='26'> <cell>8</cell> <cell>2007-10-06</cell> <cell><![CDATA[Client 3]]></cell> <cell>200.00</cell> <cell>0.00</cell> <cell>200.00</cell> <cell><![CDATA[]]></cell> </row> <row id='27'> <cell>7</cell> <cell>2007-10-05</cell> <cell><![CDATA[Client 2]]></cell> <cell>120.00</cell> <cell>12.00</cell> <cell>134.00</cell> <cell><![CDATA[]]></cell> </row> <row id='28'> <cell>6</cell> <cell>2007-10-05</cell> <cell><![CDATA[Client 1]]></cell> <cell>50.00</cell> <cell>10.00</cell> <cell>60.00</cell> <cell><![CDATA[]]></cell> </row> <row id='29'> <cell>5</cell> <cell>2007-10-05</cell> <cell><![CDATA[Client 3]]></cell> <cell>100.00</cell> <cell>0.00</cell> <cell>100.00</cell> <cell><![CDATA[no tax at all]]></cell> </row> <row id='30'> <cell>4</cell> <cell>2007-10-04</cell> <cell><![CDATA[Client 3]]></cell> <cell>150.00</cell> <cell>0.00</cell> <cell>150.00</cell> <cell><![CDATA[no tax]]></cell> </row> <row id='31'> <cell>13</cell> <cell>2007-10-06</cell> <cell><![CDATA[Client 3]]></cell> <cell>1000.00</cell> <cell>0.00</cell> <cell>1000.00</cell> <cell><![CDATA[]]></cell> </row> <row id='32'> <cell>12</cell> <cell>2007-10-06</cell> <cell><![CDATA[Client 2]]></cell> <cell>700.00</cell> <cell>140.00</cell> <cell>840.00</cell> <cell><![CDATA[]]></cell> </row> <row id='33'> <cell>11</cell> <cell>2007-10-06</cell> <cell><![CDATA[Client 1]]></cell> <cell>600.00</cell> <cell>120.00</cell> <cell>720.00</cell> <cell><![CDATA[]]></cell> </row> <row id='34'> <cell>10</cell> <cell>2007-10-06</cell> <cell><![CDATA[Client 2]]></cell> <cell>100.00</cell> <cell>20.00</cell> <cell>120.00</cell> <cell><![CDATA[]]></cell> </row> <row id='35'> <cell>9</cell> <cell>2007-10-06</cell> <cell><![CDATA[Client 1]]></cell> <cell>200.00</cell> <cell>40.00</cell> <cell>240.00</cell> <cell><![CDATA[]]></cell> </row> <row id='36'> <cell>8</cell> <cell>2007-10-06</cell> <cell><![CDATA[Client 3]]></cell> <cell>200.00</cell> <cell>0.00</cell> <cell>200.00</cell> <cell><![CDATA[]]></cell> </row> <row id='37'> <cell>7</cell> <cell>2007-10-05</cell> <cell><![CDATA[Client 2]]></cell> <cell>120.00</cell> <cell>12.00</cell> <cell>134.00</cell> <cell><![CDATA[]]></cell> </row> <row id='38'> <cell>6</cell> <cell>2007-10-05</cell> <cell><![CDATA[Client 1]]></cell> <cell>50.00</cell> <cell>10.00</cell> <cell>60.00</cell> <cell><![CDATA[]]></cell> </row> <row id='39'> <cell>5</cell> <cell>2007-10-05</cell> <cell><![CDATA[Client 3]]></cell> <cell>100.00</cell> <cell>0.00</cell> <cell>100.00</cell> <cell><![CDATA[no tax at all]]></cell> </row> </rows>
반응형
'JQ그리드 공부' 카테고리의 다른 글
jqgrid Array 데이터 불러오기 + Multi Select 다중선택 (선택된 행의 ID 보기 + 특정 행 선택하기/선택풀기) (0) | 2017.08.02 |
---|---|
jqgrid workspace (0) | 2017.06.27 |
jqgrid 사용하기 + Daum 오픈 API 검색기능 적용 (0) | 2017.06.23 |
'JQ그리드 공부' Related Articles
- jqgrid Array 데이터 불러오기 + Multi Select 다중선택 (선택된 행의 ID 보기 + 특정 행 선택하기/선택풀기) 2017.08.02
- jqgrid workspace 2017.06.27
- jqgrid 사용하기 + Daum 오픈 API 검색기능 적용 2017.06.23
Comments