FusionCharts 在java中的实现(3)

最新推荐文章于 2024-11-12 21:14:07 发布

iteye_7017

最新推荐文章于 2024-11-12 21:14:07 发布

阅读量100

点赞数

分类专栏： FusionCharts 文章标签： java javascript 数据库 ViewUI

本文链接：https://blog.csdn.net/iteye_7017/article/details/82613192

版权

FusionCharts 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

工程的目录结构以及所需的文件如下：

成功发布成功后的效果图如下：(拼接的XML中value必须有值，否则flash可能无法正常显示)

1.getProductionReportChart.jsp

<%@ page language="java" pageEncoding="gbk"%>
<%@ page import="bussiness.report.*"%>
<%@ include file="/FusionCharts.jsp"%>
<html>
<head></head>
<%
Report report = new Report();

out.println(report.getReportYTDNote());
out.println("</br>");

String msColum2dXml2 = report.getYtdApeMsLine2DXml2();
String msColum2dHtmlCode2 = createChartHTML("../fusionCharts/MSLine.swf", "", msColum2dXml2
                        , "myFirst7", 1000, 600, false) ;
out.println(msColum2dHtmlCode2);

out.println("</br></br>");

%>

2.数据源来源于Oracle数据库，因此需要编写Report.Java代码：

package bussiness.report;

import business.db.ConnectionPool;

import java.io.PrintStream;
import java.math.BigDecimal;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.text.DecimalFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Iterator;
import java.util.List;

public class Report {
	/**
	 * 保留
	 * @return
	 */
	public String getReportYTDNote() {
		Calendar now = Calendar.getInstance();

		now.add(5, -1);

		int year = now.get(1);
		int month = now.get(2) + 1;
		int date = now.get(5);

		String dateStr = year + "-" + month + "-" + date;

		StringBuilder sbXml = new StringBuilder();

		sbXml.append("<div style='background: #FFFFE6; margin-left: 0px; width: 640px; border: #FAD185 solid 1px;'>");
		sbXml.append("<p style='Padding: 5px 0px 5px 20px;'>");

		sbXml.append("<table class=tablestyle cellSpacing=0 cellPadding=0 width=560>");
		sbXml.append("<TBODY>");

		sbXml.append("<tr><td align='left'><span class='style9'>YTD:</span><span class='style11'>");
		sbXml.append(dateStr);
		sbXml.append("</span></td></tr></TBODY></table></p></div>");

		return sbXml.toString();
	}


    /**
     * 保留
     * @return
     */
	public static String getYtdApeMsLine2DXml2() {
		List categoryLst = new ArrayList();
		List budgetLst = new ArrayList();
		List netDeliverLst = new ArrayList();

		Connection conn = null;
		Statement st = null;
		ResultSet rs = null;
		try {
			conn = ConnectionPool.getConnection();
			st = conn.createStatement();

			for (rs = st
					.executeQuery("SELECT SUBSTR(LOAD_DT,1,6),SUM(Y_NET_DELIVER_APE)/1000 as NET_DELIVER_CASH,SUM(Y_BUDGET_APE)/1000 as BUDGET_CASH FROM tu_ods_report_collect_daily WHERE LOAD_DT IN (SELECT MAX(LOAD_DT) FROM TU_ODS_REPORT_COLLECT_DAILY WHERE LOAD_DT <TO_CHAR(TRUNC(SYSDATE,'MM'),'YYYYMMDD') GROUP BY SUBSTR(LOAD_DT,1,6)) GROUP BY SUBSTR(LOAD_DT,1,6)"); rs
					.next();) {
				categoryLst.add(rs.getString(1));
				budgetLst.add(format3(rs.getDouble(3)));
				netDeliverLst.add(format3(rs.getDouble(2)));
			}
		} catch (SQLException sqle) {
			sqle.printStackTrace();
		} finally {
            ConnectionPool.releaseStatement(st);
			ConnectionPool.releaseConnection(conn);
		}

		StringBuilder xmlSb = new StringBuilder();
		xmlSb.append("<chart baseFontSize='14' caption='YTD Budget APE And Net Delivery APE Month' subCaption='(RMB ,000)'");
		xmlSb.append("lineThickness='1' showValues='0' formatNumberScale='0' ");
		xmlSb.append("anchorRadius='2' divLineAlpha='20' divLineColor='CC3300' ");
		xmlSb.append("divLineIsDashed='1' showAlternateHGridColor='1' alternateHGridAlpha='5' ");
		xmlSb.append("alternateHGridColor='CC3300' shadowAlpha='40' labelStep='1' numvdivlines='5' ");
		xmlSb.append("chartRightMargin='35' bgColor='FFFFFF,CC3300' ");
		xmlSb.append("bgAngle='270' bgAlpha='10,10'>");

		if (categoryLst.size() > 0) {
			xmlSb.append("<categories>");
		}
		for (Iterator iterator = categoryLst.iterator(); iterator.hasNext();) {
			String category = (String) iterator.next();

			xmlSb.append("<category label='");
			xmlSb.append(category);
			xmlSb.append("' />");
		}
		if (categoryLst.size() > 0) {
			xmlSb.append("</categories>");
		}

		if (budgetLst.size() > 0) {
			xmlSb.append("<dataset seriesName='BUDGET APE' anchorBorderColor='1D8BD1' anchorBgColor='1D8BD1'>");
		}
		for (Iterator iterator = budgetLst.iterator(); iterator.hasNext();) {
			String budget = (String) iterator.next();

			xmlSb.append("<set value='");
			xmlSb.append(budget);
			xmlSb.append("' />");
		}
		if (budgetLst.size() > 0) {
			xmlSb.append("</dataset>");
		}

		if (netDeliverLst.size() > 0) {
			xmlSb.append("<dataset seriesName='NET DELIVERY APE' anchorBorderColor='F1683C' anchorBgColor='F1683C'>");
		}
		for (Iterator iterator = netDeliverLst.iterator(); iterator.hasNext();) {
			String actual = (String) iterator.next();

			xmlSb.append("<set value='");
			xmlSb.append(actual);
			xmlSb.append("' />");
		}
		if (budgetLst.size() > 0) {
			xmlSb.append("</dataset>");
		}

		xmlSb.append("</chart>");

		return xmlSb.toString();
	}

