---

CREATING DATABASE USING NETBEANS

Actually,Netbeans 6.0 provide database service,Derby. Derby is the open source database being developed as part of the Apache DB Project.

1.To create a database from Netbeans is very easy. Select Tools > java DB Database > Create Database...as shown below:

picture1

2.You will see a window with caption "Create java DB database " .Fill the asked information in that as shown below for example.

picture2

Click OK button.
3.Right click on Databases>jdbc:derby://localhost:1527/mydb(scott on SCOTT),and click on connect to connect to database.

picture3

4.To create any table in your created database,right click on Tables and select "create table" as shown below:

picture4

5.you will be encountered with a "create table" window. Fill it as shown below for example:

picture5

6.To insert data into created table Right click on Tables>"name of table created"(here "employee") and select view data as shown below:

picture6

7.SQL command editor will appear on the right side. write insert command as shown below for example:

picture7

8.To execute your SQL command press Ctrl+Shift+E.You can see the execution details on output window as shown below:

picture8

9.To view the data in the table Right click on Tables>"name of table created"(here "employee") and select "view data" as shown below:

picture9

10.Select command will appear for that table. Also you can modify that command according to your needs.To execute your SQL command press Ctrl+Shift+E.You can watch the table under INS window as shown in picture below.

picture10

FrontPage http://www.google.com/

Attachments