How to pass parameters to action through URL in a POST request

[Srijit Banerjee]

Hi,

In my Struts 2 Application, I am getting a table of values from the database using the iterator tag and using respective getter and setters for the same. For Example I am getting list of Account number, Name and Account Balance. Now I am using the following code to get the account details after user clicks on the ac no. url which is retrieved from DB using struts iterator. Supose there are two accounts of one customer. If I click on first account number then I am getting correct account details for that particular account number. But in case of other account I am getting 0

Java class -

package com.srijit.finasoft.customer;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Timestamp;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.sql.*;
import com.srijit.finasoft.dao.*;

import javax.servlet.http.HttpSession;
import javax.servlet.http.HttpServletRequest;

import org.apache.struts2.interceptor.ServletRequestAware;

import com.opensymphony.xwork2.ActionSupport;
import com.srijit.finasoft.dao.DBCon;
public class custACDetails extends ActionSupport implements ServletRequestAware{
    int yourAc;
     public int getYourAc() {
            return yourAc;
        }

        public void setYourAc(int yourAc) {
            this.yourAc = yourAc;
        }
    ArrayList<ACDetailsModel> detlist=new ArrayList();

String cdate;


        public String getCdate() {
    return cdate;
}

public void setCdate(String cdate) {
    this.cdate = cdate;
}
        private List<String> custAccounts;
        public List<String> getCustAccounts() {
            return custAccounts;
        }

        public void setCustAccounts(List<String> custAccounts) {
            this.custAccounts = custAccounts;
        }

        public void setServletRequest(HttpServletRequest request){
            HttpSession session=request.getSession();
            int cid=(int) session.getAttribute("custid");

            Connection con;
            try
            {           
            con=DBCon.getCon();
            custAccounts=new ArrayList<String>();
             PreparedStatement ps=con.prepareStatement("select acno from custacdetails where custid=? and actype='SA'");
              ps.setInt(1,cid);
              ResultSet rs=ps.executeQuery();
              while(rs.next()){
                  custAccounts.add(rs.getString(1));    
              }con.close();
            }
              catch(Exception e){e.printStackTrace();} 
        }
        public String execute() {
            String curdate;
             long acno=getYourAc();
            System.out.println(acno);
            //int acno=98300;

            DateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy HH:mm:ss");
            Date date = new Date();         
            cdate=dateFormat.format(date);
             Connection con;
             try{
                 con=DBCon.getCon();             
            PreparedStatement ps=con.prepareStatement("select c.custid,ca.acno,jfname,jlname,currency,address,isactive,acopendt,ACBAL,actype,acscheme from CUSTAC a,CUSTACDETAILS ca,CUSTDETAILS c where ca.acno=? and ca.acno=a.acno and ca.CUSTID=c.CUSTID");
            ps.setLong(1, acno);
            ResultSet rs=ps.executeQuery();
            while(rs.next()){                   
                ACDetailsModel ob = new ACDetailsModel();
                ob.setCustid(rs.getInt(1));
                ob.setAddr(rs.getString(6));
                ob.setAcno(rs.getLong(2));
                ob.setAcbal(rs.getDouble(9));
                ob.setCurr(rs.getString(5));
                ob.setActype(rs.getString(10));
                ob.setJacname(rs.getString(3)+" "+rs.getString(4));
                ob.setAcopendt(rs.getDate(8));
                ob.setAcscheme(rs.getString(11));
                ob.setAcstatus(rs.getString(7));
                //ob.setCname(rs.getString(11));

                detlist.add(ob);
            }
             }
             catch(Exception e){e.printStackTrace();}

            return SUCCESS;
        }

        public ArrayList<ACDetailsModel> getDetlist() {
            return detlist;
        }

        public void setDetlist(ArrayList<ACDetailsModel> detlist) {
            this.detlist = detlist;
        }



    }

custacsummary.java

package com.srijit.finasoft.customer;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;

