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

Shashank Acharya

Greenhorn

Posts: 21

I like...

posted 7 years ago

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 7 years ago

change above code to

It will generate as many options as rows in the table

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

Similar Threads