Working with Databases in Visual Web JSF Applications

The following table shows how to use databases with Visual Web JSF development.

Number one
Add database to the IDE

Databases node icon

  • To add a database to the IDE:
    1. In the , right-click the Databases node and choose New Connection.
    2. Fill in the values for the database and click OK.
  • To add another type of datbase to the IDE
    1. Add a JDBC driver to the IDE
    2. In the Services window, right-click the Databases node and choose New Connection.
    3. Fill in the values for the database and click OK.

Number two
Connect database table to page

database-name node icon

  1. In the Services window, expand the Databases node.
  2. Expand the database-name node and the Tables Node.
  3. Drag the database table to the Visual Designer.

Number three
Define rowset content

rowset icon

  1. In the , double-click the table-nameRowSet item.
  2. In the Visual SQL Editor, if the SQL query is not correct, edit it.

Number four
Bind data to component

database table icon

In the Visual Designer, add the component to the page, then:

Number five
Set event handling

visual editor icon

  • Specify event handling for retrieving, updating, or deleting the data by double-clicking the component to open the Java Editor.

Legal Notices