model view controller - How get the data using MVC- Servlets, JPS and JavaScripts -
i have jsp page has links (when people click on link supposed go servlet , bean class , db connection class pull data)..and when user clicks on tried display page using ajax...however not getting data/page pulled. can please explain on how achive this?
here link have in html page..but when click on not showing anything.
<a href="myservlet" onclick="grabfile(this.href); return false;">vt </a>
thanks help
sorry here code
public class vacationtrackerdao { public static list<vactiontrackerbean> list() throws sqlexception{ list<vactiontrackerbean> appr= new arraylist<vactiontrackerbean>(); try{ dbconnection conobj=new dbconnection(); connection dbcon= conobj.getcon(); statement stmt=conobj.getstmt(); string querycplist="select * capacity_plan"; string queryapprlist="select first_last_name vacation_approvers"; preparedstatement prestmtcplist=dbcon.preparestatement(querycplist);//get metadat preparedstatement prestmtapprlist=dbcon.preparestatement(queryapprlist);//get names resultset rscplist=prestmtcplist.executequery(); resultset rsapprlist=prestmtcplist.executequery(); resultsetmetadata metacplist=rscplist.getmetadata(); vactiontrackerbean vtbean=new vactiontrackerbean(); while(rsapprlist.next()){ vtbean.setapprover((rsapprlist.getstring("first_last_name"))); appr.add(vtbean); } }catch(exception e){ system.out.println("in vacation trackerdao.java class:"+e); } return appr; } }
here servlets gets request.
protected void dopost(httpservletrequest request, httpservletresponse response) throws servletexception, ioexception { try{ list<vactiontrackerbean> vacbean=vacationtrackerdao.list(); request.setattribute("vactracker", vacbean); request.getrequestdispatcher("web-inf/vacationtracker.jsp").forward(request,response); }catch (sqlexception e){ system.out.println("error in vacationtracker.java due vactiontrackerda.java:"+e); request.getrequestdispatcher("web-inf/error.jsp").forward(request,response); }
here code have in jsp page.
<li> <a href="main.jsp" > home </a> </li> <li><a href="vacationtracker" onclick="grabfile(this.href); return false;">vacation tracker </a> </li> </ul>
here code javascript
function gethttpobject(){ var xhr=false; if(window.xmlhttprequest){ xhr= new xmlhttprequest(); } else if(window.activexobject){ try{ xhr= new activexobject("msxml2.xmlhttp"); } catch(e){ try{ xhr=new activexobject("microsoft.xmlhttp"); }catch (e){ xhr=false; } } } return xhr;
}
function grabfile(file){ var request=gethttpobject(); if(request){ request.onreadystatechange=function(){ displayresponse(request);}; } request.open("post",file,true); request.send(null);
}
function displayresponse(request){ if(request.readystate==4){ if(request.status==200){ document.getelementbyid ("middle_sub").innerhtml=request.responsetext; } } }
i have jsp page has links (when people click on link supposed go servlet , bean class , db connection class pull data)..and when user clicks on tried display page using ajax...however not getting data/page pulled. can please explain on how achive this? here link have in html page..but when click on not showing anything. thanks help sorry here code here servlets gets request. here code have in jsp page. here code javascript } } | |||||||||
|