	private static String format3(double value) {
		DecimalFormat decimalFormat = new DecimalFormat("#");
		return decimalFormat.format(value);
	}

}

3.ConnectionPool.java只是一个数据库连接类，没别特别之处，因此在这就不写了。

4.FusionCharts.jsp文件如下：

<%!//Page: FusionCharts.jsp
	//Author: InfoSoft Global (P) Ltd.
	//This page contains functions that can be used to create FusionCharts.
	/**
	 * Encodes the dataURL before it's served to FusionCharts.
	 * If you have parameters in your dataURL, you necessarily need to encode it.
	 * @param strDataURL - dataURL to be fed to chart
	 * @param addNoCacheStr - Whether to add aditional string to URL to disable caching of data
	 * @return
	 */
	public String encodeDataURL(String strDataURL, String addNoCacheStr,
			HttpServletResponse response) {
		String encodedURL = strDataURL;
		//Add the no-cache string if required
		if (addNoCacheStr.equals("true")) {
			/*We add ?FCCurrTime=xxyyzz
			If the dataURL already contains a ?, we add &FCCurrTime=xxyyzz
			We send the date separated with '_', instead of the usual ':' as FusionCharts cannot handle : in URLs
			 */
			java.util.Calendar nowCal = java.util.Calendar.getInstance();
			java.util.Date now = nowCal.getTime();
			java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat(
					"MM/dd/yyyy HH_mm_ss a");
			String strNow = sdf.format(now);
			if (strDataURL.indexOf("?") > 0) {
				encodedURL = strDataURL + "&FCCurrTime=" + strNow;
			} else {
				strDataURL = strDataURL + "?FCCurrTime=" + strNow;
			}
			encodedURL = response.encodeURL(strDataURL);

		}
		return encodedURL;
	}

	/**
	 * Creates the Chart HTML+Javascript to create the FusionCharts object with the given parameters.
	 * This method uses JavaScript to overcome the IE browser problem with SWF wherein you have to 'Click to activate' the control
	 * @param chartSWF - SWF File Name (and Path) of the chart which you intend to plot
	 * @param strURL - If you intend to use dataURL method for this chart, pass the URL as this parameter. Else, set it to "" (in case of dataXML method)
	 * @param strXML - If you intend to use dataXML method for this chart, pass the XML data as this parameter. Else, set it to "" (in case of dataURL method)
	 * @param chartId - Id for the chart, using which it will be recognized in the HTML page. Each chart on the page needs to have a unique Id.
	 * @param chartWidth - Intended width for the chart (in pixels)
	 * @param chartHeight - Intended height for the chart (in pixels)
	 * @param debugMode - Whether to start the chart in debug mode
	 * @param registerWithJS - Whether to ask chart to register itself with JavaScript
	 */
	public String createChart(String chartSWF, String strURL, String strXML,
			String chartId, int chartWidth, int chartHeight, boolean debugMode,
			boolean registerWithJS) {
		StringBuffer strBuf = new StringBuffer();
		/*
		First we create a new DIV for each chart. We specify the name of DIV as "chartId"Div.
		DIV names are case-sensitive.
		 */
		strBuf.append("<!--START Script Block for Chart -->\n");
		strBuf.append("\t\t<div id='" + chartId + "Div' align='center'>\n");
		strBuf.append("\t\t\t\tChart.\n");

		/*The above text "Chart" is shown to users before the chart has started loading
		 (if there is a lag in relaying SWF from server). This text is also shown to users
		 who do not have Flash Player installed. You can configure it as per your needs.*/

		strBuf.append("\t\t</div>\n");

		/*Now, we render the chart using FusionCharts Class. Each chart's instance (JavaScript) Id
		 is named as chart_"chartId".*/

		strBuf.append("\t\t<script type='text/javascript'>\n");
		//Instantiate the Chart
		Boolean registerWithJSBool = new Boolean(registerWithJS);
		Boolean debugModeBool = new Boolean(debugMode);
		int regWithJSInt = boolToNum(registerWithJSBool);
		int debugModeInt = boolToNum(debugModeBool);

		strBuf.append("\t\t\t\tvar chart_" + chartId + " = new FusionCharts('"
				+ chartSWF + "', '" + chartId + "', '" + chartWidth + "', '"
				+ chartHeight + "', '" + debugModeInt + "', '" + regWithJSInt
				+ "');\n");
		//Check whether we've to provide data using dataXML method or dataURL method
		if (strXML.equals("")) {
			strBuf.append("\t\t\t\t//Set the dataURL of the chart\n");
			strBuf.append("\t\t\t\tchart_" + chartId + ".setDataURL(\""
					+ strURL + "\");\n");
		} else {
			strBuf.append("\t\t\t\t//Provide entire XML data using dataXML method\n");
			strBuf.append("\t\t\t\tchart_" + chartId + ".setDataXML(\""
					+ strXML + "\");\n");
		}
		strBuf.append("\t\t\t\t//Finally, render the chart.\n");
		strBuf.append("\t\t\t\tchart_" + chartId + ".render(\"" + chartId
				+ "Div\");\n");
		strBuf.append("\t\t</script>\n");
		strBuf.append("\t\t<!--END Script Block for Chart-->\n");
		return strBuf.substring(0);
	}

	/**
	 * Creates the Chart HTML to embed the swf object with the given parameters
	 * @param chartSWF - SWF File Name (and Path) of the chart which you intend to plot
	 * @param strURL - If you intend to use dataURL method for this chart, pass the URL as this parameter. Else, set it to "" (in case of dataXML method)
	 * @param strXML - If you intend to use dataXML method for this chart, pass the XML data as this parameter. Else, set it to "" (in case of dataURL method)
	 * @param chartId - Id for the chart, using which it will be recognized in the HTML page. Each chart on the page needs to have a unique Id.
	 * @param chartWidth - Intended width for the chart (in pixels)
	 * @param chartHeight - Intended height for the chart (in pixels)
	 * @param debugMode - Whether to start the chart in debug mode
	 */
	public String createChartHTML(String chartSWF, String strURL,
			String strXML, String chartId, int chartWidth, int chartHeight,
			boolean debugMode) {
		/*Generate the FlashVars string based on whether dataURL has been provided
		    or dataXML.*/
		String strFlashVars = "";
		Boolean debugModeBool = new Boolean(debugMode);

		if (strXML.equals("")) {
			//DataURL Mode
			strFlashVars = "chartWidth=" + chartWidth + "&chartHeight="
					+ chartHeight + "&debugMode=" + boolToNum(debugModeBool)
					+ "&dataURL=" + strURL + "";
		} else {
			//DataXML Mode
			strFlashVars = "chartWidth=" + chartWidth + "&chartHeight="
					+ chartHeight + "&debugMode=" + boolToNum(debugModeBool)
					+ "&dataXML=" + strXML + "";
		}
		StringBuffer strBuf = new StringBuffer();

		// START Code Block for Chart  
		strBuf.append("\t\t<!--START Code Block for Chart-->\n");
		strBuf.append("\t\t\t\t<object classid='clsid:d27cdb6e-ae6d-11cf-96b8-444553540000' codebase='http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=8,0,0,0' width='"
				+ chartWidth
				+ "' height='"
				+ chartHeight
				+ "' id='"
				+ chartId
				+ "'>\n");
		strBuf.append("\t\t\t\t <param name='allowScriptAccess' value='always' />\n");
		strBuf.append("\t\t\t\t <param name='movie' value='" + chartSWF
				+ "'/>\n");
		strBuf.append("\t\t\t\t<param name='FlashVars' value=\"" + strFlashVars
				+ "\" />\n");
		strBuf.append("\t\t\t\t <param name='quality' value='high' />\n");
		strBuf.append("\t\t\t\t<embed src='"
				+ chartSWF
				+ "' FlashVars=\""
				+ strFlashVars
				+ "\" quality='high' width='"
				+ chartWidth
				+ "' height='"
				+ chartHeight
				+ "' name='"
				+ chartId
				+ "' allowScriptAccess='always' type='application/x-shockwave-flash' pluginspage='http://www.macromedia.com/go/getflashplayer' />\n");
		strBuf.append("\t\t</object>\n");
		// END Code Block for Chart
		strBuf.append("\t\t<!--END Code Block for Chart-->\n");
		return strBuf.substring(0);
	}

	/**
	 * Converts boolean to corresponding integer
	 * @param bool - The boolean that is to be converted to number
	 * @return int - 0 or 1 representing the given boolean value
	 */
	public int boolToNum(Boolean bool) {
		int num = 0;
		if (bool.booleanValue()) {
			num = 1;
		}
		return num;
	}%>

注意：使用google浏览器查看页面元素