Select DropDown Default
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>
View Answers
Ads
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
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
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
dropdown
dropdown how to hide textbox field when i deselect from
select dropdown
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
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
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 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
change navbar dropdown color in bootstrap
-
default .navbar-nav .open .
dropdown-menu>li>a,.navbar-
default .navbar-nav...change navbar
dropdown color in bootstrap How to change the color of navbar
dropdown color in a bootstrap based menu in a website?
Thanks
 
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
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 cacheing
dropdown cacheing I need code to create cache for load drop down list from db in struts1 example
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
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 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
. 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
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 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
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
select option value
select option value if i
select a value of any drop down then that value should be used in a
select query of the next
dropdown in jsp????
Here is an example of dependent
dropdown box in JSP. The values come from
select option value
select option value if i
select a value of any drop down then that value should be used in a
select query of the next
dropdown in jsp on same page????
Here is an example of dependent
dropdown box in JSP. The values
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
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