Developing Database Applications : MySQL and JavaDB and Visual Database Explorer
posted Saturday, 1 December 2007
A really nice tutorial, Connecting to a MySQL Database, demonstrates how to configure the MySQL database server on your computer and set up a connection to it from NetBeans IDE. Once connected, you can begin working with MySQL in the IDE's Database Explorer by creating new databases and tables, populating tables with data, and running SQL queries on database structures and content. This tutorial is designed for beginners with a basic understanding of database management and application
|  Select to enlarge. | development, who want to apply their knowledge to working with MySQL in NetBeans IDE. The tutorial shows you how to installand configure MySQL, connect to MySQL from NetBeans IDE, create a database instance, connect to the database instance, create database tables, work with the table data and run the SQL scripts. You can read a more general tutorial, Connecting to Databases, which explains the basics of creating a connection to a database in the IDE that you can then use in your project. This more general tutorial shows you how to set up your resources, connecting to databases, working with a database connection and setting up a database connection tool. Finally if you are working with JavaDB there is a nice tutorial, Working with the Java DB Database in NetBeans IDE, which demonstrates how to set up a connection to Sun's Java DB (which is based on the Apache Derby database) in NetBeans IDE. Once a connection is made, you can begin working with the database in the IDE, allowing you to create tables, populate them with data, run SQL queries, and more. Want to see something cool ? Toni Epple has done some nice work with a Visual Database Explorer, which provides a nice visual representations of your database. Also read Geertjan's write-up on this here. |
links: digg this del.icio.us technorati