Results 1 to 3 of 3

Thread: Derby tutorial with netbeans

  1. #1
    Join Date
    May 2009
    Location
    Close to your Heart
    Beans
    137
    Distro
    Ubuntu 12.04 Precise Pangolin

    Cool Derby tutorial with netbeans

    Hello there.

    I am a newbie java programmer. I am trying to use the derby database offered with netbeans. i have create a database but how do i do the following

    1) access database elements from a cli java application.
    a) how to create rows from the application and do queries.
    2) access multiple tables. i.e relational database. (preview a query in a table instead of a single table.)



    i came from c++ and it seems like the world is 10 times the size here!.

    if you have a simple derby tutorial explaining all tasks it would be awesome.

    thanks in advance.

  2. #2
    Join Date
    May 2007
    Location
    Leeds, UK
    Beans
    1,664
    Distro
    Ubuntu 13.10 Saucy Salamander

    Re: Derby tutorial with netbeans

    Java applications access relational databases like Derby, MySQL or Oracle using a common API called JDBC, so you need to look for JDBC tutorials. Accessing any database through JDBC is basically the same, although the URL you use for connections differs.

    The main interfaces/classes in JDBC that you will be dealing with are Connection and Statement, with Resultset if you are querying.

    Rather than starting with Derby, I'd suggest setting up MySQL so that you can use the client tools (MySQL Query Browser for example) to examine what you are doing and fiddle with test data.

  3. #3
    Join Date
    May 2009
    Location
    Close to your Heart
    Beans
    137
    Distro
    Ubuntu 12.04 Precise Pangolin

    Re: Derby tutorial with netbeans

    Quote Originally Posted by r-senior View Post
    Java applications access relational databases like Derby, MySQL or Oracle using a common API called JDBC, so you need to look for JDBC tutorials. Accessing any database through JDBC is basically the same, although the URL you use for connections differs.

    The main interfaces/classes in JDBC that you will be dealing with are Connection and Statement, with Resultset if you are querying.

    Rather than starting with Derby, I'd suggest setting up MySQL so that you can use the client tools (MySQL Query Browser for example) to examine what you are doing and fiddle with test data.
    Thanks ... i almost forgot about posting here. I got a nice solution on the web about jdbc. And finally was able to use it with my program.

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
  •