Results 1 to 6 of 6
  1. #1
    bs3ac is offline Member
    Join Date
    Oct 2009
    Posts
    10
    Rep Power
    0

    Red face Java Program Using Databases For Uni Project!

    Hi guys

    Wondering if anyone could be kind enougth to give me some advice regarding a project i am planning for my final year at uni studying Computer Science.

    I have to make a program for a film store which enables the staff to store information regarding customers, films etc.

    I have made a program using java which requests customer info (age, name, address, etc) and the same for movies (titles, ratings etc).

    I have also created a databse to store the diffrent movies avaliable (movie name, quantity etc) using Access.

    The trouble i am having is linking the program to the database for example if i have a GUI which asks for the searched movie title how can i get the java program to interact with the database to retieve data? (i know i will have to use SQL somewhere down the line) but the trouble im having is finding out exactly how to link the database to the program and where to use the SQL coding to perform actions!

    Any help will be much appreciated guys.

    Thankyou!

    Sam :o

  2. #2
    mrmatt1111's Avatar
    mrmatt1111 is offline Senior Member
    Join Date
    Aug 2009
    Location
    San Jose, CA, USA
    Posts
    320
    Rep Power
    5

    Default

    I would suggest taking a course on database's before your final year. It is immensely useful after college. In the mean time, i would look up JDBC and how to use it, and pick a free database server like MySQL or Postgre.
    My Hobby Project: LegacyClone

  3. #3
    bs3ac is offline Member
    Join Date
    Oct 2009
    Posts
    10
    Rep Power
    0

    Default Hi

    Thanks, im currently taking a module focusing souly on databases and so am gaining an understanding of them.

    The project starts in our second semester so im basically preping for it :D

    Its just the linking of the database to interact with my program that i have no knowledge of and am trying to gain understanding on how to do this.

    :o

  4. #4
    Fubarable's Avatar
    Fubarable is offline Moderator
    Join Date
    Jun 2008
    Posts
    19,316
    Blog Entries
    1
    Rep Power
    26

  5. #5
    bs3ac is offline Member
    Join Date
    Oct 2009
    Posts
    10
    Rep Power
    0

    Default

    Sorry, i posted my first comment then realised it was better suited under the netbeans thread.

    Wont happen again :D

  6. #6
    Eranga's Avatar
    Eranga is offline Moderator
    Join Date
    Jul 2007
    Location
    Colombo, Sri Lanka
    Posts
    11,372
    Blog Entries
    1
    Rep Power
    19

    Default

    Quote Originally Posted by bs3ac View Post
    Sorry, i posted my first comment then realised it was better suited under the netbeans thread.

    Wont happen again :D
    In later if you want to move your thread into different location, please don't do this. Contact one of our moderators. They'll do it for you. :)

Similar Threads

  1. OOP design and Databases.
    By idefix in forum New To Java
    Replies: 4
    Last Post: 10-06-2009, 09:52 AM
  2. struts 2 and databases
    By rantravee in forum Web Frameworks
    Replies: 1
    Last Post: 12-23-2008, 06:59 AM
  3. how to use XML databases
    By paty in forum XML
    Replies: 3
    Last Post: 08-16-2008, 12:11 AM
  4. Recommendation about databases
    By tommy in forum JDBC
    Replies: 2
    Last Post: 07-28-2007, 05:04 AM
  5. multiple databases
    By varunthecool in forum JDBC
    Replies: 2
    Last Post: 07-09-2007, 08:06 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •