Java project in online examination system

Java project in online examination system

how many and which tables are required at backend as SQL for online examination system project in jsp

View Answers

January 22, 2011 at 12:29 PM

Hi Friend,

Simply, there would be 6 tables. Each table consists of different questions. Give them names as set1, set2, set3,answers1,answers2,answers3. The format of all the tables would be same. Same fields are there.

table set1(ques,op1,op2,op3,op4,ans) and table answers1(id,ans).

table set2(ques,op1,op2,op3,op4,ans) and table answers2(id,ans).

table set3(ques,op1,op2,op3,op4,ans) and table answers3(id,ans).

In the above tables, ans field of each set should be equal to the ans field of answers respectively.

But, you have to select the table names randomly. Accordingly, retrieve the data from the table. This will provide different questions to different students at a time.

For selecting table randomly, you use the following code:

String[] tables = { "set1", "set2", "set3"};
        Random r = new Random();
        int s=r.nextInt(tables.length);
        String tt = tables[s];

Then use the variable 'tt' in your query.

Hope that it will be helpful for you.

Thanks









Related Tutorials/Questions & Answers:
Java project in online examination system
Java project in online examination system  how many and which tables are required at backend as SQL for online examination system project in jsp
online examination system project in jsp
online examination system project in jsp  How many tables are required in SQL for online examination system project in jsp in java
Advertisements
online examination system project in jsp
online examination system project in jsp  How many tables are required in SQL for online examination system project in jsp in java my email id
online examination system project in jsp
online examination system project in jsp  How many and which data tables are required for online examination system project in jsp in java. please give me the detailed structure of each table
online examination system project in jsp
online examination system project in jsp  How to show the status bar which shows how much time is remaining in online examination system in jsp.my
online examination system project in jsp
online examination system project in jsp  thanks for providing me 6 tables for online examination system. I want to know what will the id field of Answers1 table contain? Will it contain same id for all the questions of Set1 &
online examination system project in jsp
online examination system project in jsp  thanks for providing me 6 tables for online examination system. I want to know what will the id field of Answers1 table contain? Will it contain same id for all the questions of Set1 &
online examination system project in jsp
online examination system project in jsp  Thanks for providing me the 6 tables.But I want to know will the id field of answers1 table be same for all questions of Set1? Will it be 1 or will be 1,2,3,... What
online examination system project in jsp
online examination system project in jsp  I am doing project in online examination system in java server pages. plz send me the simple source code in jsp for online examination system
online examination system mini project
online examination system mini project  i developed a project on online examination system using jsp and java script . I am getting the quetion... with the marks secured in a table format by using java script.could you please help me
Online Examination System
Online Examination System  Hi.. I have to create a Online Examination system using struts, Hibernate and stateful session beans.. I Wanna know the use of stateful session beans in project
servlet doubt on online examination system
servlet doubt on online examination system  hai. sir ,i am doing project in online examination system. taken back end as mysql database. and doing the programs using java servlet. MY PROBLEM and doubt is 1. how 2 skip
online examination
online examination  Hi, i am doing online examination project, i have some problem with get a paper form database and count the right answer and display the result. So, i request to you please help me come out to this problem
Online Test System Project
Online Test System Project  I want a full ready-made project on online test system in jsp. i am not using servlet but only jsp.And backend database...://www.roseindia.net/jsp/online-quiz-application-jsp.shtml
online project tracking system
online project tracking system  hello sir , I chintan patel and my question is as under how to assign project for admin to project manager in jsp servlet project my project name is "online project tracking system " and i am
Online Test System Project
Online Test System Project  I want a full ready-made project on online test system in jsp. i am not using servlet but only jsp.And backend database as mysql. my email address is help me. send a full project on online test system
online examination
online examination  coding for multiple choice question in jsp   We are providing you a simple application. Create table test...: http://www.roseindia.net/jsp/online-quiz-application-jsp.shtml
SECURE EXAMINATION SYSTEM
SECURE EXAMINATION SYSTEM  Hello sir,if any online exam is held... by one within countdown session that is within timer out.If the system failure... can continue his exam on another system with the same username and password
How to insert and retrieve Questions with special symbols and images into database in an ONLINE EXAMINATION project?
How to insert and retrieve Questions with special symbols and images into database in an ONLINE EXAMINATION project?  Hi guys. I am developing an online examination application. I am using JSP,MYSQL and ECLIPSE .The problem
On line examination project
On line examination project  Hi, I am doing project in jsp,nam eis online examination project. I am facing some problems. In my database several...-Servlet/7578-creation-of-a-form.html http://www.roseindia.net/jsp/online-quiz
online voting system source code in java
online voting system source code in java  Please send me source code for online voting system in java. please replay as fast as. Thank you
online test system
/online-quiz-application-jsp.shtml http://www.roseindia.net/answers/viewqa/JSP-Servlet/15400-online-examination-system-project-in-jsp.html http...online test system  Hi, I am creating a project for online test
java project
java project  how many tables are required in backend for online examination system project in jsp If backend is SQL
on-line examination project?(urgent pls)
on-line examination project?(urgent pls)  Hello friends, i am doing an on-line examination project. In A page i will get n(user requirement) questions from data base(question and five radio buttons) if the user had
Online performance system
Online performance system  hi m developing Online performance system in which two types of test would be there based on two subjects and i want... be created by the system , by automatically selecting the questions from database
online shopping project in java - JDBC
online shopping project in java  hii, i am doing a project online... as the project runs or should I open connections only when I am required to retrieve... as long as the project runs but close the statement after the execution of each
Should we go for javascript or applets for online exam project using java
Should we go for javascript or applets for online exam project using java  Hi, I am new to java and i am working on online examination project.As soon as the candidate login successfully a window pop up should appear
online shopping project report with source code in java
online shopping project report with source code in java  Dear Sir/Mam, i want to a project in java with source code and report project name online shopping. thank you
i-election voting system project in java
i-election voting system project in java  I want source code and documentation project in java. send
Project on mailing system using Java/JSP
Project on mailing system using Java/JSP  I am making a project on mailing system in Java/JSP. How could I display the inbox messages on the home page of user? Please tell me about how to handle these messages in database
Java Project for College Admission System - Java Beginners
Java Project for College Admission System  I want Project for Student Information System in Java Back end-MS Access plz Give Me source code or website to download it. plz Help Me
online test project on java using servlets and jsp
online test project on java using servlets and jsp  as i am doing online test project on java using jsp and servlets ,,,the problem is in the code of jsp file which i have sent,...,i used next and previous buttons and used two
College Student Admission System Project in Java
College Student Admission System Project in Java   Front End -JAVA Back End - MS Access Hello Sir, I want College Student Admission Project in Java with Source code, that includes Following Forms 1) Student Admission based
online test project
online test project  i need online test project in java using struts...kindly help..   Have a look at the following link: http://www.roseindia.net/struts/struts/struts2.2.1/onlinetestapp
online shopping project
online shopping project  Hi, i want online shopping project modules description and screens
online shopping project
online shopping project  Hi, i want online shopping project modules description and screens
Online project management degrees
Online project management degrees  Is there any Online project management degrees course available? What are the duration of the course? Thanks   Hi check the page Online Business Management Degree. Thanks
Java Project for College Admission System - Java Beginners
Java Project for College Admission System  Hello Sir I urgently wants College Admission Project in Java,with Back End Microsft Access 2007 ,sir plz Give me Full Source Code.  Could u give me the filed should
Online quiz mini project
Online quiz mini project  Sir i need a online quiz program coding using java servlet, jdbc odbc connection with ms. access. If possible send that source code to me. Thank you
online shopping project
online shopping project  sir, plz can u send me the coding of simple application of online shopping cart project using jsp and servlets which should be run in netbeans without any errors
Online quiz mini project
Online quiz mini project  Hi. I follow one of the code for "Online quiz mini project". I would like to know how to count the number of wrong answers in jsp
student admission system project
student admission system project  College Student Admission System Project in Java Front End -JAVA Back End - MS Access Hello Sir, I want College Student Admission Project in Java with Source code, that includes Following Forms
project for Student Admission System
project for Student Admission System  I want Mini Java Project for Student Admission System. actually i want 2 know how 2 start this...please show me my way
online shopping project
online shopping project  dear sir/madam,i am uday pratap singh. i need online shopping project description with code. i also want which type of question arises in interview from the current project. please send detail about
library management system jsp project
library management system jsp project  i need a project of library management system using jsp/java bean
library management system jsp project
library management system jsp project  i need a project of library management system using jsp/java bean
library management system jsp project
library management system jsp project  i need a project of library management system using jsp/java bean
CAN U HELP ME TO CODE IN JSP FOR ONLINE VOTING SYSTEM
CAN U HELP ME TO CODE IN JSP FOR ONLINE VOTING SYSTEM  can u help me to code in jsp for online voting system
online shopping project
online shopping project  can you plz send the source code of online shopping application developed with the help of struts 1.2, hibernate and sql , jsp   Please visit the following link: Struts Shopping Cart
Online Open Source Billing System Software
Online Open Source Billing System Software   ... about the Online Open Source Billing Software System. Articles discussed here... to another company. Online Open Source billing software system helps

Ads