Visual Web JSF Database Tasks: Quick Reference

See Also

This topic describes common tasks that you can perform with database connections, often by clicking the Databases node Database node icon in the . For more detailed information, click the links in the right column.

To perform this task... Follow these steps
Add a database connection to the Services window
  1. In the   , right-click the Databases node and choose New Connection.
  2. In the New Database Connection dialog box, specify the database information.
  3. Click OK.
Add a database table to a Visual Web JSF page
  1. In the , expand the Databases node.
  2. Expand the database-name node.
  3. Expand the Tables node.
  4. Drag the database table into the Visual Designer.
Add a JDBC driver
  1. In the  , expand the Databases node, right-click the Drivers node Drivers node, and choose New Driver.
  2. In the New JDBC Driver dialog box, type the name of the new driver file.
  3. Click OK.
Bind data to list components (such as Listbox) in the Basic category of the Palette
  1. Drag the database table from the   and drop it onto the page.
  2. Right-click the component to which you want to bind the data and choose Bind to Data.
Bind data to simple components (such as Button) in the Basic category of the Palette
  1. Drag and dop the database table from the   onto the Visual Designer.
  2. Right-click the component to which you want to bind the data and choose Bind to Data.
  3. In the Bind to Data dialog box, choose the data provider and data field to which the bind the component.
Bind data to a Table component
  1. Add the Table component to the page.
  2. Drag the database table from the   to the Visual Designer and drop the database table onto the Table component.
  3. If necessary, set the table layout.
Create an SQL query
  1. Add a database table to a Visual Web JSF page.
  2. In the , right-click the table-nameRowSet item and choose Edit SQL Statement.
  3. In the Visual SQL Editor, edit the query.
Delete a JDBC driver
  1. Make sure the database is disconnected.
  2. In the  , expand the Databases > Drivers nodes and then right-click the driver-name node and choose Delete.
  3. Click Yes.
Delete a database table from the page
  • In the Navigator window, right-click the table-nameRowSet item and choose Delete.
  • In the Navigator window, right-click the table-nameDataProvider item and choose Delete.
Edit a JDBC driver
  1. In the  , expand the Databases > Drivers nodes and then right-click the driver-name node and choose Customize.
  2. In the New JDBC Driver dialog box, type the name of the new driver file.
  3. Click Close.
Modify database connection properties
  1. In the  , expand the Databases node.
  2. Right-click the database-name node and choose Properties.
  3. Modify the database connection information and click Modify.
Remove a database connection
  1. In the Services window, expand the Databases node
  2. Right-click the database-name node and click Delete
View data in a database table
  1. In the  , expand Databases > database-name > Tables, and then right-click the database table name, and choose View Data.
  2. If desired, in the Query window, modify the query to specify the data to retrieve.
  3. Click the Run SQL button in the toolbar.
See Also
About Components and Data
About Components
About Binding Components to Data
Working with Databases with Visual Web JSF Applications

Legal Notices