谢谢无语老师的回复，我借用了《jsp数据库系统开发案例精选》企业进销存的年销售额分析的数据及其数据查询方式，datas数组里12个月的数据是有的，每个月也是一一对应的。程序如下。设12个月，在“histogram_Default.setCategory(category);”处出错，设3个月在“histogram_Default.setData(datas);”处出错。我现在搞不清这2个错误的原因及其解决方法，敬请老师指教，谢谢！！！
<%@ page contentType="text/html;charset=gb2312" language="java"%>
<%@ page import="java.io.*,java.sql.*"%>
<%@ page import="java.util.*" pageEncoding="GB2312"%>
<jsp:useBean id="histogram_Default" class="com.mwq.chart.Histogram_Default" scope="session"/>
<jsp:useBean id="rst" scope="page" class="com.mingri.dbconn.DBResult"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%
String year=request.getParameter("year");
//获得某年按月份分组的总销售额的SQL语句
String strSql="select sum(je) as sumje,month(xsdate) as xsmonth from tb_sell"+
" where year(xsdate)='"+year+"' group by month(xsdate)";
ResultSet rs=rst.getResult(strSql);
int counts=0;
double max1=0;double min1=0;double mon1=0;
if(!rs.next()){
out.println("<script language='javascript'>alert('"+year+"年没有销售记录');"+
"window.location.href='main.jsp';</script>");
}
else{//获得某年按销售月份分组的总记录数
String strCount="select count(*) as a1,max(sumje) as a2,min(sumje) as a3 from ( "+strSql+" ) as aa";
ResultSet rs1=rst.getResult(strCount);
if(rs1.next())
counts=rs1.getInt(1);
max1=rs1.getInt("a2");
min1=rs1.getInt("a3");
mon1=(max1+min1)/2;
rs1.close();
}
%>
<html>
<title>年销售额分析</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../CSS/style.css" rel="stylesheet" type="text/css">
<body bgcolor="#F2F2F2">
<table width="77%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" bordercolorlight="#9CA6C6" bordercolordark="#CCE3FF">
<tr align="center" bgcolor="#FFFFC1">
<%
if (counts>0){
int chartWidth = 500; //图片宽度
int chartHeight = 300; //图片高度
String chartTitle = "商品销售金额走势分析柱形图"; //图表标题
//String Cutline[] = {"高线", "中线", "低线", "销售金额"}; //图例标题
String Cutline[] = {"销售金额", "低线", "中线", "高线"}; //图例标题
String category[] = {"1月", "2月", "3月", "4月", "5月", "6月", "7月", "8月", "9月", "10月", "11月", "12月"}; //类别
String xTitle = "统计月份"; //x轴标题
String yTitle = "销售金额（单位：元）"; //y轴标题
double[][] datas = new double[Cutline.length][category.length];
int n=0;int m=n;
try{
for(n=m;n<category.length;n++){
datas[3][n]=max1;
datas[1][n]=min1;
datas[2][n]=mon1;
if(rs.getInt("xsmonth")==n+1){
datas[0][n]=rs.getInt("sumje");
m=n+1;
break;}
}
while(rs.next()){
for(n=m;n<category.length;n++){
datas[3][n]=max1;
datas[1][n]=min1;
datas[2][n]=mon1;
if(rs.getInt("xsmonth")==n+1){
datas[0][n]=rs.getInt("sumje");
m=n+1;
break;}
}
}
}catch(Exception e){
}
histogram_Default.setChartTitle(chartTitle);
histogram_Default.setSubtitle("统计种类：销售金额走势");
histogram_Default.setXTitle(xTitle);
histogram_Default.setYTitle(yTitle);
histogram_Default.setCutline(Cutline);
histogram_Default.setCategory(category);
histogram_Default.setData(datas);
histogram_Default.setContextPath(request.getContextPath());
histogram_Default.setMapName("chartInfo");
histogram_Default.setOut(out);
histogram_Default.setSession(session);
String graphURL=histogram_Default.draw();
%>
<tr align="center">
<td><img src="<%=graphURL %>" usemap="#chartInfo" border="1" alt="" ></td>
</tr>
</table>
<% } %>
<div align="center">
</div>
</body>
</html>
VIP会员
购物车
私信
发表新帖
立即签到
分享到：
关注
回复
支持(
反对(
