how to manage values of disabled cells in a row to the actionServlet in a loop?

Hi All,

I am trying to insert a data in another table which come from different table in a jsp page and want to insert only enabled data of a particular row.

Please guide me.

here is my jsp and servlet.......

<%-- 
    Document   : SelectProduct
    Created on : May 22, 2012, 3:32:30 PM
    Author     : Ading
--%>
<%@page contentType="text/html" pageEncoding="UTF-8" import="java.sql.Connection,java.sql.Statement,java.sql.ResultSet,com.db.ConnectionManager"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Select Product</title>
 <script type="text/javascript" language="javascript">
function chkBox(field)
            {
                if(document.getElementById("chk1").checked)
                 {
                for(var i=0;i<field.length;i++)
                    {
                             field[i].checked = true;
                             document.getElementById("name"+i).disabled = false;

if(document.getElementById("chk2"+i).checked)
                               {
                              document.getElementById("name"+i).disabled = false;

function otherCHK()
                  {
                      if(document.getElementById("chk1").checked)
                          {
                              document.getElementById("ch1").disabled = false;
                              document.getElementById("ch2").disabled = false;
                              document.getElementById("ch3").disabled = false;
                              document.getElementById("ch4").disabled = false;
                              document.getElementById("ch5").disabled = false;
                          }
                          else
                              {
                              document.getElementById("ch1").disabled = true;
                              document.getElementById("ch2").disabled = true;
                              document.getElementById("ch3").disabled = true;
                              document.getElementById("ch4").disabled = true;
                              document.getElementById("ch5").disabled = true;

document.getElementById("ch1").checked = false;
                              document.getElementById("ch2").checked = false;
                              document.getElementById("ch3").checked = false;
                              document.getElementById("ch4").checked = false;
                              document.getElementById("ch5").checked = false;
                              }
                  }

function chkBoxForSpecific(chkid)
            {
                var i = chkid.slice(4);
                if(document.getElementById("chk2"+i).checked)
                    {
                              document.getElementById("name"+i).disabled = false;

//////////////////////////////////////////////////////////////////////////////////
function manageValues(field,a,b,c,d,e,f)
               {
                   //var a,b,c,d,e,f;
                   
                   var a1 ,b1,c1,d1,e1,f1;

SERVLET IS

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

package com.action;

import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.Connection;
import java.sql.Statement;
import com.db.ConnectionManager;

/**
 *
 * @author Reshma
 */
public class SelectedItem extends HttpServlet
{
    
   String productCategory = null;
   String[] productName = null;
   String[] productPrice = null;
   String[] productCode = null;
   String[] productBatch = null;
   String[] productSize = null;
   String[] productNo = null;
   Connection con = null;
   Statement stmt = null;
   String sql = null;
   int i = 0 ;
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();

productCategory = request.getParameter("productCategory");
        productName = request.getParameterValues("product_name");
        productPrice = request.getParameterValues("product_price");
        productCode = request.getParameterValues("product_batch");
        productBatch = request.getParameterValues("product_code");
        productSize = request.getParameterValues("product_size");
        productNo = request.getParameterValues("product_no");
        //if(productNo == null)
            /*System.out.println("productNo: "+productNo);
        System.out.println("product category is : " + productCategory);

System.out.println("productName Length : " + productName.length);
        System.out.println("productPrice Length : " + productPrice.length);
        System.out.println("productCode Length : " + productCode.length);
        System.out.println("productBatch Length : " + productBatch.length);
        System.out.println("productSize Length : " + productSize.length);
        System.out.println("productNo Length : " + productNo.length);*/
        /*productPrice = request.getParameterValues("product_price");
        productCode = request.getParameterValues("product_batch");
        productBatch = request.getParameterValues("product_code");
        productSize = request.getParameterValues("product_size");
        productNo = request.getParameterValues("product_no");*/

try
        {
            ConnectionManager connection = new ConnectionManager();
            con = connection.getConnection();
            
            //for(i =0; i<productName.length && i<productPrice.length && i<productBatch.length && i<productCode.length && i<productSize.length && i<productNo.length ;i++)
           // for(i = 0; i<productName.length;i++)
            //while((i<productName.length))
            {
               /// for(int j =0; j<productPrice.length && j<productBatch.length && j<productCode.length && j<productSize.length && j<productNo.length ;j++)
               // {
        
               /*if(productPrice[i].equals(""))
                {
                    productPrice[i] = "NA";
                }

if(productBatch[i].equals(""))
                {
                    productBatch[i] = "NA";
                }

if((productCode[i] == null) || (productCode[i].equals("")))
                {
                    productCode[i] = "NA";
                }

if(productSize[i].equals(""))
                {
                    productSize[i] = "NA";
                }

if(productNo[i].equals(""))
                {
                    productNo[i] = "NA";
                }*/

//System.out.println("productName Values: " + productName[i]);
                //System.out.println("productPrice Values : " + productPrice[i]);
                //System.out.println("productCode Values: " + productCode[i]);
                //System.out.println("productBatch Values : " + productBatch[i]);
                //System.out.println("productSize Values : " + productSize[i]);
               // System.out.println("productNo Values : " + productNo[i]);

sql = "insert into selected_item (productCategory,productName,productPrice,productBatch,productCode,productSize,productNo,current_date_time)values('"+productCategory+"','"+productName[i]+"','"+productPrice[i]+"','"+productBatch[i]+"','"+productCode[i]+"','"+productSize[i]+"','"+productNo[i]+"',sysdate())";
            //sql = "insert into selected_item (productCategory,productName,productPrice,productBatch,productCode,productSize,productNo)values('"+productCategory+"','"+productName[i]+"','"+productPrice[i]+"','"+productBatch[i]+"','"+productCode[i]+"','"+productSize[i]+"','"+productNo[i]+"')";
            stmt = con.createStatement();
            stmt.executeUpdate(sql);
            System.out.println("sql for selected_item table : " + sql);
            //j++;
               // }
               // i++;
            }
            out.println("<html>");
            out.println("<head>");
            out.println("<title>Servlet SelectedItem</title>");  
            out.println("</head>");
            out.println("<body>");
            out.println("<h1>Servlet SelectedItem at " + request.getContextPath () + "</h1>");
            out.println("</body>");
            out.println("</html>");
        }
        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>
}

what is the solution for the above problem can anyone suggest me what should I use in my Servlet and JavaScript to avoid this problem.

Thanks in advanced!

I've moved your post to the Servlets forum; it's more likely to get an answer there. Please see CarefullyChooseOneForum (⇐ click).

You want to insert data into a database
Those data come from an html table, is that correct?

Start to move all the sql operations away from your jsp. Move them in the servlet.
A jsp file is used to show data, not to perform database operations.

In the same way move all html code away from your servlet and put it in a jsp. Servlet shouldn't build html anymore.

The steps are:

1) Put the Input mask in a jsp with all javascript and html stuff. When you are done you can post your jsp.
2) Let the Servlet get the parameters, perform database operations and forward control to a jsp. When you are done post the servlet code.

If the input mask parameters are disabled they arrive as null Strings to the servlet, so you can check them before performing the insert query.

Waiting for your jsp and servlet.

As you recommend THIS IS JSP

<%-- 
    Document   : SelectProduct
    Created on : May 22, 2012, 3:32:30 PM
    Author     : Ading
--%>
<%@page contentType="text/html" pageEncoding="UTF-8" import="java.util.Iterator,java.util.ArrayList,java.sql.Connection,java.sql.Statement,java.sql.ResultSet,com.db.ConnectionManager"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Select Product</title>
 <script type="text/javascript" language="javascript">
function chkBox(field)
            {
               // var a = document.getElementById("myfo").name;

// alert(field.length);
                if(document.getElementById("chk1").checked)
                 {
                for(var i=0;i<field.length;i++)
                    {
                             field[i].checked = true;
                             document.getElementById("name"+i).disabled = false;

if(document.getElementById("chk2"+i).checked)
                               {
                              document.getElementById("name"+i).disabled = false;

function otherCHK()
                  {
                      if(document.getElementById("chk1").checked)
                          {
                              document.getElementById("ch1").disabled = false;
                              document.getElementById("ch2").disabled = false;
                              document.getElementById("ch3").disabled = false;
                              document.getElementById("ch4").disabled = false;
                              document.getElementById("ch5").disabled = false;
                          }
                          else
                              {
                              document.getElementById("ch1").disabled = true;
                              document.getElementById("ch2").disabled = true;
                              document.getElementById("ch3").disabled = true;
                              document.getElementById("ch4").disabled = true;
                              document.getElementById("ch5").disabled = true;

document.getElementById("ch1").checked = false;
                              document.getElementById("ch2").checked = false;
                              document.getElementById("ch3").checked = false;
                              document.getElementById("ch4").checked = false;
                              document.getElementById("ch5").checked = false;
                              }
                  }

function chkBoxForSpecific(chkid)
            {
                var i = chkid.slice(4);
                if(document.getElementById("chk2"+i).checked)
                    {
                              document.getElementById("name"+i).disabled = false;

//////////////////////////////////////////////////////////////////////////////////
function manageValues(field,a,b,c,d,e,f)
               {
                   //var a,b,c,d,e,f;
                   
                   var a1 ,b1,c1,d1,e1,f1;

And This SERVLET

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

package com.action;

import com.db.ConnectionManager;
import com.google.common.collect.Collections2;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Collections;
import javax.servlet.http.HttpSession;

/**
 *
 * @author Reshma
 */
public class SelectProduct extends HttpServlet
{
   String product = null;
   Connection con = null;
   ResultSet rs = null;
   Statement stmt = null;
   String sql = null;
   ArrayList arr = new ArrayList();
   ArrayList outer = new ArrayList();
   String name = null;
   String price = null;
   String batch = null;
   String code = null;
   String size = null;
   String no = null;
   HttpSession session;

protected void processRequest(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        session = request.getSession();
        product = request.getParameter("productCategory");
        System.out.println("Welcome in servle----- : " + product);
        try
        {
            
        ConnectionManager connection = new ConnectionManager();
        con = connection.getConnection();
        int i = 0 ;
        sql = "Select product_name,product_price,product_batch from product_detail where product_category='"+product+"'";
        stmt = con.createStatement();
        rs = stmt.executeQuery(sql);
       if(rs.next())
        {
            do
            {
                /*name = rs.getString("product_name");
                price = rs.getString("product_price");
                batch = rs.getString("product_batch");
                code = rs.getString("product_batch");
                size = rs.getString("product_batch");
                no = rs.getString("product_batch");*/

//Its dummy data entry
            arr.add(rs.getString("product_name"));
            arr.add(rs.getString("product_price"));
            arr.add(rs.getString("product_batch"));
            arr.add(rs.getString("product_batch"));
            arr.add(rs.getString("product_batch"));
            arr.add(rs.getString("product_batch"));

/*arr.add(name);
               arr.add(price);
               arr.add(batch);
               arr.add(code);
               arr.add(size);
               arr.add(no);*/

outer.add(i,arr);
        }
            while(rs.next());
            i++;
            //Collections.reverse(outer);
           // outer = null;
            
        }
        session.removeAttribute("outer");
        session.setAttribute("product",outer);
       /* session.setAttribute("name",name);
        session.setAttribute("price",price);
        session.setAttribute("batch",batch);
        session.setAttribute("code",code);
        session.setAttribute("size",size);
        session.setAttribute("no",no);*/

// System.out.println("Outer---------- : " + outer);
       response.sendRedirect("SelectProduct.jsp");
            /* TODO output your page here
            out.println("<html>");
            out.println("<head>");
            out.println("<title>Servlet SelectProduct</title>");  
            out.println("</head>");
            out.println("<body>");
            out.println("<h1>Servlet SelectProduct at " + request.getContextPath () + "</h1>");
            out.println("</body>");
            out.println("</html>");
            */
        }
        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 need a good solution to set NA in that cells values which is disabled in jsp page. How it is possible.

Hi, guys its my Servlet which I missed yesterday with the above post

Please give me a solution to add value(blank or "NA") in disabled cell

Thanks in advanced

any ways I have done it using JavaScript