jsp using Beans

public class Empbean
{
   int empno;
   String ename;
   float sal;
   public Empbean()
    {
    }
    //set of set methods
    //set get methods
    public void getDbConnection() //readable method
    {
        //i get the oracle connection here
        PreparedStatement pst=con.prepareStatement("insert into emp values(?,?,?)")
    }
    public void getDbValues()//readable method
    {
        // set the values for positional params
    }
}

i need jsp program for above bean class

View Answers

January 11, 2011 at 6:07 PM

Hi Friend,

Try the following code:

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>

Thanks

Advertisements

Using Beans in JSP. A brief introduction to JSP and Java Beans.
USING BEANS IN JSP �... with Beans. <jsp:useBean..., it is very easy to connect to databases using beans rather than writing

Error in using java beans - JSP-Servlet
Error in using java beans I am getting the following error when I run the jsp code. type Exception report message description The server...: Unable to load class for JSP

How to display data in jsp from dao using java beans?
How to display data in jsp from dao using java beans? Hi I need to display data in jsp pulling from dao using java beans, Please can anyone give me the sample application with above topics. Any help would be highly appreciated

how to generate PDF file using JSP with net beans
how to generate PDF file using JSP with net beans I am trying to generate PDF file using JSP. I even added itext5.0.6 jar file in library. It shows...\apache\jsp\hh_jsp.java:8: package com.lowagie.text does not exist import

java beans code in jsp - WebSevices
java beans code in jsp can you tell me how to use java beans in jsp... summary page and funds transfer page using java beans. Hi Friend...://www.roseindia.net/jsp/user-registration-form-using-jsp.shtml Hope that it will be helpful

jsp,beans,jdbc - JSP-Servlet
jsp,beans,jdbc I have created jsp page and corresponding servlet... database for specific date .this data is retrived on jsp page by beans.i use beans... in jsp how to show field sum on jsp page plz guide Hi friend

java beans - JSP-Servlet
the problem visit to : http://www.roseindia.net/jsp/usingbeansinjsp.shtml Thanks

calling java beans - JSP-Servlet
calling java beans Sir, I want to know where to place the java beans java file and class file inside tomcat web server. and how to call them from jsp file. Hi Friend, Java Bean is placed in classes\form

How to use Java Beans in JSP?
How to use Java Beans in JSP? Hi, I have developed a employee bean...; ..... } Please tell me how I can use Employee Java bean in JSP page? Thanks Hi, Read at Java Bean in JSP. Thanks hi dude your qus

jsp directory created in net beans but not able to access
jsp directory created in net beans but not able to access File f...("/") + "artists/" +username + "/images"); images.mkdir(); i am using this code... trying to display image i am not able to display i am using netbeans and using

Is JSF using JSP?
Is JSF using JSP? Is JSF using JSP

sample application using hibernate and wicket framework in net beans IDE
sample application using hibernate and wicket framework in net beans IDE where can i get sample applications/ projects using hibernate and wicket framework in net beans IDE

how to run audio files in net beans using j2me
how to run audio files in net beans using j2me i am running the audioMidlet in net beans. Now where should i place the .wav files inorder to play them

tree using jsp code
tree using jsp code i want to draw a tree structure of a family hierarchy using jsp code

java Using net beans - Java Beginners
java Using net beans Dear Sir, I just like to ask why i cant add a data to the answer you have given me last time where i have to pick the data of the student like id , name , class , age & address using netbeans jframe then i

report generation using jsp
report generation using jsp report generation coding using jsp

A Java Program by using JSP
A Java Program by using JSP how to draw lines by using JSP plz show me the solution by using program

generate charts using JSP
generate charts using JSP any one know coding for generate bar chart or pie chart using JSP

ScatterPlot using jsp
ScatterPlot using jsp hi, can anybody provide me code for ScatterPlot using jsp. thanks

datasource in jsp using struts
datasource in jsp using struts how to get the datasource object in jsp.datasource is configured in struts-config.xml

BMI by using JSP Languange
BMI by using JSP Languange Using JSP language, create a system that calculates Body Mass Index (BMI) of users who entered their weight and height. Then, system will display all the records. Can you provide me the coding

video uploading using jsp
video uploading using jsp how to upload a videos in web page using jsp Hi, You can upload your video with the help of JSP file upload code. Once file is upload you can play using any video player. Get the code

Using Scriplet in JSP - JSP-Servlet
on } IN HOME JSP ****** home.jsp **** Currently I am directly using...Using Scriplet in JSP Hi, I need to display suitable fields in my jsp but this should be done upon suitable condition becomes true for eg

