Populating a DropDown Menu From a SQL Database Using Hibernate in Spring MVC

Question

I've done similar things to this before, but never using this particular configuration. Every example I look up shows the dropdown having the options set within the controller, when I don't want them set line by line in the controller, but pulled from a column in a SQL database.

I have other forms that currently pull from the same table and column, but with the drop down. I get nothing. Here is the JSP

This is what I have in the jsp, previously I used a c:forEach, and I suspect I might have to put that back in used in conjunction with with jsp use bean...

<table>
    <tr>
        <td>Job:</td>
        <td>    
            <form:select path="Job.jobName">
                <form:option value="" label="Select Job"/>
                <form:options value="" items="${job.jobName}"/>
            </form:select>
        </td>
        <td><form:errors path="job.jobName" /> </td>
    </tr>
</table>

This is the method call in the controller, there is more than this, but it's what I"m using..

List<Job> jobList = jobService.listjobsByPage(page);

and here is the query into the DAOImpl

public List<Job> getDataByJobName(String jobName) {            
     Session session = sessionFactory.openSession();
     List<Job> result = null;
     try{
            session.beginTransaction();
            Query query = session.createQuery("from Job where upper(jobName) like ? " +
                         "order by jobName");
            query.setParameter(0, "%" + jobName + "%");
            result = query.list();
            session.getTransaction().commit();
            session.close();
     } catch(Exception e){
            e.printStackTrace();
     }
     return result;
}

If anyone can even point me in the right direction on how to set this up that would be a great help.

Thanks in advance.

ekostadinov · Accepted Answer · 2015-01-22 06:12:02Z

2

You have to do first :

    ModelAndView model = new ModelAndView("index");
    model.addObject("lists", list);

than

    <form:select path="list">
        <form:options items="${lists}" />
    </form:select>

edited Jan 22, 2015 at 6:12

ekostadinov

6,9783 gold badges31 silver badges50 bronze badges

answered Jan 22, 2015 at 5:12

himanshu bisht

796 bronze badges

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

2 Comments

Jack Parker Over a year ago

OK, I did all this, and now I get a nullpointerexception. This is sort of where I was at before. It all comes back to that list method in the StackTrace.

himanshu bisht Over a year ago

Just check is your list is empty or not i am afraid you passing any empty list .But even you pass empty list , it should not give you nullpointer. Please attache your logs and latest code with controller

FAndrew · Accepted Answer · 2015-01-29 16:14:48Z

0

<form:options value="" items="${job.jobName}"/>

An other fail is the dropdown value will be always nothing because of value="".

answered Jan 29, 2015 at 16:14

FAndrew

2584 silver badges23 bronze badges

Collectives™ on Stack Overflow

Populating a DropDown Menu From a SQL Database Using Hibernate in Spring MVC

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related