纳金网

标题: WireFusion链接mysql数据库 [打印本页]

作者: 晃晃 时间: 2011-8-8 08:23
标题: 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.

作者: 难骑 时间: 2011-8-11 08:55
提示: 作者被禁止或删除内容自动屏蔽

作者: Asen 时间: 2011-8-16 10:51
发布是个问题

作者: 菜刀吻电线 时间: 2012-2-2 23:22
路过……

作者: C.R.CAN 时间: 2012-3-3 23:23
先顶上去，偶要高亮加精鸟！

作者: 晃晃 时间: 2012-3-29 23:29
人过留名!

作者: tc 时间: 2012-4-4 23:20
提醒猪猪，千万不能让你看见

作者: C.R.CAN 时间: 2012-4-5 23:18
佩服，好多阿，哈哈

作者: 奇 时间: 2012-4-17 23:25
路过……

作者: tc 时间: 2012-7-4 23:19
加精、加亮滴铁子，尤其要多丁页丁页

作者: 菜刀吻电线 时间: 2012-7-11 23:18
路过、路过、快到鸟，列位请继续...ing

作者: 菜刀吻电线 时间: 2013-2-26 23:27
呵呵，很好，方便罗。

欢迎光临纳金网 (http://go.narkii.com/club/)