using jsp's....and ajax - Ajax
using jsp's....and ajax Hi, i need code using ajax .....in a text box when i enter an alphabet i should get list of words starts with the alphabet given in the text box

generate pdf using jsp
generate pdf using jsp how do i generate a pdf using jsp that should query the data from the database and write it into a pdf and download the same

jsp using netbeans
jsp using netbeans Code to access and manage multiple e-mail accounts on the same page.. user should be able to edit mail accounts' link as required

barcode reader using jsp
barcode reader using jsp HI ALL, I need jsp code for barcode reader.When we scan the barcode image that barcode value will be stored in one textbox automatically. please helpe me. Regards Bhanu

Tiemsheet using jsp
Tiemsheet using jsp Hi, I am working on creating timesheet using JSP. Can you please help me on how to create a timesheet in excel using jsp and users should fill the excel sheet and then on submitting it should uplaod excel

Jsp using mvc - JSP-Servlet
Jsp using mvc hi I have written using mvc2 architecture, i have written logic in java ,i want to print a message on the form stating the the values are inserted successfully.So can you tell me how i have to write the code

sending mail using jsp
sending mail using jsp please give me the detailed procedure and code for sending mail through jsp program Please visit the following links: http://www.roseindia.net/ejb/introduction/j2eedemo.shtml http

Concept of subqueires using JSP
Concept of subqueires using JSP Can I implement the concept of sub queries in JSP page , if yes please tell me how this can be achieved. I have requirement where output of the SQL query should be given as input to the update

display image using jsp
display image using jsp display image using jsp and phonegap on emulator of eclipse Here is a simple jsp code that displays an image on browser. <%@ page import="java.io.*" %> <%@page contentType="image/gif

Implementing Bean with scriptlet in JSP
pageADS_TO_REPLACE_1 We can use all of the JSP coding while using Java Beans... in a JSP page using Java Beans. In our example we have made a bean file which...; And by using scrpitlet in JSP we are calling insert method when

emailing using jsp
emailing using jsp hi there!! i have some difficulty in sending email using jsp. basically, i have an account table that retrieve all the account from the account-table in my ms sql database. so whenever i deleted the account

jsp using include & with mysql
jsp using include & with mysql Sir, I am creating a login application using jsp & Mysql. The Codes are--- Html File...... <...; Jsp file....... <%@ page import="java.sql.*" %> <% String

Uploading image using jsp
Uploading image using jsp how to upload image using jsp. Already i... that image file ... I want know that solution using by u... Thanks, P.S.N. Here is a jsp code that upload image and display it on the browser. 1

JSP using java - Hibernate
JSP using java This is my part of Excal sheet code using jdbc connection. int index=1; while(rs.next... using hibernate.I am having function called displayIps() and displayvalues

jsp page authentication panel using jsp/servlet?
jsp page authentication panel using jsp/servlet? I have 10 jsp jsp forms and 7 users and i want to grant variour permission like edit,delete and save for users dynamically on forms.So please refer me code

how to create using jsp
how to create using jsp code 1: <%@ page language="java...;%=request.getContextPath()%>/jsp/Create.jsp">Create</a> </p> <p><a href="<%=request.getContextPath()%>/jsp/View.jsp">View </a>

file upload using JSP
file upload using JSP I have created a form to upload a file in a html page, now i want to get the path of the file in a jsp page so what code should I write? thanks and regards... 1)page.jsp: <%@ page language

image upload&download using jsp - JSP-Servlet
image upload&download using jsp can any one help in writing jsp... visit the following links: http://www.roseindia.net/jsp/fileupload.shtml http://www.roseindia.net/jsp/downloadimage.shtml Hope that the above links

Displaying image using jsp and spring.
Displaying image using jsp and spring. how to display an image stored in WEB-INF/images folder on the browser using jsp and spring

ajax using jsp
ajax using jsp <%@ page import="java.io.*" %> <%@ page import="java.util.*" %> <%@ page import="java.sql.*" %> <%@ page import="java.util.StringTokenizer" %> <%@ page import="java.lang.*" %> <

create using jsp
create using jsp code 1:``<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org

Ajax using jsp
Ajax using jsp <%@ page import="java.io.*" %> <%@ page import="java.util.*" %> <%@ page import="java.sql.*" %> <%@ page import="java.util.StringTokenizer" %> <%@ page import="java.lang.*" %> <

jsp using Beans

Questions by Category