JamesBranam's Blog
NetBeans 6.5: Viewing Data in a Database Table
Hi all,
NetBeans IDE lets you easily view data in a database. Here's how:
When a database is connected, you can execute an SQL statement in the IDE to view the data contained in a table.
To view data in a table:
- In the Services window, expand the node for a connected database.
- Expand the Tables or Views node.
- Right-click the node of the table or view and choose View Data.
When you choose View Data, an SQL query to select all the data from the table is automatically generated in the upper pane of the SQL Editor. The results of the statement are displayed in the lower pane of the SQL Editor. You can modify the statement in the SQL Editor and run the modified statement by clicking the Run SQL button in the toolbar.
For more on using the SQL Editor, see the helpset.
Note: Each column node has the same View Data item in its pop-up menu. This feature is similar to the feature for tables; however, when you view tables, the SQL statement for viewing data fetches only the one column rather than the entire set of columns that the IDE displays when you choose View Data. See you tomorrow--James
Posted at 09:00AM Oct 15, 2008 by branajam in NetBeans |