Retrieve data from Database using struts jsp

lifeisgreat20009

I am a newbie to Struts and JSP...I have been working on the code below for 5 hours now..I googled a lot but couldn't get much help so finally I am here.. Hoping of getting my problem solved. Please give me some idea where I am going wrong ??

I just want to retrieve data from my emp_mstr table and display it using my JSP file...

The table emp_mstr is as follows :-

Expand|Select|Wrap|Line Numbers

 CREATE TABLE EMP_MSTR(

    EMP_NO VARCHAR(10) PRIMARY KEY, 

    PASSWORD VARCHAR(6),

    BRANCH_NO VARCHAR(10), 

    FNAME VARCHAR(25), 

    MNAME VARCHAR(25), 

    LNAME VARCHAR(25), 

    DEPT VARCHAR(30), 

    DESIG VARCHAR(30), 

    ADDR VARCHAR(50)

);

My JSP file is as follows :-

Expand|Select|Wrap|Line Numbers

 
<html>

<head>

<meta http-equiv="content-type" content="text/html; charset=utf-8" />

<title>corporate bank</title>

<meta name="keywords" content="" />

<meta name="description" content="" />

<link href="../resource/styles.css" rel="stylesheet" type="text/css" media="screen" />

</head>

<body>

<div id="main">

<!-- start header -->

<div id="header">

 <div id="logo">

    <h1>Corporate Bank</h1>

  </div>

<!--Header end -->

<div id="menu">

  <ul>

   <li><a href="#">Home</a></li>

   <li><a href="#">Products</a></li>

   <li><a href="#">Easy loans</a></li>

   <li><a href="#">About us</a></li>

   <li><a href="#">Contact</a></li>   

  </ul>

</div>

</div>
 
<!-- end header -->

<!-- start page -->

<div id="page">

    <!-- start leftbar -->

    <div id="leftbar" class="sidebar">

            <h2>Branch Network</h2>
 
             <div class="back">
 
                <ul>

                    <li><a href="#">Branches</a></li>

                    <li><a href="#">ATMs</a></li>

                    <li><a href="#">Overseas Branches</a></li>

                    <li><a href="#">Phone banking numbers</a></li>
 
                </ul>

                </div><div class="bottom"></div>

                <h2>General Information</h2>

                <div class="back">

                <ul>

                    <li><a href="#">Interest rates on FD</a></li>

                    <li><a href="#">Service charges and fees</a></li>
 
                    <li><a href="#">Download Forms</a></li>

                    <li><a href="#">FAQ's</a></li>

                  </ul>

                </div>

                <div class="bottom"></div>

    </div>
 
    <!-- end leftbar -->

    <!-- start content -->

    <div id="content">

        <div class="post">

             <h1 class="title">Employee Details</h1>

<br><br>     <center><table>

<tr>

<td>

<div>Employee No.</div>

</td>

<td><bean:write name="employeeDetailForm" property="empNo"/></td>

</tr><tr></tr><tr></tr><tr></tr>

<tr valign="top">

<td>

<div>Branch No.</div>

</td>

<td><bean:write name="employeeDetailForm" property="branchNo"/></td>

</tr><tr></tr><tr></tr><tr></tr>

<tr valign="top">

<td>

<div>First Name</div>

</td>

<td><bean:write name="employeeDetailForm" property="fName"/></td>

</tr><tr></tr><tr></tr><tr></tr>

<tr valign="top">

<td>

<div>Middle Name</div>

</td>

<td><bean:write name="employeeDetailForm" property="mName"/></td>

</tr><tr></tr><tr></tr><tr></tr>

<tr valign="top">

<td>

<div>Last Name</div>

</td>

<td><bean:write name="employeeDetailForm" property="lName"/></td>

</tr><tr></tr><tr></tr><tr></tr>

<tr valign="top">

<td>

<div>Department</div>

</td>

<td><bean:write name="employeeDetailForm" property="dept"/></td>

