Simple Example for using JavaBeans in JSP

Introduction

JavaBeans component design conventions govern the properties of the class, and the public methods that give access to the properties.

A JavaBeans component property can be:

Read/write, read-only, or write-only.
It means it contains a single value, or indexed, i.e. it represents an array of values.

There is no requirement that a property be implemented by an instance variable; the property must simply be accessible using public methods that conform to certain conventions:

For each readable property, the bean must have a method of the form:
PropertyClass getProperty () { ... }
For each writable property, the bean must have a method of the form:
setProperty (PropertyClass pc) { ... }

In addition to the property methods, a JavaBeans component must define a constructor that takes no parameters.

CLICK HERE to download this complete example (zip file)

Store this JavaBean class inside the folder test (FindAuthor.java)

package test;

import java.io.Serializable;

import java.util.*;

import java.sql.*;

import java.io.*;

public class FindAuthor implements Serializable

{

public String url, authorName, driverName, authorId;

public Vector result;

public void setUrl(String url)

{

if(url!= null)

this.url = url;

}

public void setAuthorId(String authorId)

{

if (authorId != null)

this.authorId = authorId;

}

public void setDriverName(String driverName)

{

if (driverName != null)

this.driverName = driverName;

}

public String getAuthorId()

{

return(this.authorId);

}

public Vector getResult()

{

Vector v = new Vector();

try

{

Class.forName(driverName);

Connection con = DriverManager.getConnection(url, "sa", "");

PreparedStatement stat = con.prepareStatement( "SELECT * FROM Sample1 WHERE au_id = ? ");

stat.setString(1,authorId);

ResultSet rs = stat.executeQuery();

if(rs.next())

{

v.addElement(rs.getString("au_fname"));

v.addElement(rs.getString("address"));

v.addElement(rs.getString("city"));

v.addElement(rs.getString("state"));

v.addElement(rs.getString("zip"));

}

catch(Exception ex)

{

ex.printStackTrace();

}

this.result = v;

return result;

}

}

Download: FindAuthor.java

GetAuthorName.jsp

<%@ page import ="java.util.*" %>

<%@ page import = "test.FindAuthor" %>

<html>

<head>

<title> JSP and JavaBean </title>
<font size=4 face="Verdana" color=#112244>
<jsp:useBean id="FA" scope="application" class="test.FindAuthor" />
<jsp:setProperty name="FA" property="*" />

</head>

<body>

<%

Vector v = (Vector)FA.getResult();

Enumeration enu = v.elements();

while(enu.hasMoreElements())

{

out.println("Author Name:"+enum.nextElement());

%>

<br>

<%

out.println("Address:"+enu.nextElement());

%>

<br>

<%

out.println("City:"+enu.nextElement());

%>

<br>

<%

out.println("State:"+enu.nextElement());

%>

<br>

<%

out.println("ZIP:"+enu.nextElement());

}

%>

</body>

</html>

Download: GetAuthorName.jsp

WelcomePage.html

<html>

<body>

<br>

<h2><center>Connecting Database with JavaBean</center></h2>

<br>

<tr>

Author Id:

</font></b>

</td>

</font>

</td>

</tr>

<tr>

URL:

</font></b>

</td>

</font>

</td>

</tr>

<tr>

Driver Name:

</font></b>

</td>

</font>

</td>

</tr>

<tr>

<td>

</td>

</tr>

</table>

<br>

</form>

</body>

</html>

Download: WelcomePage.html

Click Next To Continue ...

<- PREVIOUS

NEXT ->

Complete J2EE Step-By-Step Tutorials with Examples

Simple Example for using JavaBeans in JSP