Populate Dropdown list from Using Spring,Hibernate

Question

Experts,

Class EmployeeEntity
    {
        id
        Fname
        Salary
        Phone
    }

Controller.java

@RequestMapping(value = "/list")
public String listEmployee(ModelAndView map)
{

    map.addObject("employee", employeeManager.getEmp());

    return "emp";


}

EmployeeDAO.java

@Override
public List<EmployeeEntity> getEmp() {
    return this.sessionFactory.getCurrentSession().createQuery("select e.id, e.firstname from EmployeeEntity e").list();
}

emp.jsp

<form:form method="POST">

 <form:select path="Fname">
    <form:options items="${employee}" />
</form:select>

</form:form>

This are my files. I am not geting values in drropdown.Please help me How to find out problem. I need to populate list with Fname ,and Id as value in list

Error

java.lang.IllegalStateException: Neither BindingResult nor plain target object for bean name 'command' available as request attribute
    org.springframework.web.servlet.support.BindStatus.<init>(BindStatus.java:141)

Arpit Aggarwal · Accepted Answer · 2015-04-28 14:55:19Z

1

First thing you have to use map instead of list. You can have a refernce to below code:

@RequestMapping(value = "/list")
public Map listEmployee(ModelAndView map) throws Exception {
    Map referenceData = new HashMap();
    Map<String,String> country = new LinkedHashMap<String,String>();
    country.put("US", "United Stated");
    country.put("CHINA", "China");
    country.put("SG", "Singapore");
    country.put("MY", "Malaysia");
    referenceData.put("countryList", country);
}

And iterate over Map on JSP to construct dropdown as below:

<form:select path="country">
   <form:option value="NONE" label="--- Select ---"/>
   <form:options items="${countryList}" />
</form:select>

answered Apr 28, 2015 at 14:55

Arpit Aggarwal

29.5k16 gold badges97 silver badges110 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user3639244 Over a year ago

But I need to get values in map from database using hibernate. i dont know that, that is why i used list. i need only ID and Fname in map. But class contain other fields also. here i am stuckup, how to reterive id and fname in map from Database using hibernate

Arpit Aggarwal Over a year ago

Iterate over list recieved from DAO layer and prepare a map and send it to populate a dropdown on JSP.

Collectives™ on Stack Overflow

Populate Dropdown list from Using Spring,Hibernate

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related