</tr><tr></tr><tr></tr><tr></tr>

<tr valign="top">

<td>
 
<div>Designation</div>

</td>

<td><bean:write name="employeeDetailForm" property="desig"/></td>

</tr><tr></tr><tr></tr><tr></tr>
 
<tr valign="top">

<td>
 
<div>Address</div>

</td>

<td><bean:write name="employeeDetailForm" property="address"/></td>

</tr><tr></tr><tr></tr><tr></tr>
 
<tr valign="top">

<td>

</tr><tr></tr><tr></tr><tr></tr><tr></tr><tr></tr><tr></tr>

<tr></tr><tr></tr><tr></tr><tr></tr>

<tr><td colspan=2>

<center><a href="search employee.html">Search Employee</a></center>

</td>

</tr>
 
<tr></tr><tr></tr><tr></tr><tr></tr>

<tr><td colspan=2>

<center><a href="search customer.html">Search Customer</a></center>

</td>

</tr>
 
<tr></tr><tr></tr><tr></tr><tr></tr>

<tr><td colspan=2>

<center><a href="activate saving account.html">Activate Account</a></center>

</td>

</tr>
 
<tr></tr><tr></tr><tr></tr><tr></tr>

<tr><td colspan=2>

<center><a href="new employee.html">New Employee</a></center>

</td>

</tr>

    </table></center>

<br><br>

        </div>

    </div>

    <!-- end content -->

    <!-- start rightbar -->

    <div id="rightbar" class="sidebar">                

                <h2>Login</h2>

                 <div class="back">

                <form action="">

    <center><table>

    <tr ><td color=#000000>You have logged in as:</td></tr>

    <tr><td><center>.......</center></td>

    </tr>

  <tr></tr><tr></tr><tr></tr><tr></tr><tr></tr><tr></tr><tr></tr><tr></tr><tr></tr>

<tr></tr><tr></tr><tr></tr><tr></tr>  

    <tr><td><center><a href="#">logout<a><center></td></tr>

<tr></tr><tr></tr>    </table></center>

  </form>
 
                </div><div class="bottom"></div>

                <h2>News</h2>

                 <div class="back">

                <ul>

                    <li><a href="#">Aliquam libero</a></li>

                    <li><a href="#">Consectetuer adipiscing elit</a></li>

                    <li><a href="#">Urnanet non molestie semper</a></li>

                    <li><a href="#">Proin gravida orci porttitor</a></li>

                </ul>

                </div><div class="bottom"></div>

    </div>

    <!-- end rightbar -->

    <div style="clear: both;">&nbsp;</div>

</div>

<!-- end page -->

 <div id="footer">

   <p>Copyright &copy; 2009. <a href="#">Privacy Policy</a> | <a href="#">Terms of Use</a> | <a href="#" title="This page validates as XHTML 1.0 Transitional"><abbr title="eXtensible HyperText Markup Language">XHTML</abbr></a> | <a href="#" title="This page validates as CSS"><abbr title="Cascading Style Sheets">CSS</abbr></a></p> 

    <p>Design by <a href="#" title="CORPORATE BANK">Corporate Bank</a></p>
 
</div>

</html>

employeeDetailForm.java

Expand|Select|Wrap|Line Numbers

 package com.kmg.employee;

import org.apache.struts.action.ActionForm;

public class employeeDetailForm extends ActionForm{
 
    private String empNo;

    private String password;

    private String fName;

    private String mName;

    private String lName;

    private String dept;

    private String desig;

    private String address;
 
    public String getempNo() {

        return empNo;

    }

    public void setempNo(String empNo) {

        this.empNo = empNo;

    }

    public String getpassword() {

        return password;

    }

    public void setpassword(String password) {

        this.password = password;

    }

    public String getfName() {

        return fName;

    }

    public void setfName(String name) {

        fName = name;

    }

    public String getmName() {

        return mName;

    }

