How to insert value in a table using session(ArrayList)?

[Rd Dari]

Hi all,

This is my servlet and I want to add values in a table using this servlet but I am facing a problem how to set an ArrayList object in pst.setString ???

Please suggest me and Thank you in advanced

code is here

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

package src;

import java.io.*;
import java.net.*;
import java.sql.Array;
import javax.servlet.RequestDispatcher;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.PreparedStatement;
import javax.servlet.*;
import javax.servlet.http.*;
import src.*;
import java.util.*;

/**
 *
 * @author user03
 */
public class Grocery_Booking_Detail_Servlet extends HttpServlet 
{
        HttpSession session;
        RequestDispatcher rd;
        JdbcConnection afeCon = new JdbcConnection();
        Statement stmt = null;
        ResultSet rs = null;
        Connection con = null;
        String qrt = "Na";
        PreparedStatement pst;
        String amount=null;
        String s1=null;
        int t2=1;
        int tot1=0;
        
        protected void processRequest(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException
        {
       // System.out.println("WELCOME");
        response.setContentType("text/html;charset=UTF-8");
        session=request.getSession(true);
        PrintWriter out = response.getWriter();
        String username=(String)session.getAttribute("user");
        ArrayList ar1=(ArrayList)session.getAttribute("as1");
        System.out.println("Session's value in servlet^^^^^^^^^^^  " + ar1);
        //System.out.println("USERNAME IS IN SERVLET " + username);
        /*String as1=(String)session.getAttribute("as1");
        String as2=(String)session.getAttribute("as2");
        String as3=(String)session.getAttribute("as3");
        String as4=(String)session.getAttribute("as4");
        String as5=(String)session.getAttribute("as5");
        String as6=(String)session.getAttribute("as6");*/
        //System.out.println("session's value is-------  "+as1+"---"+as2+"--"+as3+"--"+as4+"--"+as5+"--"+as6);
        String cat="Noname";
        for(int i=0;i<2;i++)
        {
        amount=request.getParameter("Amount"+i);
        System.out.println("Amount is,,,,, "+amount);
        }
        con=afeCon.getConnection();
        try
        {
            stmt=(Statement)con.createStatement();
            String sql="select max(auto_generate) as 'auto_generate' from history_grocery";
            rs=stmt.executeQuery(sql);
            System.out.println("Try !!!!!!"+sql);
            if(rs.next())
            {
                int t1=rs.getInt(1);
                tot1=t1+t2;
            }
           //for(int i=0;i<Integer.parseInt(amount);i++)
            //{
            if(ar1!=null)
            {
                ArrayList ar2=null;
                 Iterator it=ar1.iterator();
                 while(it.hasNext())
                 {
                      ar2=(ArrayList)it.next();
                 System.out.println("for loop !!!!!!");
                 pst= con.prepareStatement("insert into history_grocery values(0,?,?,?,?,?,?,?)");
                 //String s1=request.getParameter("Item"+i);
                 //System.out.println("Value of s1,,,, " + s1);
                 pst.setString(1,ar2);
                 pst.setString(2,as2);
                 pst.setString(3,as3);
                 pst.setString(4,as4);
                // String q1=request.getParameter("q1"+i);
                // System.out.println("-------q1 is ----- " +q1);
                 pst.setString(5,as5);
                 //String amt=request.getParameter("Amount"+i);
                 pst.setString(6,as6);
                 pst.setString(7,username);

                 int t5=pst.executeUpdate();
                 System.out.println("Insert query is done successfully!!!!"+pst);
                 if(t5>0)
                 {
                     System.out.println("BookIng Successfully");
                 }
                 else
                 {
                     System.out.println("error is come");
                 }
                  * 
                  */
            }
                 System.out.println("Arraylist2 value is********  " + ar2);
            }
            rd=request.getRequestDispatcher("success.jsp");
            rd.forward(request, response);

        }

        catch(Exception ex)
        {
            System.out.println("the problem is @@@@@@@@@@"+ex);
            ex.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>
}

in ar1 values are accorate and ar2 also but I am anable to set these values in pst.setString ....so please clear it...


Thanks once again!!!

[Paul Clapham]

Rd Dari wrote:This is my servlet and I want to add values in a table using this servlet but I am facing a problem how to set an ArrayList object in pst.setString ???

Well, you wouldn't. If "pst" is a PreparedStatement then its setString() method requires a String as the second parameter. So asking how to pass an ArrayList there doesn't make any sense. You should review your requirements to find out where that String is supposed to come from.

And just another piece of advice: if you are still working on basic Java or JDBC programming, then a servlet is going to be a very inconvenient test environment. Do your training and practicing in a plain old Java application. Then after you have working code, take that code and insert it into your servlet.