how to use bean to retrieve data from database

View Answers

May 2, 2011 at 11:11 AM

1)EmpBean.java:

package form;
import java.sql.*;
import java.util.*;
public class EmpBean {

public List dataList(){
ArrayList list=new ArrayList();
try{
     Class.forName("com.mysql.jdbc.Driver");
           Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
           Statement st=con.createStatement();
           ResultSet rs=st.executeQuery("select * from employee");
           while(rs.next()){
               list.add(rs.getString("name"));
               list.add(rs.getString("address"));
               list.add(rs.getString("contactNo"));
               list.add(rs.getString("email"));

}
}
catch(Exception e){}
return list;

}
}

2)BeanInServlet.java:

import java.io.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class BeanInServlet extends HttpServlet{
    protected void doGet(HttpServletRequest req, HttpServletResponse res)
        throws ServletException, IOException{
        form.EmpBean p = new form.EmpBean();
        List list=p.dataList();

        req.setAttribute("data", list);
        RequestDispatcher rd = req.getRequestDispatcher("/jsp/beandata.jsp");
        rd.forward(req, res);
    }
}

3)beandata.jsp:

<%@page language="java" import="java.util.*" %>
<html>
<body> 
<table border="1" width="303">
<tr>
<td width="119"><b>Name</b></td>
<td width="168"><b>Address</b></td>
<td width="119"><b>Contact no</b></td>
<td width="168"><b>Email</b></td>
</tr>
<%Iterator itr;%>
<% List data= (List)request.getAttribute("data");
for (itr=data.iterator(); itr.hasNext(); ){
%>
<tr>
<td width="119"><%=itr.next()%></td>
<td width="168"><%=itr.next()%></td>
<td width="168"><%=itr.next()%></td>
<td width="168"><%=itr.next()%></td>
</tr>
<%}%>
</table>
</body>
</html>

April 13, 2012 at 7:12 PM

**I am pradeep kundu. I am making program in struts in which i want to insert, delete & search data. I can delete data but i am not getting any response**.

Advertisements

how to retrieve data from database ?????/
how to retrieve data from database ?????/ how to retrieve data from database

how to retrieve data from database
how to retrieve data from database unable to retrieve data from database using mySQL by using jsp sessions and beans for editing

How to Retrieve Data from the database and write into excel file using Java
How to Retrieve Data from the database and write into excel file using Java Hi, I am trying to develop an small application where i trying to retrieve Data from the database and store the details in excel file. Please can

retrieve data from database with hyperlink
retrieve data from database with hyperlink sir....i have one table called 'name' having two values i have to retrieve those data with a hyperlink and show in browser and if we click hyperlink its shows his sub categories....how

retrieve data from mysql database
retrieve data from mysql database hi am not familiar in php.....even... selected value on combobox which is to be retrieve the relevant data from mysql database using php.... below my code is that.. <html> <head>

Data retrieve from mysql database
Data retrieve from mysql database Hi sir, please give some example of jsp code for retrieving mysql database values in multiple dropdown list... from the dropdown, related data will get displayed on the textboxes. Here we have

how to retrieve data into combo from database in java applet?
how to retrieve data into combo from database in java applet? hi,. i have written applet codes for linking two frames and database connectivity but the problem is, the database is not retrieving data into the combo..please

Retrieve multiple data from database into Table.....
Retrieve multiple data from database into Table..... hi........... I want to Retrieve multiple data from database into Table but i am not able to.... i am only able to retrieve one value not more than that. means in my

retrieve data from database using jsf
retrieve data from database using jsf Hello I want an example of source code to retrieve data from database i have a database (oracle) name as db1...),, name ,and city I want after enter value in textbox according idauthor i retrieve

How to retrieve image from database
How to retrieve image from database hi........ How to retrieve image from database when it is stored. I have stored image in postgresql and want to retrieve in java form. Can u tel me hw to do? I am trying n able to do also

retrieve data from mysql database and store it in a variable ?
retrieve data from mysql database and store it in a variable ? sir... to store that data in int variable. how to do this ? Here is an example that retrieve the integer values from the database and stored in the integer

how to retrieve data from database using combobox value without using request.getParameter in jsp - JSP-Servlet
how to retrieve data from database using combobox value without using request.getParameter in jsp Answer pl

How to retrieve image from mysql database in JSP?
How to retrieve image from mysql database in JSP? Hi, I need JSP... to retrieve image from mysql database in JSP? Thanks Hi, You can write SQL query to find the data from database and get the image from resultset using

How to retrieve and display image from database in Java?
How to retrieve and display image from database in Java? Hi, I am writing a web application for reading the data from database and displaying.... Please check the it at How to store and retrieve image from database in JSP

Retrieve data from database in swing application
Retrieve data from database in swing application I want to retrive data(doctor name,specilization,date) from my sql database...(); ResultSet rs=st.executeQuery("select * from data where id=1"); while

How to store and retrieve image from database in JSP?
How to store and retrieve image from database in JSP? Hi, In one... and retrieve image from database in JSP? Thanks HI, You can use... the image. Check this example: Retrieve image from database using Servlet. Thanks

How to retrieve image from database in Servlet?
How to retrieve image from database in Servlet? Hi, How to retrieve image from database in Servlet? Thanks Hi, Please check the tutorial Retrieve image from database using Servlet. Thanks