    public void setmName(String name) {

        mName = name;

    }

    public String getlName() {

        return lName;

    }

    public void setlName(String name) {

        lName = name;

    }

    public String getDept() {

        return dept;

    }

    public void setDept(String dept) {

        this.dept = dept;

    }

    public String getDesig() {

        return desig;

    }

    public void setDesig(String desig) {

        this.desig = desig;

    }

    public String getAddress() {

        return address;

    }

    public void setAddress(String address) {

        this.address = address;

    }
 
}

employeeDetailAction.java

Expand|Select|Wrap|Line Numbers

 package com.kmg.employee;
 
import com.kmg.employee.employeeDetailForm;

import com.kmg.services.*;
 
import java.sql.Connection;

import javax.servlet.http.*;

import javax.sql.DataSource;

import org.apache.struts.action.*;
 
public class employeeDetailAction extends Action {
 
    public ActionForward execute(ActionMapping mapping, ActionForm form,

            HttpServletRequest request, HttpServletResponse response)

            throws Exception {

        employeeDetailForm employeeDetailForm = (employeeDetailForm) form;

        EmployeeDAO employeeDAO = new EmployeeDAO();

        Employee employee = new Employee();
 
        Connection con = null;

        DataSource ds = null;
 
        ds = getDataSource(request);

        employee.setempNo(employeeDetailForm.getempNo());

        String password = employeeDetailForm.getpassword();

        String fName = employeeDetailForm.getfName();

        String mName = employeeDetailForm.getmName();

        String lName = employeeDetailForm.getlName();

        String dept = employeeDetailForm.getDept();

        String desig = employeeDetailForm.getDesig();

        String address = employeeDetailForm.getAddress();

        con = employeeDAO.getConnection(ds);

        employee = employeeDAO.getRecord(con, employee);

            employeeDAO.closeConnection(con);

            return mapping.getInputForward();
 
    }

}

EmployeeDAO.java

Expand|Select|Wrap|Line Numbers

 package com.kmg.services;
 
import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;
 
import javax.sql.DataSource;
 
public class EmployeeDAO {

    public Connection getConnection(DataSource datasource) {

        Connection con = null;

        DataSource ds = datasource;

        try {

            con = ds.getConnection();

        } catch (SQLException e) {

            e.printStackTrace();

        }

        return con;

    }
 
    public void closeConnection(Connection con) {

        try {

            con.close();

        } catch (SQLException e) {

            e.printStackTrace();

        }

    }
 
    public static Employee getRecord(Connection con, Employee employee) {

        String qry = "select PASSWORD from EMP_MSTR where EMP_NO=?";

        String password = null;

        ResultSet resultSet = null;

        try {

            PreparedStatement pstat = con.prepareStatement(qry);

            pstat.setString(1, employee.getempNo());

            resultSet = pstat.executeQuery();

            while (resultSet.next()) {

                employee.setpassword(resultSet.getString("PASSWORD"));

                employee.setfName(resultSet.getString("FNAME"));

                employee.setmName(resultSet.getString("MNAME"));

                employee.setlName(resultSet.getString("LNAME"));

                employee.setDept(resultSet.getString("DEPT"));

                employee.setDesig(resultSet.getString("DESIG"));

                employee.setAddress(resultSet.getString("ADDR"));

            }

        } catch (SQLException e) {

            e.printStackTrace();

        }
 
        return employee;

    }

}

Employee.java

Expand|Select|Wrap|Line Numbers

 package com.kmg.services;
 
public class Employee {

    private String empNo;

    private String password;

    private String fName;

    private String mName;

    private String lName;

    private String dept;

    private String desig;

    private String address;

    public String getempNo() {

        return empNo;

    }

    public void setempNo(String empNo) {

        this.empNo = empNo;

    }

    public String getpassword() {

        return password;

    }

    public void setpassword(String password) {

        this.password = password;

    }

    public String getfName() {

        return fName;

    }