import org.apache.struts2.interceptor.ServletRequestAware;

import com.opensymphony.xwork2.ActionSupport;
import com.srijit.finasoft.dao.*;

import java.sql.*;
import java.util.ArrayList;
import java.util.ListIterator;

public class ACSummary extends ActionSupport implements ServletRequestAware{
Connection con;
int cid;    
ArrayList<ACModel> al=new ArrayList();


public ArrayList getAl() {
    return al;
}
public void setAl(ArrayList al) {
    this.al = al;
}

public int getCid() {
    return cid;
}

public void setCid(int cid) {
    this.cid = cid;
}



    public void setServletRequest(HttpServletRequest request)
    {
        HttpSession session=request.getSession();
        cid=(int) session.getAttribute("custid");       
    }   
    public String execute()
    {
        if(cid!=0)
        {
            try {               
            con=DBCon.getCon();         
            PreparedStatement ps=con.prepareStatement("select a.acno,cd.fname,cd.lname,b.bname,a.acbal from custdetails cd,custac a,custacdetails d,branch_details b where d.custid=? and a.acno=d.acno and d.custid=cd.custid and a.branchid=b.bid");
            ps.setInt(1, cid);
            ResultSet rs=ps.executeQuery();
            while(rs.next()){                   
                ACModel obj = new ACModel();
                obj.setAcno(rs.getLong(1));
                obj.setAcname(rs.getString(2)+" "+rs.getString(3) );
                obj.setBranch(rs.getString(4));
                obj.setAcbal(rs.getDouble(5));              
                al.add(obj);
              }

            }
            catch(Exception e){e.printStackTrace();}            
            return "success";   
        }
        else
        {
            return "failure";
        }       
    }   
}

JSP parts csutacsummary.jsp

<a class="navlinks" href="">
    </a>
    </b>
    </div>
    </td>   
    <td>
       <s:property value="acname"/>







   </td>

    <td><div align="center">

            <s:property value="branch"/>

        </div>
    </td>
    <td>
        <div align="center">SBA</div>
    </td>


    <td>

            <div class="FL">(+)</div>

        <div class="FR"><s:property value="acbal"/></div>
    </td>


    <td>
     </s:iterator>  
<script type="text/javascript">

  $(document).ready(function() {
    $("#acno").click(function(e) {

      e.preventDefault();
      $("#form").submit();
    });
  });
</script>

[Joe Ess]

Welcome to the JavaRanch. We ask that you let us know if you have posted your question on other sites. We'd hate to waste our time working on your problem if it has already been answered elsewhere.
It looks like we don't have enough of the JSP to help you right now, but judging from Roman C's comment on the other site, you just copied something he had posted on how to make a block of text respond to a click. Do you understand how his code works? Can you fix the code posted above so we can get a better picture of what you are doing?

[Srijit Banerjee]

Joe Ess wrote:Welcome to the JavaRanch. We ask that you let us know if you have posted your question on other sites. We'd hate to waste our time working on your problem if it has already been answered elsewhere.
It looks like we don't have enough of the JSP to help you right now, but judging from Roman C's comment on the other site, you just copied something he had posted on how to make a block of text respond to a click. Do you understand how his code works? Can you fix the code posted above so we can get a better picture of what you are doing?

It's true I have asked about this problem on other sites. But I have not got any solution. So in order to find a working solution to this problem I posted here. What other jsp do you need?

[Joe Ess]

Look at the JSP you posted above. It is incomplete.

[Srijit Banerjee]

Joe Ess wrote:Look at the JSP you posted above. It is incomplete.

http://pastebin.com/WcKeYRMv

http://pastebin.com/NkPy8Uxv

http://pastebin.com/TEWXxS1M

[Maneesh Godbole]

Srijit Banerjee wrote:

Joe Ess wrote:Look at the JSP you posted above. It is incomplete.

http://pastebin.com/WcKeYRMv

http://pastebin.com/NkPy8Uxv

