<html>
<head>
<xml:namespace prefix="v"/>
<style>v\:* {behavior=url(#default#VML)}</style>
<meta http-equiv="Content-Type" content="text/html; charset=GB2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>带分页的单表示例</title>
</head>
<BODY onload='afterload();'>
<p><b>统计</b><b>图示例</b>&nbsp;&nbsp;&nbsp; <font size="2" color="#000000"><a href="sourcecode/paginationhtml.html">网页代码</a> 
&nbsp;&nbsp; <a href="sourcecode/paginationopenjsp.html">JSP代码</a>(OpenUrl)&nbsp; 
<a href="sourcecode/singletablesavejsp.html">JSP代码</a>（PostUrl)</font></p>
</BODY>
</html>

<SCRIPT language=JavaScript type="text/javascript" SRC="jcl/System.js"></SCRIPT>
<SCRIPT language=JavaScript type="text/javascript" SRC="jcl/Query.js"></SCRIPT>
<SCRIPT language=JavaScript type="text/javascript" SRC="jcl/DBGrid.js"></SCRIPT>
<SCRIPT language=JavaScript type="text/javascript" SRC="jcl/DBPageNavigator.js"></SCRIPT>
<SCRIPT language=JavaScript type="text/javascript" SRC="jcl/Canvas.js"></SCRIPT>
<SCRIPT language=JavaScript type="text/javascript" SRC="jcl/DBChartBar.js"></SCRIPT>
<SCRIPT language=JavaScript type="text/javascript" SRC="jcl/DBChartPie.js"></SCRIPT>
<SCRIPT language=JavaScript type="text/javascript">

function afterload(){
init();
query1.Open();
}

function init(){
new Query('query1');
query1.MaxRows=5; //how many record show in a page
query1.OpenUrl = "pagination.jsp";

new DBGrid('dbgrid1');
dbgrid1.DataSet=query1;
dbgrid1.style.width=500;
dbgrid1.style.height=150;
dbgrid1.style.top=140;
dbgrid1.Body.borderColorLight="#0000FF"
dbgrid1.Body.borderColorDark="#0000FF";

new DBPageNavigator('nv2');
nv2.DataSet=query1;
nv2.style.left=10;
nv2.style.top=90;

new DBChartBar('dbchartbar1');
dbchartbar1.DataSet=query1; 
dbchartbar1.LableField='PRODUCT_NAME';
dbchartbar1.ValueField='PRODUCT_PRICE';
dbchartbar1.style.top=350;
dbchartbar1.style.left=520;
dbchartbar1.style.width=250;
dbchartbar1.style.height=150;

new DBChartPie('dbchartpie1');
dbchartpie1.DataSet=query1; 
dbchartpie1.LableField='PRODUCT_NAME';
dbchartpie1.ValueField='PRODUCT_PRICE';
dbchartpie1.style.top=50;
dbchartpie1.style.left=600;
dbchartpie1.style.width=200;
dbchartpie1.style.height=200;

}
</SCRIPT>