Display the Selected DropDown Value to another JSP Page

[Daryll sabate]

hi, im a newbie in JSP Programming,

i have a simple PRogram that can display/add/delete/edit the value from the database.. in my homePage.jsp i have one DropDown Menu this is filter the record.. my problem is in my AddRecord.jsp. because if a user select a value on the DropDown Menu ex. PAGE-1 and click ADD button, what i want to do is to display on the DROPDOWN is the SELECTED value of PAGE-1. but its not working instead when i SELECT PAGE-1 from the DropDown and Click ADD button, the value of dropdown in AddRecord that jsp will be back to empty which the user need to select the value again..

this for quick understanding..hope so...

ex. i have a car collection program. which is categorized according to brand name. and if i select the brand FERARI and i want to add new car in this category.. it will automatically display my selected FERARI then add the new can to it.....

hope it will help... sorry for my poor english..

thank you for some help..

[Bear Bibeault]

Place the selected attribute on the option element that you want to be selected in the drop down.

[Daryll sabate]

honestly i dont get it.. as i've said im just a pure newbie in jsp.. so its sounds like chinese to me..

here is my code..

Homepage.jsp

<script language="javascript" type="text/javascript">  
            var xmlHttp  
            var xmlHttp
            function showPageName(str){
                if (typeof XMLHttpRequest != "undefined"){
                    xmlHttp= new XMLHttpRequest();
                }
                else if (window.ActiveXObject){
                    xmlHttp= new ActiveXObject("Microsoft.XMLHTTP");
                }
                if (xmlHttp==null){
                    alert("Browser does not support XMLHTTP Request")
                    return;
                } 
                var url="homePageFilter.jsp";
                url +="?count=" +str;
                xmlHttp.onreadystatechange = stateChange;
                xmlHttp.open("GET", url, true);
                xmlHttp.send(null);
                return;
            }
      
            function stateChange(){   
                if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete"){   
                    document.getElementById("page").innerHTML=xmlHttp.responseText   
                }   
            }
             function AddReport(id){
                var f=document.form;
                f.method="get";
                f.action='InsertReport.jsp?id='+id;
                f.submit();
                
               
            }
             showPageName("");
        </script> 

 <FORM action="HomePage.jsp" method="get">

            <table align="center">
                <tr>

                    <th>Select Page</th><td><select  id="value" name='pageName' onchange="showPageName(this.value)">  
                            <option value="">-=View All=-</option>  
                            <%
                                
                                int sum= 0;
                                Class.forName("com.mysql.jdbc.Driver").newInstance();
                                Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/error_page", "root", "password");
                                Statement stmt = con.createStatement();
                                String query = "Select * from pagename";                              
                                ResultSet rs = stmt.executeQuery(query);

                                while (rs.next()) {
                            %>

                            <option value="<%=rs.getString(1)%>"><%=rs.getString(2)%></option>  
                            <%                              
                               }
                            %>
                        </select>
                    </td>
                
                    <TD align="center">
                        <input type="button" name="add" value="Add" onclick="AddReport()"> 
                    </TD>
              
                </tr>

            </table>


            <div id='page'>
              
            
            </div>
           
        </form>

on that.. when i select a value on the dropdown, and click ADD.. it will display the nextpage which is InsertReport.jsp

InsertReport.jps code:

 <script language="javascript" type="text/javascript">  
            var xmlHttp  
            var xmlHttp
            function showPageName(str){
                if (typeof XMLHttpRequest != "undefined"){
                    xmlHttp= new XMLHttpRequest();
                }
                else if (window.ActiveXObject){
                    xmlHttp= new ActiveXObject("Microsoft.XMLHTTP");
                }
                if (xmlHttp==null){
                    alert("Browser does not support XMLHTTP Request")
                    return;
                } 
                var url="PageName.jsp";
                url +="?count=" +str;
                xmlHttp.onreadystatechange = stateChange;
                xmlHttp.open("GET", url, true);
                xmlHttp.send(null);
            }

            function stateChange(){   
                if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete"){   
                    document.getElementById("state").innerHTML=xmlHttp.responseText   
                }   
            }
            function HomePage(id){
                var f=document.form;
                f.method="post";
                f.action='HomePage.jsp?id='+id;
                f.submit();
            }
        </script>  
    </head>  
    <body> 
        <br>
        <h1 align="center" style="color: #ff0000;">Add New Report</h1>
       
        <FORM action="InsertReport.jsp" method="get"  enctype="multipart/form-data">
            <table align="center" style="background-color: aqua;">

                <tr>

                    <th>Select Page</th><td><select name='pageName' onchange="showPageName(this.value)" >  
                            <option value="">-=View Page=-</option>  
                            <%
                                Class.forName("com.mysql.jdbc.Driver").newInstance();
                                Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/error_page", "root", "password");
                                Statement stmt = con.createStatement();
                                ResultSet rs = stmt.executeQuery("Select * from pagename");
                                while (rs.next()) {
                            %>
                            <option value="<%=rs.getString(1) %>"  selected><%=rs.getString(2) %></option>
                            <%
                                }
                            %>
                        </select></td> </tr>
                <tr id="state">
                    
                </tr>
                <tr>
                    <th>Error Page :</th><td><input type="text" name="PageError"></td>
                </tr>
                <tr>
                    <th>Image Report:</th><td><input type="file" name="Image_Report"></td>
                </tr>
                <TR>
                    <TH></TH>
                    <TD><INPUT TYPE="submit" VALUE="submit"></TD>
                </tr>
            </table> 

what i want is..when i select a value a value of dropdown in HomePAge.jsp and click ADD what i want to see in the next page is the SELECTED VALUE FROM HomePage.jsp is Display to InsertReport.jsp automatically..


hope you will understand.. thanks

[Bear Bibeault]

As a novice to JSP it's important that you learn JSP correctly and you're on a very bad track.

After the introduction of JSP2 in 2002 -- yes, 10 years ago - putting Java code, and especially database code, into a JSP is considered an unacceptable practice. It still exists for compatibility with legacy applications, but any JSP written after 2002 should be using the JSTL (JSP Standard Tag Library) and EL (Expression Language) in place of Java scriptlets.

I'd also recommend reading the following articles:

The Secret Life of JSPs

The Front Man

But what it comes down to is as easy as this: if you want a particular option in the drop down to be selected, you put the selected attribute on the option. For example:
<option value="whatever" selected>Whatever!</option>

Frequently the EL's ternary operator is useful for this. For example:

<option value="${someValue}" ${someValue == selectedValue ? 'selected' : ''}>${displayText}</option>