how to write a program to search a record using mvc2

how can we write a code to search a record in table by using java bean as model, servlet as contoller and jsp as view

View Answers

July 12, 2011 at 10:57 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>

Advertisements

Write a program to print using for loop
Write a program to print using for loop Write a program to print using for loop * * * *

How to write Java Program
How to write Java Program how to write a program to find average of 5 student marks

how to write this program
how to write this program Write a program in java which calculates... or numerical grade. You will be submitting TWO versions of this program. Write one...?�s GPA. This program should take a studentâ�?��?�s First Name, Last Name a GPA

how to record qvga video using j2me - Applet
how to record qvga video using j2me hello if it is possible how i can record qvga video usin j2me

How to write calculator in J2ME program?
How to write calculator in J2ME program? How to write calculator in J2ME program

how to write servlet program in eclipse?
how to write servlet program in eclipse? how to write servlet program in eclipse

how to fetch the record using AJAX? - Ajax
how to fetch the record using AJAX? Can anyone tell me how to fetch the records from database using Ajax

How to write to file using FileOutputStream
How to write to file using FileOutputStream Hi friends, Please help me in java program. How to write to file using FileOutputStream? thanks, Hi, To write a file using FileOutputStream, we have to use

how to record qvga video using j2me - Applet
how to record qvga video using j2me hello if it is possible how i can record qvga video usin j2me? Hi Friend, Please visit the following links: http://www.roseindia.net/j2me/video-midlet.shtml http

how to write this program? - Java Beginners
how to write this program? (game:scissor,rock ,paper) A program that plays the sciccor-rock-paper game.Revise the program to let the user continuously play until either the user or the computer wins more than 4 times

write program have product - using loops
write program have product - using loops Write a program for a grocery that reads products data and determine and display the product that has...), name (String) and price (double). Your program should continue reading new

how to write the program - Java Beginners
how to write the program WAP to create the report card user input Name, Class, Division, Roll no., Marks obtained in following subjects Lang Hindi History Geography Math Phy Chem. Bio Eve CSTA Also has a back up

How to write to file using FileWriter
How to write to file using FileWriter hi, How to write to file using FileWriter thanks, Hi, To writing in a file in Java program we... of the FileWriter class can be created using the following of its constructor i.e. FileWriter

write a program to remove the element from hashset using keyboard.
write a program to remove the element from hashset using keyboard. write a program to remove the element from hashset using keyboard

Write a java program to display the season given the month using switch case
Write a java program to display the season given the month using switch case Write a java program to display the season given the month using switch case

Write a query to insert a record into a table
Write a query to insert a record into a table Write a query to insert a record into a table Hi, The query string is as follows-ADS_TO_REPLACE_1 Insert into employee values ('35','gyan','singh'); Thanks

write a program in java to read a text file and write the output to an excel file using filereader and filewriter?
write a program in java to read a text file and write the output to an excel file using filereader and filewriter? write a program in java to read a text file and write the output to an excel file using filereader and filewriter

how do i write a java program for this??
how do i write a java program for this?? �??Ask the user if they have a dog. If �??yes�??, ask the user how old is and compute the dog�??s age... in your program

how to read and write an xml file using java
how to read and write an xml file using java Hi Can anyone help me how to read and write an xml file which has CData using java

How to write a program count total prices
How to write a program count total prices Hi. all I've got a assignment to write a program that count total prices of 8 costumers. class PriceCalculator{ public void method(double quantity) { double result

write a program
write a program write a program add 2 no.s without use arithmetic,unary operaters in java

How to write a program count total prices
How to write a program count total prices Hi. all I've got a assignment to write a program that count total prices of 8 costumers. First class class PriceCalculator {print("code sample"); public void method(double quantity

How to perform search using AJAX?
How to perform search using AJAX? Hi, I have following HTML code...; <td><label for="status">Search Status</td> <td><input..." value="Please enter search criteria"/></td> </tr> <tr>

How i upload file and save that record in database using JSP?
How i upload file and save that record in database using JSP? Hi All, I m the beginner in JSP and I want to upload the file and store that file and some other form data in MySQL database. Ex. There is one employee detail form

how to write a jsp form using html
how to write a jsp form using html hi, i have written the code as below... but it is showing error. please help me how to resolve it. .html file <html> <head><title>StudentForm</title></head>

How to write a rsa algorithm using thread
How to write a rsa algorithm using thread Hi... This my **rsa algorithm sequential code..can u anyone plz change/convert to concurrent java or parallel this code.. print("code sample"); import

Record and Save Video using Java
Record and Save Video using Java How to record video(webcam) and save it using Java.?? Its really urgent

binary search program
binary search program write a program to searching a string using binary search

how to search data in xml files using php
how to search data in xml files using php So I want to create a website that allows me (or others) to type in a words and select a relevent search... this and how can I use PHP to allow them to search through, and then display

How to Write a Calculator Program in Java?
How to Write a Calculator Program in Java? In this Java Tutorial you will learn how to write a Calculator program in Java in easy steps. Calculator program..., subtraction, multiplication or division. In this example of writing program in Java

Write a query to delete a record from a table
Write a query to delete a record from a table Write a query to delete a record from a table Hi, The query string for the delete operation is as follows-ADS_TO_REPLACE_1 delete from employee where id='35'; Thanks

How to using Binary Search Array Java ?
How to using Binary Search Array Java ? Hi, I am beginners in Java Programming Language. I am trying to create small application using Array functions. The problem is that how to use binary search array in Java. Please give

How to Display next Record from Database "On the Click of Next Button" USING ARRAYLIST
How to Display next Record from Database "On the Click of Next Button" USING ARRAYLIST How to Display next Record from Database "On the Click of Next Button" USING ARRAYLIST,please send answer as soo as possible

How to write program to show status of seats(i.e.free or reserve) in java?
How to write program to show status of seats(i.e.free or reserve) in java? I have retrieved data from database table and I want to display status of seats i.e.free or reserved

how to write weighted moving average code using 2d-array
how to write weighted moving average code using 2d-array how to write weighted moving average code using 2d-array

how to use Excel Templet to write excel file using java.
how to use Excel Templet to write excel file using java. how to use Excel Templet to write excel file using java

how to use Excel Template to write excel file using java
how to use Excel Template to write excel file using java How to use Excel template to write data in that file using java

how can i write this program ?please suggest me
how can i write this program ?please suggest me Program to calculate the sum of two big numbers (the numbers can contain more than 1000 digits). Don't use any library classes or methods (BigInteger etc

how to write to java program to get the particular data from the website
how to write to java program to get the particular data from the website i have to get the particular data by selecting the just numbers.. from the site .. how to get the ful details from the website by clicking the number

search program
search program i m writing program which takes company names from.......m confused....how can i find best match..between my company name ..and all links after google search...plzz help

how to write a program in java to print numbers in equalateral triangle
how to write a program in java to print numbers in equalateral triangle the output must be 1 324 76589 Here is an example of pattern 1 2 3 4 5 6 7 8 9 Example: public class NumberTriangle{ public

Write a program using JSP that enables any student to change his/her address.
Write a program using JSP that enables any student to change his/her address. Write a program using JSP that enables any student to change his/her address

How do I write a program to manage an employee's business and personal contacts?
How do I write a program to manage an employee's business and personal contacts? A. Input Requirements 1. Include a prompt that allows the user..., System.out, output to a text file using FileWriter). a. Identify contacts by type

How to write hello world example program in Hibernate?
How to write hello world example program in Hibernate? Hello World tutorial.... Example Program: In the below example, we are inserting a record and after... is used to instantiate Hibernate SessionFactory in the program. Using this class

Ads