---
title: "Creating Dynamic Objective Test Application through Swing in JAVA ( Using MySQL Database )"  
description: "Here we are going to create an Application of Objective Test, in this application we show Questions with its options one by one, options will load dyn"  
author: "Tarun Kumar"  
published: 2015-06-26  
updated: 2026-05-13  
canonical: https://www.mindstick.com/articles/1800/creating-dynamic-objective-test-application-through-swing-in-java-using-mysql-database  
category: "java"  
tags: ["java", "mysql", "swing"]  
reading_time: 6 minutes  

---

# Creating Dynamic Objective Test Application through Swing in JAVA ( Using MySQL Database )

Previouslywe seen how to create Simple [Registration](https://answers.mindstick.com/qa/116207/what-is-lei-registration) Form with GUI [Connection](https://yourviews.mindstick.com/view/83497/a-40-year-old-man-has-been-arrested-in-connection-with-the-abe-shooting) withMySQL Database : SimpleRegistration Form using JAVA Swing - Step2 (Connecting GUI with MySQL Databaseusing JDBC)\

Here weare going to create an [Application](https://www.mindstick.com/articles/12824/calculator-application-in-android) of Objective Test, in this application weshow Questions with its options one by one, options will load dynamically. Wegetting our questions and its options through [MySQL database](https://www.mindstick.com/forum/390/how-to-create-mysql-database-backup-file-using-php).

This Javaprogram needs some important packages:

· java.sql.Connection;

· java.sql.ResultSet;

· java.sql.Statement;

For connecting java application with theMySQL database, you need to follow steps to perform [database connectivity](https://www.mindstick.com/blog/462/database-connectivity-in-c-sharp): ( In this example weare using MySQL as the database. So we need to know following informations forthe MySQL database ):

· Driverclass: The driver class for the mysql database iscom.mysql.jdbc.Driver.

· ConnectionURL: The connection URL for the mysql database is jdbc:mysql://localhost:3306/projectwhere jdbc is the API, mysql is the database, localhost is the [server name](https://answers.mindstick.com/qa/110129/how-to-change-discord-server-name) onwhich mysql is running, we may also use IP address, 3306 is the port number andproject is the database name. We may use any database, in such case, you needto replace the project with your database name.

· Username: Thedefault username for the mysql database is root.

· Password: Passwordis given by the user at the time of installing the mysql database. In thisexample, we are going to use root as the password.

[ Toconnect java application with the MySQL database mysqlconnector.jar file is

required to be loaded.]

In Database our [table Structure](https://answers.mindstick.com/qa/113649/what-is-the-database-table-structure-of-url-analyzer-details-to-store) will be like this:

![Creating Dynamic Objective Test Application through Swing in JAVA ( Using MySQL Database )](https://www.mindstick.com/mindstickarticle/7999ce43-9508-4b68-958b-02d39560faf3/images/d8ccb4d5-ca60-4b94-8774-8d1695ae202e.png)

Java Codes:

DynamicTest.java

import java.awt.Color;

import java.awt.Component;import java.awt.FlowLayout;

import java.awt.Font;

import java.awt.GridLayout;import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.awt.event.ItemEvent;

import java.awt.event.ItemListener;

import java.sql.Connection;

import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement; import java.util.HashMap;

import javax.swing.BorderFactory;

import javax.swing.ButtonGroup;

import javax.swing.ImageIcon; import javax.swing.JButton;

import javax.swing.JFrame;

import javax.swing.JLabel;

import javax.swing.JOptionPane;

import javax.swing.JPanel;

import javax.swing.JRadioButton; import javax.swing.border.Border; import javax.swing.border.TitledBorder;

@SuppressWarnings("serial")

public class DynamicTest extends JFrame implements ActionListener, ItemListener{

int frameHight=600,frameWidth=700; JFrame childFrame; JPanel questionPanel,optionPanel,buttonPanel,resultPanel; JButton previousButton,nextButton,childPreviousButton,childNextButton,

resultButton,describeResultButton,restart,childRestart; JLabel title,questionLabel,totalQuestion,attemptedQuestion,

unattemptedQuestion,correct,incorrect;

Connection con; Statement statement; String[] optionString=null; ResultSet questionRst; JRadioButton[] optionsButton = null;

ButtonGroup buttonGroup = new ButtonGroup(); HashMap<Long,String> map = new HashMap<Long,String>();

int count=0, nor=0, childCount=0;

String correctOption=null;

ImageIcon icon,icon1,icon3;

DynamicTest(){

super("Objective Questions"); setSize(frameWidth,frameHight);

setLayout(null);

try{

//calling connect() method

connect();

//fetching all rows from table

questionRst = statement.executeQuery("select * from objectivetest");

//fetch the last record of the table

questionRst.last();

nor=questionRst.getRow();

title = new JLabel("Objective Test");

title.setBounds(frameHight/2,20,200,30); title.setFont(new Font("Arial", Font.BOLD,20));

add(title);

questionPanel = new JPanel();

questionPanel.setLayout(new FlowLayout(FlowLayout.LEFT));

questionPanel.setBounds(frameWidth/9,90,550,50);

questionLabel = new JLabel("..............................");

questionPanel.add(questionLabel);

add(questionPanel);

optionPanel = new JPanel();

optionPanel.setLayout(new GridLayout(4,2));

optionPanel.setBounds(frameWidth/7,150,550,160); add(optionPanel);

buttonPanel = new JPanel();

buttonPanel.setLayout(new GridLayout(2,2,5,5)); buttonPanel.setBounds(frameWidth/9,320,550,70); previousButton = new JButton("Previous");

previousButton.addActionListener(this);

buttonPanel.add(previousButton);

nextButton = new JButton("Next");

nextButton.addActionListener(this);

buttonPanel.add(nextButton);

resultButton = new JButton("Result");

resultButton = new JButton("Result");

resultButton.addActionListener(this);

buttonPanel.add(resultButton);

describeResultButton = new JButton("Show Result Discription");

describeResultButton.addActionListener(this);

buttonPanel.add(describeResultButton);

describeResultButton.setEnabled(false);

add(buttonPanel);

//calling showNextRecord() method

showNextRecord();

resultPanel = new JPanel();

resultPanel.setLayout(new GridLayout(3,2));

resultPanel.setBounds(frameWidth/3,410,250,80);

totalQuestion = new JLabel("");

correct = new JLabel("");

attemptedQuestion = new JLabel("");

incorrect = new JLabel("");

unattemptedQuestion = new JLabel("");

resultPanel.add(totalQuestion);

resultPanel.add(correct);

resultPanel.add(attemptedQuestion);

resultPanel.add(incorrect);

resultPanel.add(unattemptedQuestion);

add(resultPanel);

resultPanel.hide();

restart = new JButton("Restart");

restart.setBounds(frameWidth/3,495,200,40);

restart.addActionListener(this);

add(restart);

restart.hide();

}catch(Exception ex){

System.out.println(ex.getMessage());

}

setDefaultCloseOperation(EXIT_ON_CLOSE);

setVisible(true);

}

// show nextRecord() method

[public void](https://www.mindstick.com/interview/2715/can-we-write-static-public-void-instead-of-public-static-void) showNextRecord(){

if(count < 1){

previousButton.setEnabled(false);

}else{

previousButton.setEnabled(true);

}

if(count+1 == nor){

nextButton.setText("FINISH");

}else{

nextButton.setEnabled(true);

nextButton.setText("Next");

}

try{

//move the cursor to the specified row number

questionRst.absolute(count+1);

questionLabel.setText((count+1)+". "+questionRst.getString(2));

String split = questionRst.getString(3);

optionString = split.split("-");

optionsButton = new JRadioButton[optionString.length];

for(int i=0; i<optionString.length; i++){

optionsButton[i] = new JRadioButton(optionString[i]);

optionsButton[i].addItemListener(this);

buttonGroup.add(optionsButton[i]);

optionPanel.add(optionsButton[i]);

if(map.containsKey((questionRst.getLong(1)))){

if(map.get(questionRst.getLong(1)).equals(optionsButton[i].

getText()))

optionsButton[i].setSelected(true);

}else

buttonGroup.clearSelection();

}

add(optionPanel);

}catch(Exception ex){

System.out.println(ex.getMessage());

}

}

//childFrame() method which creates child frame

public void childFrame(){

try{

//creating another Frame to show complete result

childFrame = new JFrame();

childFrame.setSize(frameWidth,frameHight);

childFrame.setLayout(null);

title = new JLabel("Objective Test");

title.setBounds(frameHight/2,20,200,30);

title.setFont(new Font("Arial", Font.BOLD,20));

childFrame.add(title);

questionPanel = new JPanel();

questionPanel.setLayout(new FlowLayout(FlowLayout.LEFT));

questionPanel.setBounds(frameWidth/9,90,550,50);

questionLabel = new JLabel("");

questionPanel.add(questionLabel);

childFrame.add(questionPanel);

optionPanel = new JPanel();

optionPanel.setLayout(new GridLayout(4,2));

optionPanel.setBounds(frameWidth/9,150,550,150);

buttonPanel = new JPanel();

buttonPanel.setLayout(new GridLayout(1,2,5,5));

buttonPanel.setBounds(frameWidth/9,320,550,50);

childPreviousButton = new JButton("Previous");

childPreviousButton.addActionListener(this);

buttonPanel.add(childPreviousButton);

childNextButton = new JButton("Next");

childNextButton.addActionListener(this);

buttonPanel.add(childNextButton);

childFrame.add(buttonPanel);

childRestart = new JButton("Restart");

childRestart.setBounds(frameWidth/3,410,250,40);

childRestart.addActionListener(this);

childFrame.add(childRestart);

//calling childShowNextRecord()method

childShowNextRecord();

childFrame.setDefaultCloseOperation(EXIT_ON_CLOSE);

childFrame.setVisible(true);

}catch(Exception ex){

System.out.println(ex.getMessage());

}

}

// defining childShowNextRecord() method

public void childShowNextRecord(){

if(childCount<1) childPreviousButton.setEnabled(false);

else childPreviousButton.setEnabled(true);

if(childCount+1 == nor) childNextButton.setEnabled(false);

else childNextButton.setEnabled(true);

// creating border where no options are selected Border titleBorder = BorderFactory.createLineBorder(Color.RED);

TitledBorder title = BorderFactory.createTitledBorder(titleBorder,

"Not-Attempted");

title.setTitleJustification(TitledBorder.CENTER);

try{

questionRst.absolute(childCount+1);

questionLabel.setText((childCount+1)+". "+questionRst.getString(2));

String string = questionRst.getString(3); String[] optionString = string.split("-");

correctOption = questionRst.getString(4);

optionsButton = new JRadioButton[optionString.length];

for(int i=0; i<optionString.length; i++){

optionsButton[i] = new [RadioButton](https://www.mindstick.com/blog/233/get-checked-radiobutton-using-javascript)(optionString[i]);

buttonGroup.add(optionsButton[i]);

optionPanel.add(optionsButton[i]);

if(map.containsKey((questionRst.getLong(1)))){

optionPanel.setBorder(null);

if(map.get(questionRst.getLong(1)).equals(optionsButton[i].

getText())){

optionsButton[i].setSelected(true);

icon = new ImageIcon("");

optionsButton[i].setIcon(icon);

optionsButton[i].setFont(new Font("Arial",Font.BOLD,18));

if(!map.get(questionRst.getLong(1)).equals(correctOption)){

icon1 = new ImageIcon("C:/Users/MSclient008/Desktop/

TarunDoc/icons/wrong.gif");

optionsButton[i].setIcon(icon1);

}

}

}else{

buttonGroup.clearSelection();

optionPanel.setBorder(title);

}

}

int k=0;

while(k<optionString.length){

if(correctOption.equals(optionsButton[k].getText())){

optionsButton[k].setFont(new Font("Arial",Font.BOLD,18));

icon3 = new ImageIcon("C:/Users/MSclient008/Desktop/

TarunDoc/icons/correct.gif");

optionsButton[k].setIcon(icon3);

}

k++;

}

childFrame.add(optionPanel);

Component[] component = optionPanel.getComponents(); int i=0,j=0;

while(component.length>i){

JRadioButton radio = (JRadioButton)component[i];

if(!radio.isSelected()){

radio.setEnabled(false);

j++;

}

if(radio.getText().equals(correctOption))

radio.setEnabled(true);

i++;

}

int x=0;

if(j==i)

{

while(component.length>x){

JRadioButton radio = (JRadioButton)component[x];

if(radio.getText().equals(correctOption)){

radio.setEnabled(false);

}

x++;

}

}

}catch(Exception ex){

System.out.println(ex.getMessage());

}

}

// defining actionPerformed() method

public void actionPerformed(ActionEvent ae){

JButton button = (JButton)ae.getSource(); try{ if(ae.getSource()==previousButton)

{

if(count>0)

{

count--;

optionPanel.removeAll();

optionPanel.repaint();

showNextRecord();

}

System.out.println("Prev:"+count);

}

if(ae.getSource()==nextButton)

{

if(count< nor-1)

{

optionPanel.removeAll();

optionPanel.repaint();

count++;

showNextRecord(); } else if(button.getText().equals("FINISH"))

{

Object[] options = {"Yes, please","Return!"};

// asking confirmation to show result

int n = JOptionPane.showOptionDialog(this, "Are you sure,

want to see result!","Test Result",

JOptionPane.YES_NO_OPTION,

JOptionPane.QUESTION_MESSAGE,

null,

options,

options[0]);

if(n ==0){

previousButton.setEnabled(false);

nextButton.setEnabled(false);

questionLabel.setEnabled(false);

resultButton.setEnabled(false);

showResult();

describeResultButton.setEnabled(true);

}

}

System.out.println("Next:"+count);

}

if(ae.getSource()==resultButton){

// calling showResult() method

showResult();

restart.show();

System.out.println("ResultButton:");

}

if(ae.getSource()==describeResultButton)

{

this.hide();

// calling childFrame() method

childFrame();

System.out.println("DescribeButton:");

}

if(ae.getSource()==childPreviousButton)

{

if(childCount>0)

{

childCount--;

optionPanel.removeAll();

optionPanel.repaint();

childShowNextRecord();

System.out.println("ChildPrev:"+childCount);

}

}

if(ae.getSource()==childNextButton)

{

if(childCount < nor-1)

{

optionPanel.removeAll();

optionPanel.repaint();

childCount++;

childShowNextRecord();

System.out.println("ChildNext:"+childCount);

}

}

if(ae.getSource()==restart)

{

this.hide();

new DynamicTest();

}

if(ae.getSource()==childRestart)

{

childFrame.hide();

new DynamicTest();

}

}catch(Exception ex){

System.out.println(ex.getMessage());

}

}

private void showResult(){

try{

int size=1, totalQ=0, attemptedQ=0,cor=0,inc=0; while(size <= nor){

String[] optionString = null;

String correctOption = null;

questionRst.absolute(size);

if(map.containsKey(questionRst.getLong(1))){

String split = questionRst.getString(3);

optionString = split.split("-");

questionRst.absolute(size);

correctOption = questionRst.getString(4);

if(map.get(questionRst.getLong(1)).equals(correctOption))

cor++;

else

inc++;

}

size++;

}

totalQuestion.setText("TotalQuestions"+" : "+(totalQ=nor));

attemptedQuestion.setText("Attempted"+":"+(attemptedQ=map.size()));

unattemptedQuestion.setText("Unattempted"+":"+(totalQ-attemptedQ));

correct.setText("Correct"+" : "+cor);

incorrect.setText("Incorrect"+" : "+inc);

resultPanel.show();

previousButton.setEnabled(false);

nextButton.setEnabled(false);

questionLabel.setEnabled(false);

Component[] component = optionPanel.getComponents();

int i=0;

while(component.length>i){

JRadioButton radio = (JRadioButton)component[i];

if(!radio.isSelected())

radio.setEnabled(false);

i++;

}

}catch(Exception e){

System.out.print(e.getMessage());

}

}

// defining connect() method to connect with the database

public void connect(){

try{

Class.forName("com.mysql.jdbc.Driver");

con =DriverManager.getConnection("jdbc:mysql://localhost:3306/test",

"root","1234");

statement = con.createStatement();

System.out.println("Connected");

}catch(Exception e){

System.out.print(e.getMessage());

}

}

public void itemStateChanged(ItemEvent e){ try{

JRadioButton radioButton = (JRadioButton)e.getSource();

if(radioButton.isSelected())

{

map.put(questionRst.getLong(1), radioButton.getText()); System.out.println("MapSize:"+map.size());

}

System.out.println("CheckedOption:"+map.get(questionRst.getLong(1)));

}catch(Exception ex){

System.out.print(ex.getMessage());

}

}

//defining main()method

public static void main(String ...s){

new DynamicTest();

}

}

## Running the Application

![Creating Dynamic Objective Test Application through Swing in JAVA ( Using MySQL Database )](https://www.mindstick.com/mindstickarticle/7999ce43-9508-4b68-958b-02d39560faf3/images/7515ff79-e98e-4fb2-a481-6be8c55d7127.png)

\

**Next, we will learn about :** [*JAVA : Singleton Pattern*](https://www.mindstick.com/blog/10912/JAVA%20Singleton%20Pattern)

---

Original Source: https://www.mindstick.com/articles/1800/creating-dynamic-objective-test-application-through-swing-in-java-using-mysql-database

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.