I'm rather new to Java and JavaScript, so if this question has been answered
before, please bear with me.
I've written a simple test program for a class project. It will ask ten
questions, provide four answers for each question, allow the user to select
an answer and at the end of the test it will give the correct answers to all
the questions as well as the user's answers and score. As is, it works but
needs tweaking.
Now for my question; I think this program could be quite useful to my fellow
students if it could be expanded a little. I was thinking, if the questions
and answers could be retrieved from a database, such as Access, it would be
much easier to add, modify, delete etc. the questions and the program could
be used for more than one subject.
My question is, what would be the best way to directly interact with Access
from Java. Can it even be done? I've played a bit with JavaScript - Perl
and the Server Side scripting thing, but what I'm hoping to do is develop
something that won't require server access ... ie. the database can be kept
on your local drive.
Any suggestions are welcome.
When I get this thing working, I'm planning to offer it free to anyone who
wants it. The original Java program works now, but it uses five arrays and
a switch statement and only accepts ten questions and answers. It could be
expanded, but it would be very unhandy to use as is for more than
twenty-five questions or so.