高分求助！！怎么让FusionChartsFree画出来的图显示在表格里
我把代码贴出来麻烦各位高手帮忙看下
1、最终显示页面test.jsp，这个页面是经过精简的，其实有更多代码，但与本问题无关
<%@page contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %><%String path = request.getContextPath();String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html> <head> <base href="<%=basePath%>"> <title>My JSP 'test.jsp' starting page</title> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="This is my page"> <!-- <link rel="stylesheet" type="text/css" href="styles.css"> --> </head> <body> <table width="350px" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#bdd5e0" class="ntable"> <tr height="45px"> <td width="38%" align="center" bgcolor="#e6effb"><strong>柱状图</strong></td> </tr> <tr height="200px"> <td bgcolor="#FFFFFF" class="tdl"> <jsp:include page="includes/chart.jsp" flush="true"> <jsp:param name="phone_id" value="127011" /> </jsp:include> </td> </tr> </table> </body></html>
<%@ page language="java"%><%@ page import="java.sql.*"%> <%@page contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %><HTML> <HEAD> <TITLE>FusionCharts Free - Database And Connection Class Example</TITLE> <SCRIPT LANGUAGE="Javascript" SRC="../FusionCharts/FusionCharts.js"></SCRIPT> <style type="text/css"> <!-- body { font-family: Arial, Helvetica, sans-serif; font-size: 12px; } .text{ font-family: Arial, Helvetica, sans-serif; font-size: 12px; } --> </style> </HEAD> <BODY> <CENTER> <% int pid = Integer.parseInt(request.getParameter("phone_id")); //int pid=127011; Class.forName("com.mysql.jdbc.Driver").newInstance(); Connection con=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/rv_mining","root","123123"); Statement st1=null; ResultSet rs1=null; String strXML=""; String strXML1=""; strXML = "<graph xAxisname='参数列表' yAxisname='用户倾向值' hovercapbg='DEDEBE' hovercapborder='889E6D'"+ " rotateNames='0' yAxisMaxValue='40' numdivlines='5' divLineColor='CCCCCC' divLineAlpha='80'"+ " decimalPrecision='0' showAlternateHGridColor='1' AlternateHGridAlpha='30' AlternateHGridColor='CCCCCC'>"; strXML += "<categories font='Arial' fontSize='11' fontColor='000000'>"+ "<category name='屏幕'/> <category name='系统性能' />"+ "<category name='外观及附件' /> <category name='通话及音效' /> "+ "<category name='待机' /> <category name='娱乐' />"+ "<category name='总体评价' /> </categories>"; strXML += "<dataset seriesname='正面评价' color='56B9F9'>"; strXML1 = "<dataset seriesname='负面评价' color='FDC12E'>"; try { int P = 0; int N = 0; st1=con.createStatement(); rs1 = st1.executeQuery("select * from rvm_chart where phone_id="+pid+""); while(rs1.next()){ P = rs1.getInt("P_value"); N = rs1.getInt("N_value"); strXML += " <set value='"+P+"' /> "; strXML1 += "<set value='"+N+"' /> "; } rs1.close(); st1.close(); con.close(); }catch(SQLException e) { e.printStackTrace(); } strXML1 += "</dataset>"; strXML += "</dataset>"+strXML1+"</graph>"; %> <jsp:include page="FusionChartsRenderer.jsp" flush="true"> <jsp:param name="chartSWF" value="../FusionCharts/FCF_MSColumn2D.swf" /> <jsp:param name="strURL" value="" /> <jsp:param name="strXML" value="<%=strXML %>" /> <jsp:param name="chartId" value="UsersTrend" /> <jsp:param name="chartWidth" value="300" /> <jsp:param name="chartHeight" value="210" /> <jsp:param name="debugMode" value="false" /> <jsp:param name="registerWithJS" value="false" /> </jsp:include> </CENTER> </BODY></HTML>
<% String chartSWF = request.getParameter("chartSWF"); String strURL = request.getParameter("strURL"); String strXML = request.getParameter("strXML"); String chartId = request.getParameter("chartId"); String chartWidthStr = request.getParameter("chartWidth"); String chartHeightStr = request.getParameter("chartHeight"); String debugModeStr= request.getParameter("debugMode"); String registerWithJSStr= request.getParameter("registerWithJS"); int chartWidth = 0; int chartHeight = 0; boolean debugMode=false; boolean registerWithJS=false; int debugModeInt = 0; int regWithJSInt = 0; if (null != chartWidthStr && !chartWidthStr.equals("")) { chartWidth = Integer.parseInt(chartWidthStr); } if (null != chartHeightStr && !chartHeightStr.equals("")) { chartHeight = Integer.parseInt(chartHeightStr); } if(null!=debugModeStr && !debugModeStr.equals("")){ debugMode = new Boolean(debugModeStr); debugModeInt=boolToNum(debugMode); } if(null!=registerWithJSStr && !registerWithJSStr.equals("")){ registerWithJS = new Boolean(registerWithJSStr); regWithJSInt=boolToNum(registerWithJS); } %> <!-- START Script Block for Chart <%=chartId%> --> <div id='<%=chartId %>Div'>Chart.</div> <script type='text/javascript'> var chart_<%=chartId%> = new FusionCharts("<%=chartSWF %>", "<%=chartId%>", "<%=chartWidth %>", "<%= chartHeight%>", "<%= debugModeInt%>", "<%= regWithJSInt%>"); <% // Check whether we've to provide data using dataXML method or dataURL // method if (strXML.equals("")) { %> <!-- Set the dataURL of the chart--> chart_<%= chartId%>.setDataURL("<%= strURL%>"); <%} else {%> // Provide entire XML data using dataXML method chart_<%= chartId%>.setDataXML("<%= strXML%>"); <%}%> <!-- Finally, render the chart.--> chart_<%=chartId%>.render("<%=chartId%>Div"); </script> <!--END Script Block for Chart <%=chartId%> --><%! /** * Converts a Boolean value to int value<br> * * @param bool Boolean value which needs to be converted to int value * @return int value correspoding to the boolean : 1 for true and 0 for false */ public int boolToNum(Boolean bool) { int num = 0; if (bool.booleanValue()) { num = 1; } return num; }%>