Retrieve data from the database and write into ppt file
Java Retrieve data from the database & write into ppt file In this section, we are going to retrieve data from the database and write into the .ppt file... * from data"); String name = ""; String address = ""; while (rs.next

How to retrieve blob image from database in JSP?
How to retrieve blob image from database in JSP? Hello, JSP is used... the blog image from database. How to retrieve blob image from database in JSP? Hi, Please check the tutorial Retrieve image from database using

Retrieve Data from the database and write into excel file
Retrieve Data from the database and write into excel file. In this section, we are going to retrieve data from the database and write into the excel file... class create the cell in the excel sheet. With the use of setCellValue() method

How to Retrieve data from database in jsp
How to Retrieve data from database in jsp In this section we will discuss about how to fetch data from database table. We will give a simple example which... Here is the video tutorial of "How to retrieve data from database

retrieve the data to text fields from database on clicking the value of combo box
retrieve the data to text fields from database on clicking the value of combo box retrieve the data to text fields from database on clicking... getting data into textarea from database table by clicking on the button

How to Retrieve Data from Facebook Using PHP
How to Retrieve Data from Facebook Using PHP is this link has right content regards that?? http://techpdf.co.cc/blog/how-to-retrieve-data-from-facebook-using-php

how to retrieve images from database to jsp?
how to retrieve images from database to jsp? Hi sir,i want to stores images along with the name and price with database and retrieve it on jsp.and...=con.createStatement(); String strQuery = "select * from data"; ResultSet rs

how to store and retrieve image from database
how to store and retrieve image from database how to store and retrieve images into database(oracle) and how to retrive images from database using jsp Here is a jsp code that insert and retrieve image from mysql

retrieve related data from database using jsp and mysql
retrieve related data from database using jsp and mysql Hi sir, please give some example of jsp code for retrieving mysql database values in multiple dropdown list. if we change a value in a dropdown its related value must

Retrieve data from database by using sql tag of JSTL SQL library
we will see how retrieve data from database using sql query given by user... Retrieve data from database by using sql tag of JSTL SQL library... to create data source for specified driver, user name and password of database

How to retrieve data from database by using combo box value in jsp? - JSP-Servlet
How to retrieve data from database by using combo box value in jsp? Hello friend i want use only one jsp page.. but u give 2 pages... I want to work in one page... Pl response.. I do not need getParameter... Pl respose me

Retrieve The Data From MySql Datbase
Retrieve The Data From MySql Datbase How to Retrieve The Data From MYSQL database TO Use Select the Emp_id Option.And Also Search Option

how we retrieve image from database
how we retrieve image from database my code is:- $search=$_POST... from mysql database: <?php mysql_connect("localhost","username","password... not connect to Database"); $query = "SELECT content,size,type FROM upload WHERE id=1

how to insert, retrieve data from,to db(code)....
how to insert, retrieve data from,to db(code).... Hi..... i ve created login page n in that a registration form also.... my doubt is-when... that data will b stored in db(m using sybase). 2.also hw to retrieve the data from

how to insert, retrieve data from,to db(code)....
how to insert, retrieve data from,to db(code).... Hi, i have created... register his details,(for ex,username,password,dob,gender) 1.how that data will b stored in db(m using sybase). 2.also hw to retrieve the data from db. cn u

how to store and retrieve images int and from the database using php
how to store and retrieve images int and from the database using php please anyone can help me in storing the images and retrieve it back from the Mysql database using php

How to retrieve image from database using jsp and servlet?
How to retrieve image from database using jsp and servlet? Hi, I am trying to find code for displaying the image from database in a JSP page. How to retrieve image from database using jsp and servlet

how to retrieve data from table with runtime values in sql?
how to retrieve data from table with runtime values in sql? how to retrieve data from table with runtime values in sql? For example, I have table... to execute the command with the dates which I pass. I know how to retrieve a particular

JPA read data from database example
JPA read data from database example �... data from database using JPA. Create a "JPARead.java" file and follows the following steps to reading data from database. Again, you create

retrieve from database........
retrieve from database........ <p>hi i am not able to retrieve string from database to a text box in web page my code is as follows:-</p>...("username"); re=stmt.executeQuery("select * from userreg where username='"+username

Select data from Table in Database
the selected data from table in database. The select query in the database retrieve... The Tutorial illustrates an example, how to retrieve the data from table... Select data from Table in Database �

how to display data from database in jsp
how to display data from database in jsp how to display data from database in jsp

Retrieve date from MYSQL database
Retrieve date from MYSQL database In this tutorial, you will learn how to retrieve date from database. Storing and Retrieving dates from the database... to retrieve the date of birth of persons from the database table. For this, we have

Retrieve values from database using views
Retrieve values from database using views hi......... I have a huge... giving me error . So can u plz help??????? Can u tell me how to retrieve data... the columns which are required. As my front end is java swings i want to retrieve data

JPA read data from database example
JPA read data from database example In this section, you will learn how to retrieve data... the following steps to reading data from database. Create "JPARead" class

how to send and retrieve image along with text to and from database
how to send and retrieve image along with text to and from database im using app engine and i have two logics from different sources and i want to combine them. ive used the greeting example from app engine and i have a random

retrieve data from database in java swing form using prev n next buttons
retrieve data from database in java swing form using prev n next buttons i have a database having columns id(int),path(text),width(int),height(int... of various rows from database in labels by clicking previous and next

Ads