Java Program Using Databases For Uni Project!

[bs3ac]

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

[mrmatt1111]

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.

[bs3ac]

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

[Fubarable]

OP, please no double posts. Cross-post has been closed. Thanks for your cooperation.

[bs3ac]

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

Wont happen again :D

[Eranga]

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. :)