Java project in online examination system

Ads
 

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

Ads









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 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  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
java project
java project  how many tables are required in backend for online examination system project in jsp If backend is SQL
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
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
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 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
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
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
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 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
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 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
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

Ads