http://pastebin.com/TEWXxS1M

The help us best help you, please copy paste your JSP here (Please UseCodeTags)
Not many people will be bothered to go to some other site to see the code

[Srijit Banerjee]

Maneesh Godbole wrote:

Srijit Banerjee wrote:

Joe Ess wrote:Look at the JSP you posted above. It is incomplete.

http://pastebin.com/WcKeYRMv

http://pastebin.com/NkPy8Uxv

http://pastebin.com/TEWXxS1M

The help us best help you, please copy paste your JSP here (Please UseCodeTags)
Not many people will be bothered to go to some other site to see the code

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
    <%@ taglib uri="/struts-tags" prefix="s" %>  
<s:set name="theme" value="'simple'" scope="page" />
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
   <script src="../assets/scripts/custLoginUI/jquery.min.js"></script>

<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
<link rel="stylesheet" href="../assets/css/custAC/style.css" type="text/css">




<link href="../assets/css/custAC/style(1).css" rel="stylesheet" type="text/css">
</head>
<body>
<td align="left" valign="top" class="mainContainer">


<table width="120%" border="0" cellspacing="0" cellpadding="0" align="center">
<tbody><tr>
<td>
<script language="JavaScript">

function checkopt()
{
	var selectedvalue = document.getElementById('selectopt');

	if (selectedvalue.value == "Option.Accounts.DefaultValue")
	{
		alert("Please Select An Option From Dropdown");
		selectedvalue.focus();
		return false;
	} 
	else
	{
		return true;
	}   
}

</script>


<link rel="stylesheet" href="./Operative Accounts Summary_files/style.css" type="text/css">







<marquee><p><font color="#B60548"><b>Current Account Holders of Constitutions other than Individual and Sole Proprietorship will have limited access to Retail Internet Banking starting from 17th May, 2013. Please visit the nearest Axis Bank branch and apply for Corporate Internet Banking for continued Online Banking facilities.</b> </font></p></marquee><p> </p><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tbody><tr>
	<td align="left" valign="top" class="titleLine"><h2 class="tTxt">Account Summary</h2></td>
</tr>

<tr>
	 <td>
		<p> </p>
	 </td>
</tr>

  

<tr>
	<td align="left">
		<br>If you are unable to view any of your accounts please <input type="submit" name="Action.Accounts.MissingAccountDetail" value="Click here to get the account details" class="but"><br>
	</td>
</tr>

<tr>
	<td align="left" valign="top" class="boxCon">
  	<!--*************************************code for Status as on date ****************************Siddharth Newalkar*** -->

  	  <div class="actionBreadcrum"><span class="function FL">Click on an Account Number to view its details</span> 
	  
	  <span class="header FR">Summary as on 01/08/2014</span></div>
	  </td>
</tr>
                
<tr>
	<td align="left" valign="top">                

<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center" class="itemGrid">
 <tbody><tr class="gridhead">
    <td width="18%">
        <div align="center"><b><font color="#000000">Account Number</font></b></div><font color="#000000">
    </font></td>
    <td width="30%">
      <div align="center"><b><font color="#000000">Account Name </font></b></div><font color="#000000">
    </font></td>
    <td>
          <div align="center"><b><font color="#000000">Branch</font></b></div><font color="#000000">
    </font></td>
    <td width="8%">
      <div align="center"><b><font color="#000000">Account Type</font></b></div><font color="#000000">
    </font></td>
	
    <td width="16%">
      <div align="center"><b><font color="#000000">Account Balance</font></b></div><font color="#000000">
    </font></td>
	  
    <!-- <td height="16" width="20%">
        <div align="center"><b><font  color="#000000" >Status As of Date</b></div>
    </td>
	-->
    <td width="14%">
        <div align="center"><b><font color="#000000">Statement</font></b></div><font color="#000000">
    </font></td>
</tr>


<s:iterator value="al">
	<tr class="tr2">
	
     
 
    <td>
