WireFusion链接mysql数据库

晃晃

*** MySQL connectivity in WireFusion presentations ***

Connecting a WireFusion presentation to a MySQL database is quite easy. A JDBC driver

for MySQL is included in this archive (mysql-jdbc.jar) and an example project showing

how it can be used is also included (jdbc-example.wfp). It is assumed that you are

familiar with SQL and JDBC. (If you are not familiar with JDBC, you can learn the basics

here:

http://java.sun.com/developer/onlineTraining/Database/JDBCShortCourse/index.html)
Steps to follow to get the example project running:

- Create a table in your database with the following SQL statement:

  CREATE TABLE Test(Inttest Int, Stringtest VARCHAR(20), PRIMARY KEY(Inttest));

- Insert a new row into the table with this statement:

  INSERT INTO Test VALUES (10,'hello');

- Open jdbc-example.wfp in WireFusion. Open the JDBC-Connection object and edit dbURL

  to match the url of your database. Also modify the username and password parameters.

- Run the presentation, and click the "Get Data" button. The data should now be displayed

  in the presentation.
Notes:

When you create a new Java object that uses JDBC connectivity from scratch, you

must add mysql-jdbc.jar as a Java Librariy to the Java object. Do this from

"Edit/Preferences" in the Java object.

You may want to set the database to read only mode if you are concerned with

security.

难骑

这个好呀

难骑

学习了

Asen

发布是个问题

菜刀吻电线

路过……

C.R.CAN

先顶上去，偶要高亮加精鸟！

晃晃

人过留名!

tc

提醒猪猪，千万不能让你看见

C.R.CAN

佩服，好多阿 ，哈哈

奇

路过……