how can i create an online quiz using java and sql as the database.?

Question

database
-----------
question number
question
answer 1
answer 2
answer 3
answer 4
correct answer
it should have a timer besides

Answer 1

Other than the timer, which you could do in java, the rest would be much easier with PHP.

go to http://www.hotscripts.com and do a search for quiz software, you will find many. Even if yo do not plan on using it, you can at least study the code and learn from there.

With PHP, you can have the question be in a form. When they submit the answer, if it is wrong, they do not get a point and it goes to the next question, if they are right, it adds +1 to the points variable and moves on. You can do a lot more than that with PHP, it's the best way to go with mysql, or any sql for that matter.

Answer 2

Long question. The short story is, create the following:

Table to hold questions
Table to hold users
Table to hold user-question link (creates series of questions for each user)
Table to hold results

Now build a set of JSPs exposing these and tie it back to using a few simple queries. Each time they submit the page, have it insert their answer in the user-question table. There are tons of examples of how to do this if you need further help, just search for something like "JSP query example".

Hope that gets you started.