hey am creating a quiz(examination) which randomly selects questions from a database,and each question has 4 options,out of which 1 is correct.....also i need to show the final result of the number of ques correctly answered,wrong and those not attempted....

im at loss at MySql...don't know how the design of the database should work out..no idea whatsoever.....

am using jdbc,prpeared statements etc etc....

please a little help with the database!!

6 Years
Discussion Span
Last Post by nohup


well I'm trying to create an offline quiz using java...i have created the database...i have created the whole layout....

problem is jdbc..i have no idea how to make it work....

I'm using WAMPSERVER to create a database using MySql...have done that succesfully...now trying to connect the database to my java project and am unable to do so

ive downloaded the MySql connector( environment variable reads :" .;C:\Program Files\Java\jre6\lib\ext\QTJava.zip;C:\mysql-connector-java-5.1.13\mysql-connector-java-5.1.13-bin.jar; " )

i have no idea what a DSN name is...i googled for some help,created a txt file DSN...

just need a small programme that shows how to connect the database to any java proggrame using jdbc.odbc.JdbcOdbc driver....
(i wanna figure out the database connection with my project bymyself)

any proggrame will do..a simple "connected" if connection is succesfull with my database will suffice...please help me!!!


I would suggest to save in a table, the question, the options and the correct answer as columns.
Then query the table into an ArrayList for example and randomly select an element. Use Math.random()*list.size()

Were exactly are you having problems?


well the main problem is that i have WAMPSERVER installed,,,,,i created a database....but i just dont get jdbc....i dont know how to link the database with my proggrame.....where is the database stored....no idea.... :(:(


Have you really read the above mentioned examples and tutorials and still are at a loss?

Well...regarding the connection to a MySQL database it all boils down to this:

Your database server, when started, listens to a port (by default 3306) on your PC (localhost).
The connection string for MySQL is: "jdbc:mysql://{host}:{port}/{dbname}.
So, if you wanted to connect to the database "mydb" on your server, as the user "a_user" with the password "a_password", you would use:

Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb","a_user", "a_password");

If you have got mysql-connector, as you said, then you already have access to the class "com.mysql.jdbc.Driver".

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.