<div align="left">
<!-- ****This code is used to get the hyper link for the dedicated detail page of the corresponding user****-->
    

            <div align="center"><b>
           <!-- 
<s:url action="custACDetails" var="urlTag" >
    <s:param name="yourAc"><s:property value="acno"/></s:param>
</s:url>
<a href="<s:property value="#urlTag" />" ><s:property value="acno"/></a>
 -->
 
 <s:url action="custACDetails" includeContext="false" var="urlTag"/>
<s:set var="contextPath">${pageContext.request.contextPath}</s:set>
<s:a id="acno" href="%{#contextPath+#urlTag}"><s:property value="acno"/></s:a>
<s:form id="form" action="%{#urlTag}" method="POST">
  <s:hidden name="yourAc" value="%{acno}"/>
</s:form>

 

</b>
</div>
<b>
<a class="navlinks" href="">
    </a>
    </b>
    </div>
    </td>   
    <td>
       <s:property value="acname"/>
	 

	




   </td>
    
    <td><div align="center">
		
			<s:property value="branch"/>
					
		</div>
    </td>
    <td>
		<div align="center">SBA</div>
    </td>
  

    <td>
    	
			<div class="FL">(+)</div>
		
		<div class="FR"><s:property value="acbal"/></div>
    </td>

 
    <td>
     
       <div align="center">
       <s:form name="form1">
<s:hidden name="yourAc" value="%{acno}" />
					<s:submit type="image" value="pay" action="custMStatement" src="../assets/img/custAC/st.png"/> </s:form> 




    </div></td>
  </tr>
  </s:iterator>  
<script type="text/javascript">

  $(document).ready(function() {
    $("#acno").click(function(e) {
    	
      e.preventDefault();
      $("#form").submit();
    });
  });
</script>
</tbody></table>
	</td>
	
	</tr>
	<tr>
	<td>
	<div>
	
</div>
	</td>
 </tr>	
</tbody></table>
<table width="100%">

		<tbody><tr>
			
			<td width="93%" align="left" valign="middle"><font size="2"><b>			
			Banking with Axis Bank is now just a touch away with Axis Mobile - a simple, user-friendly, convenient and secure mobile application. To download SMS MBANK to 5676782. <a href="http://www.axisbank.com/personal/speed-banking/axis-mobile/axis-mobile.aspx" target="_blank" class="navlinks">View details</a></b></font>
			</td>
		</tr>
</tbody></table><br>

 <!------------------------------------------------------------ Card Products Start -------------------------------->
			<table width="100%"><tbody><tr><td>
							
															
							
							</td></tr><tr>
							<td class="box1">
									</td><td width="7%" align="left" valign="top"><img alt="AXIS Bank iConnect" src="../assets/img/custAC/cards_acc.jpg" width="46" height="29"></td>
									<td width="93%" align="left" valign="middle"><h2 class="tTxt">			
								
									<a href="https://www.axisbank.co.in/BankAway/(S(t0bm1pjzwqjrotrwsrnfl2zw))/web/L001/retail/jsp/accounts/CorpAccountSummary.aspx?RequestId=41244994#." onclick="document.ccfrm.submit();" class="navlinks"><font size="2">Click here to instantly apply</font></a>
									for your Axis Bank Credit Card. Enjoy 25% cashback on all movie tickets or get 2 complimentary flight tickets with our range of Credit Cards. Also, earn eDGE Loyalty Rewards points. 
							</h2></td>
							</tr>
                          
						
			
			</tbody></table>
			<!---------------------------------------------------------------------------------- Card Products End ---------------------------------------------------------------------------------->





		<table width="100%" border="0" cellspacing="0" cellpadding="0" class="hbox" style="margin-top:8px;">
                    <!--<tr>
					<td><h2 class="hTitle">Help us enhance your Internet Banking experience by filling in a short survey, please <A HREF ="#."  style="text-decoration: none;" onclick='OpenWindFull("http://www.axisbank.com/xmlapplication/webforms/ib_rec_survey/InternetSurvey.asp")'> click here</a> to continue.</h2>
					</td>
					</tr>-->
					<tbody><tr>
                      <td><h2 class="hTitle">Please Note</h2>
                          <ul class="ulList">
                            <!--<li>If you are unable to view any of your accounts please <a href=  tranHttpHandler.aspx?bwayparam=qDqKkTbBuAM3mjVHftjpts9XLSkDMdKnKBlgoJFsJVoxMmsRCNCdQNul5Ue%2bPDheLLrH2fMBuY8E%0d%0aiX4NUk5bifVWkWMfn3T6 class=navlinks>
							click here </a></li>-->
							<li>The account balance displayed includes the credit balance and overdraft limit (if any) in your account. It excludes funds which are under clearing and amount marked lien, if any. For any further clarifications, please contact the Branch.</li>
                            <li>Please click on "Mini Statement" to view your last 10 transactions.</li>
                            <li>Please click on an Account Number to view its details.</li>
							<li>Current Account Holders of Constitutions other than Individual and Sole Proprietorship will have limited access to Retail Internet Banking starting from 17th May, 2013. Please visit the nearest Axis Bank branch and apply for Corporate Internet Banking for continued Online Banking facilities.
							</li>

                          </ul>
                     </td>
                    </tr>
        </tbody></table>
            </td>
            </tr>
            </tbody></table>
            <!-- section for PLACE HOLDERS-->
