Retriveing Data and passing it to view

[ksriram]

Hi,
I am using hibernate to data persistence and retrieval.
My requirement is to get a set of data from the data base (postgres) and storing those list of data in a drop down box.
Once the drop down box is populated, the user would select an option from it.Again based on the selection of option i should retrieve the data from the db and show the rest of the data in text box, that i have in the same page.

My first doubt is, when the page is loading i.e on the page load i should be populating the drop down menu.For this what is the controller that i should be using (my option was abstract command controller).
Once the drop down menu is populated, the user would be selecting an option.So again based on the option selected i have to retrieve the data and show it in a form.Can i do all this stuff in a single controller.

At last, the user would update rather do some workarounds in the form and submit it.
Can anyone guide me on which controller and how many of them i should be using to make my code optimized.
Reply With Quote

[ksriram]

Hi,
Now i am able to retrieve the data.But the following error is thrown while the page is loaded :

org.springframework.beans.NotReadablePropertyExcep tion: Invalid property 'state_name_eng' of bean class [java.util.ArrayList]: Bean property 'state_name_eng' is not readable or has an invalid getter method: Does the return type of the getter match the parameter type of the setter?
org.springframework.beans.BeanWrapperImpl.getPrope rtyValue(BeanWrapperImpl.java:534)
org.springframework.beans.BeanWrapperImpl.getPrope rtyValue(BeanWrapperImpl.java:526)
org.springframework.validation.AbstractPropertyBin dingResult.getActualFieldValue(AbstractPropertyBin dingResult.java:77)
org.springframework.validation.AbstractBindingResu lt.getFieldValue(AbstractBindingResult.java:337)
org.springframework.web.servlet.support.BindStatus .<init>(BindStatus.java:117)
org.springframework.web.servlet.tags.form.Abstract DataBoundFormElementTag.getBindStatus(AbstractData BoundFormElementTag.java:179)
org.springframework.web.servlet.tags.form.Abstract HtmlElementTag.resolveCssClass(AbstractHtmlElement Tag.java:502)
org.springframework.web.servlet.tags.form.Abstract HtmlElementTag.writeDefaultAttributes(AbstractHtml ElementTag.java:479)
org.springframework.web.servlet.tags.form.Abstract HtmlInputElementTag.writeDefaultAttributes(Abstrac tHtmlInputElementTag.java:176)
org.springframework.web.servlet.tags.form.SelectTa g.writeTagContent(SelectTag.java:195)
org.springframework.web.servlet.tags.form.Abstract FormTag.doStartTagInternal(AbstractFormTag.java:93 )
org.springframework.web.servlet.tags.RequestContex tAwareTag.doStartTag(RequestContextAwareTag.java:7 7)
org.apache.jsp.WEB_002dINF.jsp.EditState_jsp._jspx _meth_form_005fselect_005f0(EditState_jsp.java:233 )
org.apache.jsp.WEB_002dINF.jsp.EditState_jsp._jspS ervice(EditState_jsp.java:147)
org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet .java:803)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:328)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:315)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet .java:803)
org.springframework.web.servlet.view.InternalResou rceView.renderMergedOutputModel(InternalResourceVi ew.java:142)
org.springframework.web.servlet.view.AbstractView. render(AbstractView.java:247)
org.springframework.web.servlet.DispatcherServlet. render(DispatcherServlet.java:1123)
org.springframework.web.servlet.DispatcherServlet. doDispatch(DispatcherServlet.java:860)
org.springframework.web.servlet.DispatcherServlet. doService(DispatcherServlet.java:774)
org.springframework.web.servlet.FrameworkServlet.p rocessRequest(FrameworkServlet.java:460)
org.springframework.web.servlet.FrameworkServlet.d oGet(FrameworkServlet.java:415)
javax.servlet.http.HttpServlet.service(HttpServlet .java:690)
javax.servlet.http.HttpServlet.service(HttpServlet .java:803)

This is the controller code :