    public void setfName(String name) {

        fName = name;

    }

    public String getmName() {

        return mName;

    }

    public void setmName(String name) {

        mName = name;

    }

    public String getlName() {

        return lName;

    }

    public void setlName(String name) {

        lName = name;

    }

    public String getDept() {

        return dept;

    }

    public void setDept(String dept) {

        this.dept = dept;

    }

    public String getDesig() {

        return desig;

    }

    public void setDesig(String desig) {

        this.desig = desig;

    }

    public String getAddress() {

        return address;

    }

    public void setAddress(String address) {

        this.address = address;

    }
 
}

struts-config.xml

Expand|Select|Wrap|Line Numbers

 <?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE struts-config PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 1.2//EN" "http://struts.apache.org/dtds/struts-config_1_2.dtd">
 
<struts-config>

  <data-sources>

<data-source type="org.apache.commons.dbcp.BasicDataSource">

    <set-property

      property="driverClassName"

      value="com.mysql.jdbc.Driver" />

    <set-property

      property="url"

      value="jdbc:mysql://localhost:3306/bank_sys?autoReconnect=true" />

    <set-property

      property="username"

      value="root"/>

    <set-property

      property="password"

      value="hr"/>

      </data-source>

      </data-sources>

   <form-beans>

    <form-bean name="index1Form"

               type="com.kmg.customer.Index1Form"/>
 
    <form-bean name="index2Form"

               type="com.kmg.employee.Index2Form"/>
 
     <form-bean name="employeeDetailForm"

               type="com.kmg.employee.employeeDetailForm"/>

  </form-beans>
 
  <!-- Action Mappings Configuration -->

  <action-mappings>

    <action path="/index1"

            type="com.kmg.customer.Index1Action"

            name="index1Form"

           input="/jsp/index1.jsp">

           <forward name="accountDetail" path="/jsp/accountDetail.jsp"/>

           </action>
 
           <action path="/index2"

            type="com.kmg.employee.Index2Action"

            name="index2Form"

           input="/jsp/index2.jsp">

           <forward name="employeeDetail" path="/jsp/employeeDetail.jsp"/>

           </action>
 
           <action path="/employeeDetail"

            type="com.kmg.employee.employeeDetailAction"

            name="employeeDetailForm"

           input="/jsp/employeeDetail.jsp">

           </action>
 
  </action-mappings>

</struts-config>

web.xml

Expand|Select|Wrap|Line Numbers

 <?xml version="1.0" encoding="UTF-8"?>

<web-app xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="2.4" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee   http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
 
  <servlet>

    <servlet-name>action</servlet-name>

    <servlet-class>org.apache.struts.action.ActionServlet</servlet-class>

    <init-param>

      <param-name>config</param-name>

      <param-value>/WEB-INF/struts-config.xml</param-value>

    </init-param>

    <init-param>

      <param-name>debug</param-name>

      <param-value>3</param-value>

    </init-param>

    <init-param>

      <param-name>detail</param-name>

      <param-value>3</param-value>

    </init-param>

    <load-on-startup>0</load-on-startup>

  </servlet>

  <servlet-mapping>

    <servlet-name>action</servlet-name>

    <url-pattern>*.do</url-pattern>

  </servlet-mapping>

  <welcome-file-list>

    <welcome-file>/jsp/employeeDetail.jsp</welcome-file>

  </welcome-file-list>
 
</web-app>

I am sorry for posting all the code if its against the community guide lines.
But I really need help. I m SOO lost. How to display data retrieved from database using JSP file ?? Nothing is getting displayed when I run the JSP file.

Nitin646

Okay, seems that you are newbie,

hey buddy you've already done the code for retrieving the data from database
checkout EmployeeDAO.java

Click: JSP Database Connectivity Code

hope it works

lifeisgreat20009

Yes I know the code to retrieve is there in that DAO class..
But how do I display it ?? I mean I have used the <bean:write > tag in my JSP file but its not displaying any value.

