How to Get Data Into Comobox From Databse Using Hibernate in JSP Page?

Shashank Acharya

Greenhorn

Posts: 21

I like...

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Any One Solve this Problem.

This is what i do with my page of get value from database into combo box.

<%@page contentType="text/html" pageEncoding="UTF-8" import="java.util.*,org.hibernate.*,util.*,entity.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
    "http://www.w3.org/TR/html4/loose.dtd">

<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Online Attendance Main Page</title>
        <script src="ajax.js" type="text/javascript"></script>
    </head>
    <body>
        <%
            try {
                SessionFactory sf = HibernateUtil.getSessionFactory();
                Session s = sf.openSession();
                Transaction tx = s.beginTransaction();

Second se = new Second();

String hql = "select area from hibernatedb.second";
                Query q = s.createQuery(hql);
                ArrayList li = (ArrayList) q.list();
                Iterator ie = li.iterator();
        %>
        <center>
            Area:-
            <%
                while (ie.hasNext()) {
                    se = (Second) ie.next();
            %>
            <select>
                <option>
                    <%se.getArea();%>
                </option>
            </select>
            <%}
            } catch (HibernateException he) {
                he.printStackTrace();
            }%>
        </center>
    </body>
</html>

The result of this code is empty combo box.

Please help in this problem.
Thanks in advance.

Girish Wakure

Greenhorn

Posts: 28

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

change above code to

It will generate as many options as rows in the table

There’s no place like 127.0.0.1. But I'll always remember this tiny ad:

Clean our rivers and oceans from home

https://www.kickstarter.com/projects/paulwheaton/willow-feeders