Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa JSP-Servlet Java project in online examination system
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


moiza sayyed
Java project in online examination system
1 Answer(s)      3 years and 9 months ago
Posted in : JSP-Servlet


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


Advertisement
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 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...://www.roseindia.net/jsp/online-quiz-application-jsp.shtml
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  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 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
java project
java project  how many tables are required in backend for online examination system project in jsp If backend is SQL
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 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
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 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
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
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
i-election voting system project in java
i-election voting system project in java  I want source code and documentation project in java. send
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
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
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
 

 

 

DMCA.com