Three buttons in one form

Ranch Hand

Posts: 32

posted 22 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi,
I have three buttons in a form. Each button passes control to a different servlet when clicked. The problem is it is not passing any parameters when button is clicked. When i used the buttons individually everything works fine, the parameters are received correctly. Could anyone tell me what the problem might be.

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;import java.sql.*;
public class CCCtable extends HttpServlet{
   public void init(ServletConfig config) throws  ServletException   {
      super.init(config);
      try{        Class.forName("oracle.jdbc.driver.OracleDriver");  
    }catch (ClassNotFoundException e) {          System.out.println("Couldn't load Oracle driver");
         throw new UnavailableException(this, "Couldn't load Oracledriver");   
   }      catch (Exception e)      {         e.printStackTrace();      }
//      System.out.println("***Leaving Table servlet init ***");
   }
    public void doGet(HttpServletRequest req, HttpServletResponse res)                     throws ServletException, IOException
{
//     System.out.println("**** Inside table Servlet - doGet ****");       doPost(req, res);   }                                     
   public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
   {     ServletContext cont = getServletContext();   int i = 0, j = 0;      String[] row_id = new String[100];      HttpSession hs = request.getSession(true);      hs.putValue("theKey", row_id);      response.setContentType("Text/html");
      PrintWriter out = response.getWriter();      out.println("<HTML>");
      out.println("<HEAD><TITLE>Holiday Table</TITLE></HEAD>");      out.println("<BODY BGCOLOR=\"#FFFFFF\">");      out.println("<CENTER>");      out.println("<BR><BR>");      Connection conn = null;      try      {         conn = DriverManager.getConnection(
                 "jdbc [img]http://www.javaranch.com/ubb/redface.gif[/img]racle:thin:@asd:1521:asd","qwer",                 "qwer");         Statement stmt = conn.createStatement();
         ResultSet rs = stmt.executeQuery("Select a.*, rowid from holiday a");

out.println("<TABLE><TR>");
         out.println("<Form method=\"post\"><TH>");
         out.println("<INPUT type=\"button\" name=\"add\" value=\"Add\" onClick=\"sendToServlet(1)\"> ");                   
         out.println("<INPUT type=\"button\" name=\"delete\" value=\"Delete\" onClick=\"sendToServlet(2)\"> ");
         out.println("<INPUT type=\"button\" name=\"update\" value=\"Update\" onClick=\"sendToServlet(3)\"> ");
         out.println("</TR></TABLE>");

//Print start of table and column headers
         out.println("<TABLE CELLSAPCING=\"0\" CELLPADDING=\"3\" BORDER=\"1\">");         
         out.println("<TR><TH>SELECT</TH><TH>HOLIDAY_CODE</TH><TH>HOLIDAY_DESCR</TH>");
         out.println("<TH>HOLIDAY_DATE</TH><TH>LAST_CHANGE_USERID</TH>");
         out.println("<TH>LAST_CHANGE_TMSTMP</TH></TR>");

//Loop through results of the query
         while(rs.next())
         {
            out.println("<TR>");
            out.println("<TD align=center><input type=checkbox name=icheck["+(i++)+"] value="+i+"></TD>");
            out.println("<TD align=center>" + rs.getString("HOLIDAY_CODE") + "</TD>");
            out.println("<TD align=center>" + rs.getString("HOLIDAY_DESCR") + "</TD>");
            out.println("<TD align=center>" + rs.getString("HOLIDAY_DATE") + "</TD>");
            out.println("<TD align=center>" + rs.getString("LAST_CHANGE_USERID") + "</TD>");
            out.println("<TD align=center>" + rs.getString("LAST_CHANGE_TMSTMP") + "</TD>");
            out.println("</TR>");
            row_id[j] = rs.getString("rowid");
            j++;
         }

out.println("<input type=hidden name=abcd value="+i+">");
         out.println("</FORM>");
         out.println("<script language=\"JavaScript\">");
         out.println("function sendToServlet(buttonPressed){");
         out.println("if (buttonPressed == 1) {");
         out.println("window.location = \"http://rupd1b42:8159/servlet/add.class\";");
         out.println("}else if (buttonPressed == 2)");
         out.println("{window.location = \"http://rupd1b42:8159/servlet/delete.class\";");
         out.println("}else if (buttonPressed == 3)");
         out.println("{window.location = \"http://rupd1b42:8159/servlet/update.class\";");
         out.println(" }}");                   
         out.println("</script>");

/*       for(int a=0; a<row_id.length; a++)
         {
            cont.log("the row id is: " + row_id[a]);
         }
*/
         out.println("</TABLE>");
      }
      catch(SQLException e)
      {
         out.println("SQLException: " + e.getMessage() + "<BR>");
         while((e = e.getNextException()) != null)
            out.println(e.getMessage() + "<BR>");
      }
      finally
      {
         //Clean up resources, close the connection
         if(conn != null)
         {
            try
            {
               conn.close();
            }
            catch (Exception ignored) { }
          }
      }

/*      out.println("<TABLE><TR>");
      out.println("<Form method=\"post\"  action=\"http://rupd1b42:8159/add.html\"><TH>");
      out.println("<INPUT type=\"submit\" value=\"add\">");
//      out.println("<INPUT type=\"hidden\" name=\"action\" value=\"add\">");
      out.println("</TH></Form>");
      out.println("<Form method=\"post\"  action=\"Modify\"><TH>");
      out.println("<INPUT type=\"submit\" value=\"Modify\">");
//      out.println("<INPUT type=\"hidden\" name=\"action\" value=\"Modify\">");
      out.println("</TH></Form>");

out.println("<Form method=\"post\"  action=\"http://rupd1b42:8159/servlet/delete1.class?abcd=59\"><TH>");
      out.println("<INPUT type=\"submit\" value=\"Delete\">");
//      out.println("<INPUT type=\"hidden\" name=\"action\" value=\"Delete\">");
      out.println("</TH></Form>");                 
      out.println("</TR></TABLE>");
*/
      out.println("</CENTER>");
      out.println("</BODY>");
      out.println("</HTML>");

}
}

Madhav Lakkapragada

Ranch Hand

Posts: 5040

posted 22 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

The highlighted portion I guess is the
code (I am no javascript expert) that is
invoking the servlets. And as you can see the
URL doesn't have any parameters. Hence, I am
not surprised that you don't get the parameters
in your servlets: add.class, delete.class
and update.class.
I donot know how javascript will add parameters to the URL's.
Sorry!
I hope I am right, please check with a javascript expert.

- satya

Take a Minute, Donate an Hour, Change a Life
http://www.ashanet.org/workanhour/2006/?r=Javaranch_ML&a=81

You have to be odd to be #1 - Seuss. An odd little ad:

a bit of art, as a gift, the permaculture playing cards

https://gardener-gift.com