How can I write the code for DB connection and data retrieval again in my JSP when I have already made a separate class for that purpose i.e EmployeeDAO.java

Why is it not getting displayed ? Is there some problem with <bean:write > tag ?

Also when I hover mouse on <bean:write> tag
it says "unknown tag bean:write"

Whats wrong with it ?

Nitin646

At the top of the jsp page, just above the <html> tag write following lines:-

Expand|Select|Wrap|Line Numbers

 
<%@ page language="java" %>

<%@ taglib uri="/WEB-INF/struts-bean.tld"   prefix="bean" %>

lifeisgreat20009

I just included the line below in my JSP file. It doesn't show the error "unknown tag bean:write" anymore.

<%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean" %>

Now that I am running my file it says :-
I know the error has to do something with name and property attributes I have given in the <bean:write> tag .. I am just not able to figure out. Please help me guys.

exception

org.apache.jasper.JasperException: An exception occurred processing JSP page /jsp/employeeDetail.jsp at line 69

66: <td>
67: <div>Employee No.</div>
68: </td>
69: <td><bean:write name="employeeDetailForm" property="empNo"/></td>
70: </tr><tr></tr><tr></tr><tr></tr>
71: <tr valign="top">
72: <td>

Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handle JspException(JspServletWrapper.java:505)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:398)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet .java:717)

root cause

javax.servlet.ServletException: javax.servlet.jsp.JspException: Cannot find bean employeeDetailForm in any scope
org.apache.jasper.runtime.PageContextImpl.doHandle PageException(PageContextImpl.java:852)
org.apache.jasper.runtime.PageContextImpl.handlePa geException(PageContextImpl.java:781)
org.apache.jsp.jsp.employeeDetail_jsp._jspService( employeeDetail_jsp.java:275)
org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet .java:717)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet .java:717)

root cause

javax.servlet.jsp.JspException: Cannot find bean employeeDetailForm in any scope
org.apache.struts.taglib.TagUtils.lookup(TagUtils. java:992)
org.apache.struts.taglib.bean.WriteTag.doStartTag( WriteTag.java:227)
org.apache.jsp.jsp.employeeDetail_jsp._jspx_meth_b ean_005fwrite_005f0(employeeDetail_jsp.java:294)
org.apache.jsp.jsp.employeeDetail_jsp._jspService( employeeDetail_jsp.java:131)
org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet .java:717)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet .java:717)

note The full stack trace of the root cause is available in the Apache Tomcat/6.0.18 logs.

lifeisgreat20009

Oh I just did that only..
Now its giving another error :(

I am sure it has something to do with the name and property attribute in the <bean:write> tag in my JSP file.

Nitin646

you have to define employeeDetailForm on the jsp page

lifeisgreat20009

u mean i need to import that employeeDetailsForm.java file in my JSP file or what ??

What do u mean by define ?
create object of it in JSP file ??

Seriously my mind has stopped working ...
I am struggling with this code for like 6-7 hours now and I need to complete it today only

Nitin646

http://struts.apache.org/1.2.x/userG...ruts-bean.html

Google Search

might help you

lifeisgreat20009

ok in my DAO class I have retrieved all fields from the emp_mstr table in the getRecords() method and returning the Employee object ..

Now how do I use this object in my JSP page to display the values of all the fields that it contains ??

god I am sooo lost :(

Retrieve data from Database using struts jsp

re: Retrieve data from Database using struts jsp

re: Retrieve data from Database using struts jsp

re: Retrieve data from Database using struts jsp

re: Retrieve data from Database using struts jsp

re: Retrieve data from Database using struts jsp

re: Retrieve data from Database using struts jsp

re: Retrieve data from Database using struts jsp

re: Retrieve data from Database using struts jsp

re: Retrieve data from Database using struts jsp

Similar Java bytes

/bytes/development

/bytes/it

/bytes/about