Quiz Application Project in Java Swing

everyone, I share you a project based on Java Swing - A Quiz Application by which you can

> Give Online Quiz Test.

> As Admin,you can

> Add

> Update

> Delete and View Questions.

Software And Tool Used :

1. Knowledge of Java Swing

2. NetBeans

3. MySQL Database

By all these tools, we create a swing Application.

>>>> First of all create a new Project on netbeans IDE.

And Connect your Project with MySQL database.

Create Database Name as "quiz"

> Create Table Named "user"

  CREATE TABLE `user` (
  `userID` int NOT NULL AUTO_INCREMENT,
  `username` varchar(45) NOT NULL,
  `email` varchar(45) NOT NULL,
  `password` varchar(45) NOT NULL,
  PRIMARY KEY (`userID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci

> Create table "question"

   CREATE TABLE `question` (
  `QuestionID` int NOT NULL AUTO_INCREMENT,
  `Name` varchar(45) DEFAULT NULL,
  `Option1` varchar(45) DEFAULT NULL,
  `Option2` varchar(45) DEFAULT NULL,
  `Option3` varchar(45) DEFAULT NULL,
  `Option4` varchar(45) DEFAULT NULL,
  `Answer` varchar(45) DEFAULT NULL,
  `QuizID` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`QuestionID`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci

> Create Class For Connection to Database

ConnectionProvider.java

   import java.sql.*;

public class ConnectionProvider {

    private static Connection con;

    public static Connection getConnection() {
        try {

            if (con == null) {
                //driver class load
                Class.forName("com.mysql.cj.jdbc.Driver");

                //create a connection..
                con = DriverManager.
                        getConnection("jdbc:mysql://localhost:3306/quiz", "root", "Bhanu@123");
                
            }

        } catch (Exception e) {
            e.printStackTrace();
        }

        return con;
    }
}

Now follow below steps carefully.

Create Main Class for access other class

public class Main {
    public static void main(String s[])  
    {  
           System.out.println("connection"+ ConnectionProvider.getConnection());

        new Registration();
        
    }  
}

> Create the login and logout Page

Registration.java

import java.sql.*;
import java.awt.*;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.*;
import javax.swing.border.TitledBorder;

public class Registration implements ActionListener {

    JFrame frame;
    JPanel signup_panel, front, registration;
    JPanel login_panel;
    JLabel signup_username, welcome;
    JLabel signup_email;
    JLabel signup_password, signup_confirm_password;
    JLabel login_email;
    JLabel login_password;
    JTextField tf_signup_username;
    JTextField tf_signup_email;
    JPasswordField tf_signup_password;
    JPasswordField tf_signup_confirm_password;
    JTextField tf_login_email;
    JPasswordField tf_login_password;
    JButton btn_signup, btn_login, login, signup;
    Boolean isLogined;

    public Registration() {

        frame = new JFrame();
        signup_panel = new JPanel();
        front = new JPanel();
        registration = new JPanel();
        login_panel = new JPanel();
        signup_username = new JLabel("User Name : ");
        welcome = new JLabel("Welcome to Quiz Show - A Mind Refreshing Game");
        signup_email = new JLabel("Email : ");
        signup_password = new JLabel("Password : ");
        signup_confirm_password = new JLabel("Confirm "
                + "Password : ");
        tf_signup_username = new JTextField();
        tf_signup_email = new JTextField();
        tf_signup_password = new JPasswordField();
        tf_signup_confirm_password = new JPasswordField();
        btn_signup = new JButton("Sign Up");
        signup = new JButton("Sign Up");
        login = new JButton("Login");

        login_email = new JLabel("Email:");
        login_password = new JLabel("Password :");
        tf_login_email = new JTextField();
        tf_login_password = new JPasswordField();
        btn_login = new JButton("Login");
        signup_username.setBounds(10, 100, 120, 30);
        signup_email.setBounds(10, 140, 120, 30);
        signup_password.setBounds(10, 180, 120, 30);
        signup_confirm_password.setBounds(10, 220, 180, 30);
        tf_signup_username.setBounds(180, 100, 120, 30);
        tf_signup_email.setBounds(180, 140, 120, 30);
        tf_signup_password.setBounds(180, 180, 120, 30);
        tf_signup_confirm_password.setBounds(180, 220, 120, 30);
        btn_signup.setBounds(180, 300, 80, 40);

        login_email.setBounds(10, 100, 120, 30);
        login_password.setBounds(10, 140, 120, 30);
        //tf_signup_username.setBounds(80, 100, 120, 30);
        tf_login_email.setBounds(80, 100, 120, 30);
        tf_login_password.setBounds(80, 140, 120, 30);
        btn_login.setBounds(100, 220, 80, 40);

        login.setBounds(200, 400, 80, 40);
        signup.setBounds(400, 400, 80, 40);
        login.setForeground(Color.blue);
        signup.setForeground(Color.blue);
        welcome.setBounds(30, 50, 700, 200);
        welcome.setFont(new Font("Jokerman", Font.PLAIN, 26));
        welcome.setForeground(Color.BLUE);
        registration.add(welcome);
        registration.add(login);
        registration.add(signup);

        signup_panel.setBorder(BorderFactory.createTitledBorder(BorderFactory.createEtchedBorder(), "SIGN UP FORM", TitledBorder.CENTER, TitledBorder.TOP));
        login_panel.setBorder(BorderFactory.createTitledBorder(BorderFactory.createEtchedBorder(), "LOGIN FORM", TitledBorder.CENTER, TitledBorder.TOP));

        signup_panel.add(signup_username);
        signup_panel.add(tf_signup_username);
        signup_panel.add(signup_email);
        signup_panel.add(tf_signup_email);
        signup_panel.add(signup_password);
        signup_panel.add(tf_signup_password);
        signup_panel.add(signup_confirm_password);
        signup_panel.add(tf_signup_confirm_password);
        signup_panel.add(btn_signup);
        login_panel.add(login_email);
        login_panel.add(login_password);
        login_panel.add(tf_login_email);
        login_panel.add(tf_login_password);
        login_panel.add(btn_login);

        signup_panel.setLayout(null);
        login_panel.setLayout(null);
        registration.setLayout(null);
        front.setLayout(null);
        front.setBackground(Color.BLUE);

        frame.add(front);
        frame.add(registration);
        btn_signup.addActionListener(this);
        btn_login.addActionListener(this);
        login.addActionListener(this);
        signup.addActionListener(this);
        frame.setExtendedState(JFrame.MAXIMIZED_BOTH);

        frame.setSize(600, 400);
        frame.setLayout(new GridLayout(1, 2));
        frame.setTitle("Welcome Page");

        frame.setVisible(true);
    }

    public void actionPerformed(ActionEvent e) {
        if (e.getSource() == signup) {
            JInternalFrame f = new JInternalFrame();
            f.add(signup_panel);
            f.setSize(600, 800);
            f.setTitle("Signup Form");
            f.setClosable(true);
            signup.disable();

            front.add(f);
            f.setVisible(true);

        }
        if (e.getSource() == login) {
            JInternalFrame f = new JInternalFrame();
            f.add(login_panel);
            f.setSize(600, 800);
            f.setTitle("Login Form");
            f.setClosable(true);
            front.add(f);
            f.setVisible(true);
        }
        if (e.getSource() == btn_signup) {

            SignUp();
        }

        if (e.getSource() == btn_login) {

            Login();
        }
    }

    private void SignUp() {
        int x = 0;

        Connection con = ConnectionProvider.getConnection();
        String Username = tf_signup_username.getText();
        String Email = tf_signup_email.getText();
        char[] s1 = tf_signup_password.getPassword();
        String Password = new String(s1);
        char[] s2 = tf_signup_confirm_password.getPassword();
        String CPassword = new String(s2);
        if (Password.equals(CPassword)) {
            try {

                PreparedStatement ps = con.prepareStatement("insert into user(username,email,password) values(?,?,?)");
                ps.setString(1, Username);
                ps.setString(2, Email);
                ps.setString(3, CPassword);
                ps.executeUpdate();
                x++;
                if (x > 0) {
                    JOptionPane.showMessageDialog(btn_signup, "Data Saved Successfully");
                }
            } catch (Exception ex) {
                System.out.println(ex);
            }
        } else {
            JOptionPane.showMessageDialog(btn_signup, "Password Does Not Match");
        }
    }

    private void Login() {
        Connection con = ConnectionProvider.getConnection();
        JFrame f1 = new JFrame();
        JLabel l, l0;

        String Email = tf_login_email.getText();

        char[] p = tf_login_password.getPassword();

        String Password = new String(p);
        if (Email.equals("admin@gmail.com") && Password.equals("Admin@123")) {
            new QuizApplication();
        } else {

            try {

                PreparedStatement ps = con.prepareStatement("select username from user where email=? and password=?");

                ps.setString(1, Email);

                ps.setString(2, Password);

                ResultSet rs = ps.executeQuery();

                if (rs.next()) {

                    new UserProfile(rs.getString(1));
                    frame.setVisible(false);

                } else {

                    JOptionPane.showMessageDialog(null,
                            "Incorrect Email-Id or Password.."
                            + "Try Again with correct detail");

                }

            } catch (Exception ex) {

                System.out.println(ex);

            }

        }
    }

}

Display Output

Welcome Page

SignUp Form

Login Form

Now create users profile page.

UserProfile.java

import java.awt.BorderLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
public class UserProfile {

    JFrame f;
    JPanel panel,top_panel;
    JLabel l = new JLabel();

    UserProfile(String Username) {
        f = new JFrame();
        panel = new JPanel();
        top_panel = new JPanel();
        l.setText("Welcome to Quiz World , " + Username);
        JButton b1 = new JButton("NORTH");;
        JButton b2 = new JButton("SOUTH");;
        JButton b3 = new JButton("EAST");;
        JButton b4 = new JButton("WEST");;
        JButton b5 = new JButton("Take Quiz");
        b5.setBounds(200, 200, 150, 30);
       // b1.setBounds(900,0,40,80);
        l.setBounds(500, 50, 200, 30);
        panel.add(b5);
        
        panel.add(l);
        top_panel.add(b1);
        panel.setLayout(null);
        top_panel.setLayout(null);
        f.add(top_panel, BorderLayout.NORTH);
        //f.add(b2, BorderLayout.SOUTH);
       // f.add(b3, BorderLayout.EAST);
       // f.add(b4, BorderLayout.WEST);
        f.add(panel, BorderLayout.CENTER);
        b5.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                new Test(Username);
                f.setVisible(false);
            }

        });
        f.setExtendedState(JFrame.MAXIMIZED_BOTH);
        f.setTitle("Welcome " +Username);
        f.setSize(300, 300);
        f.setVisible(true);
    }
}

Now create Quiz page.

Test.java

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;
import javax.swing.*;
public class Test implements ActionListener{
    NumberOfQuestions numberOfQuestions = new NumberOfQuestions();
    public int numberofQuestion = numberOfQuestions.getCount();
    JFrame frame;
    JLabel question;
    JRadioButton option1, option2, option3, option4;
    JButton save,submit;
    String Questions[][] = new String[numberofQuestion][5];
    String Answers[][]   = new String[numberofQuestion][1];
    String pa[][] = new String[numberofQuestion][1];
    String Username;
    ButtonGroup options;
    public static int i=0;
    public static int count = 0;
    public static int timer = 15;
    public static int ans_given = 0;
    public  int score = 0;
    public Test(String Username) {
        this.Username = Username;
        frame = new JFrame();
        question = new JLabel();
        option1 = new JRadioButton();
        option2 = new JRadioButton();
        option3 = new JRadioButton();
        option4 = new JRadioButton();
        save = new JButton("Save & Next");
         submit = new JButton("Submit");
        question.setBounds(10, 10, 200, 50);
        option1.setBounds(10, 60, 200, 50);
        option2.setBounds(10, 110, 200, 50);
        option3.setBounds(10, 160, 200, 50);
        option4.setBounds(10, 210, 200, 50);
        save.setBounds(40, 260, 80, 40);
        submit.setBounds(140, 260, 80, 40);
        options = new ButtonGroup();
        options.add(option1);
        options.add(option2);
        options.add(option3);
        options.add(option4);
        Connection con = ConnectionProvider.getConnection();
        try {

            PreparedStatement ps = con.prepareStatement("select * from question");

            ResultSet rs = ps.executeQuery();
             while(rs.next()) {
            
                
               
                        
                         System.out.print("i " +i);
                        Questions[i][0] = rs.getString(2);
                        Questions[i][1] = rs.getString(3);
                        Questions[i][2] = rs.getString(4);
                        Questions[i][3] = rs.getString(5);
                        Questions[i][4] = rs.getString(6);
                        Answers[i][0] = rs.getString(7);
                        i = i+1;
                    
                              
                                 
                 

            }
             
        } catch (Exception ex) {

            System.out.println(ex);

        }
                 save.addActionListener(this);
                 submit.addActionListener(this);
        frame.add(question);
        frame.add(option1);
        frame.add(option2);
        frame.add(option3);
        frame.add(option4);
        frame.add(save);
        frame.add(submit);
               

        frame.setLayout(null);
        frame.setSize(600, 600);
        frame.setVisible(true);
        frame.setTitle("Test is Running");
         start(0);
    }

    public Test() {
    }
    public void actionPerformed(ActionEvent ae){
        if(ae.getSource() == save){
            //repaint();
            option1.setEnabled(true);
            option2.setEnabled(true);
            option3.setEnabled(true);
            option4.setEnabled(true);
            
            ans_given = 1;
            if(options.getSelection() == null){
                pa[count][0] = "";
            }else {
                pa[count][0] = options.getSelection().getActionCommand();
            }
            
            if(count == (numberofQuestion-2)){
                save.setEnabled(false);
                submit.setEnabled(true);
            }
            
            count++;
            start(count);
        }else if(ae.getSource() == submit){
            ans_given = 1;
            if(options.getSelection() == null){
                pa[count][0] = "";
            }else {
                pa[count][0] = options.getSelection().getActionCommand();
            }

            for(int ii =0 ; ii < pa.length ; ii++){
                System.out.println(ii);
                if(pa[ii][0].equals(Answers[ii][0])){
                    score+=10;
                }else{
                    score+=0;
                }
            }
            System.out.println(score);
            frame.setVisible(false);
            new Score(Username, score).setVisible(true);
        }
        }
    
    
  
   public void start(int count){
       /*for(int i =0;i<10;i++)
       {
           System.out.println("Question " + Questions[i][0]);
                        System.out.println("Option1 "+Questions[i][1]);
                        System.out.println("Option2 "+Questions[i][2]);
                        System.out.println("Option3 "+Questions[i][3]);
                        System.out.println("Option4 "+Questions[i][4]);
                        System.out.println("Answer "+Answers[i][0]);
       }*/
        //qno.setText("" + (count + 1) + ". ");
        question.setText(Questions[count][0]);
        option1.setText(Questions[count][1]);
        option1.setActionCommand(Questions[count][1]);
        option2.setText(Questions[count][2]);
        option2.setActionCommand(Questions[count][2]);
        option3.setText(Questions[count][3]);
        option3.setActionCommand(Questions[count][3]);
        option4.setText(Questions[count][4]);
        option4.setActionCommand(Questions[count][4]);
        options.clearSelection();
        
    }

    

}

Now Create Score Class for Display Score

Score.java

import java.awt.Color;
import java.awt.Font;
import java.awt.Image;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;

public class Score extends JFrame implements ActionListener {

    Score(String username, int score) {
        setBounds(600, 150, 750, 550);
        getContentPane().setBackground(Color.WHITE);
        setLayout(null);

       

        JLabel l2 = new JLabel("Thankyou " + username + " for Playing Simple Minds");
        l2.setBounds(45, 30, 700, 30);
        l2.setFont(new Font("RALEWAY", Font.PLAIN, 26));
        add(l2);

        JLabel l3 = new JLabel("Your Score is " + score);
        l3.setBounds(350, 200, 300, 30);
        l3.setFont(new Font("Jokerman", Font.PLAIN, 26));
        l3.setForeground(new Color(199, 21, 133));
        add(l3);

        JButton b1 = new JButton("Play Again");
        b1.setBackground(Color.BLUE);
        b1.setForeground(Color.WHITE);
        b1.addActionListener(this);

        b1.setBounds(400, 270, 120, 30);
        add(b1);
    }

    public void actionPerformed(ActionEvent ae) {
        this.setVisible(false);
        new Test("User");
    }

    public static void main(String[] args) {
        new Score("", 0).setVisible(true);
    }
}

Now create Admin Panel in which Add Question,Update,Delete And View All Questions.

QuizApplication.java

import java.awt.BorderLayout;
import java.awt.CardLayout;
import java.awt.Color;
import java.awt.Container;
import java.awt.FlowLayout;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import static java.util.Collections.copy;
import javax.swing.JButton;
import javax.swing.JDesktopPane;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;

public class QuizApplication implements ActionListener {

    JFrame f;
    JPanel p, p1;
    CardLayout card;
    JDesktopPane desktop;
    Container c;
        JButton addQuiz = new JButton("Add Question");;
        JButton updateQuiz = new JButton("Update Or Remove Question");;
        JButton viewQuiz = new JButton("View Questions");;
        JButton exit = new JButton("Exit");;
        JButton logout = new JButton("Logout");;
    QuizApplication() {
        f = new JFrame();
        p = new JPanel();
        p1 = new JPanel();
         
        
        p.add(addQuiz);
        p.add(updateQuiz);
        p.add(viewQuiz);
        p.add(exit);
        p.add(logout);
        p.setLayout(new GridLayout(5, 1));
         //p1.setSize(900,900);
         p1.setLayout(null);
        f.add(p, BorderLayout.LINE_START);
        
    

    //p1.setBackground(Color.white);
    addQuiz.addActionListener(this);    
    updateQuiz.addActionListener(this);    
    viewQuiz.addActionListener(this);    
    exit.addActionListener(this);    
    logout.addActionListener(this);    
     f.setExtendedState(JFrame.MAXIMIZED_BOTH);
    
     
    f.setSize (300,300);  
    f.setVisible (true);  
}  
    public void actionPerformed(ActionEvent e) {
        if (e.getSource() == addQuiz) {
            Thread runner = new Thread() {

                public void run() {
                   // CheckBoxExample cl = new CheckBoxExample();
                   AddQuiz ot = new AddQuiz();
                   //p1.add(ot);
                    f.add(ot, BorderLayout.CENTER);
                   
                }
            };
            runner.start();
   
        }
        if (e.getSource() == updateQuiz) {
           Thread runner = new Thread() {

                public void run() {
                   // CheckBoxExample cl = new CheckBoxExample();
                   EditQuiz ot = new EditQuiz();
                  // p1.add(ot);
                   f.add(ot, BorderLayout.CENTER);

                }
            };
            runner.start();
        }
        if (e.getSource() == viewQuiz) {
            ViewQuiz vq = new ViewQuiz();
            f.add(vq, BorderLayout.CENTER);
           
        }
        if (e.getSource() == exit) {
            f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); 
            f.setVisible(false);
    
        }
         if (e.getSource() == logout) {
            f.setVisible(false); 
            new Registration();
    
        }
    }
    
       
}

Helper Classes

> To Find Number of Questions

NumberOfQuestions.java

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class NumberOfQuestions {
    public  int count;

    public  int getCount() {
        return count;
    }

    public NumberOfQuestions() {
        Connection con = ConnectionProvider.getConnection();
        try {

            PreparedStatement ps = con.prepareStatement("SELECT Count(*) FROM question ");

            ResultSet rs = ps.executeQuery();
             while(rs.next()) {
                 
                 count = rs.getInt(1);
               
                 
             }

        } catch (Exception ex) {

            System.out.println(ex);

        }
    }
    
     public static void main(String args[]) {
        new NumberOfQuestions();
       // System.out.print("Count "+count);
    }
    
}

Now Create Add question

AddQuiz.java

import java.sql.*;
import java.awt.FlowLayout;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.beans.PropertyVetoException;
import javax.swing.*;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;


public class AddQuiz extends JInternalFrame{
    NumberOfQuestions numberOfQuestions = new NumberOfQuestions();
    int i;
    int numberofQuestion = numberOfQuestions.getCount();
      
        JPanel panel = new JPanel(); 
        JLabel question = new JLabel("Question");
        JPanel[] quizes = new JPanel[10];
        JLabel[] questions = new JLabel[10];
        
        JLabel options1 = new JLabel("Option1");
        JLabel options2 = new JLabel("Option2");
        JLabel options3 = new JLabel("Option3");
        JLabel options4 = new JLabel("Option4");
        JLabel answer = new JLabel("Answer");
        JTextField tf_question = new JTextField();
        JTextField tf_option1 = new JTextField();
        JTextField tf_option2 = new JTextField();
        JTextField tf_option3 = new JTextField();
        JTextField tf_option4 = new JTextField();
        JTextField tf_answer = new JTextField();
        JSeparator sep[] = new JSeparator[10];  
        JButton btn_add_question = new JButton("Add Question");
        String Quiz[] = new String[10];
        JComboBox cb_quiz;
        
       // JComboBox.setTitle("Select Quiz");
        Quiz quiz = new Quiz();

        AddQuiz()
        {
           
             AddQuizes();
              cb_quiz=new JComboBox(Quiz);
         question.setBounds(10,10,80,30);
         options1.setBounds(10, 40,80,30);
         options2.setBounds(10,70,80,30);
         options3.setBounds(10,110,80,30);
         options4.setBounds(10,150,80,30);
         answer.setBounds(10,190,80,30);
         tf_question.setBounds(100,10,200,30);
         tf_option1.setBounds(100, 40,80,30);
         tf_option2.setBounds(100,70,80,30);
         tf_option3.setBounds(100,110,80,30);
         tf_option4.setBounds(100,150,80,30);
         tf_answer.setBounds(100,190,80,30);
         cb_quiz.setBounds(40,230,100,40);
         btn_add_question.setBounds(40,280,80,30);
         panel.add(question);
         panel.add(options1);
         panel.add(options2);
         panel.add(options3);
         panel.add(options4);
         panel.add(answer);
         panel.add(tf_question);
         panel.add(tf_option1);
         panel.add(tf_option2);
         panel.add(tf_option3);
         panel.add(tf_option4);
          panel.add(tf_answer);
          panel.add(btn_add_question);
          panel.add(cb_quiz);
         /*for(int i =0;i<10;i++)
         {
             
             add(questions[i] =questions[i] = new JLabel(Quiz[i]) );
            // add(quizes[i] = new JPanel());
             //add(sep[i]);
           

         } */
          btn_add_question.addActionListener(new ActionListener(){  
public void actionPerformed(ActionEvent e){  
            AddQuestion(); 
        }  

                });  
         panel.setLayout(null);
       
        add(panel);  
        setSize(600, 600);  
       
       setClosable(true);
        setVisible(true);  
        setTitle("Add New Question");
        //setLayout(null);
        pack();
        }
        
        
         private void AddQuestion() {
             int x=0;
             String Question = tf_question.getText();
              String Option1 = tf_option1.getText();
               String Option2 = tf_option2.getText();
                String Option3 = tf_option3.getText();
                String Option4 = tf_option4.getText();
                  String Answer = tf_answer.getText();
              
              
            
             Connection con = ConnectionProvider.getConnection();
             quiz.connection("select * from quiz where Name = " + cb_quiz.getItemAt(cb_quiz.getSelectedIndex()));
                 
                  try  
                {  
                  PreparedStatement ps = con.prepareStatement("insert into question (Name,Option1,Option2,Option3,Option4,Answer,QuizID) values(?,?,?,?,?,?,?)");  
                    ps.setString(1, Question);  
                    ps.setString(2, Option1);  
                    ps.setString(3, Option2);  
                    ps.setString(4, Option3);  
                    ps.setString(5, Option4);  
                    ps.setString(6, Answer);  
                    ps.setInt(7, quiz.getQuizID());  

                    ps.executeUpdate();
                    x++;
                if (x > 0) {
                    JOptionPane.showMessageDialog(btn_add_question, "Question Saved Successfully");
                }
                     }  
                catch (Exception ex)   
                {  
                    System.out.println(ex);  
                }  
         }
        private void AddQuizes() {
            Connection con = ConnectionProvider.getConnection();
                  //To change body of generated methods, choose Tools | Templates.
                  try  
                {  
                  PreparedStatement ps = con.prepareStatement("Select * from quiz");  
                      
                   
                    ResultSet rs = ps.executeQuery();
                    while(rs.next())
                    {
                        Quiz[i] = rs.getString("Name");
                        System.out.println(Quiz[i]);
                        i++;
                    }
                    
                    
                
                     }  
                catch (Exception ex)   
                {  
                    System.out.println(ex);  
                }  
             }

        
    

    
}

Now Create Edit Page

EditQuiz.java

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.swing.*;

public class EditQuiz extends JInternalFrame {
    NumberOfQuestions numberOfQuestions = new NumberOfQuestions();
int numberofQuestion = numberOfQuestions.getCount();
   
    JPanel panel = new JPanel();
    JLabel question = new JLabel("Question");
    JLabel questionID = new JLabel("Question ID : ");
    JLabel options1 = new JLabel("Option1");
    JLabel options2 = new JLabel("Option2");
    JLabel options3 = new JLabel("Option3");
    JLabel options4 = new JLabel("Option4");
    JLabel answer = new JLabel("Answer");
    JTextField tf_question = new JTextField();
    JTextField tf_option1 = new JTextField();
    JTextField tf_option2 = new JTextField();
    JTextField tf_option3 = new JTextField();
    JTextField tf_option4 = new JTextField();
    JTextField tf_answer = new JTextField();
    JTextField tf_questionID = new JTextField();
    JButton btn_edit_question = new JButton("Update Question");
    JButton btn_search_question = new JButton("Search");
    JButton btn_delete_question = new JButton("Delete");

    EditQuiz() {
        questionID.setBounds(10, 10, 80, 30);
        btn_search_question.setBounds(200, 10, 80, 30);
        question.setBounds(10, 60, 80, 30);
        options1.setBounds(10, 100, 80, 30);
        options2.setBounds(10, 140, 80, 30);
        options3.setBounds(10, 180, 80, 30);
        options4.setBounds(10, 220, 80, 30);
        answer.setBounds(10, 260, 80, 30);

        tf_questionID.setBounds(100, 10, 80, 30);
        tf_question.setBounds(100, 60, 80, 30);
        tf_option1.setBounds(100, 100, 80, 30);
        tf_option2.setBounds(100, 140, 80, 30);
        tf_option3.setBounds(100, 180, 80, 30);
        tf_option4.setBounds(100, 220, 80, 30);
        tf_answer.setBounds(100, 260, 80, 30);
        btn_edit_question.setBounds(40, 300, 80, 30);
        btn_delete_question.setBounds(140, 300, 80, 30);
        panel.add(question);
        panel.add(options1);
        panel.add(options2);
        panel.add(options3);
        panel.add(options4);
        panel.add(answer);
        panel.add(tf_question);
        panel.add(tf_option1);
        panel.add(tf_option2);
        panel.add(tf_option3);
        panel.add(tf_option4);
        panel.add(tf_answer);
        panel.add(btn_edit_question);
        panel.add(btn_search_question);
        panel.add(btn_delete_question);
        panel.add(questionID);
        panel.add(tf_questionID);

        btn_search_question.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                EditQuestion();
            }

        });
        btn_edit_question.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                UpdateQuestion();
            }

        });
        btn_delete_question.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                DeleteQuestion();
            }

        });
        panel.setLayout(null);

        add(panel);
        setSize(300, 300);
        setClosable(true);

        // frame.setLocationRelativeTo(null);  
        //frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);  
        setVisible(true);
        setTitle("Update Questions");
    }

    private void EditQuestion() {
        int x = 0;
        String QuestionID = tf_questionID.getText();
        Connection con = ConnectionProvider.getConnection();
        try {
            PreparedStatement ps = con.prepareStatement("select * from question where QuestionID = ?");
            ps.setString(1, QuestionID);
            ResultSet rs = ps.executeQuery();
            if (rs.next()) {
                tf_question.setText(rs.getString(2));
                tf_option1.setText(rs.getString(3));
                tf_option2.setText(rs.getString(4));
                tf_option3.setText(rs.getString(5));
                tf_option4.setText(rs.getString(6));
                tf_answer.setText(rs.getString(7));
                // .setText("Welcome " + rs.getString(1));

                //l.setForeground(Color.red);
                //l.setFont(new Font("Serif", Font.BOLD, 30));
            } else {

                JOptionPane.showMessageDialog(null,
                        "Question Id is wrong");

            }
        } catch (Exception ex) {
            System.out.println(ex);
        }
        //To change body of generated methods, choose Tools | Templates.
        /* try {
            PreparedStatement ps = con.prepareStatement("insert into question (Name,Option1,Option2,Option3,Option4,Answer) values(?,?,?,?,?,?)");
            ps.setString(1, Question);
            ps.setString(2, Option1);
            ps.setString(3, Option2);
            ps.setString(4, Option3);
            ps.setString(5, Option4);
            ps.setString(6, Answer);
            ps.executeUpdate();
            x++;
            if (x > 0) {
                JOptionPane.showMessageDialog(btn_add_question, "Question Saved Successfully");
            }
        } catch (Exception ex) {
            System.out.println(ex);
        }
    }*/
    }

    private void UpdateQuestion() {
        int x = 0;
        String Question = tf_question.getText();
        String option1 = tf_option1.getText();
        String option2 = tf_option2.getText();
        String option3 = tf_option3.getText();
        String option4 = tf_option4.getText();
        String answer = tf_answer.getText();

        Connection con = ConnectionProvider.getConnection();
        //To change body of generated methods, choose Tools | Templates.
        try {
            PreparedStatement ps = con.prepareStatement("UPDATE question SET Name = '" + Question + "',Option1 = '" + option1 + "',Option2 = '" + option2
                    + "',Option3 = '" + option3 + "',Option4 = '" + option4 + "',Answer = '" + answer
                    + "' WHERE QuizID =" + tf_questionID.getText());

            ps.executeUpdate();
            x++;
            if (x > 0) {
                JOptionPane.showMessageDialog(btn_edit_question, "Question Upadate Successfully");
            }
        } catch (Exception ex) {
            System.out.println(ex);
        }
    }

    private void DeleteQuestion() {
        int x = 0;
        String QuestionID = tf_questionID.getText();
        Connection con = ConnectionProvider.getConnection();
        try {
            PreparedStatement ps = con.prepareStatement("Delete from question where QuestionID =" + tf_questionID.getText());
            //ps.setString(1, QuestionID);
            ps.executeUpdate();

            JOptionPane.showMessageDialog(null,
                    "Deleted Successfully");

        } catch (Exception ex) {
            System.out.println(ex);
        }

        throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
    }

    public static void main(String s[]) {
        //System.out.println("connection" + ConnectionProvider.getConnection());

        new EditQuiz();

    }
}

Now Create View Question Page

ViewQuiz.java

 import java.awt.Button;
import java.awt.Frame;
import java.awt.GridLayout;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.swing.*;
import static quiz.application.Test.i;

public class ViewQuiz extends JInternalFrame {
    NumberOfQuestions numberOfQuestions = new NumberOfQuestions();
     public  int numberofQuestion = numberOfQuestions.getCount();
    
    //JFrame frame = new JFrame();
     String Questions[][] = new String[numberofQuestion][5];
     String Answers[][]   = new String[numberofQuestion][1];
     JLabel[] question,option1,option2,option3,option4;

    public ViewQuiz() {
         Test test = new Test();
        question = new JLabel[numberofQuestion];
        option1 = new JLabel[numberofQuestion];
        option2 = new JLabel[numberofQuestion];
        option3 = new JLabel[numberofQuestion];
        option4 = new JLabel[numberofQuestion];
        
        Connection con = ConnectionProvider.getConnection();
        try {

            PreparedStatement ps = con.prepareStatement("select * from question");

            ResultSet rs = ps.executeQuery();
             while(rs.next()) {
            
                
               
                        
                         System.out.print("i " +i);
                        Questions[i][0] = rs.getString(2);
                        Questions[i][1] = rs.getString(3);
                        Questions[i][2] = rs.getString(4);
                        Questions[i][3] = rs.getString(5);
                        Questions[i][4] = rs.getString(6);
                        Answers[i][0] = rs.getString(7);
                        i = i+1;
                    
                              
                                 
                 

            } 

        } catch (Exception ex) {

            System.out.println(ex);

        }
        for(int i=0;i<numberofQuestion;i++)
        {
            
           
            add(question[i] = new JLabel(Questions[i][0]));
            add(option1[i]= new JLabel(Questions[i][1]));
            add(option2[i]= new JLabel(Questions[i][2]));
            add(option3[i]= new JLabel(Questions[i][3]));
            add(option4[i]= new JLabel(Questions[i][4]));
        }
        setSize(500,500);
        setLayout(new GridLayout(numberofQuestion,1));
               setClosable(true);

       setVisible(true);
       setTitle("All Questions");
    }

    public static void main(String args[]) {
        new ViewQuiz();
        
    }

}

Thats all From my side.

Please Keep updated.

I will add Some more features like

> Category of quizes

> Host Your Online Quiz

>Display Past Attempted

>Add Different type of Timers in Quiz.

> Update UI of Application

InShort Complete Quiz Application is Updated And an advance level Project is Present to you soon.

If you have project or assignment files, You can send atcontact@codersarts.com  directly. Give us a chance.

Thank you for reading.