水晶報表CrystalReport2008使用JDBC連接配接Oracle資料庫-詳細傻瓜步驟

 <b>水晶報表CrystalReport2008</b><b>使用JDBC</b><b>連接配接Oracle</b><b>資料庫-</b><b>詳細步驟</b>

連接配接的資料庫可以改成MySQL,詳細的在連接配接資料庫的時候說明.

一: 前期準備工作

l         Crystal Report 2008

l         JDBC 相關jar包 --- ojdbc5.jar(Oracle) 或 mysql-connector-java-5.1.7.jar(MySQL)

Jar包下載下傳:

ojdbc5.jar  http://www.oracle.com/technetwork/cn/articles/oem/jdbc-112010-094555-zhs.html

mysql-connector-java-5.1.7.jar  http://www.mysql.com/downloads/connector/j/

       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 在&lt;Classpath&gt;添加

&lt;Classpath&gt;<b>C:\Program Files\Business Objects\Common\4.0\java/lib/external/ojdbc5.jar;</b>

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}&lt;/Classpath&gt;

MySQL 則添加<b>mysql-connector-java-5.1.7.jar</b>

<b></b>

JAR包添加完畢!

準備工作完成!

三:  打開Crystal Report 2008

打開file&gt; new&gt; stander report

Connection URL :         <b>jdbc:oracle:thin:@name:port:sid</b>

                   例如: --- ( <b>jdbc:oracle:thin:@localhost:1521:dev</b>)

Database ClassName:    <b>oracle.jdbc.driver.OracleDriver</b>

       至此成功連接配接資料庫.

       END

2012-10-16