dynamic display
hi,i want to display dynamic values in drop drown box in a jsp page.these values are in the form of arraylist's object which came form another servlet or bussiness logic after being validated in rdbms.hope u will understand what i have mentioned.plz reply soon....
View Answers
July 5, 2010 at 11:51 AM
Hi Friend,
Try the following code:
1)DataServlet.java:
import java.io.*;
import java.util.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class DataServlet extends HttpServlet{
String page="/jsp/data.jsp";
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
PrintWriter out = response.getWriter();
String connectionURL = "jdbc:mysql://localhost:3306/test";;
Connection connection=null;
ResultSet rs;
response.setContentType("text/html");
List dataList=new ArrayList();
try {
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection(connectionURL, "root", "root");
String sql = "select name from data";
Statement s = connection.createStatement();
s.executeQuery (sql);
rs = s.getResultSet();
while (rs.next ()){
dataList.add(rs.getString("name"));
}
rs.close ();
s.close ();
}
catch(Exception e){
System.out.println("Exception is ;"+e);
}
request.setAttribute("data",dataList);
RequestDispatcher dispatcher = request.getRequestDispatcher(page);
if (dispatcher != null){
dispatcher.forward(request, response);
}
}
}
2)data.jsp:
<%@page language="java" import="java.util.*" %>
<html>
<head>
<title>Data Page</title>
</head>
<body>
<select>
<% List data= (List)request.getAttribute("data");
for(int i=0;i<data.size();i++)
{
%>
<option value="<%=data.get(i).toString()%>"><%=data.get(i).toString()%></option>
<%
}%>
</select>
</body>
</html>
Thanks
Try the following code:
1)DataServlet.java:
import java.io.*;
import java.util.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class DataServlet extends HttpServlet{
String page="/jsp/data.jsp";
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
PrintWriter out = response.getWriter();
String connectionURL = "jdbc:mysql://localhost:3306/test";;
Connection connection=null;
ResultSet rs;
response.setContentType("text/html");
List dataList=new ArrayList();
try {
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection(connectionURL, "root", "root");
String sql = "select name from data";
Statement s = connection.createStatement();
s.executeQuery (sql);
rs = s.getResultSet();
while (rs.next ()){
dataList.add(rs.getString("name"));
}
rs.close ();
s.close ();
}
catch(Exception e){
System.out.println("Exception is ;"+e);
}
request.setAttribute("data",dataList);
RequestDispatcher dispatcher = request.getRequestDispatcher(page);
if (dispatcher != null){
dispatcher.forward(request, response);
}
}
}
2)data.jsp:
<%@page language="java" import="java.util.*" %>
<html>
<head>
<title>Data Page</title>
</head>
<body>
<select>
<% List data= (List)request.getAttribute("data");
for(int i=0;i<data.size();i++)
{
%>
<option value="<%=data.get(i).toString()%>"><%=data.get(i).toString()%></option>
<%
}%>
</select>
</body>
</html>
Thanks
Related Tutorials/Questions & Answers:
dynamic display - JSP-Servlet
dynamic display hi, i want to display dynamic values in drop drown box in a jsp page.these values are in the form of arraylist's object which came form another servlet or bussiness logic after being validated
dynamic display hi, i want to display dynamic values in drop drown box in a jsp page.these values are in the form of arraylist's object which came form another servlet or bussiness logic after being validated
Dynamic retrieval od data from database and display it in the table at jsp
Dynamic retrieval od data from database and display it in the table at jsp Hi friends.... Am creating software for chit fund.. I want to display...; Here is a jsp code that retrieves the data from the database and display
Dynamic retrieval od data from database and display it in the table at jsp Hi friends.... Am creating software for chit fund.. I want to display...; Here is a jsp code that retrieves the data from the database and display
Advertisements
display
display please tell me how to display the content from database.. if we click on any image using servlets/jsp...please
display please tell me how to display the content from database.. if we click on any image using servlets/jsp...please
dynamic image change javascript
dynamic image change javascript How to display images in JavaScript dynamically
dynamic image change javascript How to display images in JavaScript dynamically
dynamic polymorphism
dynamic polymorphism give an example for dynamic polymorphism? Dynamic polymorphism is where a class overrides a superclass method... seen at runtime, so they are considered dynamic. Here is an example
dynamic polymorphism give an example for dynamic polymorphism? Dynamic polymorphism is where a class overrides a superclass method... seen at runtime, so they are considered dynamic. Here is an example
dynamic polymorphism
dynamic polymorphism Develop with suitable hierarchy, classes for Point, Shape, Rectangle, Square, Circle, Ellipse, Triangle, Polygon, etc. Design a simple test application to demonstrate dynamic polymorphism
dynamic polymorphism Develop with suitable hierarchy, classes for Point, Shape, Rectangle, Square, Circle, Ellipse, Triangle, Polygon, etc. Design a simple test application to demonstrate dynamic polymorphism
Dynamic keyword
Dynamic keyword hi....... What is the dynamic keyword used for in flex? give me the answer ASAP Thanks Ans: Dynamic keyword-> Specifies that instances of a class may possess dynamic properties added
Dynamic keyword hi....... What is the dynamic keyword used for in flex? give me the answer ASAP Thanks Ans: Dynamic keyword-> Specifies that instances of a class may possess dynamic properties added
create dynamic array in javascript
create dynamic array in javascript How to create dynamic array in javascript
create dynamic array in javascript How to create dynamic array in javascript
dynamic content on the inbox page - Java Beginners
dynamic content on the inbox page sample java code to display the dynamic content on the inbox page. Hi friend, Plz give details with source code where you having the problem : Thanks
dynamic content on the inbox page sample java code to display the dynamic content on the inbox page. Hi friend, Plz give details with source code where you having the problem : Thanks
dynamic textfields
dynamic textfields Hi, I am a fresher and joined recently in one company. they gave me a desktop application project using swings.here is my detailed spec Screen 1 - The user enters the ingredients from a food product, saves
dynamic textfields Hi, I am a fresher and joined recently in one company. they gave me a desktop application project using swings.here is my detailed spec Screen 1 - The user enters the ingredients from a food product, saves
Dynamic form
Dynamic form I need to make a dynamic form using jsp for example, i will need a list of items which when we select one option another list is modified ( like 2 lists of countries and citys ), and also a radio button wich once
Dynamic form I need to make a dynamic form using jsp for example, i will need a list of items which when we select one option another list is modified ( like 2 lists of countries and citys ), and also a radio button wich once
dynamic form
dynamic form I need to make a dynamic form using php, for example, i will need a list of items which when we select one option another list is modified ( like 2 lists of countries and citys from a dtabase ), and also a radio
dynamic form I need to make a dynamic form using php, for example, i will need a list of items which when we select one option another list is modified ( like 2 lists of countries and citys from a dtabase ), and also a radio
dynamic calender
dynamic calender hi i need the code to "insert date using GUI" Hi Friend, Try the following code:ADS_TO_REPLACE_1 import java.awt.*; import java.awt.event.*; import javax.swing.*; class DatePicker{ int month
dynamic calender hi i need the code to "insert date using GUI" Hi Friend, Try the following code:ADS_TO_REPLACE_1 import java.awt.*; import java.awt.event.*; import javax.swing.*; class DatePicker{ int month
dynamic query
dynamic query DECLARE QUERY VARCHAR2(32767); FIN_QUERY VARCHAR2(32767); CURSOR C IS (select distinct PORTFOLIO from MPE_TEST1); CURSOR C2 IS SELECT DISTINCT PORTFOLIO_LEVEL, PORTFOLIO FROM MPE_TEST1 ORDER
dynamic query DECLARE QUERY VARCHAR2(32767); FIN_QUERY VARCHAR2(32767); CURSOR C IS (select distinct PORTFOLIO from MPE_TEST1); CURSOR C2 IS SELECT DISTINCT PORTFOLIO_LEVEL, PORTFOLIO FROM MPE_TEST1 ORDER
how to add dynamic data
how to add dynamic data how to add dynamic data to an existing web application
how to add dynamic data how to add dynamic data to an existing web application
static page and dynamic pages?
static page and dynamic pages? what is the static page and dynamic pages
static page and dynamic pages? what is the static page and dynamic pages
static page and dynamic pages?
static page and dynamic pages? what is the diff between static page and dynamic pages
static page and dynamic pages? what is the diff between static page and dynamic pages
static page and dynamic pages?
static page and dynamic pages? what is the static page and dynamic pages adv and disadv
static page and dynamic pages? what is the static page and dynamic pages adv and disadv
dynamic pagination in jsp - JSP-Servlet
dynamic pagination in jsp i am unable to display the data in multiple pages. I am gettting data from the database from the javaBeans to jsp by vectors... but i am unable to displaying them in jsp 15 records per page
dynamic pagination in jsp i am unable to display the data in multiple pages. I am gettting data from the database from the javaBeans to jsp by vectors... but i am unable to displaying them in jsp 15 records per page
ModuleNotFoundError: No module named 'dynamic'
ModuleNotFoundError: No module named 'dynamic' Hi, My Python... 'dynamic' How to remove the ModuleNotFoundError: No module named 'dynamic... to install padas library. You can install dynamic python with following command
ModuleNotFoundError: No module named 'dynamic' Hi, My Python... 'dynamic' How to remove the ModuleNotFoundError: No module named 'dynamic... to install padas library. You can install dynamic python with following command
ModuleNotFoundError: No module named 'dynamic'
ModuleNotFoundError: No module named 'dynamic' Hi, My Python... 'dynamic' How to remove the ModuleNotFoundError: No module named 'dynamic... to install padas library. You can install dynamic python with following command
ModuleNotFoundError: No module named 'dynamic' Hi, My Python... 'dynamic' How to remove the ModuleNotFoundError: No module named 'dynamic... to install padas library. You can install dynamic python with following command
Dynamic Array iPhone
Dynamic Array iPhone Dynamic Array iPhone How can i add NSMutable array dynamically into my iPhone App
Dynamic Array iPhone Dynamic Array iPhone How can i add NSMutable array dynamically into my iPhone App
Display Problem
Display Problem i am creating a small window application , i want to fetch data from ms-access(db) and want to display it on tables. what options are there to show result on table. is CSS helpfull
Display Problem i am creating a small window application , i want to fetch data from ms-access(db) and want to display it on tables. what options are there to show result on table. is CSS helpfull
how to display?
how to display? How to write a select query for displaying data where i have author as multivalued attribute
how to display? How to write a select query for displaying data where i have author as multivalued attribute
how to display?
how to display? How to write a select query for displaying data where i have author as multivalued attribute
how to display? How to write a select query for displaying data where i have author as multivalued attribute
how to display?
how to display? How to write a select query for displaying data where i have author as multivalued attribute
how to display? How to write a select query for displaying data where i have author as multivalued attribute
Display data
Display data after successful login how i can fetch my account information from sql database
Display data after successful login how i can fetch my account information from sql database
Dynamic polymorphism - Java Beginners
Dynamic polymorphism Develop with suitable hierarchy, classes for point, shape, rectangele, square, circle,ellipse, triangle, polygon, etc. Design a simple test application to demonstrate dynamic polymorphism.. Thanks
Dynamic polymorphism Develop with suitable hierarchy, classes for point, shape, rectangele, square, circle,ellipse, triangle, polygon, etc. Design a simple test application to demonstrate dynamic polymorphism.. Thanks
Dynamic Polymorphism - Java Beginners
Dynamic Polymorphism Develop with suitable hierarchy, classes for Point, Shape, Rectangle, Square, Circle, Ellipse, Triangle, Polygon, etc. Design a simple test application to demonstrate dynamic polymorphism.? Thanks
Dynamic Polymorphism Develop with suitable hierarchy, classes for Point, Shape, Rectangle, Square, Circle, Ellipse, Triangle, Polygon, etc. Design a simple test application to demonstrate dynamic polymorphism.? Thanks
Display Tag
Display Tag Hi Here is My code, There is problem At line no.3, where i want to display two fields in one column but it gives error.. Please any one knows the solution must reply Thanks In Advance
Display Tag Hi Here is My code, There is problem At line no.3, where i want to display two fields in one column but it gives error.. Please any one knows the solution must reply Thanks In Advance
Display Information
Display Information I have a listbox having many names and I have a button "display". I select some names and when I click the button , the names along with the address(they are in database) should be displayed. I am using php
Display Information I have a listbox having many names and I have a button "display". I select some names and when I click the button , the names along with the address(they are in database) should be displayed. I am using php
image display
image display sir the answer which you have sent to me is already I have I want to know that the syntax which you have writen for display... to display in image from databse plz help me i will wait for ur reply
image display sir the answer which you have sent to me is already I have I want to know that the syntax which you have writen for display... to display in image from databse plz help me i will wait for ur reply
Display Tag
Display Tag Hi Here is My code, There is problem At line no.3, where i want to display two fields in one column but it gives error.. Please any one knows the solution must reply Thanks In Advance
Display Tag Hi Here is My code, There is problem At line no.3, where i want to display two fields in one column but it gives error.. Please any one knows the solution must reply Thanks In Advance
display result
display result i want a code that takes input from user through dropdown box and display the result into table.all the values regarding the user input must be displayed. i am using mysql database hi i want study
display result i want a code that takes input from user through dropdown box and display the result into table.all the values regarding the user input must be displayed. i am using mysql database hi i want study
Retina Display
Retina Display is it possible to test Retina Display on simulator? Yes, run the application from Xcode, when the simulator opens go to Hardware->Device->iPhone 4 That will now have a 2x screen resolution
Retina Display is it possible to test Retina Display on simulator? Yes, run the application from Xcode, when the simulator opens go to Hardware->Device->iPhone 4 That will now have a 2x screen resolution
profile display
profile display Search page to display matching results in JSP and Servlet Please visit the following links: http://www.roseindia.net/servlets/search.shtml http://www.roseindia.net/jsp/user-search.shtml
profile display Search page to display matching results in JSP and Servlet Please visit the following links: http://www.roseindia.net/servlets/search.shtml http://www.roseindia.net/jsp/user-search.shtml
display shapes
display shapes Hi, I would like to see geometric shapes like square, triangle, circle, rectangle as my outputs. Also, those figures shouldn't overlap while they get displayed. Please help me
display shapes Hi, I would like to see geometric shapes like square, triangle, circle, rectangle as my outputs. Also, those figures shouldn't overlap while they get displayed. Please help me
image display
image display sir the answer which you have sent to me is already I have I want to know that the syntax which you have writen for display... to display in "div image from databse /div" plz help me i will wait for ur reply
image display sir the answer which you have sent to me is already I have I want to know that the syntax which you have writen for display... to display in "div image from databse /div" plz help me i will wait for ur reply
Display Configurations
Display Configurations The year is 2136. A lot of things have changed but BITS Pilani still exists. The display technology used now is a WASDLED screen. This display technology consists of a configuration matrix containing
Display Configurations The year is 2136. A lot of things have changed but BITS Pilani still exists. The display technology used now is a WASDLED screen. This display technology consists of a configuration matrix containing
Dynamic html examples
Dynamic html examples Hi, What is Dynamic HTML? Explain with dynamic html examples. Thanks (adsbygoogle = window.adsbygoogle || []).push({}); Hi, DHTML stands for Dynamic HTML and is uses the HTML
Dynamic html examples Hi, What is Dynamic HTML? Explain with dynamic html examples. Thanks (adsbygoogle = window.adsbygoogle || []).push({}); Hi, DHTML stands for Dynamic HTML and is uses the HTML
profile display
profile display how to display matching Results using jsp-servlet? Please visit the following links: http://www.roseindia.net/servlets/search.shtml http://www.roseindia.net/jsp/user-search.shtml http
profile display how to display matching Results using jsp-servlet? Please visit the following links: http://www.roseindia.net/servlets/search.shtml http://www.roseindia.net/jsp/user-search.shtml http
profile display
profile display how to display matching jobs in jobseeker's profile using jsp-servlets? Please visit the following links: http://www.roseindia.net/servlets/search.shtml http://www.roseindia.net/jsp/user
profile display how to display matching jobs in jobseeker's profile using jsp-servlets? Please visit the following links: http://www.roseindia.net/servlets/search.shtml http://www.roseindia.net/jsp/user
Ads