水晶报表 mysql_水晶报表CrystalReport2008使用JDBC连接MySQL数据库-详细步骤

Love The Way You Lie 2023-01-11 08:15 179阅读 0赞

水晶报表CrystalReport2008使用JDBC连接MySQL数据库-详细步骤

一:前期准备工作

lCrystal Report 2008

lJDBC相关jar包 ---mysql-connector-java-5.1.22-bin.jar(MySQL)

Jar包下载:

mysql-connector-java-5.1.22-bin.jar见附件)

JAR包添加:

1.把JAR包放在水晶报表CrystalReport的目录下面

C:\\Program Files\\Business Objects\\Common\\4\\java\\lib\\external

2.然后找到JAR包的配置文件CRConfig.xml

C:\\Program Files\\Business Objects\\Common\\4\\java\\CRConfig.xml

3.打开CRConfig.xml

A. 更改水晶报表的JDK环境

C:\\Program Files\\Java\\jdk1.6.0\_06\\bin

B.在添加

C:\\Program Files\\Business Objects\\Common\\4.0\\java/lib/external/mysql-connector-java-5.1.22-bin.jar;

C:\\Program Files\\Business Objects\\Common\\4.0\\java/lib/crlovmanifest.jar;

C:\\Program Files\\Business Objects\\Common\\4.0\\java/lib/CRLOVExternal.jar;

C:\\Program Files\\Business Objects\\Common\\4.0\\java/lib/CRDBJDBCServer.jar;

C:\\Program Files\\Business Objects\\Common\\4.0\\java/lib/CRDBXMLServer.jar;

C:\\Program Files\\Business Objects\\Common\\4.0\\java/lib/CRDBJavaBeansServer.jar;

C:\\Program Files\\Business Objects\\Common\\4.0\\java/lib/external/CRDBXMLExternal.jar;

C:\\Program Files\\Business Objects\\Common\\4.0\\java/lib/external/log4j.jar;

C:\\Program Files\\Business Objects\\Common\\4.0\\java/lib/CRDBSForceServer.jar;

C:\\Program Files\\Business Objects\\Common\\4.0\\java/lib/external/CRDBSForceExternal.jar;$\{CLASSPATH\}

JAR包添加完毕!

准备工作完成!

三:打开Crystal Report 2008

![6aa69273c694e69214fc94eb58bb959c.png][]

打开file> new> stander report

![931f8336a6b366fde88f47a480d7396c.png][]

Connection URL :jdbc:mysql://LOCAL\_HOST:3306/DB\_NAME

例如: --- ( jdbc:mysql://localhost:3306/db\_name)

Database ClassName:com.mysql.jdbc.Driver

![5690cc3ccadd02f96e61dd5eace2e194.png][]

![a65c7c96d9177335d8337c35cb9e1919.png][]

至此成功连接数据库.

END

2012-12-07

[6aa69273c694e69214fc94eb58bb959c.png]: /images/20221119/d00cf10826074a3d993ab24019e5c453.png
[931f8336a6b366fde88f47a480d7396c.png]: /images/20221119/bcde56c53d8c44f3a05633d838bd7997.png
[5690cc3ccadd02f96e61dd5eace2e194.png]: /images/20221119/b1a53ea1fd33444faee44a1fda4dfcda.png
[a65c7c96d9177335d8337c35cb9e1919.png]: https://img-blog.csdnimg.cn/img_convert/a65c7c96d9177335d8337c35cb9e1919.png