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
没有合适的资源?快使用搜索试试~ 我知道了~
FusionCharts图形报表工具正式版
共1114个文件
html:312个
jpg:267个
gif:72个
5星 · 超过95%的资源 需积分: 9 47 下载量 89 浏览量
2008-09-24
17:30:56
上传
评论 1
收藏 24.19MB RAR 举报
温馨提示
该版本为正式版,最近做了一个项目要引入fusioncharts,所以弄来了这个正式版,绝对没有问题,大家可以放心下载使用
资源推荐
资源详情
资源评论
收起资源包目录
FusionCharts图形报表工具正式版 (1114个子文件)
ruby_sess.0d12060727744e22 69B
ruby_sess.2c465119466f2f94 69B
ruby_sess.4fcb64c07e4ca192 69B
ruby_sess.86a19f42a9378058 69B
ruby_sess.8f850d857a50caf0 69B
about 95B
Web.config.ajax 6KB
Web.config.ajax 6KB
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
DBConn.asp 569B
Sample1.aspx 7KB
Sample1.aspx 6KB
Default.aspx 5KB
Default.aspx 5KB
Default.aspx 4KB
Default.aspx 4KB
Sample2.aspx 4KB
Sample2.aspx 4KB
Default.aspx 3KB
Default.aspx 3KB
Default.aspx 3KB
Default.aspx 3KB
BasicDataXML.aspx 2KB
dataXML.aspx 2KB
dataXML.aspx 1KB
BasicDataXML.aspx 1KB
MultiChart.aspx 1KB
MultiChart.aspx 1KB
BasicDBExample.aspx 1KB
BasicDBExample.aspx 1KB
Default.aspx 1KB
Default.aspx 1KB
Detailed.aspx 1KB
Detailed.aspx 1KB
SingleSeries.aspx 1KB
SimpleChart.aspx 1KB
Default.aspx 1KB
Combination.aspx 1KB
SingleSeries.aspx 1KB
MultiSeries.aspx 1KB
BasicChart.aspx 1KB
MultiSeries.aspx 1KB
Stacked.aspx 1KB
Stacked.aspx 1KB
SimpleChart.aspx 1KB
Combination.aspx 1KB
Default.aspx 1KB
BasicChart.aspx 1KB
Default.aspx 605B
Default.aspx 598B
FactoryData.aspx 121B
PieData.aspx 118B
FactoryData.aspx 116B
PieData.aspx 110B
FusionChartsSave.aspx 102B
benchmarker 117B
breakpointer 102B
Default.cfm 7KB
Default.cfm 5KB
FusionCharts.cfm 5KB
MultiSeries.cfm 4KB
Combination.cfm 4KB
Stacked.cfm 4KB
FusionChartsSave.cfm 3KB
dataXML.cfm 3KB
Chart.cfm 3KB
Default.cfm 3KB
SingleSeries.cfm 3KB
BasicDataXML.cfm 2KB
Default.cfm 2KB
BasicDBExample.cfm 2KB
Detailed.cfm 2KB
MultiChart.cfm 2KB
Default.cfm 2KB
SimpleChart.cfm 2KB
PieData.cfm 1KB
BasicChart.cfm 1KB
FactoryData.cfm 1KB
dispatch.cgi 476B
Web.config 2KB
web.config 2KB
共 1114 条
- 1
- 2
- 3
- 4
- 5
- 6
- 12
资源评论
- yozochen2012-12-26FLASH图样比较丰富,并且没有产品logo 赞
- liangtiana2011-10-09有没有带例子的资源啊
- kalazan2011-11-04FLASH图样比较丰富,并且没有产品logo 赞~
- guosnow_whu2011-10-26这个比较全,包括的图比较多,还不错。
- geqiandetong2013-05-16这个比较全,包括的图比较多,还不错。有没有带例子的资源啊,FLASH图样比较丰富,并且没有产品logo 赞~
guaowuji
- 粉丝: 1
- 资源: 1
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功