This version works with the Access mdb database which is bundled with the web application or with MySQL whose database-creation scripts are provided along with the web application.
We have used JSP 2.0 and j2sdk1.4.2_02 for the development of this demo.
Prerequisites:
1. Java version - j2sdk1.4.2_02
2. Apache Tomcat version - jakarta-tomcat-5.0.28
3. MySQL 4.X or higher OR MS Access database
Installation Instructions:
1. Java version - j2sdk1.4.2_02 which can be downloaded from the following link:
http://java.sun.com/j2se/1.4.2/download.html
2. After downloading and installing java,JAVA_HOME environment variable has to be set to determine the base path of the JDK.
To set this variable on Windows do the following:
Go to MyComputer, right click to view properties -> advanced tab ->environment variables
Set a new Variable name: JAVA_HOME with Value as the installation directory. For eg:
C:\j2sdk1.4.2_02
3. Apache Tomcat version - jakarta-tomcat-5.0.28 which can be downloaded from the following link:
http://tomcat.apache.org/download-55.cgi
Click on the core zip file. Download it.Extract it to some folder.
4.After downloading and installing tomcat,CATALINA_HOME environment variable has to be set to determine the base path of the tomcat.
To set this variable on Windows do the following:
Go to MyComputer, right click to view properties -> advanced tab ->environment variables
Set a new Variable name: CATALINA_HOME with Value as the installation directory. For eg:
C:\jakarta-tomcat-5.0.25
5. Copy the fcgeneral.war to "CATALINA_HOME"/webapps folder
6. Creation of the database required by FusionCharts:
If you are using MSAccess, then copy the FactoryDB.mdb present in the Database/MSAccess folder to some location on your hard-drive.
If you are using MySQL, then run the FactoryDBCreation.sql (present in the Database/MySQL) in your MySQL.
This creates the FactoryDB database on your machine.
7. In order to configure the MySQL database:
Open the file "CATALINA_HOME"/conf/server.xml
Add the following xml code just before </Host>
<Context path="/fcgeneral" docBase="fcgeneral"
debug="5" reloadable="true" crossContext="true">
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="localhost_DBTest_log." suffix=".txt"
timestamp="true"/>
<Resource name="jdbc/FactoryDB"
auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/FactoryDB">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<!-- Maximum number of dB connections in pool. Make sure you
configure your mysqld max_connections large enough to handle
all of your db connections. Set to 0 for no limit.
-->
<parameter>
<name>maxActive</name>
<value>100</value>
</parameter>
<!-- Maximum number of idle dB connections to retain in pool.
Set to 0 for no limit.
-->
<parameter>
<name>maxIdle</name>
<value>30</value>
</parameter>
<!-- Maximum time to wait for a dB connection to become available
in ms, in this example 10 seconds. An Exception is thrown if
this timeout is exceeded. Set to -1 to wait indefinitely.
-->
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
<!-- MySQL dB username and password for dB connections -->
<parameter>
<name>username</name>
<value>fcuser</value>
</parameter>
<parameter>
<name>password</name>
<value>fcuser</value>
</parameter>
<!-- Class name for the old mm.mysql JDBC driver - uncomment this entry and comment next
if you want to use this driver - we recommend using Connector/J though
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>
-->
<!-- Class name for the official MySQL Connector/J driver -->
<parameter>
<name>driverClassName</name>
<value>com.mysql.jdbc.Driver</value>
</parameter>
<!-- The JDBC connection url for connecting to your MySQL dB.
The autoReconnect=true argument to the url makes sure that the
mm.mysql JDBC Driver will automatically reconnect if mysqld closed the
connection. mysqld by default closes idle connections after 8 hours.
-->
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost:3306/factorydb?autoReconnect=true</value>
</parameter>
</ResourceParams>
</Context>
In the above xml,please change the username,password,url according to your database.Optionally, you can change the resource name,resourceparams name which are used to lookup for this database.Whatever values are given here same values should be given in the web.xml of your webapp.
8. Changes to web.xml present in "CATALINA_HOME"/webapps/fcgeneral/WEB-INF/ folder:
In order to change the database from mysql to access or vice-versa, change the following entry in web.xml.
<context-param>
<param-name>dbName</param-name>
<param-value>MySQL</param-value>
<description>Database Name</description>
</context-param>
Currently, you can set the param-value to MySQL or MSAccess.(case-sensitive)
In the case of Access DB, you have to set the path to the database in the following parameter in web.xml.
<context-param>
<param-name>AccessDBPath</param-name>
<param-value>C:/tomcat/fcgeneral/GeneralPages/JSP/DB/FactoryDB.mdb</param-value>
<description> Absolute path to the Access DB </description>
</context-param>
In the case of MySQL DB,you have to set the Data Source Name in the following parameter in the web.xml
<!-- DataSourceName as given in the resource-ref tag and in server.xml -->
<context-param>
<param-name>dataSourceName</param-name>
<param-value>jdbc/FactoryDB</param-value>
<description>DataSource Name</description>
</context-param>
9.If you are using MySQL as the database, please start your MySQL instance.
10.To start the tomcat server,go to the tomcat installation directory ("CATALINA_HOME") and run startup.bat
11.Access the FusionCharts website by opening the browser window with the following address:
http://localhost:8080/fcgeneral/GeneralPages/JSP/
Note: "CATALINA_HOME" refers to the installation directory of Tomcat
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
图表显示是很多开发工作所必不可少的一项功能,今天我介绍一个前段时间发现的免费的Flash图表开发工具,可以通过Adobe Flash实现数据的图表化,动态化以及相互交互。 FusionChart是一个简单易用的图表工具,使用它可以显示丰富的柱状图和曲线图,而且完全免费。使用FusionChart可以方便的生成漂亮的柱状图、曲线图等图标,显示直观、清晰,可以让管理层在最短的时间内宏观掌握业绩信息。 FusionCharts和其他常见的图表控件不同,它使用Flash技术,能够快速创建引人注目的动态图像效果。充分利用Macromedia Flash所具有的流畅功能来创建简洁的、交互式的和引人注目的动态图像。极大增强了报表图表的现实效果。 前端时间我们开发小组就使用FusionCharts已经在一个内部业务系统中使用,显示效果很不错,得到众多领导的好评。这个免费工具在各类业务系统的报表项目中都具有使用的前景,起到增强各类报表的显示效果。
资源推荐
资源详情
资源评论
收起资源包目录
Fusion Chart v.3.0 Flash图表工具 Source (1118个子文件)
ruby_sess.0d12060727744e22 69B
ruby_sess.2c465119466f2f94 69B
ruby_sess.4fcb64c07e4ca192 69B
ruby_sess.86a19f42a9378058 69B
ruby_sess.8f850d857a50caf0 69B
about 95B
Doughnut3DChart.as 143KB
Pie3DChart.as 142KB
MSCombiDY2DChart.as 140KB
MSStackedColumn2DLineDYChart.as 131KB
MSCombi2DChart.as 129KB
StackedColumn3DLineDYChart.as 125KB
MSColumn3DLineDYChart.as 119KB
Doughnut2DChart.as 113KB
ScrollArea2DChart.as 112KB
MSColumnLine3DChart.as 112KB
Pie2DChart.as 111KB
StackedArea2DChart.as 109KB
MSArea2DChart.as 105KB
ScrollLine2DChart.as 103KB
MSLine2DChart.as 99KB
ScrollColumn2DChart.as 95KB
StackedColumn3DChart.as 94KB
MSStackedColumn2DChart.as 94KB
XYPlotChart.as 92KB
Area2DChart.as 91KB
StackedColumn2DChart.as 90KB
MSColumn3DChart.as 90KB
MSColumn2DChart.as 88KB
Line2DChart.as 85KB
StackedBar2DChart.as 82KB
MSBar2DChart.as 80KB
Column3DChart.as 77KB
Column2DChart.as 75KB
BubbleChart.as 70KB
Scatter2DChart.as 70KB
Doughnut3D.as 68KB
Bar2DChart.as 67KB
Pie3D.as 59KB
DualYAxisChart.as 55KB
Chart.as 51KB
FCHScrollPane.as 38KB
SingleYAxisChart.as 38KB
StyleManager.as 36KB
SSGrid.as 35KB
Doughnut2D.as 30KB
Pie2D.as 25KB
DualYAxis2DChart.as 25KB
DualYAxis3DChart.as 23KB
SingleYAxis3DChart.as 21KB
SingleYAxis2DVerticalChart.as 19KB
SingleYAxis2DHorizontalChart.as 18KB
Legend.as 15KB
ScrollBar.as 13KB
DefaultColors.as 12KB
DataFunctions.as 12KB
Logger.as 12KB
Utils.as 10KB
Column3D.as 9KB
ColorExt.as 8KB
Macros.as 8KB
ToolTip.as 7KB
LoadingFunctions.as 7KB
SingleYAxis2DChart.as 6KB
DrawingExt.as 6KB
PreLoad.as 4KB
ScrollSingleYAxis2DVerticalChart.as 4KB
AppMessages.as 4KB
MathExt.as 4KB
Column2D.as 4KB
Bar2D.as 3KB
HashTable.as 3KB
Init.as 3KB
FCEnum.as 3KB
StringExt.as 2KB
DepthManager.as 2KB
ExternalInterface.as 2KB
StyleObject.as 1KB
IComponent.as 1KB
FCError.as 721B
Default.asp 7KB
FusionCharts.asp 6KB
Default.asp 6KB
MultiSeries.asp 4KB
Combination.asp 3KB
Stacked.asp 3KB
Default.asp 3KB
dataXML.asp 3KB
Chart.asp 3KB
BasicDBExample.asp 3KB
Detailed.asp 3KB
Default.asp 2KB
BasicDataXML.asp 2KB
SingleSeries.asp 2KB
Default.asp 2KB
MultiChart.asp 2KB
PieData.asp 2KB
SimpleChart.asp 2KB
FactoryData.asp 1KB
BasicChart.asp 1KB
共 1118 条
- 1
- 2
- 3
- 4
- 5
- 6
- 12
资源评论
- 撼地神牛2014-01-03就是fusionchartdemo,api啥的
- xuqb12018-07-21其实和eCharts相比,已经没有什么优势了。
- liyuan992013-01-21很不错的资源,表格样式很全面,部分上面有版权,是您学习的好资料!
- hbxflqh2013-10-15东西不错,是不错的东西
- chenyuwang20092014-11-30很不错的demo,各种图表都有,收藏加学习
hanoi2005
- 粉丝: 0
- 资源: 87
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功