Adam Bien's Weblog
Wednesday Dec 03, 2008
Netbeans 6.5: Nice "Hidden" Feature In The SQL Explorer
- Open the tab "Services" (Ctrl+5)
- Connect to a database
- Select a table and invoke "View Data" from the context menu
- The data will be displayed in a table.
- Right click on row in the table. A context menu with "Insert Record", "Delete Recort" ...Show SQL Script etc. should open. These are actually useful functions which create Insert, Update, Delete and even create statements for you. The create statements are not always syntactically correct (they sometimes end with a comma), but useful anyway.
Posted at 09:38AM Dec 03, 2008 by Adam Bien in Netbeans | Kommentare[4]
[my tweets] 
Rss My book: Real World Java EE - Rethinking Best Practices
Indeed, the editing features in the table view are rather helpful, but more than that I am just happy to see the ability to store SQL Command sheets appear in recent NetBeans builds. This is something that has been missing for way too long... ;)
K.
Gesendet von Kristian am December 03, 2008 at 10:12 AM CET #
prety informative screencast on topic:
http://netbeans.tv/screencasts/NetBeans-6.5%3A-Database-Support-Improvements-403/
the screencast demonstrates at around 4:45 the SQL History (also a well hidden gimmic ;-))
Gesendet von mbien am December 03, 2008 at 10:46 AM CET #
I still miss a visual designer to design database tables. Afterwards it should be possible to make this tool create your database entities.
How do u solve this requirement?
Gesendet von Daniel am December 04, 2008 at 04:33 PM CET #
Hi,
This would make a fantastic contribution to the NB Community Docs wiki. Could you please submit it?
Thanks a lot,
--James Branam
Gesendet von James Branam am December 09, 2008 at 11:25 AM CET #