Results 1 to 5 of 5

Thread: How to configure database in NetBeans 6?

  1. #1
    Join Date
    Apr 2010
    Posts
    84

    How to configure database in NetBeans 6?

    I have recently started studying about the NetBeans. I am practicing on NetBeans 6.8. I am trying to configure database in NetBeans but I am not able to do it. So thought that there would be someone who might be interested in helping me.!! The important thing that I want to know is how to configure database in NetBeans 6? Since, I am novice in this topic explain me in details.

  2. #2
    Join Date
    Dec 2008
    Posts
    161

    Re: How to configure database in NetBeans 6?

    We may use any database at our disposal for this course. What follows is an example using the database "Java DB" included in NetBeans 6.x JavaDB is a database designed for small, lightweight development. We will create a database, create tables and insert rows to the test. The table creation script and lines so you can use in any database you choose to use. Top of the database
    1. In NetBeans IDE, go to windows menu> Services
    2. Select the node "Java DB"> right click> Start server
    3. The database server is now running

  3. #3
    Join Date
    Jan 2006
    Posts
    211

    Re: How to configure database in NetBeans 6?

    The following steps would be useful for creating the database :
    1. Select the node "Java DB"> right click> Create database
    2. Complete the form below:
      1. Database Name: myideas
      2. User Name: myideas
      3. Password: myideas
      4. Click Ok
    3. The database is created.

  4. #4
    Join Date
    Apr 2008
    Posts
    193

    Re: How to configure database in NetBeans 6?

    I am trying to explain you to connect to the database...
    1. Select "jdbc:derby://localhost:1527/myideas"> right click> Connect ...
    2. We are connected to the database.

    From here we can create tables, queries and other tasks.

  5. #5
    Join Date
    Mar 2008
    Posts
    232

    Re: How to configure database in NetBeans 6?

    We will be a console to forfeit SQL querys. To do this, right click on the link> Execute command. Copy and paste the following SQL commands in the console, and click on the icon "Run SQL" (Ctrl + Shift + E).
    Code:
     create table name(id_name numeric (8) primary key, name varchar (50));
    Code:
    create table PROVINCE (
      id_province numeric (8) primary key,
      id_name numeric (8)
      name varchar (50)
     );
    Code:
     insert into countries values (1, 'India');
    
     insert into STATE values (1, 1, 'Maharashtra');
     insert into STATE values (2, 1, 'Assam');
     INSERT INTO states VALUES (3, 1, 'Kerela');
     insert into STATE values (4, 1, 'Orissa');
     insert into STATE values (5, 1, 'Punjab');
     insert into STATE values (6, 1, 'Jammu & Kashmir');
     insert into STATE values (7, 1, 'Madhya Pradesh');
     insert into STATE values (8, 1, 'Gujarat');
    Open a SQL console (right click on the link> Execute command ...), and run the following queries (separately):
    SELECT * FROM PROVINCE
    select * from COUNTRY
    Should return the data we just inserted.

Similar Threads

  1. How to install Netbeans 6 on N900
    By MindFu@er in forum Portable Devices
    Replies: 5
    Last Post: 22-01-2011, 12:14 AM
  2. How to install NetBeans 6.8?
    By Cheng-Gong in forum Software Development
    Replies: 11
    Last Post: 11-08-2010, 11:30 AM
  3. From JCreator to NetBeans
    By Messenger in forum Software Development
    Replies: 6
    Last Post: 29-07-2010, 10:28 AM
  4. Basics of NetBeans IDE
    By - Empty Shell - in forum Software Development
    Replies: 4
    Last Post: 14-02-2010, 04:56 AM
  5. How to connect ms Access Database with the Netbeans 5.5
    By Joko in forum Software Development
    Replies: 2
    Last Post: 23-09-2009, 09:49 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,662,982.39758 seconds with 17 queries