Working With Data Sources

Add data source to the IDE

• To add a single data source to the Servers window:
   
  
• In the Servers window, right-click the Data Sources node and choose Add Data Source.
   
  
• Fill in the values for the database and click Add.
   
  
• To add a set of data sources exported by another developer:
   
  
• In the Servers window, right-click the Data Sources node and choose Import Data Sources.
   
  
• Find the exported database file and click Open.
   
  

Connect database table to page

1. In the Servers window, expand the Data Sources node.
    
   
2. Expand the data-source-name node and the Tables Node.
    
   
3. Drag the database table or view to the Visual Designer.
    
   

Define rowset content

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

Bind data to component

• Bind data to a simple component, such as a Button.
   
  
• Bind data to a list component, such as a Listbox.
   
  
• Bind data to a Table component.
   
  

Set event handling

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