</td>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

    <%@ taglib uri="/struts-tags" prefix="s" %>  
<s:set name="theme" value="'simple'" scope="page" />
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Acount Details</title>
<link rel="stylesheet" href="../assets/css/custLoginUI/style.css" type="text/css">
</head>
<body>
<body bgcolor="#FFFFFF" topmargin="0" leftmargin="0" marginheight="0" marginwidth="0">
<td align="left" valign="top" class="mainContainer" style="padding-right:0px;">

<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tbody><tr>
    <td align="left" valign="top" class="titleline">
    <h2 class="tTxt">Account Details</h2>
    </td>
</tr>
<tr>
   <td align="left" valign="top" style="padding:5px 0px;">Select an Account from the dropdown list.</td>
  </tr>
<script language="JavaScript">

function checkopt()
{
	var selectedvalue = document.getElementById('selectopt');

	if (selectedvalue.value == "Option.Accounts.DefaultValue")
	{
		alert("Please Select An Option From Dropdown");
		selectedvalue.focus();
		return false;
	} 
	else
	{
		return true;
	}   
}

     
     function chg()
	{
	   var  refurl = "tranHttpHandler.aspx?bwayparam=qCaQB%2f6sp%2fcaADErLVU5Bx6EQ%2boOkrzJ%2f6O4PSR%2f9NDGYtD4IZO9PYrXCA%3d%3d";
	   var  FormName=document.getElementById("accoptionsfrm");
	   FormName.action=refurl;
           FormName.submit();
	}
</script>

</tbody></table><table border="0" width="100%" cellpadding="0" align="center" cellspacing="0" class="listgrid">
	<tbody><tr>
		<td class="box1">
			<table border="0" width="100%" cellpadding="0" align="center" cellspacing="0">
				<tbody><tr>
					<td class="box2">
<table border="0" width="100%" cellpadding="0" cellspacing="0" class="zerolist">
  <tbody><tr>
    <td class="lcolon"><b>Account Name</b> </td>
	<td style="padding-left:10px;">   
<s:form action="custACDetails" >
	<s:select label="AC Name" list="custAccounts" name="yourAc" cssClass="sbut"/>


    </td>

  <td valign="top" style="padding-left:10px;">
  <!--  <input type="submit" class="but" border="white" name="Action.Accounts.AccountDetails" value="Click here to get details"> -->

<s:submit type="sumit" cssClass="but" border="white" value="Click here to get details"/>
</s:form>
</td>
</tr>
</tbody></table>
</td>
</tr>
</tbody></table>
</td>
</tr>
</tbody></table>

