Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa JSP-Servlet Select DropDown Default

Have Programming Question? Ask it here!
 
 
 


Daryll Sabate
Select DropDown Default
0 Answer(s)      2 years and a month ago
Posted in : JSP-Servlet


Hi there, i have a program in JSP where i have 2 tables tbl1 which contains the "page" and tbl2 which contains most of the record, in my jsp page i have a one dropdown menu where the user can choose, i.e if the user select PAGE 1 in the dropdown menu, it will display all the content of tbl2 that has the value of PAGE 1 from tbl1. and it is working properly.

the problem is if the user select "View ALL Pages" it will dislay nothing. what i want to do is if the user select the "View ALL Page" from the dropdown menu it will display all the records from my database.

here is my code: index.jsp

</head>  
<body> 
    <h1 style="color:red; text-align: center">Report Table</h1>
    <br>

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

        <table align="center">
            <tr>

                <th>Select Page</th><td><select name='pageName' onchange="showPageName(this.value)">  
                        <option value="">-=Show All=-</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)%>"><%=rs.getString(2)%></option>  
                        <%
                            }
                        %>
                    </select>

        </table>


        <div id='page'>


        </div>
    </form>

Advertisement
View Answers

Related Tutorials/Questions & Answers:
Select DropDown Default
Select DropDown Default  Hi there, i have a program in JSP where i..., i.e if the user select PAGE 1 in the dropdown menu, it will display all... i want to do is if the user select the "View ALL Page" from the dropdown menu
Multiple select dropdown with Ajax
Multiple select dropdown with Ajax This tutorial explains how to create multiple select  dropdown with Ajax  in JSP and Servlet . This example... output as: Again when select one or more category in dropdown
Advertisements
help to select a value from the dropdown list
help to select a value from the dropdown list  I have a html file...("$('#suggestions').hide();", 200); } $('#inputString').select(function() { alert('Handler for .select() called.'); }); function selectText(suggestions
dropdown
dropdown  how to hide textbox field when i deselect from select dropdown
How to select default FileFilter when creating a JFileChooser dialog?
How to select default FileFilter when creating a JFileChooser dialog? ... directory say "c:\mydirectory" when browse button is clicked. How to select default FileFilter when creating a JFileChooser dialog? Thanks   Hi
dropdown
dropdown  I have a dropdown having 2 options-"Open"& "closed".When i select "open" option the related rows of data are retrieved from database and same with the other option.My database is Mysql and coding in PHP
dropdown
dropdown  how to select an item from the dropdownlist when we load the page   Hi Friend, Try the following code: <html> <head>...; <select name="sel" id="sel" onchange="sel();" > <option value="C">
Ajax Dropdown
Ajax Dropdown  hi I have One Dropdown that contains 2 options assume A and B,if i select A option then samepage one more Dropdown is their it should display values in german language using DWRUtil Parameter values in ajax. Only
DropDown list
DropDown list  how to get mysql database values into dropdown usign... values into dropdown list. 1)country.jsp: <%@page import="java.sql.*"%>...; <select name='country' onchange="showState(this.value)"> <
DropDown Menu
is the problem.. for example; if i select page 1 in my dropdown menu, and click...DropDown Menu  Hello, i have a program that can view,add,delete... me draw to your my mind my program.. in my homepage which i have a dropdown
dropdown box
dropdown box  i need to have country,state and city in drop down box using ajax and use db2 database   Have a look at the following link: JSP dependent dropdown
ajax+dropdown+table format
ajax+dropdown+table format  HI, i am looking for an ajax application which must contain two dropdown list.In first dropdown if i select a manager name from the first dropdown all the reporties under the selected manager should
dropdown cacheing
dropdown cacheing   I need code to create cache for load drop down list from db in struts1 example
Dropdown menus onchange atribute
Dropdown menus onchange atribute  Can I know how do we get the drop down list from database? I want to select a type of vehicle from a drop down... from database and store it into dropdown list. On selecting the value from
Default Package
Default Package  Can we import default packages???   Yes, you can import the default packages. But there will be no error or exception, if you will not import default packages. Otherwise, importing packages is must
DropDown in ajax+jsp
DropDown in ajax+jsp  I have four dropdown if i select first dd...; <select name='country' onchange="showState(this.value)">... = con.createStatement(); ResultSet rs = stmt.executeQuery("Select * from country
dropdown list in jsf
dropdown list in jsf  I want to add a list box to display the country name from the lists on all countries.When I select for e.g India then in the second list box it will display the states related to India only and the flow
dropdown - JSP-Servlet
dropdown  i want to use dropdown select value in query-string in same page.. Using selected 'name' want to fetch details of that person from database...); } Select Employee Name: <--Select--> Angelina Martina Julia
jsp dropdown - JSP-Servlet
jsp dropdown  in my table there are 3 fields named orderid ,itemname, itemqty. i want code that fetch orderid in dropdown... on select dropdown get... } } Select
binding data with textbox on dropdown click
binding data with textbox on dropdown click  Hello friends,Divyesh here. i have jsp page and i would like to bind data with text box on dropdown click. in dropdown employee id are load.and when we select perticular id than how
jsp- database dependent dropdown list
jsp- database dependent dropdown list   i want 2 dropdown list 1- CLASS 2-SECTION both are should come from database. and if i select a class suppose class a the corresponding section dropdown list should retrieve the section
. Display JavaScript dropdown selected value
;/script> </head> <body> Select any one: <select id="dropdown" name...;/html> Description: Create dropdown list by using select and option tag. Now when.... Display JavaScript dropdown selected value  How to get the selected
about select tag
about select tag  Hi, i have a doubt regarding the usage of select tag,that is,suppose i am having two dropdown boxes,based on the selection of one dropdown item another dropdown item will be displayed without interacting
dropdown - JSP-Servlet
dropdown  i have below code for dropdown . now i want to user that textbox value in query at same page... how to get it in a new variable...; } <--Select--> Alto Nano Innova Esteem Centro Scorpio
Dependant Dropdown Lists
Dependant Dropdown Lists  Hello, I'm trying to create 2 dropdown lists. When the visitor chooses one option from the 1st list it will automatically update the 2nd dropdown. Ive already found some code which i edited but still
dropdown list in jsp
dropdown list in jsp  hai, i have static dropdown list.. i want to get the selected value in string variable without jsp regards asha
html dropdown not working firefox
html dropdown not working firefox  I am writing a Dropdown code in HTML which is not working in firefox. What could be the reason as it's perfectly working in IE and Crome. Thanks
creating dropdown lists in jsp
creating dropdown lists in jsp  i want to create two dropdown list which are dependent that is the first box choice have to evaluate the second boxs options
Retrieval of Dropdown list
Retrieval of Dropdown list  Hi frnds... Am having problem... ... for eg, let A1,A2,A3,A4 be the values in dropdown.. if i click A1... dropdown.. Am not able to retrive the name for further process... Pls check
populate dropdown box
populate dropdown box  hi, Is there any ways in which i can populate my dropdown menu with values from 1 to n (n = the value stored in database... item in dropdown menu is 10 then the second dropdown box should contain values
jsp dropdown refresh - JSP-Servlet
jsp dropdown refresh  Sir Thank u for your jsp code for dependent dropdown list, i used it in different table for data extraction but the probleam during data extraction when i select first drop down its refresh then 2nd
getting values from dropdown list
getting values from dropdown list  I am having a dropdown list which has hardcoded values ( we need it hardcoded only and will not be populated from the database) My question is when i select a particular value it should be pass
fetch values in dropdown
fetch values in dropdown  in my application i want fetch dropdown values in jsp page through servlet. means i have to fetch the database fields values in array variable of servlet and then i have to print those values in dropdown
dropdown - JSP-Servlet
dropdown  i want to use dropdown select value in query-string in same...,true) xmlHttp.send(null) } else{ alert("Please Select Employee Id...("address").focus(); alert("Please Select Employee Id
DropDown Department Login
DropDown Department Login  Hi all, I am doing a project using JSP... the departments. Now, my intention is to select the department from the drop... is having the departments in the same table. Bcoz as per the SQL Query select * from
parent and child dropdown
parent and child dropdown  Hi, I have one scenario in spring,i need to populate child drop down,based on parent dropdown using spring mvc and ajax... know how to use it in child drop down.How to set that child dropdown in success
struts dropdown list
struts dropdown list   In strtus how to set the dropdown list values from database ? I have a ArrayList object and set this object in dropdown jsp page using struts ? please send me jsp code... sample code: **Action
checkbox with dropdown listbox in jsp
checkbox with dropdown listbox in jsp  i loaded the the data into the drop down listbox in jsp from access database.now i have to add a check box,if it checked means dropdownlist box carryout the data's,else it should
java serializable default constructor
java serializable default constructor  java serializable default constructor
is set interface synchronize by default???????
is set interface synchronize by default???????  is set interface synchronize by default??????? an whether list is syncrhronized by default
html:select in struts - Struts
html select in struts  What is the HTML select in struts default value
inserting dropdown values into database table
inserting dropdown values into database table   hi i want to insert dropdown values into a database table by using jsp
Label n Dropdown Issue
Label n Dropdown Issue  Hi guys, Some how Iam able to receive the data for labels, dropdowns. I created one array with the size of label... with corresponding labels... the last dropdown is overriding the previous one... below
Dropdown and label issue
Dropdown and label issue  This is Venkat from Hyderabad,India.Working as a JavaDeveloper herein. Could you please read the code n give your valuable... to display the dropdowns with corresponding labels... the last dropdown
dropdown in struts - Struts
dropdown in struts  how to populate a drop down from database entries in struts application when i have the workflow as jsp->acton->Business Delegator->controller->Business object->DAO->database. Where should i
ipad default image names
ipad default image names  i have a problem while launching application in iPad. The Default image that i have set is not displaying in landscape mode correctly. please suggest. Thanks.   ipad Default image names
multiple dropdown issue
multiple dropdown issue  This is Venkat from Hyderabad,India.Working... was not able to display the dropdowns with corresponding labels... the last dropdown... variables, and submit, then the last variable and its corresponding dropdown
creating list in dropdown using struts - Struts
creating list in dropdown using struts   creating list in dropdown using struts : In action class list.add(new LabelValueBean("ID","Name")); In Jsp * Select Item Select In Form : getter
MySQL Default Port number
MySQL Default Port number  HI, What is MySQL Default Port number? Thanks   Hello, MySQL Server Default Port number is 3306. Thanks
jsp dropdown - JSP-Servlet
jsp dropdown  print dropdown selected value in same page without refreshing page in jsp....   Hi Friend, Try the following code: 1)selectbox.jsp: var xmlHttp function showState(str
 

 

 

DMCA.com