public class StateEditController extends SimpleFormController{
protected final Log logger = LogFactory.getLog(getClass());
private EditStateModel editStateModel;
private List stateName;
protected Object formBackingObject(HttpServletRequest request) throws Exception {
if(request.getParameter("state_name_eng") != null) {
logger.info("State Name"+request.getParameter("state_name_eng"));
}
else {
logger.info("Inside Else !!!!!!");
stateName = editStateModel.editData();

}

request.setAttribute("state_name_eng", stateName);
return stateName;
}

public void setEditStateModel(EditStateModel editStateModel) {
this.editStateModel = editStateModel;
}
}


I checked through logs, tht the name is been got from the db.But the erro occurs while framing and sending it to the view.

Kindly pool in ur suggestion and ideas.

[ksriram]

Hi, i am getting the following error now

javax.servlet.jsp.JspTagException: Don't know how to iterate over supplied "items" in &lt;forEach&gt;
org.apache.taglibs.standard.tag.common.core.ForEac hSupport.toForEachIterator(ForEachSupport.java:255 )
org.apache.taglibs.standard.tag.common.core.ForEac hSupport.supportedTypeForEachIterator(ForEachSuppo rt.java:219)
org.apache.taglibs.standard.tag.common.core.ForEac hSupport.prepare(ForEachSupport.java:137)
javax.servlet.jsp.jstl.core.LoopTagSupport.doStart Tag(LoopTagSupport.java:227)
org.apache.jsp.WEB_002dINF.jsp.EditState_jsp._jspx _meth_c_005fforEach_005f0(EditState_jsp.java:287)
org.apache.jsp.WEB_002dINF.jsp.EditState_jsp._jspx _meth_form_005fselect_005f0(EditState_jsp.java:251 )
org.apache.jsp.WEB_002dINF.jsp.EditState_jsp._jspS ervice(EditState_jsp.java:159)
org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet .java:803)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:328)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:315)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet .java:803)
org.springframework.web.servlet.view.InternalResou rceView.renderMergedOutputModel(InternalResourceVi ew.java:142)
org.springframework.web.servlet.view.AbstractView. render(AbstractView.java:247)
org.springframework.web.servlet.DispatcherServlet. render(DispatcherServlet.java:1123)
org.springframework.web.servlet.DispatcherServlet. doDispatch(DispatcherServlet.java:860)
org.springframework.web.servlet.DispatcherServlet. doService(DispatcherServlet.java:774)
org.springframework.web.servlet.FrameworkServlet.p rocessRequest(FrameworkServlet.java:460)
org.springframework.web.servlet.FrameworkServlet.d oGet(FrameworkServlet.java:415)
javax.servlet.http.HttpServlet.service(HttpServlet .java:690)
javax.servlet.http.HttpServlet.service(HttpServlet .java:803)


This is my controller code

public class StateEditController extends SimpleFormController{
protected final Log logger = LogFactory.getLog(getClass());
private StateRegisterService stateRegisterService;
private EditStateModel editStateModel;
private List stateName;

protected void doSubmitAction(Object command) throws Exception {
logger.info("Inside doSubmit !!!!!!!");
State state = (State) command;
stateRegisterService.setState(state);

}
protected Object formBackingObject(HttpServletRequest request) throws Exception {

State state = new State();
if(request.getParameter("state_name_eng") != null) {
logger.info("State Name"+request.getParameter("state_name_eng"));
}
else {
logger.info("Inside Else !!!!!!");
//state.getState_name_eng();
state = editStateModel.editData();

}

request.setAttribute("state_name_eng", state);
return state;
}

public void setEditStateModel(EditStateModel editStateModel) {
this.editStateModel = editStateModel;
}
public void setStateRegisterService(StateRegisterService stateRegisterService) {
this.stateRegisterService = stateRegisterService;
}


I want to populate my drop down menu with data from db while page loading.

Any Suggestion please.

[ksriram]

How to bind model object in the jsp page ?