<s:iterator value="detlist">

<table border="0" cellpadding="0" cellspacing="0" width="95%" align="center">
    <tbody><tr>
			  <td align="left" valign="top" class="boxCon"><div class="actionBreadcrum"><span class="header FR">Account Details - <s:property value="cname"/> [Details till
	      <s:property value="cdate"/> ]
      </span> </div></td>
			  </tr>

</tbody></table>
<table border="0" cellpadding="0" cellspacing="0" width="100%" align="center">
<tbody><tr><td class="box1"><table width="100%" border="0" cellspacing="0" cellpadding="5">
                  <tbody><tr>
                    <td width="50%" align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0" class="aclistgrid">
      <tbody>
      
      <tr class="altrow">              
      <td width="50%" class="lcolon"> <font face="Arial, Helvetica">Account Number</font> </td>
      <td width="69%"> <s:property value="acno"/>  </td>
  </tr>


									<tr class="tr1">
													
								
								<td class="lcolon" height="14">Joint Account Holder 1 </td>
								<td height="14" width="69%"> <s:property value="jacname"/>  </td>
								</tr>
					
	
  <tr class="tr2">
      <td class="lcolon">Currency  </td>
      <td width="69%"> <s:property value="curr"/>  </td>
  </tr>
  <tr class="altrow">
	  <td class="lcolon">Account Type  </td>
	  <td width="69%"><s:property value="actype"/>  </td>
  </tr>
    <tr class="tr2">
      <td class="lcolon" valign="top">Communication Address  </td>
      <td width="69%"><s:property value="addr"/> L </td>
   
  </tr>
 
  <!--<tr class="tr2">
	  <td  class="lcolon">Permanent Address  </TD>
	  <td width="69%"> </TD>
  </tr>-->
  <tr class="altrow">
      <td class="lcolon">Account Category Scheme Code </td>
	  <td width="69%"><s:property value="acscheme"/>  </td>
  </tr>
  <tr class="tr2">
      <td class="lcolon">Account Status  </td>
	  <td width="69%"><s:property value="acstatus"/>  </td>
  </tr>
<!--  <tr class="altrow">
      <td  class="lcolon">Primary Account Y/N  </TD>
      
       <td width="69%"> N  </TD>
  </tr>  -->
  
  
  
      
  <tr class="tr2">
      <td class="lcolon">Customer Id </td>
      <!--td width="69%">
      D1/9830014855 
      </TD-->
      <td width="69%"><s:property value="custid"/> </td>
  </tr>
  <!--<tr class="tr2">
      <td width="31%">Customer Name </TD>
		
				<td width="69%"> Not Available </TD>
		
  </tr>-->
  <tr class="altrow">
       <td class="lcolon">Account Open Date </td>
       <td width="69%"><s:property value="acopendt"/>  </td>
  </tr>
  <tr class="tr2">
      <td class="lcolon">Account Balance </td>
		
			<td width="69%"><s:property value="acbal"/>  </td>
		
  </tr>
  <tr class="altrow">
	  <td class="lcolon">Available Balance </td>
      
          <td width="69%"><s:property value="avbal"/>  </td>
      
  </tr>
    </tbody></table></td>
    <td width="50%" align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0" class="aclistgrid">
  <tbody><tr class="tr2">
      <td width="50%" class="lcolon">Effective Available Balance </td>
      
		<td width="69%"> 9,55,000.12 </td>
	  
  </tr>
  <tr class="altrow">
      <td class="lcolon">Lien Amount </td>
      
         <td width="69%"> 0.00 </td>
      
  </tr>
