{"id":24028,"date":"2023-01-15T14:23:55","date_gmt":"2023-01-15T08:53:55","guid":{"rendered":"https:\/\/copyassignment.com\/?p=24028"},"modified":"2023-01-15T14:23:57","modified_gmt":"2023-01-15T08:53:57","slug":"survey-management-system-in-java","status":"publish","type":"post","link":"https:\/\/copyassignment.com\/survey-management-system-in-java\/","title":{"rendered":"Survey Management System In Java"},"content":{"rendered":"\n<p>In this article, we will learn to create a project on survey management system in Java. There are two actors: The user who can add questions and surveys and view the survey results and the guest user who can answer those surveys.<\/p>\n\n\n\n<script async=\"\" src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\n<ins class=\"adsbygoogle\" style=\"display:block; text-align:center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-9886351916045880\" data-ad-slot=\"2002566052\"><\/ins>\n<script>\n     (adsbygoogle = window.adsbygoogle || []).push({});\n<\/script>\n\n\n\n<h2 class=\"wp-block-heading\">Survey Management System In Java: Project Overview<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>Project Name:<\/strong><\/td><td>Survey Management System in Java<\/td><\/tr><tr><td><strong>Abstract:<\/strong><\/td><td>It\u2019s a GUI-based project with the Swing module to create, manage and answer surveys.<\/td><\/tr><tr><td><strong>Language\/s Used:<\/strong><\/td><td>Java<\/td><\/tr><tr><td><strong>IDE:<\/strong><\/td><td>Eclipse IDE for Java Developers<\/td><\/tr><tr><td><strong>Java version<\/strong><br><strong>(Recommended):<\/strong><\/td><td><strong>Java SE 18.0.<\/strong>&nbsp;<strong>2.1<\/strong><\/td><\/tr><tr><td><strong>Database:<\/strong><\/td><td>MySQL<\/td><\/tr><tr><td><strong>Type:<\/strong><\/td><td>Desktop Application<\/td><\/tr><tr><td>Recommended for:<\/td><td>Final Year Students<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Setting Up the environment<\/h2>\n\n\n\n<p>Make sure JDK is present in your system. It can be installed using the IDE you are using.<\/p>\n\n\n\n<p>The first step is to create a project in the name you wish. Create a package named \u201c<strong><em>survey<\/em><\/strong>\u201c. We are creating java classes in this package.<\/p>\n\n\n\n<p>To connect the project to the database, follow the steps:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Make sure MySQL is installed on your system.<\/li>\n\n\n\n<li>Download the MySQL connector from&nbsp;<a href=\"https:\/\/dev.mysql.com\/get\/Downloads\/Connector-J\/mysql-connector-j-8.0.31.zip\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a>.<\/li>\n\n\n\n<li>Open the properties of the project from the dropdown list which appears on right-click on the project. Navigate to the libraries tab and click on the classpath. Select \u201cAdd External JARs\u2026\u201d. Select the jar file from the file you downloaded after extracting it. This step will differ on IDE you are using.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">MySQL Setup for Survey Management System Project In Java<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">1. Create the database<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE DATABASE survey;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">2. Use the database<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>USE survey;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">3. Create necessary tables<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>--Actor table\nCREATE TABLE actors(id int primary key auto_increment, fname varchar(50), uname varchar(50), pass varchar(50));\n\n--User Question Table\nCREATE TABLE userQuestions(id int, surveycode varchar(5), total int);\n\n--Questions table\nCREATE TABLE questions(surveycode varchar(5), question varchar(255), option1 varchar(255), option2 varchar(255), option3 varchar(255), option4 varchar(255)); \n\n--Survey Answer table\nCREATE TABLE surveyquestions(surveycode varchar(5), qno int, opno int);<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Coding Survey Management System in Java<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">1. Main Module<\/h3>\n\n\n\n<p>File Name: &#8220;<em><strong>Main.java<\/strong><\/em>&#8220;<\/p>\n\n\n\n<p>This class contains the main function where the program starts to execute.<\/p>\n\n\n\n<div style=\"height: 250px; position:relative; margin-bottom: 50px;\" class=\"wp-block-simple-code-block-ace\"><div style=\"position:absolute;top:-20px;right:0px;cursor:pointer\" class=\"copy-simple-code-block\"><span class=\"dashicon dashicons dashicons-admin-page\"><\/span><\/div><pre class=\"wp-block-simple-code-block-ace\" style=\"position:absolute;top:0;right:0;bottom:0;left:0\" data-mode=\"java\" data-theme=\"xcode\" data-fontsize=\"14\" data-lines=\"Infinity\" data-showlines=\"true\" data-copy=\"true\">package survey;\n\nimport java.sql.SQLException;\n\npublic class Main {\n\tpublic static void main(String args[]) throws SQLException {\n\t\tLogin login = new Login();\n\t\tlogin.loginView();\n\t}\n}<\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">2. Login Module<\/h3>\n\n\n\n<p>File Name: &#8220;<em><strong>Login.java<\/strong><\/em>&#8220;<\/p>\n\n\n\n<p>This class contains the frame for the login page. Option for a signup and guest login is also present.<\/p>\n\n\n\n<div style=\"height: 250px; position:relative; margin-bottom: 50px;\" class=\"wp-block-simple-code-block-ace\"><div style=\"position:absolute;top:-20px;right:0px;cursor:pointer\" class=\"copy-simple-code-block\"><span class=\"dashicon dashicons dashicons-admin-page\"><\/span><\/div><pre class=\"wp-block-simple-code-block-ace\" style=\"position:absolute;top:0;right:0;bottom:0;left:0\" data-mode=\"java\" data-theme=\"xcode\" data-fontsize=\"14\" data-lines=\"Infinity\" data-showlines=\"true\" data-copy=\"true\">package survey;\n\nimport java.awt.Font;\nimport java.awt.event.ActionEvent;\nimport java.awt.event.ActionListener;\nimport java.sql.SQLException;\n\nimport javax.swing.JButton;\nimport javax.swing.JFrame;\nimport javax.swing.JLabel;\nimport javax.swing.JOptionPane;\nimport javax.swing.JPasswordField;\nimport javax.swing.JTextField;\n\npublic class Login {\n\t\n\tint id;\n\t\n\tpublic void loginView() throws SQLException {\n\t\tSQLManage manage = new SQLManage();\n\t\tJFrame frame = new JFrame();\n\t\tframe.setSize(450, 450);\n\t\tframe.setLayout(null);\n\t\tframe.setLocationRelativeTo(null);\n\t\t\n\t\tJLabel heading = new JLabel(\"SURVEY SYSTEM\");\n\t\theading.setBounds(0, 50, 450, 50);\n\t\theading.setHorizontalAlignment(JLabel.CENTER);\n\t\theading.setFont(new Font(\"Times New Roman\", Font.BOLD, 40));\n\t\tframe.add(heading);\n\t\t\n\t\tJLabel uname = new JLabel(\"Username : \");\n\t\tuname.setBounds(50, 130, 150, 50);\n\t\tframe.add(uname);\n\t\t\n\t\tJTextField name = new JTextField();\n\t\tname.setBounds(50, 170, 350, 30);\n\t\tframe.add(name);\n\t\t\n\t\tJLabel upass = new JLabel(\"Password : \");\n\t\tupass.setBounds(50, 200, 150, 50);\n\t\tframe.add(upass);\n\t\t\n\t\tJPasswordField pass = new JPasswordField();\n\t\tpass.setBounds(50, 240, 350, 30);\n\t\tframe.add(pass);\n\t\t\n\t\tJButton login = new JButton(\"LOGIN\");\n\t\tlogin.setBounds(100, 300, 100, 40);\n\t\tframe.add(login);\n\t\tlogin.addActionListener(new ActionListener() {\n\t\t\t@Override\n\t\t\tpublic void actionPerformed(ActionEvent e) {\n\t\t\t\tString username = name.getText();\n\t\t\t\tString password = pass.getText();\n\t\t\t\tif(username.isEmpty() || password.isEmpty()) {\n\t\t\t\t\tJOptionPane.showMessageDialog(frame, \"Please Enter All Details!!!\", \"Warning Message\", JOptionPane.WARNING_MESSAGE);\n\t\t\t\t}\n\t\t\t\telse {\n\t\t\t\t\ttry {\n\t\t\t\t\t\tSQLManage manage= new SQLManage();\n\t\t\t\t\t\tid = manage.authUser(username, password);\n\t\t\t\t\t} catch (SQLException e1) {\n\t\t\t\t\t\te1.printStackTrace();\n\t\t\t\t\t}\n\t\t\t\t\tif (id == -1) {\n\t\t\t\t\t\tJOptionPane.showMessageDialog(frame, \"No User Found!!!\", \"Warning Message\", JOptionPane.WARNING_MESSAGE);\n\t\t\t\t\t}\n\t\t\t\t\telse if(id == 0) {\n\t\t\t\t\t\tJOptionPane.showMessageDialog(frame, \"Wrong Password!!!\", \"Warning Message\", JOptionPane.WARNING_MESSAGE);\n\t\t\t\t\t}\n\t\t\t\t\telse {\n\t\t\t\t\t\tMainPage mainPage = new MainPage();\n\t\t\t\t\t\ttry {\n\t\t\t\t\t\t\tmainPage.mainPageView(id);\n\t\t\t\t\t\t} catch (SQLException e1) {\n\t\t\t\t\t\t\te1.printStackTrace();\n\t\t\t\t\t\t}\n\t\t\t\t\t\tframe.dispose();\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t}\n\t\t});\n\t\t\n\t\tJButton signUp = new JButton(\"SIGNUP\");\n\t\tsignUp.setBounds(250, 300, 100, 40);\n\t\tframe.add(signUp);\n\t\tsignUp.addActionListener(new ActionListener() {\n\t\t\t@Override\n\t\t\tpublic void actionPerformed(ActionEvent e) {\n\t\t\t\tSignUp signup = new SignUp();\n\t\t\t\tsignup.signUpView();\n\t\t\t}\n\t\t});\n\t\t\n\t\tJButton attend = new JButton(\"ATTEND A SURVEY (GUEST)\");\n\t\tattend.setBounds(100, 350, 250, 40);\n\t\tframe.add(attend);\n\t\tattend.addActionListener(new ActionListener() {\n\t\t\t@Override\n\t\t\tpublic void actionPerformed(ActionEvent e) {\n\t\t\t\tString surveyCode = JOptionPane.showInputDialog(\"Enter the Survey Code : \");\n\t\t\t\ttry {\n\t\t\t\t\tif(!surveyCode.isEmpty() &amp;&amp; surveyCode.length() == 5) {\n\t\t\t\t\t\tif(manage.check(surveyCode)) {\n\t\t\t\t\t\t\tGuest guest = new Guest();\n\t\t\t\t\t\t\tguest.guestView(surveyCode);\n\t\t\t\t\t\t}\n\t\t\t\t\t\telse {\n\t\t\t\t\t\t\tJOptionPane.showMessageDialog(frame, \"No Survey Available!!!\", \"Warning Message\", JOptionPane.WARNING_MESSAGE);\n\t\t\t\t\t\t}\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t\tcatch(Exception e2) {\n\t\t\t\t\t\n\t\t\t\t}\n\t\t\t}\n\t\t});\n\t\t\n\t\tframe.setVisible(true);\n\t}\n}<\/pre><\/div>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img decoding=\"async\" data-src=\"https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/login.png\" alt=\"login output\" class=\"wp-image-24037 lazyload\" width=\"409\" height=\"415\" data-srcset=\"https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/login.png 542w, https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/login-295x300.png 295w, https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/login-100x100.png 100w\" data-sizes=\"(max-width: 409px) 100vw, 409px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 409px; --smush-placeholder-aspect-ratio: 409\/415;\" \/><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\">3. SignUp Module<\/h3>\n\n\n\n<p>File Name: &#8220;<em><strong>SignUp.java<\/strong><\/em>&#8220;<\/p>\n\n\n\n<p>This module helps to create new users.<\/p>\n\n\n\n<div style=\"height: 250px; position:relative; margin-bottom: 50px;\" class=\"wp-block-simple-code-block-ace\"><div style=\"position:absolute;top:-20px;right:0px;cursor:pointer\" class=\"copy-simple-code-block\"><span class=\"dashicon dashicons dashicons-admin-page\"><\/span><\/div><pre class=\"wp-block-simple-code-block-ace\" style=\"position:absolute;top:0;right:0;bottom:0;left:0\" data-mode=\"java\" data-theme=\"xcode\" data-fontsize=\"14\" data-lines=\"Infinity\" data-showlines=\"true\" data-copy=\"true\">package survey;\n\nimport java.awt.Font;\nimport java.awt.event.ActionEvent;\nimport java.awt.event.ActionListener;\nimport java.sql.SQLException;\n\nimport javax.swing.JButton;\nimport javax.swing.JFrame;\nimport javax.swing.JLabel;\nimport javax.swing.JOptionPane;\nimport javax.swing.JPasswordField;\nimport javax.swing.JTextField;\n\npublic class SignUp {\n\tpublic void signUpView() {\n\t\tJFrame frame = new JFrame();\n\t\tframe.setSize(450, 450);\n\t\tframe.setLayout(null);\n\t\tframe.setLocationRelativeTo(null);\n\t\t\n\t\tJLabel heading = new JLabel(\"SURVEY SYSTEM\");\n\t\theading.setBounds(0, 50, 450, 50);\n\t\theading.setHorizontalAlignment(JLabel.CENTER);\n\t\theading.setFont(new Font(\"Times New Roman\", Font.BOLD, 40));\n\t\tframe.add(heading);\n\t\t\n\t\tJLabel fName = new JLabel(\"Name : \");\n\t\tfName.setBounds(50, 120, 150, 50);\n\t\tframe.add(fName);\n\t\t\n\t\tJTextField fNameField = new JTextField();\n\t\tfNameField.setBounds(50, 160, 350, 30);\n\t\tframe.add(fNameField);\n\t\t\n\t\tJLabel uName = new JLabel(\"Username : \");\n\t\tuName.setBounds(50, 190, 150, 50);\n\t\tframe.add(uName);\n\t\t\n\t\tJTextField uNameField = new JTextField();\n\t\tuNameField.setBounds(50, 230, 350, 30);\n\t\tframe.add(uNameField);\n\t\t\n\t\tJLabel uPass = new JLabel(\"Password : \");\n\t\tuPass.setBounds(50, 260, 150, 50);\n\t\tframe.add(uPass);\n\t\t\n\t\tJPasswordField uPassField = new JPasswordField();\n\t\tuPassField.setBounds(50, 300, 150, 30);\n\t\tframe.add(uPassField);\n\t\t\n\t\tJLabel uPass2 = new JLabel(\"Confirm Password : \");\n\t\tuPass2.setBounds(250, 260, 150, 50);\n\t\tframe.add(uPass2);\n\t\t\n\t\tJPasswordField uPassField2 = new JPasswordField();\n\t\tuPassField2.setBounds(250, 300, 150, 30);\n\t\tframe.add(uPassField2);\n\t\t\n\t\tJButton submit = new JButton(\"SUBMIT\");\n\t\tsubmit.setBounds(175, 350, 100, 40);\n\t\tframe.add(submit);\n\t\tsubmit.addActionListener(new ActionListener() {\n\t\t\t@Override\n\t\t\tpublic void actionPerformed(ActionEvent e) {\n\t\t\t\tString fname = fNameField.getText();\n\t\t\t\tString uname = uNameField.getText();\n\t\t\t\tString pass1 = uPassField.getText();\n\t\t\t\tString pass2 = uPassField2.getText();\n\t\t\t\tif(fname.isEmpty() || uname.isEmpty() || pass1.isEmpty() || pass2.isEmpty()) {\n\t\t\t\t\tJOptionPane.showMessageDialog(frame, \"Please Enter All Details!!!\", \"Warning Message\", JOptionPane.WARNING_MESSAGE);\n\t\t\t\t}\n\t\t\t\telse {\n\t\t\t\t\tif(pass1.equals(pass2)) {\n\t\t\t\t\t\ttry {\n\t\t\t\t\t\t\tSQLManage manage = new SQLManage();\n\t\t\t\t\t\t\tmanage.newUser(fname, uname, pass1);\n\t\t\t\t\t\t\tfNameField.setText(\"\");\n\t\t\t\t\t\t\tuNameField.setText(\"\");\n\t\t\t\t\t\t\tuPassField.setText(\"\");\n\t\t\t\t\t\t\tuPassField2.setText(\"\");\n\t\t\t\t\t\t\tJOptionPane.showMessageDialog(frame, \"User Created Succesfully!!!\", \"User Created\", JOptionPane.PLAIN_MESSAGE);\n\t\t\t\t\t\t\tframe.dispose();\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t} catch (SQLException e1) {\n\t\t\t\t\t\t\tJOptionPane.showMessageDialog(frame, \"Something went wrong!!!\", \"Warning Message\", JOptionPane.WARNING_MESSAGE);\n\t\t\t\t\t\t}\n\t\t\t\t\t\t\n\t\t\t\t\t}\n\t\t\t\t\telse {\n\t\t\t\t\t\tJOptionPane.showMessageDialog(frame, \"Password Mismatch\", \"Warning Message\", JOptionPane.WARNING_MESSAGE);\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t}\n\t\t});\n\t\t\n\t\tframe.setVisible(true);\n\t}\n}<\/pre><\/div>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img decoding=\"async\" data-src=\"https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/2.png\" alt=\"signup output\" class=\"wp-image-24039 lazyload\" width=\"406\" height=\"413\" data-srcset=\"https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/2.png 542w, https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/2-295x300.png 295w\" data-sizes=\"(max-width: 406px) 100vw, 406px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 406px; --smush-placeholder-aspect-ratio: 406\/413;\" \/><\/figure>\n<\/div>\n\n\n<script async=\"\" src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\n<ins class=\"adsbygoogle\" style=\"display:block; text-align:center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-9886351916045880\" data-ad-slot=\"2002566052\"><\/ins>\n<script>\n     (adsbygoogle = window.adsbygoogle || []).push({});\n<\/script>\n\n\n\n<h3 class=\"wp-block-heading\">4. Home page Module<\/h3>\n\n\n\n<p>File Name: &#8220;<em><strong>MainPage.java<\/strong><\/em>&#8220;<\/p>\n\n\n\n<p>This is the module for the home page of the users. Options for creating new surveys and viewing their result can be done from this page.<\/p>\n\n\n\n<div style=\"height: 250px; position:relative; margin-bottom: 50px;\" class=\"wp-block-simple-code-block-ace\"><div style=\"position:absolute;top:-20px;right:0px;cursor:pointer\" class=\"copy-simple-code-block\"><span class=\"dashicon dashicons dashicons-admin-page\"><\/span><\/div><pre class=\"wp-block-simple-code-block-ace\" style=\"position:absolute;top:0;right:0;bottom:0;left:0\" data-mode=\"java\" data-theme=\"xcode\" data-fontsize=\"14\" data-lines=\"Infinity\" data-showlines=\"true\" data-copy=\"true\">package survey;\n\nimport java.awt.Color;\nimport java.awt.Font;\nimport java.awt.event.ActionEvent;\nimport java.awt.event.ActionListener;\nimport java.awt.event.KeyEvent;\nimport java.awt.event.KeyListener;\nimport java.awt.event.MouseAdapter;\nimport java.awt.event.MouseEvent;\nimport java.awt.event.MouseListener;\nimport java.nio.charset.Charset;\nimport java.sql.ResultSet;\nimport java.sql.SQLException;\nimport java.util.Random;\n\nimport javax.swing.JButton;\nimport javax.swing.JFrame;\nimport javax.swing.JLabel;\nimport javax.swing.JOptionPane;\nimport javax.swing.JPanel;\nimport javax.swing.JScrollPane;\nimport javax.swing.JTable;\nimport javax.swing.JTextField;\nimport javax.swing.table.DefaultTableModel;\n\npublic class MainPage {\n\t\n\tSQLManage manage;\n\tJButton submit;\n\tString[] questionsArray, option1Array, option2Array, option3Array, option4Array;\n\tstatic DefaultTableModel model;\n\tString cd;\n\t\n\tint i=0, h=0;\n\tString[] queStr = new String[50];\n\tString[] op1Str = new String[50];\n\tString[] op2Str = new String[50];\n\tString[] op3Str = new String[50];\n\tString[] op4Str = new String[50];\n\tint id;\n\tpublic void mainPageView(int id) throws SQLException {\n\t\tthis.id=id;\n\t\tquestionsArray = new String[25];\n\t\toption1Array = new String[25]; \n\t\toption2Array = new String[25];\n\t\toption3Array = new String[25];\n\t\toption4Array = new String[25];\n\t\t\n\t\tmanage = new SQLManage();\n\t\t\n\t\tJFrame frame = new JFrame();\n\t\tframe.setSize(800, 600);\n\t\tframe.setLayout(null);\n\t\tframe.setLocationRelativeTo(null);\n\t\t\n\t\t\/\/-------------------------------------ADD PANEL--------------------------------------------------\n\t\tJPanel addPanel = new JPanel();\n\t\taddPanel.setBounds(250, 0, 550, 600);\n\t\taddPanel.setLayout(null);\n\t\t\n\t\tJLabel question = new JLabel(\"Question : \");\n\t\tquestion.setBounds(50, 100, 100, 20);\n\t\taddPanel.add(question);\n\t\tJTextField questionField = new JTextField();\n\t\tquestionField.setBounds(50, 125, 450, 30);\n\t\taddPanel.add(questionField);\n\t\t\n\t\tJLabel option1 = new JLabel(\"Option 1 : \");\n\t\toption1.setBounds(50, 165, 100, 20);\n\t\taddPanel.add(option1);\n\t\tJTextField option1Field = new JTextField();\n\t\toption1Field.setBounds(50, 190, 200, 30);\n\t\taddPanel.add(option1Field);\n\t\t\n\t\tJLabel option2 = new JLabel(\"Option 2 : \");\n\t\toption2.setBounds(50, 230, 100, 20);\n\t\taddPanel.add(option2);\n\t\tJTextField option2Field = new JTextField();\n\t\toption2Field.setBounds(50, 255, 200, 30);\n\t\taddPanel.add(option2Field);\n\t\t\n\t\tJLabel option3 = new JLabel(\"Option 3 : \");\n\t\toption3.setBounds(50, 295, 100, 20);\n\t\taddPanel.add(option3);\n\t\tJTextField option3Field = new JTextField();\n\t\toption3Field.setBounds(50, 320, 200, 30);\n\t\taddPanel.add(option3Field);\n\t\t\n\t\tJLabel option4 = new JLabel(\"Option 4 : \");\n\t\toption4.setBounds(50, 360, 100, 20);\n\t\taddPanel.add(option4);\n\t\tJTextField option4Field = new JTextField();\n\t\toption4Field.setBounds(50, 385, 200, 30);\n\t\taddPanel.add(option4Field);\n\t\t\n\t\tJLabel start = new JLabel(\"CREATE A SURVEY\");\n\t\tstart.setBounds(0, 10, 550, 50);\n\t\tstart.setHorizontalAlignment(JLabel.CENTER);\n\t\tstart.setFont(new Font(\"Times New Roman\", Font.BOLD, 40));\n\t\taddPanel.add(start);\n\t\t\n\t\tJButton next = new JButton(\"ADD QUESTION >\");\n\t\tnext.setBounds(50, 440, 450, 35);\n\t\taddPanel.add(next);\n\t\tnext.addActionListener(new ActionListener( ) {\n\t\t\t@Override\n\t\t\tpublic void actionPerformed(ActionEvent e) {\n\t\t\t\tString qn = questionField.getText();\n\t\t\t\tString op1 = option1Field.getText();\n\t\t\t\tString op2 = option2Field.getText();;\n\t\t\t\tString op3 = option3Field.getText();;\n\t\t\t\tString op4 = option4Field.getText();;\n\t\t\t\tif(qn.equals(\"\") || op1.equals(\"\") || op2.equals(\"\") || op3.equals(\"\") || op4.equals(\"\")) {\n\t\t\t\t\tJOptionPane.showMessageDialog(frame, \"Please Enter All Details!!!\", \"Warning Message\", JOptionPane.WARNING_MESSAGE);\n\t\t\t\t}\n\t\t\t\telse {\n\t\t\t\t\tquestionField.setText(\"\");\n\t\t\t\t\toption1Field.setText(\"\");\n\t\t\t\t\toption2Field.setText(\"\");\n\t\t\t\t\toption3Field.setText(\"\");\n\t\t\t\t\toption4Field.setText(\"\");\n\t\t\t\t\tqueStr[i] = qn;\n\t\t\t\t\top1Str[i] = op1;\n\t\t\t\t\top2Str[i] = op2;\n\t\t\t\t\top3Str[i] = op3;\n\t\t\t\t\top4Str[i] = op4;\n\t\t\t\t\ti++;\n\t\t\t\t\tsubmit.setEnabled(true);\n\t\t\t\t}\n\t\t\t}\n\t\t});\n\t\t\n\t\tsubmit = new JButton(\"SUBMIT\");\n\t\tsubmit.setBounds(50, 490, 200, 50);\n\t\tsubmit.setEnabled(false);\n\t\taddPanel.add(submit);\n\t\tsubmit.addActionListener(new ActionListener( ) {\n\t\t\t@Override\n\t\t\tpublic void actionPerformed(ActionEvent e) {\n\t\t\t\tString code = stringGenerator();\n\t\t\t\tString qn = questionField.getText();\n\t\t\t\tString op1 = option1Field.getText();\n\t\t\t\tString op2 = option2Field.getText();;\n\t\t\t\tString op3 = option3Field.getText();;\n\t\t\t\tString op4 = option4Field.getText();;\n\t\t\t\tif(!(qn.equals(\"\") &amp;&amp; op1.equals(\"\") &amp;&amp; op2.equals(\"\") &amp;&amp; op3.equals(\"\") &amp;&amp; op4.equals(\"\"))) {\n\t\t\t\t\tJOptionPane.showMessageDialog(frame, \"Last details are not added. If not required, Please clear the fields!!!\", \"Warning Message\", JOptionPane.WARNING_MESSAGE);\n\t\t\t\t}\n\t\t\t\telse {\n\t\t\t\t\tif(i==0) {\n\t\t\t\t\t\tJOptionPane.showMessageDialog(frame, \"No Questions Added\", \"Warning Message\", JOptionPane.WARNING_MESSAGE);\n\t\t\t\t\t}\n\t\t\t\t\telse {\n\t\t\t\t\t\ttry {\n\t\t\t\t\t\t\tmanage.userQuestionAdd(id, code);\n\t\t\t\t\t\t\tfor(int j=0; j&lt;i; j++) {\n\t\t\t\t\t\t\t\tmanage.newQuestion(code, queStr[j], op1Str[j], op2Str[j], op3Str[j], op4Str[j]);\n\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t\tJOptionPane.showMessageDialog(frame, \"Survey Added. Survey Code : \" + code, \"Congradulations\", JOptionPane.PLAIN_MESSAGE); \n\t\t\t\t\t\t}\n\t\t\t\t\t\tcatch (SQLException e1) {\n\t\t\t\t\t\t\t\te1.printStackTrace();\n\t\t\t\t\t\t}\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t\tsubmit.setEnabled(false);\n\t\t\t}\n\t\t});\n\t\t\n\t\tJButton cancel = new JButton(\"CANCEL\");\n\t\tcancel.setBounds(300, 490, 200, 50);\n\t\taddPanel.add(cancel);\n\t\tcancel.addActionListener(new ActionListener( ) {\n\t\t\t@Override\n\t\t\tpublic void actionPerformed(ActionEvent e) {\n\t\t\t\tquestionField.setText(\"\");\n\t\t\t\toption1Field.setText(\"\");\n\t\t\t\toption2Field.setText(\"\");\n\t\t\t\toption3Field.setText(\"\");\n\t\t\t\toption4Field.setText(\"\");\n\t\t\t\ti=0;\n\t\t\t}\n\t\t});\n\t\t\n\t\tframe.add(addPanel);\n\t\t\/\/---------------------------------------------------------------------------------------------------\n\t\t\n\t\t\/\/----------------------------------------------------VIEW PANEL---------------------------------------------\n\t\tJPanel viewPanel = new JPanel();\n\t\tviewPanel.setBounds(250, 0, 550, 600);\n\t\tviewPanel.setLayout(null);\n\t\tJLabel searchLabel = new JLabel(\"Search : \");\n\t\tsearchLabel.setBounds(100, 20, 100, 50);\n\t\tviewPanel.add(searchLabel);\n\t\t\n\t\tJTextField search = new JTextField();\n\t\tsearch.setBounds(160, 30, 290, 30);\n\t\tviewPanel.add(search);\n\t\tsearch.addKeyListener(new KeyListener() {\n\t\t\t@Override\n\t\t\tpublic void keyReleased(KeyEvent e) {\n\t\t\t\ttblupdt(search.getText());\n\t\t\t}\n\n\t\t\t@Override\n\t\t\tpublic void keyTyped(KeyEvent e) {\n\t\t\t\t\/\/To avoid errors.\n\t\t\t}\n\n\t\t\t@Override\n\t\t\tpublic void keyPressed(KeyEvent e) {\n\t\t\t\t\/\/To avoid errors.\n\t\t\t}\n\t\t});\n\t\t\n\t\tJTable table=new JTable(){\n\t\t\tpublic boolean isCellEditable(int row,int column){\n\t\t\t\treturn false;\n\t\t\t}\n\t\t};\n\t\tmodel = (DefaultTableModel)table.getModel();\n\t\ttable.setBackground(Color.decode(\"#f9d6c4\"));\n\t\tmodel.addColumn(\"Your Surveys\");\n\t\ttblupdt(\"\");\n\t\tJScrollPane scPane=new JScrollPane(table);\n\t\tscPane.setBounds(100, 70, 350, 225);\n\t\tviewPanel.add(scPane);\n\t\t\n\t\tJLabel quesView = new JLabel();\n\t\tquesView.setBounds(50, 340, 150, 50);\n\t\tviewPanel.add(quesView);\n\t\t\n\t\tJLabel op1View = new JLabel();\n\t\top1View.setBounds(70, 380, 150, 50);\n\t\tviewPanel.add(op1View);\n\t\t\n\t\tJLabel op2View = new JLabel();\n\t\top2View.setBounds(70, 420, 150, 50);\n\t\tviewPanel.add(op2View);\n\t\t\n\t\tJLabel op3View = new JLabel();\n\t\top3View.setBounds(70, 460, 150, 50);\n\t\tviewPanel.add(op3View);\n\t\t\n\t\tJLabel op4View = new JLabel();\n\t\top4View.setBounds(70, 500, 150, 50);\n\t\tviewPanel.add(op4View);\n\t\t\n\t\tJLabel op1Select = new JLabel();\n\t\top1Select.setBounds(100, 400, 150, 50);\n\t\tviewPanel.add(op1Select);\n\t\t\n\t\tJLabel op2Select = new JLabel();\n\t\top2Select.setBounds(100, 440, 150, 50);\n\t\tviewPanel.add(op2Select);\n\t\t\n\t\tJLabel op3Select = new JLabel();\n\t\top3Select.setBounds(100, 480, 150, 50);\n\t\tviewPanel.add(op3Select);\n\t\t\n\t\tJLabel op4Select = new JLabel();\n\t\top4Select.setBounds(100, 520, 150, 50);\n\t\tviewPanel.add(op4Select);\n\t\t\n\t\tJButton delete = new JButton(\"DELETE\");\n\t\tdelete.setBounds(210, 300, 130, 50);\n\t\tdelete.setEnabled(false);\n\t\tviewPanel.add(delete);\n\t\t\n\t\tJButton viewPrev = new JButton(\"PREVIOUS\");\n\t\tviewPrev.setBounds(100, 300, 100, 50);\n\t\tviewPrev.setEnabled(false);\n\t\tviewPanel.add(viewPrev);\n\t\tviewPrev.addActionListener(new ActionListener() {\n\t\t\t@Override\n\t\t\tpublic void actionPerformed(ActionEvent e) {\n\t\t\t\tif(h>=0) {\n\t\t\t\t\th--;\n\t\t\t\t\tquesView.setText(questionsArray[h]);\n\t\t\t\t\top1View.setText(option1Array[h]);\n\t\t\t\t\top2View.setText(option2Array[h]);\n\t\t\t\t\top3View.setText(option3Array[h]);\n\t\t\t\t\top4View.setText(option4Array[h]);\n\t\t\t\t\ttry {\n\t\t\t\t\t\top1Select.setText(String.valueOf(manage.getCount(cd, h, 1)));\n\t\t\t\t\t\top2Select.setText(String.valueOf(manage.getCount(cd, h, 2)));\n\t\t\t\t\t\top3Select.setText(String.valueOf(manage.getCount(cd, h, 3)));\n\t\t\t\t\t\top4Select.setText(String.valueOf(manage.getCount(cd, h, 4)));\n\t\t\t\t\t} catch (SQLException e1) {\n\t\t\t\t\t\te1.printStackTrace();\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t}\n\t\t});\n\t\t\n\t\tdelete.addActionListener(new ActionListener() {\n\t\t\t@Override\n\t\t\tpublic void actionPerformed(ActionEvent e) {\n\t\t\t\ttry {\n\t\t\t\t\tmanage.removeSurvey(cd);\n\t\t\t\t} catch (SQLException e1) {\n\t\t\t\t\te1.printStackTrace();\n\t\t\t\t}\n\t\t\t\ttblupdt(search.getText());\n\t\t\t}\n\t\t});\n\t\t\n\t\tJButton viewNext = new JButton(\"NEXT\");\n\t\tviewNext.setBounds(350, 300, 100, 50);\n\t\tviewNext.setEnabled(false);\n\t\tviewPanel.add(viewNext);\n\t\tviewNext.addActionListener(new ActionListener() {\n\t\t\t@Override\n\t\t\tpublic void actionPerformed(ActionEvent e) {\n\t\t\t\th++;\n\t\t\t\tquesView.setText(questionsArray[h]);\n\t\t\t\top1View.setText(option1Array[h]);\n\t\t\t\top2View.setText(option2Array[h]);\n\t\t\t\top3View.setText(option3Array[h]);\n\t\t\t\top4View.setText(option4Array[h]);\n\t\t\t\ttry {\n\t\t\t\t\top1Select.setText(String.valueOf(manage.getCount(cd, h, 1)));\n\t\t\t\t\top2Select.setText(String.valueOf(manage.getCount(cd, h, 2)));\n\t\t\t\t\top3Select.setText(String.valueOf(manage.getCount(cd, h, 3)));\n\t\t\t\t\top4Select.setText(String.valueOf(manage.getCount(cd, h, 4)));\n\t\t\t\t} catch (SQLException e1) {\n\t\t\t\t\te1.printStackTrace();\n\t\t\t\t}\n\t\t\t}\n\t\t});\n\t\t\n\t\t\n\t\ttable.addMouseListener(new MouseAdapter() {\n\t\t\t@Override\n\t\t\tpublic void mouseClicked(MouseEvent e) {\n\t\t\t\th=0;\n\t\t\t\tdelete.setEnabled(true);\n\t\t\t\tviewNext.setEnabled(true);\n\t\t\t\tviewPrev.setEnabled(true);\n\t\t\t\tint row = table.getSelectedRow();\n\t\t\t\tcd = String.valueOf(model.getValueAt(row, 0));\t\n\t\t\t\ttry {\n\t\t\t\t\tResultSet rst1 = manage.getQuestions(cd);\n\t\t\t\t\tfor(int x=0; rst1.next(); x++) {\n\t\t\t\t\t\tquestionsArray[x] = rst1.getString(\"question\");\n\t\t\t\t\t\toption1Array[x] = rst1.getString(\"option1\");\n\t\t\t\t\t\toption2Array[x] = rst1.getString(\"option2\");\n\t\t\t\t\t\toption3Array[x] = rst1.getString(\"option3\");\n\t\t\t\t\t\toption4Array[x] = rst1.getString(\"option4\");\n\t\t\t\t\t}\n\t\t\t\t\top1Select.setText(String.valueOf(manage.getCount(cd, h, 1)));\n\t\t\t\t\top2Select.setText(String.valueOf(manage.getCount(cd, h, 2)));\n\t\t\t\t\top3Select.setText(String.valueOf(manage.getCount(cd, h, 3)));\n\t\t\t\t\top4Select.setText(String.valueOf(manage.getCount(cd, h, 4)));\n\t\t\t\t} \n\t\t\t\tcatch (SQLException e1) {\n\t\t\t\t\te1.printStackTrace();\n\t\t\t\t}\n\t\t\t\tquesView.setText(questionsArray[h]);\n\t\t\t\top1View.setText(option1Array[h]);\n\t\t\t\top2View.setText(option2Array[h]);\n\t\t\t\top3View.setText(option3Array[h]);\n\t\t\t\top4View.setText(option4Array[h]);\n\t\t\t}\n\t\t});\n\t\n\t\t\n\t\tframe.add(viewPanel);\n\t\t\n\t\t\/\/--------------------------------------------------------------------------------------------------------------\n\t\t\n\t\t\/\/-----------------------------------------------SIDE PANEL-------------------------------------------------------\n\t\tJPanel optionPanel = new JPanel();\n\t\toptionPanel.setBounds(0, 0, 250, 600);\n\t\toptionPanel.setBackground(Color.gray);\n\t\toptionPanel.setLayout(null);\n\t\tframe.add(optionPanel);\n\t\t\n\t\tJButton addSurvey = new JButton(\"ADD SURVEY\");\n\t\taddSurvey.setBounds(50, 113, 150, 50);\n\t\toptionPanel.add(addSurvey);\n\t\taddSurvey.addActionListener(new ActionListener() {\n\t\t\t@Override\n\t\t\tpublic void actionPerformed(ActionEvent e) {\n\t\t\t\tviewPanel.setVisible(false);\n\t\t\t\taddPanel.setVisible(true);\n\t\t\t}\n\t\t});\n\t\t\n\t\tJButton viewSurvey = new JButton(\"VIEW SURVEY\");\n\t\tviewSurvey.setBounds(50, 276, 150, 50);\n\t\toptionPanel.add(viewSurvey);\n\t\tviewSurvey.addActionListener(new ActionListener() {\n\t\t\t@Override\n\t\t\tpublic void actionPerformed(ActionEvent e) {\n\t\t\t\ttblupdt(search.getText());\n\t\t\t\tviewPanel.setVisible(true);\n\t\t\t\taddPanel.setVisible(false);\n\t\t\t}\n\t\t});\n\t\t\n\t\tJButton logout = new JButton(\"LOGOUT\");\n\t\tlogout.setBounds(50, 440, 150, 50);\n\t\toptionPanel.add(logout);\n\t\tlogout.addActionListener(new ActionListener() {\n\t\t\t@Override\n\t\t\tpublic void actionPerformed(ActionEvent e) {\n\t\t\t\tLogin login = new Login();\n\t\t\t\ttry {\n\t\t\t\t\tlogin.loginView();\n\t\t\t\t} catch (SQLException e1) {\n\t\t\t\t\te1.printStackTrace();\n\t\t\t\t}\n\t\t\t\tframe.dispose();\n\t\t\t}\n\t\t});\n\t\t\/\/-------------------------------------------------------------------------------------------------------\n\t\t\n\t\tviewPanel.setVisible(false);\n\t\t\n\t\tframe.setVisible(true);\n\t}\n\t\n\tpublic String stringGenerator() {\n\t\t  String AlphaNumericString = \"ABCDEFGHIJKLMNOPQRSTUVWXYZ\";\n\t\t\t  String sb = \"\";\n\t\t\t  for (int i = 0; i &lt; 5; i++) {\n\t\t\t   int index = (int)(AlphaNumericString.length() * Math.random());\n\t\t\t   sb += (AlphaNumericString.charAt(index));\n\t\t\t  }\n\t\treturn sb;\n\t}\n\t\n\tpublic void tblupdt(String str) {\n\t\ttry {\n\t\t\tSQLManage man = new SQLManage();\n\t\t\tResultSet res = man.surveys(id, str);\n\t\t\tint rowCount = model.getRowCount();\n\t\t\tint i;\n\t\t\tfor (i = rowCount - 1; i >= 0; i--)\n\t\t\t    model.removeRow(i);\n\t\t\tfor(i=0; res.next(); i++) {\n\t\t\t\tmodel.addRow(new Object[0]);\n\t\t        model.setValueAt(res.getString(\"surveycode\"), i, 0);\n\t\t\t}\n\t\t} catch (SQLException e1) {\n\t\t\te1.printStackTrace();\n\t\t}\n\t}\n\n}<\/pre><\/div>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img decoding=\"async\" data-src=\"https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/main.png\" alt=\"main or home page\" class=\"wp-image-24040 lazyload\" width=\"584\" height=\"440\" data-srcset=\"https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/main.png 981w, https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/main-300x226.png 300w, https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/main-768x579.png 768w, https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/main-675x508.png 675w\" data-sizes=\"(max-width: 584px) 100vw, 584px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 584px; --smush-placeholder-aspect-ratio: 584\/440;\" \/><\/figure>\n<\/div>\n\n\n<p>This page helps to create surveys.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img decoding=\"async\" data-src=\"https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/main2.png\" alt=\"view survey\" class=\"wp-image-24041 lazyload\" width=\"582\" height=\"437\" data-srcset=\"https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/main2.png 981w, https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/main2-300x226.png 300w, https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/main2-675x508.png 675w, https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/main2-480x360.png 480w\" data-sizes=\"(max-width: 582px) 100vw, 582px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 582px; --smush-placeholder-aspect-ratio: 582\/437;\" \/><\/figure>\n<\/div>\n\n\n<script async=\"\" src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\n<ins class=\"adsbygoogle\" style=\"display:block; text-align:center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-9886351916045880\" data-ad-slot=\"2002566052\"><\/ins>\n<script>\n     (adsbygoogle = window.adsbygoogle || []).push({});\n<\/script>\n\n\n\n<p>This page helps to view the response from the survey.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">5. Guest Module<\/h3>\n\n\n\n<p>File Name: &#8220;<strong><em>Guest.java<\/em><\/strong>&#8220;<\/p>\n\n\n\n<p>This module helps the users to attend the survey without logging in.<\/p>\n\n\n\n<div style=\"height: 250px; position:relative; margin-bottom: 50px;\" class=\"wp-block-simple-code-block-ace\"><div style=\"position:absolute;top:-20px;right:0px;cursor:pointer\" class=\"copy-simple-code-block\"><span class=\"dashicon dashicons dashicons-admin-page\"><\/span><\/div><pre class=\"wp-block-simple-code-block-ace\" style=\"position:absolute;top:0;right:0;bottom:0;left:0\" data-mode=\"java\" data-theme=\"xcode\" data-fontsize=\"14\" data-lines=\"Infinity\" data-showlines=\"true\" data-copy=\"true\">package survey;\n\nimport java.awt.Font;\nimport java.awt.event.ActionEvent;\nimport java.awt.event.ActionListener;\nimport java.sql.ResultSet;\nimport java.sql.SQLException;\n\nimport javax.swing.ButtonGroup;\nimport javax.swing.JButton;\nimport javax.swing.JFrame;\nimport javax.swing.JLabel;\nimport javax.swing.JOptionPane;\nimport javax.swing.JRadioButton;\n\npublic class Guest {\n\t\n\tSQLManage manage;\n\tint[] opt;\n\tint k;\n\t\n\tpublic void guestView(String surveyCode) throws SQLException {\n\t\t\n\t\tmanage = new SQLManage();\n\t\tResultSet rst = manage.getQuestions(surveyCode);\n\t\topt = new int[50];\n\t\t\n\t\tFont options = new Font(\"Times New Roman\", Font.BOLD, 15);\n\t\t\n\t\tJFrame frame = new JFrame();\n\t\tframe.setSize(800, 600);\n\t\tframe.setLayout(null);\n\t\tframe.setLocationRelativeTo(null);\n\n\t\tJLabel start = new JLabel(\"ATTENDING THE SURVEY\");\n\t\tstart.setBounds(0, 50, 800, 50);\n\t\tstart.setHorizontalAlignment(JLabel.CENTER);\n\t\tstart.setFont(new Font(\"Times New Roman\", Font.BOLD, 40));\n\t\tframe.add(start);\n\t\t\n\t\tJLabel ques = new JLabel(\"Question Here!!!\");\n\t\tques.setBounds(80, 200, 500, 30);\n\t\tques.setFont(new Font(\"Times New Roman\", Font.BOLD, 18));\n\t\tframe.add(ques);\n\t\t\n\t\tJRadioButton op1 = new JRadioButton(\"Option1\");\n\t\tJRadioButton op2 = new JRadioButton(\"Option2\");\n\t\tJRadioButton op3 = new JRadioButton(\"Opyion3\");\n\t\tJRadioButton op4 = new JRadioButton(\"Option4\");\n\t\t\n\t\tButtonGroup bgroup = new ButtonGroup();\n\t\tbgroup.add(op1);\n\t\tbgroup.add(op2);\n\t\tbgroup.add(op3);\n\t\tbgroup.add(op4);\n\t\t\n\t\top1.setBounds(100, 250, 500, 30);\n\t\top2.setBounds(100, 300, 500, 30);\n\t\top3.setBounds(100, 350, 500, 30);\n\t\top4.setBounds(100, 400, 500, 30);\n\t\t\n\t\top1.setFont(options);\n\t\top2.setFont(options);\n\t\top3.setFont(options);\n\t\top4.setFont(options);\n\t\t\n\t\tif(rst.next()) {\n\t\t\tques.setText(rst.getString(\"question\"));\n\t\t\top1.setText(rst.getString(\"option1\"));\n\t\t\top2.setText(rst.getString(\"option2\"));\n\t\t\top3.setText(rst.getString(\"option3\"));\n\t\t\top4.setText(rst.getString(\"option4\"));\n\t\t}\n\t\t\n\t\tframe.add(op1);\n\t\tframe.add(op2);\n\t\tframe.add(op3);\n\t\tframe.add(op4);\n\t\tk=0;\n\t\t\n\t\tJButton nextButton = new JButton(\"NEXT\");\n\t\tnextButton.setBounds(100, 470, 600, 50);\n\t\tframe.add(nextButton);\n\t\tnextButton.addActionListener(new ActionListener() {\n\t\t\t@Override\n\t\t\tpublic void actionPerformed(ActionEvent e) {\n\t\t\t\tint x;\n\t\t\t\tif(op1.isSelected()) {\n\t\t\t\t\tx=1;\n\t\t\t\t}\n\t\t\t\telse if(op2.isSelected()) {\n\t\t\t\t\tx=2;\n\t\t\t\t}\n\t\t\t\telse if(op3.isSelected()) {\n\t\t\t\t\tx=3;\n\t\t\t\t}\n\t\t\t\telse if(op4.isSelected()) {\n\t\t\t\t\tx=4;\n\t\t\t\t}\n\t\t\t\telse\n\t\t\t\t\tx=0;\n\t\t\t\t\n\t\t\t\tif(x!=0) {\t\t\n\t\t\t\t\topt[k] = x;\n\t\t\t\t\tk++;\n\t\t\t\t\ttry {\n\t\t\t\t\t\tif(rst.next()) {\n\t\t\t\t\t\t\tques.setText(rst.getString(\"question\"));\n\t\t\t\t\t\t\top1.setText(rst.getString(\"option1\"));\n\t\t\t\t\t\t\top2.setText(rst.getString(\"option2\"));\n\t\t\t\t\t\t\top3.setText(rst.getString(\"option3\"));\n\t\t\t\t\t\t\top4.setText(rst.getString(\"option4\"));\n\t\t\t\t\t\t}\n\t\t\t\t\t\telse {\n\t\t\t\t\t\t\tfor(int j=0; j&lt;k; j++) {\n\t\t\t\t\t\t\t\tmanage.answerUpdt(surveyCode, j+1, opt[j]);\n\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\tJOptionPane.showMessageDialog(frame, \"Survey Completed. Thank You.\", \"Congradulations\", JOptionPane.PLAIN_MESSAGE);\n\t\t\t\t\t\t\tmanage.addTotal();\n\t\t\t\t\t\t\tframe.dispose();\n\t\t\t\t\t\t}\n\t\t\t\t\t} catch (SQLException e1) {\n\t\t\t\t\t\te1.printStackTrace();\n\t\t\t\t\t}\n\t\t\t\t}\n\t\t\t\telse {\n\t\t\t\t\tJOptionPane.showMessageDialog(frame, \"Select an option!\", \"Warning\", JOptionPane.WARNING_MESSAGE);\n\t\t\t\t}\n\t\t\t\tbgroup.clearSelection();\n\t\t\t}\n\t\t});\n\t\t\n\t\t\n\t\tframe.setVisible(true);\n\t\t\n\t}\n}<\/pre><\/div>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img decoding=\"async\" data-src=\"https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/guest.png\" alt=\"answering questions\" class=\"wp-image-24042 lazyload\" width=\"578\" height=\"435\" data-srcset=\"https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/guest.png 981w, https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/guest-300x226.png 300w, https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/guest-768x579.png 768w, https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/guest-675x508.png 675w, https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/guest-480x360.png 480w\" data-sizes=\"(max-width: 578px) 100vw, 578px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 578px; --smush-placeholder-aspect-ratio: 578\/435;\" \/><\/figure>\n<\/div>\n\n\n<p>This page helps to answer the surveys. We can use the radio buttons.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">6. MySql Manage Module<\/h3>\n\n\n\n<p>File Name: &#8220;<em><strong>SQLManage.java<\/strong><\/em>&#8220;<\/p>\n\n\n\n<p>This class manages all the operations with databases. All classes call this class for SQL operations.<\/p>\n\n\n\n<div style=\"height: 250px; position:relative; margin-bottom: 50px;\" class=\"wp-block-simple-code-block-ace\"><div style=\"position:absolute;top:-20px;right:0px;cursor:pointer\" class=\"copy-simple-code-block\"><span class=\"dashicon dashicons dashicons-admin-page\"><\/span><\/div><pre class=\"wp-block-simple-code-block-ace\" style=\"position:absolute;top:0;right:0;bottom:0;left:0\" data-mode=\"java\" data-theme=\"xcode\" data-fontsize=\"14\" data-lines=\"Infinity\" data-showlines=\"true\" data-copy=\"true\">package survey;\n\nimport java.sql.Connection;\nimport java.sql.DriverManager;\nimport java.sql.ResultSet;\nimport java.sql.SQLException;\nimport java.sql.Statement;\n\npublic class SQLManage {\n\t\n\tConnection con;\n\t\n\tpublic SQLManage() throws SQLException {\n\t\tString url = \"jdbc:mysql:\/\/localhost:3306\/survey\";\n\t\tString usr = \"root\";\n\t\tString pass = \"roshanhussainv1969@\";\n\t\tcon = DriverManager.getConnection(url, usr, pass);\n\t}\n\t\n\tpublic void newUser(String name, String uname, String pass) throws SQLException {\n\t\tString str = \"INSERT INTO actors(fname, uname, pass) values ('\"+name+\"', '\"+uname+\"', '\"+pass+\"')\";\n\t\tStatement stm = con.createStatement();\n\t\tstm.executeUpdate(str);\n\t}\n\t\n\tpublic int authUser(String uname, String pass) throws SQLException {\n\t\tString str = \"SELECT * FROM actors WHERE uname = '\"+uname+\"'\";\n\t\tStatement stm = con.createStatement();\n\t\tResultSet rst = stm.executeQuery(str);\n\t\tif (!rst.next())\n\t\t\treturn -1;\n\t\telse {\n\t\t\tif(rst.getString(\"pass\").equals(pass))\n\t\t\t\treturn rst.getInt(\"id\");\n\t\t\telse\n\t\t\t\treturn 0;\n\t\t}\n\t}\n\t\n\tpublic void newQuestion(String code, String question, String op1, String op2, String op3, String op4) throws SQLException {\n\t\tString str = \"INSERT INTO questions values ('\"+code+\"', '\"+question+\"', '\"+op1+\"', '\"+op2+\"', '\"+op3+\"', '\"+op4+\"')\";\n\t\tStatement stm = con.createStatement();\n\t\tstm.executeUpdate(str);\n\t}\n\t\n\tpublic void userQuestionAdd(int id, String surveycode) throws SQLException {\n\t\tString str = \"INSERT INTO userQuestions values (\"+id+\", '\"+surveycode+\"', 0)\";\n\t\tStatement stm = con.createStatement();\n\t\tstm.executeUpdate(str);\n\t}\n\t\n\tpublic void answerUpdt(String surveycode, int qno, int option) throws SQLException {\n\t\tString str = \"INSERT INTO surveyquestions values ('\"+surveycode+\"', \" + qno + \", \" + option + \")\";\n\t\tStatement stm = con.createStatement();\n\t\tstm.executeUpdate(str);\n\t}\n\t\n\tpublic ResultSet getQuestions(String surveycode) throws SQLException {\n\t\tString str = \"SELECT * FROM questions WHERE surveycode = '\"+surveycode+\"'\";\n\t\tStatement stm = con.createStatement();\n\t\tResultSet rst = stm.executeQuery(str);\n\t\treturn rst;\n\t}\n\t\n\tpublic ResultSet surveys(int id, String search) throws SQLException {\n\t\tString str = \"SELECT * FROM userQuestions WHERE id = \"+id+\" and surveycode like '%\"+search+\"%'\";\n\t\tStatement stm = con.createStatement();\n\t\tResultSet rst = stm.executeQuery(str);\n\t\treturn rst;\n\t}\n\t\n\tpublic void addTotal() throws SQLException {\n\t\tString str = \"UPDATE userQuestions SET total = total+1\";\n\t\tStatement stm = con.createStatement();\n\t\tstm.executeUpdate(str);\n\t}\n\t\n\tpublic boolean check(String search) throws SQLException {\n\t\tString str = \"SELECT * FROM userQuestions WHERE surveycode = '\"+search+\"'\";\n\t\tStatement stm = con.createStatement();\n\t\tResultSet rst = stm.executeQuery(str);\n\t\tif(rst.next())\n\t\t\treturn true;\n\t\telse\n\t\t\treturn false;\n\t}\n\t\n\tpublic void removeSurvey(String surveycode) throws SQLException {\n\t\tString str = \"DELETE FROM questions WHERE surveycode = '\"+surveycode+\"'\";\n\t\tStatement stm = con.createStatement();\n\t\tstm.executeUpdate(str);\n\t\tstr = \"DELETE FROM surveyquestions WHERE surveycode = '\"+surveycode+\"'\";\n\t\tstm.executeUpdate(str);\n\t\tstr = \"DELETE FROM userQuestions WHERE surveycode = '\"+surveycode+\"'\";\n\t\tstm.executeUpdate(str);\n\t}\n\t\n\tpublic int getCount(String surveycode, int qno, int op) throws SQLException {\n\t\tString str = \"SELECT count(opno) FROM surveyquestions WHERE surveycode = '\"+surveycode+\"' AND qno = \"+(qno+1)+\" AND opno = \"+op;\n\t\tStatement stm = con.createStatement();\n\t\tResultSet rst = stm.executeQuery(str);\n\t\tif(rst.next())\n\t\t\treturn rst.getInt(\"count(opno)\");\n\t\telse\n\t\t\treturn 0;\n\t}\n\t\n}<\/pre><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Output for Survey Management System In Java<\/h2>\n\n\n\n<script async=\"\" src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\n<ins class=\"adsbygoogle\" style=\"display:block; text-align:center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-9886351916045880\" data-ad-slot=\"2002566052\"><\/ins>\n<script>\n     (adsbygoogle = window.adsbygoogle || []).push({});\n<\/script>\n\n\n\n<h3 class=\"wp-block-heading\">Output 1: Login and Signup<\/h3>\n\n\n\n<figure class=\"wp-block-video aligncenter\"><video height=\"368\" style=\"aspect-ratio: 364 \/ 368;\" width=\"364\" controls src=\"https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/1.mp4\"><\/video><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Output 2: Home Page<\/h3>\n\n\n\n<figure class=\"wp-block-video aligncenter\"><video height=\"492\" style=\"aspect-ratio: 654 \/ 492;\" width=\"654\" controls src=\"https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/2.mp4\"><\/video><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Output 3: Attending Survey (Guest)<\/h3>\n\n\n\n<figure class=\"wp-block-video\"><video height=\"488\" style=\"aspect-ratio: 654 \/ 488;\" width=\"654\" controls src=\"https:\/\/copyassignment.com\/wp-content\/uploads\/2023\/01\/6.mp4\"><\/video><\/figure>\n\n\n\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-9886351916045880\"\n     crossorigin=\"anonymous\"><\/script>\n<ins class=\"adsbygoogle\"\n     style=\"display:block\"\n     data-ad-format=\"autorelaxed\"\n     data-ad-client=\"ca-pub-9886351916045880\"\n     data-ad-slot=\"7933252109\"><\/ins>\n<script>\n     (adsbygoogle = window.adsbygoogle || []).push({});\n<\/script>\n\n\n\n<p>Thank you for visiting <a href=\"https:\/\/copyassignment.com\/\" data-type=\"URL\" data-id=\"https:\/\/copyassignment.com\/\">us<\/a>.<\/p>\n\n\n\n<div style=\"text-align:center\" class=\"wp-block-atomic-blocks-ab-button ab-block-button\"><a href=\"https:\/\/copyassignment.com\/?s=java\" class=\"ab-button ab-button-shape-rounded ab-button-size-medium\" style=\"color:#ffffff;background-color:#3373dc\">Click here to get Best Java Projects<\/a><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>Also Read:<\/strong><\/p>\n\n\n<ul class=\"wp-block-latest-posts__list is-grid columns-3 wp-block-latest-posts\"><li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/dino-game-in-java\/\">Dino Game in Java<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/java-games-code-copy-and-paste\/\">Java Games Code | Copy And Paste<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/supply-chain-management-system-in-java\/\">Supply Chain Management System in Java<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/survey-management-system-in-java\/\">Survey Management System In Java<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/phone-book-in-java\/\">Phone Book in Java<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/email-application-in-java\/\">Email Application in Java<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/inventory-management-system-project-in-java\/\">Inventory Management System Project in Java<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/blood-bank-management-system-project-in-java\/\">Blood Bank Management System Project in Java<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/electricity-bill-management-system-project-in-java\/\">Electricity Bill Management System Project in Java<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/cgpa-calculator-app-in-java\/\">CGPA Calculator App In Java<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/chat-application-in-java\/\">Chat Application in Java<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/100-java-projects-for-beginners-2023\/\">100+ Java Projects for Beginners 2023<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/airline-reservation-system-project-in-java\/\">Airline Reservation System Project in Java<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/password-and-notes-manager-in-java\/\">Password and Notes Manager in Java<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/gui-number-guessing-game-in-java\/\">GUI Number Guessing Game in Java<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/how-to-create-notepad-in-java\/\">How to create Notepad in Java?<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/memory-game-in-java\/\">Memory Game in Java<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/simple-car-race-game-in-java\/\">Simple Car Race Game in Java<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/atm-program-in-java\/\">ATM program in Java<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/drawing-application-in-java\/\">Drawing Application In Java<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/tetris-game-in-java\/\">Tetris Game in Java<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/pong-game-in-java\/\">Pong Game in Java<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/hospital-management-system-project-in-java\/\">Hospital Management System Project in Java<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/ludo-game-in-java\/\">Ludo Game in Java<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/restaurant-management-system-project-in-java\/\">Restaurant Management System Project in Java<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/flappy-bird-game-in-java\/\">Flappy Bird Game in Java<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/atm-simulator-in-java\/\">ATM Simulator In Java<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/brick-breaker-game-in-java\/\">Brick Breaker Game in Java<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/best-java-roadmap-for-beginners-2023\/\">Best Java Roadmap for Beginners 2023<\/a><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/copyassignment.com\/snake-game-in-java\/\">Snake Game in Java<\/a><\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"<p>In this article, we will learn to create a project on survey management system in Java. There are two actors: The user who can add&#8230;<\/p>\n","protected":false},"author":62,"featured_media":24093,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22,1926,1918],"tags":[],"class_list":["post-24028","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-allcategorites","category-gui-java-project","category-java-projects","wpcat-22-id","wpcat-1926-id","wpcat-1918-id"],"_links":{"self":[{"href":"https:\/\/copyassignment.com\/wp-json\/wp\/v2\/posts\/24028","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/copyassignment.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/copyassignment.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/copyassignment.com\/wp-json\/wp\/v2\/users\/62"}],"replies":[{"embeddable":true,"href":"https:\/\/copyassignment.com\/wp-json\/wp\/v2\/comments?post=24028"}],"version-history":[{"count":0,"href":"https:\/\/copyassignment.com\/wp-json\/wp\/v2\/posts\/24028\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/copyassignment.com\/wp-json\/wp\/v2\/media\/24093"}],"wp:attachment":[{"href":"https:\/\/copyassignment.com\/wp-json\/wp\/v2\/media?parent=24028"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/copyassignment.com\/wp-json\/wp\/v2\/categories?post=24028"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/copyassignment.com\/wp-json\/wp\/v2\/tags?post=24028"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}