Servlet Displays Old DB Entries

hello, I made this code which simply fetches the data and each row has a Edit link Besides it...
When i click on Edit, the record appears perfectly, but when i make changes and click on save, it refreshes but shows old (unchanged) record.

Table - Qtable

code For Edit page..

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;

/**
 *
 * @author Ezrockgw
 */
public class edit extends HttpServlet {
    static String s;
   Connection con;
   PreparedStatement ps;
    /** 
     * Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        try {

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

//Connect to emaildb Data source
                 con = DriverManager.getConnection("jdbc:odbc:gdsn", "", "");

Statement theStatement=con.createStatement();
                  s = request.getParameter("value");
                ResultSet theResult=theStatement.executeQuery("select * from Qtable where Number="+s);
                theResult.next();
                String q2 = theResult.getString(2);
                String q3 = theResult.getString(3);
                String q4 = theResult.getString(4);
                String q5 = theResult.getString(5);
                String q6 = theResult.getString(6);
                String q7 = theResult.getString(7);

out.println("<html>");
            out.println("<head>");
            out.println("<title>edit</title>");  
            out.println("</head>");
            out.println("<body>");
            out.println("<form name=\"abc\" action =\"edit\">");
            out.println("<h2> Question : </h2>");
            out.println("<input type=\"text\"  size=\"45\" name=\"question\" value=\"" +q2+ "\">");
            out.println(" <br><br><br> <b>Option 1</b>  <input type=\"text\" name=\"op1\" value=\"" +q3+ "\"> <br><br>");
            out.println("<b>Option 2</b> <input type=\"text\" name=\"op2\" value=\"" +q4+ "\"> <br><br>");
            out.println(" <b>Option 3</b> <input type=\"text\" name=\"op3\" value=\"" +q5+ "\"> <br><br>");
            out.println("<b>Option 4</b> <input type=\"text\" name=\"op4\" value=\"" +q6+ "\"> <br><br>");
            out.println("<b>Answer </b> <input type=\"text\" name=\"ans\" value=\"" +q7+ "\"> <br><br>");
            out.println("<input type=\"hidden\" name=\"value\" value=\"" +s+ "\"> <br><br>");
            out.println("<input type=\"submit\" name=\"Make Changes\" >  <input type=\"reset\" name=\"Reset\">");

out.println("</body>");
            out.println("</html>");

}

catch (ClassNotFoundException e)
            {
                e.printStackTrace();

}

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

finally {
            out.close();
        }
    }

// <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /** 
     * Handles the HTTP <code>GET</code> method.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        processRequest(request, response);
    }

/** 
     * Handles the HTTP <code>POST</code> method.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        processRequest(request, response);
    }

/** 
     * Returns a short description of the servlet.
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>

}

Hi Gaurav,

I think the code is for the edit screen. It doesnt have any details of your save operation.

You need to have a code to save the edited record. Its only having select statement. So once you edit and save some insert should go through.

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;

/**
 *
 * @author Ezrockgw
 */
public class edit extends HttpServlet {
    static String s;
   Connection con;
   PreparedStatement ps;
    /** 
     * Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        try {

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

//Connect to  Data source
                 con = DriverManager.getConnection("jdbc:odbc:gdsn", "", "");

Statement theStatement=con.createStatement();
                  s = request.getParameter("value");
                ResultSet theResult=theStatement.executeQuery("select * from Qtable where Number="+s);
                theResult.next();
                String q2 = theResult.getString(2);
                String q3 = theResult.getString(3);
                String q4 = theResult.getString(4);
                String q5 = theResult.getString(5);
                String q6 = theResult.getString(6);
                String q7 = theResult.getString(7);

out.println("<html>");
            out.println("<head>");
            out.println("<title>edit</title>");  
            out.println("</head>");
            out.println("<body>");
            out.println("<form name=\"abc\" action =\"edit\">");
            out.println("<h2> Question : </h2>");
            out.println("<input type=\"text\"  size=\"45\" name=\"question\" value=\"" +q2+ "\">");
            out.println(" <br><br><br> <b>Option 1</b>  <input type=\"text\" name=\"op1\" value=\"" +q3+ "\"> <br><br>");
            out.println("<b>Option 2</b> <input type=\"text\" name=\"op2\" value=\"" +q4+ "\"> <br><br>");
            out.println(" <b>Option 3</b> <input type=\"text\" name=\"op3\" value=\"" +q5+ "\"> <br><br>");
            out.println("<b>Option 4</b> <input type=\"text\" name=\"op4\" value=\"" +q6+ "\"> <br><br>");
            out.println("<b>Answer </b> <input type=\"text\" name=\"ans\" value=\"" +q7+ "\"> <br><br>");
            out.println("<input type=\"hidden\" name=\"value\" value=\"" +s+ "\"> <br><br>");
            out.println("<input type=\"submit\" name=\"Make Changes\" >  <input type=\"reset\" name=\"Reset\">");
             ps = con.prepareStatement("UPDATE Qtable SET Question = \'"+ q2 +"\',opt1 = \'"+ q3 +"\',opt2=\'"+ q4  +"\',opt3 =\'"+ q5  +"\',opt4 =\'"+ q6  +"\',ans =\'"+ q7  +"\' WHERE Number="+s);
            int m = ps.executeUpdate();
             out.println("m = " + m);
            out.println("</body>");
            out.println("</html>");

}

catch (ClassNotFoundException e)
            {
                e.printStackTrace();

}

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

finally {
            out.close();
        }
    }

// <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /** 
     * Handles the HTTP <code>GET</code> method.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        processRequest(request, response);
    }

/** 
     * Handles the HTTP <code>POST</code> method.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        processRequest(request, response);
    }

/** 
     * Returns a short description of the servlet.
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>

}

I missed out the essential part....the code shows on error on execution, but doesnt update the record

What error it shows? it shows an error or an exception?

The first step is to print the actual SQL statement that you're passing to the DB; then you can run that directly against the DB and see what happens.

SQL statement seems to be correct.

Hi,

I don't think update will happen with this code. The sequence of the code is as follows:

When the screen loads:
1. A select statement is executed and the q2-q7 gets populated
2. the q2-q7 values are painted on the screen from the servlet.
3. Then an update statement executes with the same q2-q7 values(user havent modified anything in the screen yet).
4. Screen loading is complete and now the user can change the values.

User operation:
1. user changes the values and submits.

Again we are calling the same servlet:
1. A select statement is executed and the q2-q7 gets populated
2. the q2-q7 values are painted on the screen from the servlet.
3. Then an update statement executes with the same q2-q7 values(not the user modified values-- its all the original values in DB that we got from the select statement).
4. Screen loading is complete.

So data are not saved in the DB.

Solution:

1. In the starting get the values(q2-q7) from the request using getParameter().
2. If they are not null(primary key is not null or any condition which distinguish new screen or edit screen) execute update statement.
3. After that the code flow remains same(select and then HTML painting). The update statement in the below part is not required.

@Prasad : i made a mistake, wanted to write *shows no error on execution.
@lester : i didnt get you.

@Sudipta : Thank you so much, your explanation made things really clear and now its working.

But just a bit of a problem now. When i click on Submit Query, it shows "null" in every text box.

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;

/**
 *
 * @author Ezrockgw
 */
public class edit extends HttpServlet {
    static String s;
   Connection con;
   PreparedStatement ps;
    /** 
     * Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        try {

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

//Connect to  Data source
                 con = DriverManager.getConnection("jdbc:odbc:gdsn", "", "");

Statement theStatement=con.createStatement();
                  s = request.getParameter("value");
                ResultSet theResult=theStatement.executeQuery("select * from Qtable where Number="+s);
                theResult.next();
                String q2 = theResult.getString(2);
                String q3 = theResult.getString(3);
                String q4 = theResult.getString(4);
                String q5 = theResult.getString(5);
                String q6 = theResult.getString(6);
                String q7 = theResult.getString(7);

out.println("<html>");
            out.println("<head>");
            out.println("<title>edit</title>");  
            out.println("</head>");
            out.println("<body>");
            out.println("<form name=\"abc\" action =\"edit\">");
            out.println("<h2> Question : </h2>");
            out.println("<input type=\"text\"  size=\"45\" name=\"question\" value=\"" +q2+ "\">");
            out.println(" <br><br><br> <b>Option 1</b>  <input type=\"text\" name=\"op1\" value=\"" +q3+ "\"> <br><br>");
            out.println("<b>Option 2</b> <input type=\"text\" name=\"op2\" value=\"" +q4+ "\"> <br><br>");
            out.println(" <b>Option 3</b> <input type=\"text\" name=\"op3\" value=\"" +q5+ "\"> <br><br>");
            out.println("<b>Option 4</b> <input type=\"text\" name=\"op4\" value=\"" +q6+ "\"> <br><br>");
            out.println("<b>Answer </b> <input type=\"text\" name=\"ans\" value=\"" +q7+ "\"> <br><br>");
            out.println("<input type=\"hidden\" name=\"value\" value=\"" +s+ "\"> <br><br>");
            out.println("<input type=\"submit\" name=\"Make Changes\" >  <input type=\"reset\" name=\"Reset\">");
             out.println("</body>");
            out.println("</html>");

if ((!q2.equals(request.getParameter("question"))) || !q3.equals(request.getParameter("op1") )|| !q4.equals(request.getParameter("op2") ) || !q5.equals(request.getParameter("op3") ) || !q6.equals(request.getParameter("op4") ) || !q7.equals(request.getParameter("ans") ) )
            {
            ps = con.prepareStatement("UPDATE Qtable SET Question = \'"+ request.getParameter("question") +"\',opt1 = \'"+ request.getParameter("op1") +"\',opt2=\'"+ request.getParameter("op2")  +"\',opt3 =\'"+ request.getParameter("op3")  +"\',opt4 =\'"+ request.getParameter("op4")  +"\',ans =\'"+ request.getParameter("ans")  +"\' WHERE Number="+s);
            int m = ps.executeUpdate();
            }

}

catch (ClassNotFoundException e)
            {
                e.printStackTrace();

}

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

finally {
            out.close();
        }
    }

// <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /** 
     * Handles the HTTP <code>GET</code> method.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        processRequest(request, response);
    }

/** 
     * Handles the HTTP <code>POST</code> method.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        processRequest(request, response);
    }

/** 
     * Returns a short description of the servlet.
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>

}

I believe the update should be on the top.
Reason: Suppose you update the details and submit. The select statement goes before the update is done to the DB and it will show the old data when the screen loads.

And for the null value, check the values in the resultset by giving SOP.

i checked value of result set...it shows true

And cant figure out how to get Update on top, because before it fetches the data using SELECT, if it executes UPDATE then it will set all the values to "null".

hi...

Its depends on you how you want to handle it.

1. You may always run a update query when the form is submited , by giving a param like mode.

2. you may run two select query one before update to check your update condition and the 2nd one to show the updated data.

hi...
i couldnt understand how to implement your first point..

And when i used 2nd , it didnt work.

If i use the ResultSet (Using Same Object of Statement ) statement to execute Select two times i get "java.sql.SQLException: ResultSet is closed"

And If i declare the A new Statement object for using ResultSet - i get "No data found" for which the code is

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;

/**
 *
 * @author Ezrockgw
 */
public class edit extends HttpServlet {
    String s;
   Connection con;
   PreparedStatement ps;
    /** 
     * Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        try {

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                  String q2,q3,q4,q5,q6,q7;

//Connect to  Data source
                 con = DriverManager.getConnection("jdbc:odbc:gdsn", "", "");

Statement theStatement=con.createStatement();
                  s = request.getParameter("value");
                ResultSet theResult;
                theResult=theStatement.executeQuery("select * from Qtable where Number="+s);
                boolean  ab = theResult.next();

q2 = theResult.getString(2);
                q3 = theResult.getString(3);
                q4 = theResult.getString(4);
                q5 = theResult.getString(5);
                q6 = theResult.getString(6);
                q7 = theResult.getString(7);

out.println("<html>");
            out.println("<head>");
            out.println("<title>edit</title>");  
            out.println("</head>");
            out.println("<body>");
            out.println("<form name=\"abc\" action =\"edit\">");
            out.println("<h2> Question : </h2>");
            out.println("<input type=\"text\"  size=\"45\" name=\"question\" value=\"" +q2+ "\">");
            out.println(" <br><br><br> <b>Option 1</b>  <input type=\"text\" name=\"op1\" value=\"" +q3+ "\"> <br><br>");
            out.println("<b>Option 2</b> <input type=\"text\" name=\"op2\" value=\"" +q4+ "\"> <br><br>");
            out.println(" <b>Option 3</b> <input type=\"text\" name=\"op3\" value=\"" +q5+ "\"> <br><br>");
            out.println("<b>Option 4</b> <input type=\"text\" name=\"op4\" value=\"" +q6+ "\"> <br><br>");
            out.println("<b>Answer </b> <input type=\"text\" name=\"ans\" value=\"" +q7+ "\"> <br><br>");
            out.println("<input type=\"hidden\" name=\"value\" value=\"" +s+ "\"> <br><br>");
            out.println("s = " + s + "ResultSET = " + ab);
            out.println("<input type=\"submit\" name=\"Make Changes\" >  <input type=\"reset\" name=\"Reset\">");
             out.println("</body>");
            out.println("</html>");

if ((!q2.equals(request.getParameter("question"))) || !q3.equals(request.getParameter("op1") )|| !q4.equals(request.getParameter("op2") ) || !q5.equals(request.getParameter("op3") ) || !q6.equals(request.getParameter("op4") ) || !q7.equals(request.getParameter("ans") ) )
            {
            ps = con.prepareStatement("UPDATE Qtable SET Question = \'"+ request.getParameter("question") +"\',opt1 = \'"+ request.getParameter("op1") +"\',opt2=\'"+ request.getParameter("op2")  +"\',opt3 =\'"+ request.getParameter("op3")  +"\',opt4 =\'"+ request.getParameter("op4")  +"\',ans =\'"+ request.getParameter("ans")  +"\' WHERE Number="+s);
            int m = ps.executeUpdate();
            }
            ResultSet R;
            Statement theS=con.createStatement();
          R=theS.executeQuery("select * from Qtable where Number="+s);
           R.next();

q2 = theResult.getString(2);
                q3 = theResult.getString(3);
                q4 = theResult.getString(4);
                q5 = theResult.getString(5);
                q6 = theResult.getString(6);
                q7 = theResult.getString(7);
        }

catch (ClassNotFoundException e)
            {
                e.printStackTrace();

}

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

finally {
            out.close();
        }
    }

// <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /** 
     * Handles the HTTP <code>GET</code> method.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        processRequest(request, response);
    }

/** 
     * Handles the HTTP <code>POST</code> method.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        processRequest(request, response);
    }

/** 
     * Returns a short description of the servlet.
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>

}

Hi,

You need to understand the sequence. The code is not having the correct flow.
Take a look at the operations you are doing. The last select is of no used as you dont use the data.

1. It should be select 1st.
2. Then there should be an update.
3. Then there should be select again to get updated data.
4. Then there should be the HTML code to display the data to UI.

WOW! that worked

Thank you mate

If you would notice the code, I added another condition to check if the values were null. Without that condition...if i would click on EDIT, It will fetch and update each attribute with "null". That is because
1. It gets values for a record using SELECT
2. It Checks if there is any change in it, if there is then it Causes UPDATE to run. Since the Update statement is above HTML code, Hence the parameter values initially are "null" which Satisfies the condition to run UPDATE. The Update statement would then make the values Null.
3. Another Select to get the Updated Values.

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;

/**
 *
 * @author Ezrockgw
 */
public class edit extends HttpServlet {
    String s;
   Connection con;
   PreparedStatement ps;
    /** 
     * Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        try {

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                  String q2,q3,q4,q5,q6,q7;

//Connect to  Data source
                 con = DriverManager.getConnection("jdbc:odbc:gdsn", "", "");

Statement theStatement=con.createStatement();
                  s = request.getParameter("value");
                ResultSet theResult;
                theResult=theStatement.executeQuery("select * from Qtable where Number="+s);
                boolean  ab = theResult.next();

q2 = theResult.getString(2);
                q3 = theResult.getString(3);
                q4 = theResult.getString(4);
                q5 = theResult.getString(5);
                q6 = theResult.getString(6);
                q7 = theResult.getString(7);
                theResult.close();

if (q2!=null ||q3!=null ||q4!=null ||q5!=null ||q6!=null ||q7!=null )
                {

if ((!q2.equals(request.getParameter("question"))) ||  !q3.equals(request.getParameter("op1") )|| !q4.equals(request.getParameter("op2") ) || !q5.equals(request.getParameter("op3") ) || !q6.equals(request.getParameter("op4") ) || !q7.equals(request.getParameter("ans") ) )
                     {
                         ps = con.prepareStatement("UPDATE Qtable SET Question = \'"+ request.getParameter("question") +"\',opt1 = \'"+ request.getParameter("op1") +"\',opt2=\'"+ request.getParameter("op2")  +"\',opt3 =\'"+ request.getParameter("op3")  +"\',opt4 =\'"+ request.getParameter("op4")  +"\',ans =\'"+ request.getParameter("ans")  +"\' WHERE Number="+s);
                         int m = ps.executeUpdate();
                         con.commit();
                    }
                }

ResultSet R;
           Statement theS=con.createStatement();
          R=theS.executeQuery("select * from Qtable where Number="+s);
           R.next();

q2 = R.getString(2);
                q3 = R.getString(3);
                q4 = R.getString(4);
                q5 = R.getString(5);
                q6 = R.getString(6);
                q7 = R.getString(7);
               
            out.println("<html>");
            out.println("<head>");
            out.println("<title>edit</title>");  
            out.println("</head>");
            out.println("<body>");
            out.println("<form name=\"abc\" action =\"edit\">");
            out.println("<h2> Question : </h2>");
            out.println("<input type=\"text\"  size=\"45\" name=\"question\" value=\"" +q2+ "\">");
            out.println(" <br><br><br> <b>Option 1</b>  <input type=\"text\" name=\"op1\" value=\"" +q3+ "\"> <br><br>");
            out.println("<b>Option 2</b> <input type=\"text\" name=\"op2\" value=\"" +q4+ "\"> <br><br>");
            out.println(" <b>Option 3</b> <input type=\"text\" name=\"op3\" value=\"" +q5+ "\"> <br><br>");
            out.println("<b>Option 4</b> <input type=\"text\" name=\"op4\" value=\"" +q6+ "\"> <br><br>");
            out.println("<b>Answer </b> <input type=\"text\" name=\"ans\" value=\"" +q7+ "\"> <br><br>");
            out.println("<input type=\"hidden\" name=\"value\" value=\"" +s+ "\"> <br><br>");
            out.println("s = " + s + "ResultSET = " + ab);
            out.println("<input type=\"submit\" name=\"Make Changes\" >  <input type=\"reset\" name=\"Reset\">");
             out.println("</body>");
            out.println("</html>");

}

catch (ClassNotFoundException e)
            {
                e.printStackTrace();

}

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

finally {
            out.close();
        }
    }

// <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /** 
     * Handles the HTTP <code>GET</code> method.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        processRequest(request, response);
    }

/** 
     * Handles the HTTP <code>POST</code> method.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        processRequest(request, response);
    }

/** 
     * Returns a short description of the servlet.
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>

}