<!-- 
    <tr class="tr2">
		<td height="14" class="lcolon"> Unclear Balance </td>
		
			<td height="14" width="69%"> 0.00 </td>
		
    </tr>
    <tr class="altrow">
		<td height="14" class="lcolon"> Float Balance </td>
        
             <td height="14" width="69%"> 0.00 </td>
		
    </tr>
    
    <tr class="tr2">
		<td height="14" class="lcolon"> Other Balance </td>
        
			<td height="14" width="69%"> 9,55,000.12 </td>
        
    </tr>
    <tr class="altrow">
		<td class="lcolon"> Sanction Limit </td>
		
			<td width="69%"> 0.00 </td>
		
    </tr>
    <tr class="tr2">
		<td height="14" class="lcolon">Drawing Power  </td>
		
			<td height="14" width="69%"> 0.00 </td>
		
    </tr>
	<tr class="altrow">
		<td height="14" class="lcolon">System Reserve Amount </td>
		
			<td height="14" width="69%"> 0.00 </td>
		
    </tr>
    <tr class="tr2">
		<td height="14" class="lcolon">OverDue Liability </td>
		
			<td height="14" width="69%"> 0.00 </td>
		
    </tr>
    <tr class="altrow">
		<td height="14" class="lcolon">Available Amount in FFD </td>
		
			<td height="14" width="69%"> 0.00 </td>
		
    </tr>
	<tr class="tr2">
		<td height="14" class="lcolon">Funds In Clearing </td>
		
			<td height="14" width="69%"> 0.00 </td>
		
    </tr> -->
    </s:iterator>
  </tbody>
  </table>
  
    </td></tr></tbody></table></td>
                  </tr>
                </tbody></table>



<center>
  <!--<input type="submit" name="Action.Accounts.SecurityDetails" value="Security Details" class="but">-->
  <!--input type="submit" name="Action.Accounts.AccountSummary" value="Cancel" class="but"-->
  <!--<button type="submit" name="Action.Accounts.CorpAccount_Details" value="Back" class="btnMain"><span>Back</span></button>-->
</center></td>
</body>
</html>

package com.srijit.finasoft.customer;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;

import org.apache.struts2.interceptor.ServletRequestAware;

import com.opensymphony.xwork2.ActionSupport;
import com.srijit.finasoft.dao.*;

import java.sql.*;
import java.util.ArrayList;
import java.util.ListIterator;

public class ACSummary extends ActionSupport implements ServletRequestAware{
Connection con;
int cid;	
ArrayList<ACModel> al=new ArrayList();


public ArrayList getAl() {
    return al;
}
public void setAl(ArrayList al) {
    this.al = al;
}

public int getCid() {
	return cid;
}

public void setCid(int cid) {
	this.cid = cid;
}



	public void setServletRequest(HttpServletRequest request)
	{
		HttpSession session=request.getSession();
		if (session.getAttribute("custid")!=null)
		{
			cid=(int) session.getAttribute("custid");	
		}
		
		
	}	
	public String execute()
	{
		if(cid!=0)
		{
			try {				
			con=DBCon.getCon();			
			PreparedStatement ps=con.prepareStatement("select a.acno,cd.fname,cd.lname,b.bname,a.acbal from custdetails cd,custac a,custacdetails d,branch_details b where d.custid=? and a.acno=d.acno and d.custid=cd.custid and a.branchid=b.bid");
	    	ps.setInt(1, cid);
	    	ResultSet rs=ps.executeQuery();
	    	while(rs.next()){		    		
	    		ACModel obj = new ACModel();
	    		obj.setAcno(rs.getLong(1));
	    		obj.setAcname(rs.getString(2)+" "+rs.getString(3) );
	    		obj.setBranch(rs.getString(4));
	    		obj.setAcbal(rs.getDouble(5));	    		
	    		al.add(obj);
	   		  }
	    	
			}
			catch(Exception e){e.printStackTrace();} 	
			
			return "success";
		}
		else
			{
				return LOGIN;
			}
			
				
	}	
}

[Joe Ess]

Any way you can try to narrow the problem down? 600 lines is an awful lot of code to read through (not to mention I don't think Axis Bank wants you posting their code)