Dynamic Menu from database in jsp

<![CDATA[<%@page contentType="text/html" pageEncoding="UTF-8"%>]]>
<![CDATA[<%@page language="java" import="java.util.*" %>]]>
<![CDATA[<%@page language="java" import="java.sql.*" %>]]>


<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <link rel="stylesheet" type="text/css" href="skin.css">
        <title>JSP Page</title>
    </head>
    <body>
        <div>
            <%
                ArrayList list = new ArrayList();
                ArrayList sublist = new ArrayList();
                try {
                    Class.forName("oracle.jdbc.OracleDriver");  
                    Connection con = DriverManager.getConnection("jdbc:oracle:thin:@//localhost:1521/ORCL", "PORDFW", "PORDFW");
            %>
            <ul>
                <%
                    String query1 = "select * from tbl_category";
                    Statement st1 = con.createStatement();
                    ResultSet rs1 = st1.executeQuery(query1);
                    
                    while (rs1.next()) {
                        

                %>
                <li>
                    <a href="#">

                        <%= rs1.getString("category_name")%>
                    </a>
                    <ul>
                        <%
                            String query2 = "select subcategory_name from tbl_subcategory where category_id='" + rs1.getString("category_id") + "'";
                            Statement st2 = con.createStatement();
                            ResultSet rs2 = st1.executeQuery(query2);
                            while (rs2.next()) {
                        %>
                        <li>
                            <a href="#">
                                <%= rs2.getString("subcategory_name")%>
                            </a>
                        </li>
                        <%
                            }
                        %>
                    </ul>
                </li>
                <%
                    }
                %>
            </ul>
            <%
                } catch (Exception e1) {
                }
            %>
        </div>  
    </body>
</html>



</link>

my database has 2 tables:

1. tbl_category - > category_id, category_name
2. tbl_subcategory - > subcategory_id, category_id, subcategory_name

First table has 2 values as
Category_id Category_name
------------ --------------
1 Sports
2 Books

Second table values,
Subcategory_id Category_id Subcategory_name
-------------- ------------ -----------------
1 1 Cricket
2 1 Football
3 2 Science
4 2 Maths

My CSS :
ul {
font-family: Arial, Verdana;
font-size: 14px;
margin: 0;
padding: 0;
list-style: none;
}
ul li {
display: block;
position: relative;
float: left;
}
li ul {
display: none;
}
ul li a {
display: block;
text-decoration: none;
color: #ffffff;
border-top: 1px solid #ffffff;
padding: 5px 15px 5px 15px;
background: #2C5463;
margin-left: 1px;
white-space: nowrap;
}
ul li a:hover { background: #617F8A; }
li:hover ul {
display: block;
position: absolute;
}
li:hover li {
float: none;
font-size: 14px;
}
li:hover a { background: #617F8A; }
li:hover li a:hover { background: #95A9B1; }
ul li.next {
position: absolute;
display: block;
float: left;
background:#E8E8E8;
font-size: 14px;
border-top: 1px solid #ffffff;
padding: 5px 15px 5px 15px;
}
ul li a.first {
background: #617F8A;
}

When i run this jsp, i am getting the menu as:

Sports
> Cricket
> Footbal

I am not getting the second menu "Books" with its submenu....

Pls help me...

Thanks in advance..

Posted 5-May-13 20:06pm

mohaideen shalim

Comments

Sudhakar Shinde 6-May-13 3:15am

You can not ask a question as a solution. You need to use 'Improve Question' link to provide these details instead of putting those as a solution.

Solution 4

Replace this line:
ResultSet rs2 = st1.executeQuery(query2); 
with this line: 
ResultSet rs2 = st2.executeQuery(query2);

Posted 11-Feb-14 2:02am

Member 10588029

Updated 11-Feb-14 2:05am

v2

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Accepted Answer · 2013-04-27T20:10:00

It does not work like this here.

Here is what is expected of enquirers:
1. TRY first what you want to do! You may find that it's not that hard.
2. Formulate what was done by you that looks like an issue/not working.

Try them and tell if you face issues.
Members will be more than happy to help like this.

A similar question with few headsup to start: Dynamically populating menu items from the database in JSP or javascript[^]

Rezaul Hassan · Accepted Answer · 2013-04-29T08:00:00

Solution 2

Sometimes we need to generate menu form database according to our requirements. The following url

[^] will help you to generate menu dynamically in ASP.NET. You can apply your customize CSS as you like to give nice outlook of the menu.

Posted 29-Apr-13 8:00am

Rezaul Hassan

Dynamic Menu from database in jsp

4 solutions

Solution 1