報表使用經驗、技巧大總結（包括JFreechart、JS chart以及自己的使用經驗）

報表使用經驗、技巧大總結

前面我的工作中用到了報表，當時積累了一些試用心得。也觸發了一些靈感。這里總結下來，希望對大家有一定幫助。

一、利用基本的TABLE元素

——自己的創意之作

可以參考我先前的一篇關于TABLE制作柱狀圖的blog：

http://www.aygfsteel.com/JAVA-HE/archive/2007/04/20/112352.html

如果只是需要在頁面上現實一些柱狀圖，那么這種方式是非常簡單和實用的。核心原理利用HTML的基本元素——table。繪制table，不顯示其邊框，不顯示其間距，然后利用獲得的數據，使用JS控制哪行哪列用什么顏色。

如：

document.getElementById('tab').rows[0].cells[0].bgColor = 'red';

二、立體感的柱狀圖

——這是在網上陶下來的漂亮代碼

<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office">
2

<!--[if !mso]>
4

<style>
6

v\:* { behavior: url(#default#VML) }
8

o\:* { behavior: url(#default#VML) }
10

.shape { behavior: url(#default#VML) }
12

</style>
14

<![endif]-->
16

<HEAD>
18

<TITLE>柱狀圖形報表樣列</TITLE>
20

//addPole 增加一個柱狀圖
24

//left 與窗口左邊的距離
26

//width 寬度
28

//height 高度
30

//zindex 層高度
32

//fillcolor 主色
34

//color 漸變色
36

//type 默認為豎,1為橫
38

function addPole(left,top,width,height,zindex,fillcolor,color,type)

{
40

top=top-height;
42

var a="";
44

if(type==1)

{
46

a="angle='-90' focus='100%'";
48

}
50

var html="<v:rect style='position:absolute;";
52

html=html+"left:"+left+"px;";
54

html=html+"top:"+top+"px;";
56

html=html+"width:"+width+"px;";
58

html=html+"height:"+height+"px;";
60

html=html+"z-index:"+zindex+"'";
62

html=html+"fillcolor='"+fillcolor+"'>";
64

html=html+"<v:fill color2='"+color+"'";
66

html=html+" rotate='t' "+a+" type='gradient'/><o:extrusion v:ext='view' backdepth='20pt' ";
68

html=html+"color='"+fillcolor+"' on='t'/></v:rect>";
70

document.write(html);
72

}
74

//left 與窗口左邊的距離
78

//width 寬度
80

//height 高度
82

//zindex 立體高度
84

//fillcolor 主色
86

function addBackground(left,top,width,height,zindex,fillcolor)

{
88

top=top-height;
90

var html="<v:rect style='position:absolute;left:"+left+"px;";
92

html=html+"top:"+top+"px;";
94

html=html+"width:"+width+"px;";
96

html=html+"height:"+height+"px;";
98

html=html+"z-index:"+zindex+"'";
100

101

html=html+"fillcolor='"+fillcolor+"'";
102

103

html=html+" stroked='f'><v:fill rotate='t' angle='-45' focus='100%' type='gradient'/></v:rect>";
104

105

document.write(html);
106

107

}
108

109

110

111

function addLine(zindex,from,to,color)

{
112

113

var html="<v:line style='position:absolute;left:0;text-align:left;top:0;flip:y;z-index:"+zindex+"'";
114

115

html=html+" from='"+from+"' to='"+to+"' strokecolor='"+color+"'/>"
116

117

document.write(html);
118

119

}
120

121

122

123

function addText(left,top,width,height,zindex,value,fontsize)

{
124

125

top=top-height;
126

127

var html="<v:shape style='position:absolute;left:"+left+"px;";
128

129

html=html+"top:"+top+"px;";
130

131

html=html+"width:"+width+"px;";
132

133

html=html+"height:"+height+"px;";
134

135

html=html+"z-index:"+zindex+"'>";
136

137

html=html+"<v:textbox inset='0px,0px,0px,0px'><table cellspacing='3' cellpadding='0' width='100%' height='100%'><tr><td";
138

139

html=html+" style='FONT-SIZE:"+fontsize+"' align='center'>"+value+"</td></tr></table></v:textbox></v:shape>";
140

141

document.write(html);
142

143

}
144

145

146

147

function addGround(left,top,width,height,zindex,fillcolor,linecolor1,linecolor2,offset,level,min,leftoffset,textwidth,textheight,fontsize)

{
148

149

addBackground(left,top,width,height,zindex,fillcolor);
150

151

addLine(zindex,left+"px,"+top+"px",((left-0)+(width-0))+"px,"+top+"px",linecolor1);
152

153

addLine(zindex,left+"px,"+top+"px",left+"px,"+(top-height)+"px",linecolor1);
154

155

addLine(zindex,((left-0)+(offset-0))+"px,"+(top-offset)+"px",((left-0)+(width-0))+"px,"+(top-offset)+"px",linecolor2);
156

157

addLine(zindex,((left-0)+(offset-0))+"px,"+(top-offset)+"px",((left-0)+(offset-0))+"px,"+(top-height)+"px",linecolor2);
158

159

addLine(zindex,left+"px,"+(top-offset)+"px",((left-0)+(offset-0))+"px,"+top+"px",linecolor2);
160

161

for(var i=1;i<level;i++)

{
162

163

addLine(zindex,left+"px,"+(top-offset-(height*i)/level)+"px",((left-0)+(offset-0))+"px,"+(top-(height*i)/level)+"px",linecolor2);
164

165

addLine(zindex,(left-leftoffset)+"px,"+(top-(height*i)/level)+"px",left+"px,"+(top-(height*i)/level)+"px",linecolor1);
166

167

addText(left-textwidth,(top-(height*i)/level)+(textheight-0)+2,textwidth,textheight,"-1",i*min,fontsize)
168

169

addLine(zindex,((left-0)+(offset-0))+"px,"+(top-offset-(height*i)/level)+"px",((left-0)+(width-0))+"px,"+(top-offset-(height*i)/level)+"px",linecolor2);
170

171

}
172

173

addLine(zindex,(left-leftoffset)+"px,"+(top-(height*level)/level)+"px",left+"px,"+(top-(height*level)/level)+"px",linecolor1);
174

175

addText(left-textwidth,(top-(height*level)/level)+(textheight-0)+2,textwidth,textheight,"-1",level*min,fontsize)
176

177

}
178

179

180

181

function addEPole(left,top,width,height,zindex,fillcolor,color,textwidth,textheight,value1,value2,fontsize)

{
182

183

addText(left-textwidth/2+width/2,top-height-10,textwidth,textheight,zindex,value1,fontsize);
184

185

addText(left-textwidth/2+width/2,(top-0)+(textheight-0),textwidth,textheight,zindex,value2,fontsize);
186

187

addPole(left,top,width,height,zindex,fillcolor,color)
188

189

}
190

191

</SCRIPT>
192

193

</HEAD>
194

195

196

197

<BODY>
198

199

<div>
200

201

202

203

<!--
204

205

206

207

addEPole("180","400","30","150","1","#3300FF","#66FFFF","80","18","300","1月份","9pt");
208

209

addEPole("230","400","30","300","1","#FF0000","#99FFFF","80","18","600","2月份","9pt");
210

211

addEPole("280","400","30","200","1","#33CC00","#99FFFF","80","18","400","3月份","9pt");
212

213

addEPole("330","400","30","100","1","#FF0099","#99FFFF","80","18","200","4月份","9pt");
214

215

addEPole("380","400","30","50","1","#660000","#99FFFF","80","18","100","5月份","9pt");
216

217

addEPole("430","400","30","20","1","#FFFF00","#99FFFF","80","18","40","6月份","9pt");
218

219

addEPole("480","400","30","180","1","#330066","#99FFFF","80","18","360","7月份","9pt");
220

221

addEPole("530","400","30","120","1","#CC6633","#99FFFF","80","18","240","8月份","9pt");
222

223

addEPole("580","400","30","80","1","#9933FF","#99FFFF","80","18","160","9月份","9pt");
224

225

addGround("160","400","460","300","-1","#33CCFF","#000000","#6699CC","10","6","100","20","40","18","9pt")
226

227

//-->
228

229

</SCRIPT>
230

231

</div>
232

233

</body>
234

235

</html>
236

效果圖如下：

是不是很漂亮呢？我是覺得很漂亮。

其中方法調用，想知道每個參數的詳細信息，你可以自己試：

addEPole("580","400","30","80","1","#9933FF","#99FFFF","80","18","160","9月份","9pt");

參數含義包括上邊距離，左邊距，以及高寬，以及XY上的內容。以及顏色，柱體的寬度等等信息。

addGround("160","400","460","300","-1","#33CCFF","#000000","#6699CC","10","6","100","20","40","18","9pt")

定義了范圍大小以及6個刻度，每個100，還包括字體大小，刻度線顏色，以及內部線條顏色，以及漸變色等等含義。

三、JFreechart使用

注意生成圖都自動存在臨時文件夾里的。

總結過上手資料文章：

http://www.aygfsteel.com/JAVA-HE/archive/2007/04/18/111439.html

但是朋友反映總結得過于粗淺。

這里寫詳細點：

1. 柱狀圖

DefaultCategoryDataset dataset = new DefaultCategoryDataset ();
2

dataset.addValue (300, "廣州", "蘋果");
4

dataset.addValue (200, "廣州", "梨子");
6

dataset.addValue (600, "廣州", "葡萄");
8

dataset.addValue (340, "廣州", "芒果");
10

dataset.addValue (280, "廣州", "荔枝");
12

JFreeChart chart = ChartFactory.createBarChart3D ("水果銷量統計圖","水果","銷量",
14

dataset,PlotOrientation.VERTICAL, //選擇水平或者垂直放
16

false,//是否顯示顏色類別（地區）提示
18

false,
20

false);
22

String filename = ServletUtilities.saveChartAsPNG (chart, 500, 300, null, session);
24

String graphURL = request.getContextPath () + "/servlet/DisplayChart?filename=" + filename;
26

2. 餅圖

DefaultPieDataset data = new DefaultPieDataset();
2

data.setValue("六月", 500);
4

data.setValue("七月", 580);
6

data.setValue("八月", 828);
8

PiePlot plot = new PiePlot(data);
10

JFreeChart chart = new JFreeChart("", JFreeChart.DEFAULT_TITLE_FONT, plot, true);
12

chart.setBackgroundPaint(java.awt.Color.white); //可選，設置圖片背景色
14

chart.setTitle("Welcome to Jfreechart !"); //可選，設置圖片標題
16

ChartRenderingInfo info = new ChartRenderingInfo(new StandardEntityCollection());
18

//500是圖片長度，300是圖片高度
20

String filename = ServletUtilities.saveChartAsPNG(chart, 500, 300, info, session);
22

String graphURL = request.getContextPath() + "/servlet/DisplayChart?filename=" + filename;
24

在插入圖片的地方：
28

<img src="<%= graphURL %>" width=500 height=300 border=0 usemap="#<%= filename %>">
30

在xml中加入了：
34

<servlet>
36

<servlet-name>DisplayChart</servlet-name>
38

<servlet-class>org.jfree.chart.servlet.DisplayChart</servlet-class>
40

</servlet>
42

<servlet-mapping>
44

<servlet-name>DisplayChart</servlet-name>
46

<url-pattern>/servlet/DisplayChart</url-pattern>
48

</servlet-mapping>
50

圖片效果，請訪問：http://www.aygfsteel.com/JAVA-HE/archive/2007/04/18/111439.html
52

還可以如下創建 dataset對象：
54

double[][] data = new double[][]

{

{672, 766, 223, 540, 126},

{325, 521, 210, 340, 106},

{332, 256, 523, 240, 526} };
56

String[] rowKeys =

{"蘋果","梨子","葡萄"};
58

String[] columnKeys =

{"北京","上海","廣州","成都","深圳"};
60

CategoryDataset dataset = DatasetUtilities.createCategoryDataset(rowKeys, columnKeys, data);
62

效果：

參照網上介紹的一些文章總是發現不能向我的這么順利，不是說他們的有錯。我想版本不一樣了。區別肯定是有的。

實際上建立什么樣的圖表，ChartFactory可以選擇不同方法建立不同圖表的。

比如直接講原來一個柱狀圖，中改了一個方法，圖就變了。

如：

JFreeChart chart = ChartFactory.createLineChart ("水果銷量統計圖","水果","銷量",
2

dataset,PlotOrientation.VERTICAL,//選擇水平或者垂直放
4

true,//廣州或者成都，這里顏色有區別的。（顏色類別）
6

true,
8

true);
10

對比兩幅圖。只是方法名字不同。

再來個3D的:（createLineChart3D方法）

而作為createAreaChart建立的面積比例圖：

需要注意點的是，數據先后對圖像效果是有影響的。因為有覆蓋存在。

補充一個讓大家都暈的，我居然一直一位JFreechart 和CEWOLG是一個東西。所以總在那里找標簽。還以為我下載的版本不同，所以那些東西都找不到呢！

四、結合cewolf使用

實際上大量應用的是線圖：

經典應用，無非是讀取數據庫，然后根據數據庫中的值來生成線圖。

生成線圖的JSP：

<%@page pageEncoding="UTF-8"%>
4

<%@page import="java.sql.*"%>
6

<%@page import="java.util.*"%>
8

<%@page import="de.laures.cewolf.*"%>
10

<%@page import="de.laures.cewolf.tooltips.*"%>
12

<%@page import="de.laures.cewolf.links.*"%>
14

<%@page import="org.jfree.data.*"%>
16

<%@page import="org.jfree.data.time.*"%>
18

<%@page import="org.jfree.data.gantt.*"%>
20

<%@page import="org.jfree.chart.*"%>
22

<%@page import="org.jfree.chart.plot.*"%>
24

<%@page import="org.jfree.data.category.*"%>
26

<%@page import="org.jfree.data.general.*"%>
28

<%@page import="org.jfree.data.xy.*"%>
30

<%@page import="java.awt.*" %>
32

<%@page import="de.laures.cewolf.taglib.CewolfChartFactory" %>
34

<%@page import="org.jfree.chart.event.ChartProgressListener" %>
36

<%@page import="org.jfree.chart.event.ChartProgressEvent" %>
38

<%@page import="com.palmtech.util.*" %>
40

<%@page import="com.palmtech.sqldata.*" %>
42

<%
44

final int round=roleInfo.round;//獲取游戲輪數
46

int[][] loanDataTemp=new int[round][2];
48

conn = null;
50

result = new Vector ();
52

ps = null;
54

try
56

{
58

conn = DriverManager.getConnection ("proxool.BreadServer");
60

ps = conn.prepareStatement ("CALL proc_graph_role_fee(?,?,?)");
62

ps.setInt (1,gameID);
64

ps.setInt (2,roleID);
66

ps.setInt (3,2);
68

ResultSet rs = ps.executeQuery ();
70

for(int histroyRound=0;histroyRound<round;histroyRound++)
72

{
74

rs.absolute (histroyRound+1);//游標從1開始
76

for(int i=0;i<2;i++)
78

{
80

loanDataTemp[histroyRound][i]=rs.getInt (2+i);
84

//out.print (loanDataTemp[histroyRound][i]+" ");
86

}
88

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

}
92

rs.close ();
94

ps.close ();
96

ps = null;
98

}
100

101

catch (Exception ex)
102

103

{
104

105

ex.printStackTrace ();
106

107

result = new Vector ();
108

109

}
110

111

finally
112

113

{
114

115

if(ps!=null)
116

117

{try
118

119

{ps.close ();}
120

121

catch(Exception e)
122

123

{}ps=null;}
124

125

try
126

127

{conn.close ();}
128

129

catch(Exception e)
130

131

{}conn=null;
132

133

}
134

135

final int[][] loanData=loanDataTemp;
136

137

%>
138

139

<%
140

141

//if (pageContext.getAttribute("initFlag") == null)
142

143

{
144

145

DatasetProducer g_loan = new DatasetProducer ()
146

147

{
148

149

public Object produceDataset (Map params)
150

151

{
152

153

final String[] seriesNames =

{ "銷售利潤", "貸款增加額曲線"};
154

155

String[] categories=new String[round];
156

157

for(int i=0;i<round;i++)
158

159

{
160

161

categories[i]=""+(i+1);
162

163

}
164

165

DefaultCategoryDataset dataset = new DefaultCategoryDataset ()
166

167

{
168

169

protected void finalize () throws Throwable
170

171

{
172

173

super.finalize ();
174

175

}
176

177

};
178

179

for (int series = 0; series < seriesNames.length; series ++)
180

181

{
182

183

for (int i = 0; i < categories.length; i++)
184

185

{
186

187

dataset.addValue (loanData[i][series], seriesNames[series], categories[i]);
188

189

}
190

191

}
192

193

return dataset;
194

195

}
196

197

public String getProducerId ()
198

199

{
200

201

return "CategoryDataProducer";
202

203

}
204

205

public boolean hasExpired (Map params, java.util.Date since)
206

207

{
208

209

return (System.currentTimeMillis () - since.getTime ()) > 5000;
210

211

}
212

213

};
214

215

pageContext.setAttribute ("g_loan", g_loan);
216

217

pageContext.setAttribute ("initFlag", "init");
218

219

}
220

221

%>
222

223

<%int r_loan=MathUtil.random(-2, 2);%>
224

225

<html>
226

227

<head>
228

229

231

<BODY>
232

233

<p>
234

235

<table border=0>
236

237

<TR>
238

239

<TD>
240

241

<cewolf:chart id="lineChart" title="銷售利潤/貸款增加額曲線" type="line" xaxislabel="回合數" yaxislabel="金額">
242

243

<cewolf:data>
244

245

<cewolf:producer id="g_loan" />
246

247

</cewolf:data>
248

249

</cewolf:chart>
250

251

<cewolf:img chartid="lineChart" renderer="/cewolf" width="300" height="<%=(r_loan+300)%>"/>
252

253

</TD>
254

255

</TR>
256

257

258

259

</TABLE>
260

261

</body>
262

263

</html>
264

265

266

在上面的程序<cewolf:data>上加入：

<cewolf:colorpaint color="#FFEEEE"/>

指定圖的背景色。

也可以：

<cewolf:gradientpaint>

<cewolf:point x="0" y="0" color="#FFFFFF" />

<cewolf:point x="300" y="0" color="#DDDDFF" />

</cewolf:gradientpaint>

這樣指定漸變色。

甚至

<cewolf:texturepaint image="/img/bg.jpg" width="60" height="60" />

指定背景圖。

而在另一個JSP頁面里顯示：

<%@include file='graph.jsp'%>

這樣就把上面生成線圖的JSP頁面應用到當前JSP頁面里。

也許你疑問為何用這個tld呢？因為這樣嵌入了圖表的JSP就不用使用任何Java代碼。

記得將cewolf.tld放在web-inf下面。

在xml里追加:

< servlet >
2

< servlet-name > CewolfServlet </ servlet-name >
4

< servlet-class > de.laures.cewolf.CewolfRenderer </ servlet-class >
6

8

< init-param >
10

< param-name > storage </ param-name >
12

< param-value > de.laures.cewolf.storage.TransientSessionStorage </ param-value >
14

</ init-param >
16

18

< init-param >
20

< param-name > overliburl </ param-name >
22

< param-value > overlib.js </ param-value >
24

</ init-param >
26

28

< init-param >
30

< param-name > debug </ param-name >
32

< param-value > true </ param-value >
34

</ init-param >
36

< load-on-startup > 1 </ load-on-startup >
38

</ servlet >
40

< servlet-mapping >
42

< servlet-name > CewolfServlet </ servlet-name >
44

< url-pattern > /cewolf/* </ url-pattern >
46

</ servlet-mapping >
48

將overlib.js復制到WEB應用程序的根目錄下；

verticalBar類型和line類型可以直接換 。不需要改其他地方。

效果圖對比:

只是類型變了（加上了背景色效果）：

加點背景圖片：（加了個半裸女，可惜擋住了。呵呵）

五、JS CHART

隨后我又在http://webfx.eae.net/發現一個用js寫的chart開源工具包。

要用到報表的地方：

而在HTMLhead部分導入需要的JS 文件。參考其提供的demo文件，稍做修改就能完全使用。

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
2

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
4

<head>
6

<title>Chart Demo (WebFX)</title>
8

.chart { margin-left: 20px; }
28

</style>
30

</head>
32

<body onload="demo();">
34

<div class="webfx-main-body">
36

<div id="chart3" class="chart" style="width: 400px; height: 200px;"></div>
38

</div>
40

</body>
42

</html>
44

負責繪制工作的js：

function demo() {
2

var c = new Chart(document.getElementById('chart3'));
4

c.setDefaultType(CHART_LINE);
6

c.setGridDensity(10, 10);
8

c.setHorizontalLabels(['mon', 'tue', 'wed', 'thu', 'fri', 'sat', 'sun', 'mon', 'tue', 'wed']);
10

11%

posted on 2007-05-08 00:43 -274°C 閱讀(23950) 評論(10) 編輯收藏所屬分類: JSP 、計算機綜合

FeedBack: