Iframe to automatic update in jsp according to the database

Hi,

I am trying to do a jsp which simply have the label campaign and leads count .I have a controller which checks the database and give the output for campaign and leads count.
I have used a jsp which calls the controller and the jsp in iframe .I need to display the campaigns and the leads count for that particular campaign without refreshing the page.But now i am unable to do this.I have to refresh the page to view the current update in database.The code is as follows:

Frame.jsp

<%@ page import="java.net.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.io.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.awt.event.*"%>
<%@ page session="true" %>
<%@ page import="java.text.SimpleDateFormat"%>
<%@ page import="java.util.Calendar" %>
<%@ page import="java.util.Date" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Frameset//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-frameset.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>CRM</title>
<script type="text/javascript" language="javascript">
 function onIFrameLoad() {
   //alert("Inside IFrame");
   document.first.action="count.do";
   document.first.method="post";
   document.first.submit();
    var serverResponse = extractIFrameBody($("iFrame")).innerHTML;
   $("response").innerHTML = serverResponse;
   //alert("Outside IFrame");
 }
</script>
</head>
<body>
<form name="first">
  <iframe id="iFrame" frameborder="0" onload="onIFrameLoad();" src="lesdscount.jsp" width="100%" height="700" scrolling="no">
  </iframe>  
   </form>
   </body>
 </html>

leadscount.jsp

<%@ page import="java.text.*,java.util.Date" %>
<%@taglib uri="http://java.sun.com/jsp/jstl/core"  prefix="c"%>
<%@taglib uri="http://java.sun.com/jsp/jstl/fmt"  prefix="fmt"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Contact Center CRM Admin Panel Campaign Creation</title>
<link href="/ContactCenterAdmin/style3.css" rel="stylesheet" type="text/css" />

</style>
<script type="text/javascript">

<!--
function FP_swapImg() {//v1.0
 var doc=document,args=arguments,elm,n; doc.$imgSwaps=new Array(); for(n=2; n<args.length;
 n+=2) { elm=FP_getObjectByID(args[n]); if(elm) { doc.$imgSwaps[doc.$imgSwaps.length]=elm;
 elm.$src=elm.src; elm.src=args[n+1]; } }
}

function FP_preloadImgs() {//v1.0
 var d=document,a=arguments; if(!d.FP_imgs) d.FP_imgs=new Array();
 for(var i=0; i<a.length; i++) { d.FP_imgs[i]=new Image; d.FP_imgs[i].src=a[i]; }
}

// -->
</script>
<%String date = DateFormat.getInstance().format(new Date()); %>
</head>
<body onload="FP_preloadImgs(/*url*/'button66.jpg',/*url*/'button67.jpg',/*url*/'button22.jpg',/*url*/'button23.jpg',/*url*/'button28.jpg',/*url*/'button29.jpg')">
<form ENCTYPE="multipart/form-data" action="count.do" method="post" name="campaign" >
<div id="container">
<div id="masthead">
 <h1 class="style1">Contact Center CRM - Admin Panel</h1>
<p>office (044) 
		26260810/26220019, Email : support@peopletech.co.in<br />
		</p>
</div>
<div id="pagecontent">
<div id="sidebar">
<ul>
				<li><a >Home</a></li>
				<li><a >User Settings</a></li>
				<li><a >Campaign Settings</a></li>				
				<li><a >Voice Logger</a></li>
				<li><a >Reports</a></li>
				<li><a >Logout</a></li>
			</ul> 
</div>
<div id="content">
<p class="style8">Home->Campaign Settings-><strong>AssignUsers</strong>                                                                                                           
Date:<%=date %></p>
<table  class="style4">
	<tr>
		<td class="style3" ></td>
		<td class="style3">                                
		<a / rel="nofollow">
		<img  id="img5"         /></td>
	</tr>
	<tr>		
		<td class="style3" > </td>
		<td class="style3" > </td>
		<td class="style3"  >
		<a >
		<img  id="img6"         /></a>
		<a >
		<img  id="img7"         /></a>
		
		<a >
		<img  id="img7"         /></a>
	<a >
		<img  id="img7"         /></a>
	
	</tr>
	
</table>
<table  border="1" class="style9">
	<tr>
		<td class="style7" >
	    <strong>Campaign Name</strong>
	    <c:forEach var="campaignname" items="${Camp}"><br/>
		<c:out value="${campaignname}">
		</c:out>
		</c:forEach>
		</td>
	
	<td class="style7" ><strong>Leads Count</strong>
		<c:forEach var="leadscount" items="${leadscount}"><br/>
	   <c:out value="${leadscount}"/>
        </c:forEach>
	    </td>
	
	</tr>
	
	</table>

</div>
</div>
<div id="footer">
<p>
		Copyright © 2010 PeopleTech Systems. All Rights Reserved.</p>

</div>
</div>

</body>

</html>

//!to check the database in leadscount
package Com.PeopleTech;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;

@Controller
public class CheckController {	
	Statement st=null;
	ResultSet rs=null;
	ResultSet rs1=null;
	Connection conn=null;

public static Connection getMySqlConnection() throws Exception 
	 {
		    String driver = "com.mysql.jdbc.Driver";
		    String url = "jdbc:mysql://localhost:3306/contactcenter";
		    String username = "peopletech";
		    String password = "peopletech";
		    Class.forName(driver); 
		    Connection conn = DriverManager.getConnection(url, username, password);
		    return conn;
	 }
@RequestMapping("/jsp/count.do")	
	
	public ModelAndView doShow(HttpServletRequest request, HttpServletResponse response) throws Exception
	{
	
	//!declaring the items
			String campaignname = null;
			String leadscount;		
			String count;
			List namelist= new ArrayList();
			List countlist= new ArrayList();			
		    Connection mysqlConn = null;	
		try
	 	{
	 		
	//!getting mysql connection 			
	 	   conn = getMySqlConnection();
	 	    st =conn.createStatement();
	 	    
	//!executing the query		
	 	    
	 	  rs=st.executeQuery("select campaignname from cc_campaign where campaignstatus=1");  	
	 	  while(rs.next())	
	 	  
	//!getting the items from the database and declaring in a variable and printing out those items list 	  
	 	  { 
	 		 
	 		campaignname=rs.getString("campaignname");
	 		 String Camp="cc_"+campaignname;
	 		System.out.println("CampaignName:"+Camp);	 		
	 		namelist.add(Camp);	 
	 		
	 Statement	st1 =conn.createStatement();	 
	      count="select * from  cc_freenumberscount where campaignname='"+ Camp +"' ";
	 	  System.out.println(count);
	 	  rs1=st1.executeQuery(count);
	 	  while(rs1.next())
	 	  {
	 		 leadscount=rs1.getString("freenumbers");
	 		 System.out.println("leadscount+++++++++++++++++++++"+leadscount);
	 		countlist.add(leadscount);
	 		 
	 	  }
	 	  }
	 	}
	 	catch(Exception e)
	 	{
	 		e.printStackTrace();
	 	}
	 	
	//!redirecting to the leadscount after the completion of the process 	
	 	ModelAndView mav=new ModelAndView("lesdscount");
	 	
	 	
	//!adding the items to the list 	
	 	mav.addObject("Camp",namelist);	 
	 	mav.addObject("leadscount",countlist);	 
	 
	 	return mav;	 
		 }
	private void getString(String string2) {
		// TODO Auto-generated method stub
		
	}
	}

Am i doing wrong?please help me to do this.

Thanks

HI Preeti

my suggestion is , you can use AJAX instead go for iframe .

Regards
Ramesh

Moving to our JSP forum.