urgent help for inserting database in a project



Share on Google+Share on Google+

kavneet rekhi
urgent help for inserting database in a project
0 Answer(s)      5 years ago
Posted in : JDBC

I need some urgent help i have made java application for conducting a quiz which displays 25 mcq's and then the result at the end.I need to add simple database connectivity to it just a single table i guess which would have sno,username result and percentage and order by percentage descending so that basically we can view the rank list at the end of all the participants here is my code:

import java.awt. *;
import java.awt. event.*;
import javax.swing.*;

class QuestionSeries{
static String info ="IT QUIZ  \n \nINSTRUCTIONS:\nThere are 25 questions in this test and 10 minutes to complete them all.\nThe finish button is highlighted in blue when you reach the end of the test. \nClicking the finish button will display the results with the correct answers marked in light red.  \n \nThe timecounter  begins when you click on the 'start' button \n \nBest of luck!\n\n";

static String []question ={"Question 1:\nWho invented Poking?\n",
"Question 2:\n This game was developed by a Finland based company for the iOS, Android and Symbian3 platforms. It even won the Crunchies'11 runners up award for the 'Best Time Sink Application'. A newer version of this game was recently launched, with no difference, but with monkeys. Identify the game.\n",
"Question 3: \n Lion is an OS by which company\n",
"Question 4:\n Ashish Kashyap is the CEO of which company?\n",
"Question 5:\n The world's first X invented by Tom Cranston, Fred Longstaff and Kenyon Taylor working on the Royal Canadian Navy's DATAR project in 1952. It used a standard Canadian five-pin bowling ball. Identify x\n",
"Question 6:\n This was invented by David Bradley and is known as the ?three-finger-salute?. What am I talking about?\n",
"Question 7:\n[W]e came across the word 'X', and it was just perfect. The definition was 'a short burst of inconsequential information? what am I talking about. ?\n",
"Question 8:\n What was the codename for ?Kinect for Xbox360\n",
"Question 9:\n What is the simplest and the most used encryption technique. It uses substitution\n",
"Question 10:\n Which of the following cannot be connected using PS/2 port\n",
"Question 11:\nWhat is Google's URL shortener called ?\n",
"Question 12:\n Which company owns Alexa?\n",
"Question 13:\n What would you call a list of contacts that the user deems are acceptable to receive e-mails from and should not be sent to the trash folder?\n",
"Question 14:\n What does the ISO-9660 standard relate to\n",
"Question 15:\nExpand MMORPG\n",
"Question 16:\n Who coined the term 'bit' and 'software\n",
"Question 17:\nHTML was originally a subset of another document-formatting standard. Name it\n",
"Question 18:\nIn PHP, the function 'ECHO' is the same as which other function?\n",
"Question 19:\nwhat is the name given to Android 4.0\n",
"Question 20:\n Shadow , Speedy , Bashful , Pokey are characters from which famous game?\n",
"Question 21:\n This programming language was published by Niklaus Wirth named in honor of a French mathematician and philosopher.\n",
"Question 22:\n What  is the name given to something that the  computer  will automatically use unless you tell it otherwise?\n",
"Question 23:\n PCI Stands for\n",
"Question 24:\n Linux kernel is written in? \n",
"Question 25:\n Which was the first computer virus?\n"

static String [][]answers ={{"Jerry Yang\n","Mark Zuckerberg\n","Sergey M. Brin\n","Eduardo saverin\n"},{"Winds of steel \n"," \n Angry Birds","Temple Run\n"," \n Replica Island\n"},{" \n Microsoft\n","Red hat \n","Apple \n","Oracle"},{" \n Ibibo \n","HCL \n"," \n TCS\n"," \n Yahoo\n"},{" \n Trackball\n"," \nMouse \n"," \n USB \n"," \n Joystick \n"},{" \n XYZ \n"," \nE-Mail\n"," \n Joystick \n","Ctrl+Alt+Del \n"},{" \nOrkut\n"," \nFacebook\n"," \nYoutube\n"," \nTwitter\n"},{" \nLady Bird\n"," \nPaxos\n"," \nProject Natal\n"," \n Paxos\n"},{" \nROT13\n"," \nWEP\n"," \n WPA \n"," \n Caesar Cipher \n"},{" \nMouse \n"," \nKeyboard\n"," \nJoystick\n"," \nTrackball\n"},{" \ndwarfURL.com\n"," \nTiny.cc\n"," \nBit.ly\n"," \nGoo.gl\n"},{" \nAmazon\n"," \nApple\n"," \nGoogle \n"," \nMicrosoft\n"},{" \nBlock list\n"," \n black lsit \n"," \nE-mail white list\n"," \nRealtor list\n"},{"Hard Disk \n"," \nData cable\n"," \nCD-Rom\n"," \n Mother Board\n"},{" \nMultimode online roller play games\n"," \nMy Mode of racing port game\n"," \nMassive,multiplayer or road play games\n"," \n Massively multiplayer online role playing games\n"},{" \nBarry Collin\n"," \nBill Gates\n"," \n2 Algore \n"," \n John Tukey\n"},{" \n Java\n"," \n SGML\n"," \nAJAX\n"," \nOASIS\n"},{" \nEdit\n"," \nRun\n"," \n Compile \n"," \n Print\n"},{" \nFroyo\n"," \nGingerbread\n"," \nIcecream Sandwich\n"," \n Honeycomb \n"},{" \n Contra \n"," \n Packman\n"," \nMario\n"," \nAladdin\n"},{" \nC\n"," \n Pascal\n"," \nJava\n"," \nCOBOL\n"},{" Specification\n"," \nWildcard\n"," \nDefault\n"," \n Rule\n"},{" Personal Computer Interface\n"," Peripheral Computer Interconnect\n","Peripheral Component Interconnect\n"," Peripherical Communication Interface\n"},{" \n C++\n"," \n C \n"," \n Java \n"," \n PHP \n"},{"Brain\n","Trojan\n","Melisa\n"," \n Bug \n"} };

static int []n = {2,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1};
static String []choice= {"2","2","3","1","1","4","4","3","4","3","4","1","3","3","4","4","2","4","3","2","2","3","3","2","1"};
static int tally = choice.length;
static String testtitle="Online IT Quiz";
static int timeLimit =10;
static int passMark = 15;

/* OnlineTest class */

public class OnlineTest extends JFrame{
    static String studentname ="";
    static int TOTAL=0;

    static {
    TOTAL = QuestionSeries.tally;       
    /*  The input window */
    studentname = JOptionPane.showInputDialog("Enter your name: ");
    if(studentname.length() < 1) studentname = "Anonymous   ";
    else studentname = studentname.trim() + " ";
    }catch(NullPointerException e){ System.exit(0); }

        int seconds, minutes;
        int quesnum, itemCheck, mark; 
    final String TESTTITLE = QuestionSeries.testtitle;
        final int TIMELIMIT = QuestionSeries.timeLimit;
        final int PASS = QuestionSeries.passMark;
        String []answers = new String[TOTAL];
    JButton []choice_button = new JButton[6];
    JTextArea answerboxes[] = new JTextArea[4];
    JCheckBox []boxes = new JCheckBox[4];
        JTextPane pane = new JTextPane();
    JLabel student, choose, message, timecounter, testresult;
        boolean start_test, check_answer, allowRestart, finishtest;
    Northwindow panelNorth = new Northwindow();
    Southwindow panelSouth = new Southwindow();
    Centerwindow panelCenter = new Centerwindow();

/*  OnlineTest Constructor */
    protected OnlineTest(){
        for (int i=0; i<TOTAL; i++) answers[i] ="";
        getContentPane().setLayout(new BorderLayout() );
        getContentPane().add("North", panelNorth);
        getContentPane().add("South", panelSouth);
        getContentPane().add("Center", panelCenter);
        int width = 0, height=0; 
            if(java.awt.Toolkit.getDefaultToolkit().getScreenSize().getWidth()<799){width=      640;        height=460; }
            else {width=720; height=540; }
        Dimension dim = java.awt.Toolkit.getDefaultToolkit().getScreenSize();
        setLocation((dim.width-width)/2, (dim.height-height)/2);

**  Northwindow class

class Northwindow extends JPanel{

**  Northwindow constructor 
    public Northwindow(){
        setLayout(new GridLayout(2,2));
        setBackground(new Color(230, 230, 255));
        student = new JLabel("\t Welcome : "+studentname+" to the Online IT Quiz");
        student.setFont(new Font("",Font.BOLD,16) );
        message = new JLabel();
        add(new JLabel("               ") );
        add(new JLabel("               ") );
        setBorder(BorderFactory.createEtchedBorder() );

**  Southwindow class
class Southwindow extends JPanel{
    public Southwindow(){
        String []key = {"","start:","next:","finish:","check next:","check previous:"};
            for(int i=0; i<choice_button.length; i++)
                choice_button[i] = new JButton(key[i]);
                choice_button[i].addActionListener(new ActionHandler() );
                if(i !=0)add(choice_button[i]);
        setBorder(BorderFactory.createEtchedBorder() );

**  Centerwindow class 
class Centerwindow extends JPanel{

    public Centerwindow(){
        setLayout(new GridLayout(1,2) );
        JScrollPane west = new JScrollPane(pane);       
        pane.setFont(new Font ("monospaced",0,12) );
        JPanel east = new JPanel();
        east.setLayout(new BorderLayout() );    
        JPanel northEast = new JPanel();
        northEast.setBackground(new Color(230, 230, 255) ); 
        east.add("North", northEast);
        JPanel westEast = new JPanel();
        westEast.setLayout(new GridLayout(6,1) );
        east.add("West", westEast);
        JPanel centerEast = new JPanel();
        centerEast.setLayout(new GridLayout(6,1) );
        centerEast.setBackground(new Color(255,255,200));
        east.add("Center", centerEast);       
            timecounter = new JLabel("     There are "+TOTAL+" questions in total");
            timecounter.setFont(new Font ("Arial",Font.BOLD,16) );
            timecounter.setForeground(new Color(0,90,20) );
            westEast.add(new JLabel(" "));
        String []boxs = {" A ", " B ", " C ", " D "};
            for(int i=0; i<boxes.length; i++) { 
                boxes[i] = new JCheckBox(boxs[i]);
                boxes[i].addItemListener(new ItemHandler() );
        westEast.add(new JLabel() );
        choose = new JLabel("    CHOOSE CORRECT ANSWERS");
        choose.setBorder(BorderFactory.createEtchedBorder() );
        JScrollPane panes[] = new JScrollPane[4];
            for(int i=0; i<answerboxes.length; i++){
                answerboxes[i] = new JTextArea();
                answerboxes[i].setBorder(BorderFactory.createEtchedBorder() );
                answerboxes[i].setFont(new Font("",0,12) );
                panes[i] = new JScrollPane(answerboxes[i]);
        if(TIMELIMIT >0)testresult = new JLabel(studentname+",   You have only : "+TIMELIMIT+" minutes to complete.");   
        else testresult = new JLabel("     There is no time limit for this test");
        testresult.setBorder(BorderFactory.createEtchedBorder() );

**  ActionHandler class to handle all the action events from the buttons. 

class ActionHandler implements ActionListener{

/* actionPerformed method */
    public void actionPerformed(ActionEvent evt){
      String source = evt.getActionCommand();
            if(TIMELIMIT >0)new Timer(); // inner Timer class 
            panelSouth.remove(choice_button[1]); //start
        if(source.equals("previous:"))  {                       
            if(quesnum ==  -1) quesnum=TOTAL-1;
        if(source.equals("next:")) {
            if(quesnum ==  TOTAL-1) finishtest=true;
            if(quesnum ==  TOTAL) quesnum=0;
        if(source.equals("finish:")) {
            if (finishtest){
                quesnum = 0;

                timecounter.setFont(new Font ("Arial",0,14) );
            else  JOptionPane.showMessageDialog(null,"Cycle through all questions before pressing finish",
                                                                 "User Message",JOptionPane.INFORMATION_MESSAGE);

    if (check_answer){
        if(source.equals("check next:")) {
            if(quesnum ==  TOTAL) quesnum=0;
        if(source.equals("check previous:")) {
            if(quesnum ==  -1) quesnum=TOTAL-1;

/* Timer class */

class Timer extends Thread implements Runnable{
    public Timer(){
        new Thread(this).start();

    public void run() {
            try {
                if(seconds % 60 == 0 && seconds != 0){
                    seconds -= 60;
                timecounter.setText("    Time Counter:  "+minutes+" mins : "+seconds+" secs ");
            catch(InterruptedException ex)  { System.out.print(ex); }

/* checkteststatus method */

        public void checkteststatus(){
        if((quesnum ==  TOTAL-1)&&(start_test))choice_button[3].setBackground(Color.green);
        else choice_button[4].setBackground(Color.lightGray);
          if(answers[quesnum].length() >0){ 
            for(int i=0; i<answers[quesnum].length(); i++)
            boxes[Integer.parseInt(answers[quesnum].substring(i,i+1) )-1].setSelected           (true);
        else for(int i=0; i<boxes.length; i++)boxes[i].setSelected(false);

/* displayquestion method */

    public void displayquestion(){
        int j = quesnum+1;
        if(start_test)message.setText("Question "+j+" out of "+TOTAL);
        for (int i=0; i<4; i++)answerboxes[i].setText(QuestionSeries.answers[quesnum][i]);
            String temp="";
            if(QuestionSeries.n[quesnum]==1) temp="<html>   Choose only         <b>ONE</b>  Option</html>";
            else if(QuestionSeries.n[quesnum]==2) temp="<html>  Choose <b>TWO       </b> Options</html>";
        else if(QuestionSeries.n[quesnum]==3) temp="<html>  Choose <b>THREE</b>         Options</html>";
            else temp="<html>  <b>ALL are true</b> true</html>";
        else {
        timecounter.setText("    Your choices are shown in the boxes");
            choose.setText("    Correct answers are marked in light red.");

/* record answer method */

    public void recordanswer(){
        String tmp = "";
        for(int i=0; i<boxes.length; i++) if(boxes[i].isSelected() ) tmp +=i+1;
        answers[quesnum] = tmp;

/* endTest method */ 

    public void endTest(){
        message.setText("TIME OVER: please press 'finish'");

/* mark_ques() method to highlight correct answers */

    public void mark_ques(){
        for(int i=0; i<answerboxes.length; i++) answerboxes[i].setBackground(Color.white);
        for(int i=0; i<QuestionSeries.choice[quesnum].length(); i++)
        if(QuestionSeries.choice[quesnum].equals(answers[quesnum])) message.setText("Answer correct, well done!");
        else message.setText("Sorry, you got this one wrong.");

    public void calculateResult(){
        double temp=0.0;
        java.text.DecimalFormat df = new java.text.DecimalFormat("#0.#");
        for(int i=0; i<TOTAL; i++)if(QuestionSeries.choice[i].equals(answers[i]))mark++;
        if(temp/TOTAL*100 >=PASS) testresult.setText("  Well done "+studentname.substring(0,studentname.indexOf(' ') )+", you passed");
        else testresult.setText("  Better luck next time "+studentname.substring(0,studentname.indexOf(' ') ) );
        student.setText(" Final score for "+studentname+":  "+mark+" out of "+TOTAL+":  "+df.format(temp/TOTAL*100)+"%");
        new Resultwindow().show();

/* Resultwindow class */

class Resultwindow extends JFrame{
        Resultwindow() {
        super( studentname+" results: " +(mark*100/TOTAL >=PASS?"PASS":"FAIL") );
        Container cont = getContentPane();
        cont.setLayout(new GridLayout(TOTAL/2+3,5,2,5) );
        cont.setBackground(new Color(255,220,255) );
        cont.add(new JLabel("  "+"Marks:    "+mark+"/"+TOTAL+": "+"Percentage:  "+(mark*100/TOTAL)+"%") );
           for(int i=0; i<3; i++)cont.add(new JLabel() );
          String temp[] = new String[TOTAL];
            for(int i=0; i<TOTAL; i++){
                if(QuestionSeries.choice[i].equals(answers[i])) temp[i]="correct";
                else temp[i]="wrong";
            for(int i=0; i<TOTAL; i++) cont.add(new JLabel("  Question "+(i+1)+":  "+temp       [i]) );

/* ItemHandler class */

class ItemHandler implements ItemListener{
    public void itemStateChanged(ItemEvent evt){
        for(int i=0; i<boxes.length; i++) if(boxes[i].isSelected() ) itemCheck++; 
        if(itemCheck > QuestionSeries.n[quesnum]){
            if(QuestionSeries.n[quesnum]==1)    JOptionPane.showMessageDialog(null,"<html><font         size='4' color='00308a'><center>"+
        "There is only "+QuestionSeries.n[quesnum]+" possible<br> answer to question "+(quesnum+1)+
                    "<html>","User Information Message",JOptionPane.INFORMATION_MESSAGE);
            else JOptionPane.showMessageDialog(null,"<html><font size='4' color='00308a'><center>"+
                    "There are only "+QuestionSeries.n[quesnum]+" possible<br> answers to question "+(quesnum+1)+
                    "<html>","User Information Message",JOptionPane.INFORMATION_MESSAGE);

/*  main method */

    public static void main(String [] args){
        OnlineTest frame = new OnlineTest();
        frame.setTitle("    "+QuestionSeries.testtitle);
        frame.setDefaultCloseOperation( EXIT_ON_CLOSE );

someone please help me out quickly i am searching a lot..creating teh database si ok but the connectivity is a problem

View Answers

Related Tutorials/Questions & Answers:
urgent help for inserting database in a project
urgent help for inserting database in a project   I need some urgent help i have made java application for conducting a quiz which displays 25 mcq's... help me out quickly i am searching a lot..creating teh database si ok
urgent help for inserting database in a project
urgent help for inserting database in a project   I need some urgent help i have made java application for conducting a quiz which displays 25 mcq's... help me out quickly i am searching a lot..creating teh database si ok
plz help -java project very urgent
plz help -java project very urgent  ? Ford furniture is a local furniture store in acts, and they as CS graduate students to implement a software system to generate various reports for them at the end of each month. You
PROJECT ON JAVA NET BEANS AND MYSQL !! PLEASE HELP URGENT  i need a project based on connectivity..it can be based on any of the following topics 1.for calculating income tax. 2.for pf calculation 3.hospital management 4.students
inserting image into database
inserting image into database  how to insert image into database using struts frame work and spring JDBC
displaying List of records from database in a jsp using ajax, onclick it should display the results ?? its urgent can u help me
displaying List of records from database in a jsp using ajax, onclick it should display the results ?? its urgent can u help me   displaying List... ?? its urgent can u help me
Please help me urgent...........
Please help me urgent...........  For what kind of a problem would use a Tree Set and not a Tree Map For what kind of a problem would use a Tree Map and not a Tree Set   Hello Friend, If you want to display the list
urgent please, help!
urgent please, help!  how to make jTable unclickable and have unmovable columns, thanks in advance   import javax.swing.*; import java.awt.*; public class SimpleJTableExample{ public static void main(String[] args
inserting dropdown values into database table
inserting dropdown values into database table   hi i want to insert dropdown values into a database table by using jsp
pls help me it urgent
pls help me it urgent  hey, pls help me i want to know that can we call java/.bat file from plsql/proceudre /trigger
pls help me it urgent
pls help me it urgent  hey, pls help me i want to know that can we call java/.bat file from plsql/proceudre /trigger
pls help me it urgent
pls help me it urgent  hey, pls help me i want to know that can we call java/.bat file from plsql/proceudre /trigger
urgent help needed!!!!
from connected comboboxes for storing in database...i'm attatching a code i got.......please help me.... 1)state.jsp: <%@page import="java.sql.*"%>... created two database tables: CREATE TABLE `country
urgent help needed!!!!
to access values selected from connected comboboxes for storing in database...i'm... access country and state....please help me.... 1)state.jsp: <%@page import...; For the above code, we have created two database tables: CREATE TABLE `country
inserting multiple file formats into database
inserting multiple file formats into database  hi i want to insert multiple file format like .pdf.doc.zip into mysql database using jsp
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... not getting how to transfer the values or how to disable the form ...please help
urgent...pleAse help me.....please!
urgent...pleAse help me.....please!  please help me urgent! how can i do dictionary with the use of array code in java, where i will type the word then the corresponding meaning for that word will appear...thanks
its very urgent please help me
its very urgent please help me  how can i retrieve all images from ms access database and display in jsp pages
Programming Help URGENT - JSP-Servlet
Programming Help URGENT  Respected Sir/Madam, I am R.Ragavendran. I am in urgent need of the coding. My requirement is as follows: Beside... and Employee Name present in the database. When I click Employee ID present in the pop
inserting an path of an image in database - JDBC
inserting an path of an image in database  hello kindly help related to the following issue... I m working in a project where we have to capture an image using web cam.... and when the image is saved in a project at the same
Need urgent help with C++ errors!
Need urgent help with C++ errors!  hi, i'm new to C++ programming... don't know what to do. Please help!! #include<iostream.h> void main... help
Inserting id in place of name to database
Inserting id in place of name to database  Hello, I have a database department where I have "id" and "name". I am fetching this data to a jsp form in dropdown list displaying "name" there and Now I wanted to insert data from
very urgent, want to submit my project on monday
very urgent, want to submit my project on monday  i have the code... the values selected in those combo-boxes, for storing in database. in the case... combobox (state). When i'm using 'state' i'm getting null value...help me..please
Inserting data on a database in servlet - JSP-Servlet
Inserting data on a database in servlet  Hi I am following... to a databse by a servlet.I used the example in "Inserting Data In Database table...:8080/DataInsertion/DataInsertion) in the browser, I just saw my designed database in the form
Data is not inserting correctly in mysql database.
Data is not inserting correctly in mysql database.  Hello Sir, below is my code to insert data into database by list iteration through for loop but it is not getting inserted ..it is taking only one value
Urgent java programming question.Pls help
Urgent java programming question.Pls help  Q1. Generate 10 thousand random integers with values in the range between 1 to 100. Q2. Store each randomly generated number into a node and then attach the node to a linked list
Inserting values into a database table of selected DropDown in jsp.
Inserting values into a database table of selected DropDown in jsp.  http://www.roseindia.net/answers/viewqa/Ajax/15250-DropDown-in-ajax+jsp.html... "SelectedCountry" and "SelectedState" and "SelectedCity". Help me. Thanks
help me in inserting data into db using hibernate
help me in inserting data into db using hibernate  How to insert data into dependent tables through hybernate   Hi Friend, Please visit the following link: http://www.roseindia.net/hibernate/insert-data-database.shtml
Ple help me its very urgent
Ple help me its very urgent  Hi.. I have one string 1)'2,3,4' i want do like this '2','3','4' ple help me very urgent
inserting multiple file formats into database using html
inserting multiple file formats into database using html   hi the code was working fine,i want to choose the file and then upload to database,by using html.whether it is possible to upload larger file size,please explain
Lock while inserting/updating database in multithreaded.
Lock while inserting/updating database in multithreaded.  Hi, I am... inserting/updating to database. I dont know what is the issue but it was never... site but its coming at deployment site only. I verified all database indexes. I


Advertisement null