Retrieve data from Database using struts jsp

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • lifeisgreat20009
    New Member
    • Oct 2007
    • 70
    #1

    Retrieve data from Database using struts jsp

    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 :-

    Code:
    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 :-

    Code:
    <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>
    employeeDetailF orm.java

    Code:
    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;
	}
	
}
    employeeDetailA ction.java

    Code:
    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.jav a

    Code:
    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

    Code:
    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

    Code:
    <?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


    Code:
    <?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.
    Last edited by lifeisgreat20009; Apr 13 '09, 04:10 PM. Reason: forgot to mention error
    Tags: None
    • NitinSawant
      Contributor
      • Oct 2007
      • 271
      #2
      Okay, seems that you are newbie,

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

      Click: JSP Database Connectivity Code

      hope it works

        Comment

        • lifeisgreat20009
          New Member
          • Oct 2007
          • 70
          #3
          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.jav a

          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 ?

            Comment

            • NitinSawant
              Contributor
              • Oct 2007
              • 271
              #4
              At the top of the jsp page, just above the <html> tag write following lines:-

              Code:
              <%@ page language="java" %>
<%@ taglib uri="/WEB-INF/struts-bean.tld"   prefix="bean" %>

                Comment

                • lifeisgreat20009
                  New Member
                  • Oct 2007
                  • 70
                  #5
                  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.jasp er.JasperExcept ion: An exception occurred processing JSP page /jsp/employeeDetail. jsp at line 69

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


                  Stacktrace:
                  org.apache.jasp er.servlet.JspS ervletWrapper.h andleJspExcepti on(JspServletWr apper.java:505)
                  org.apache.jasp er.servlet.JspS ervletWrapper.s ervice(JspServl etWrapper.java: 398)
                  org.apache.jasp er.servlet.JspS ervlet.serviceJ spFile(JspServl et.java:342)
                  org.apache.jasp er.servlet.JspS ervlet.service( JspServlet.java :267)
                  javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:717)


                  root cause

                  javax.servlet.S ervletException : javax.servlet.j sp.JspException : Cannot find bean employeeDetailF orm in any scope
                  org.apache.jasp er.runtime.Page ContextImpl.doH andlePageExcept ion(PageContext Impl.java:852)
                  org.apache.jasp er.runtime.Page ContextImpl.han dlePageExceptio n(PageContextIm pl.java:781)
                  org.apache.jsp. jsp.employeeDet ail_jsp._jspSer vice(employeeDe tail_jsp.java:2 75)
                  org.apache.jasp er.runtime.Http JspBase.service (HttpJspBase.ja va:70)
                  javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:717)
                  org.apache.jasp er.servlet.JspS ervletWrapper.s ervice(JspServl etWrapper.java: 374)
                  org.apache.jasp er.servlet.JspS ervlet.serviceJ spFile(JspServl et.java:342)
                  org.apache.jasp er.servlet.JspS ervlet.service( JspServlet.java :267)
                  javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:717)


                  root cause

                  javax.servlet.j sp.JspException : Cannot find bean employeeDetailF orm in any scope
                  org.apache.stru ts.taglib.TagUt ils.lookup(TagU tils.java:992)
                  org.apache.stru ts.taglib.bean. WriteTag.doStar tTag(WriteTag.j ava:227)
                  org.apache.jsp. jsp.employeeDet ail_jsp._jspx_m eth_bean_005fwr ite_005f0(emplo yeeDetail_jsp.j ava:294)
                  org.apache.jsp. jsp.employeeDet ail_jsp._jspSer vice(employeeDe tail_jsp.java:1 31)
                  org.apache.jasp er.runtime.Http JspBase.service (HttpJspBase.ja va:70)
                  javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:717)
                  org.apache.jasp er.servlet.JspS ervletWrapper.s ervice(JspServl etWrapper.java: 374)
                  org.apache.jasp er.servlet.JspS ervlet.serviceJ spFile(JspServl et.java:342)
                  org.apache.jasp er.servlet.JspS ervlet.service( JspServlet.java :267)
                  javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:717)


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

                    Comment

                    • lifeisgreat20009
                      New Member
                      • Oct 2007
                      • 70
                      #6
                      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.

                        Comment

                        • NitinSawant
                          Contributor
                          • Oct 2007
                          • 271
                          #7
                          you have to define employeeDetailF orm on the jsp page

                            Comment

                            • lifeisgreat20009
                              New Member
                              • Oct 2007
                              • 70
                              #8
                              u mean i need to import that employeeDetails Form.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

                                Comment

                                • NitinSawant
                                  Contributor
                                  • Oct 2007
                                  • 271
                                  #9
                                  404 Page Not Found
                                  http://struts.apache.org/1.2.x/userGuide/struts-bean.html


                                  Google Search

                                  might help you
                                  Last edited by NitinSawant; Apr 13 '09, 05:36 PM. Reason: add new link

                                    Comment

                                    • lifeisgreat20009
                                      New Member
                                      • Oct 2007
                                      • 70
                                      #10
                                      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 :(

                                        Comment

                                        • Anbu007
                                          New Member
                                          • Sep 2010
                                          • 1
                                          #11
                                          <%@ page language="java" import="java.ut il.*" pageEncoding="U TF-8"%>

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

                                          <%@ taglib uri="/WEB-INF/innovation.tld" prefix="innov"% >

                                          import in your jsp... u should have those tld file in your WEB-INF folder. you can download tld from internet.

                                          Page not found – allapplabs.com
                                          http://www.allapplabs.com/struts/struts_example.htm

                                          http://j2ee.masslight.com/Chapter5.html


                                          use the above link for your reference

                                            Comment

                                            • raj1001
                                              New Member
                                              • Apr 2012
                                              • 1
                                              #12
                                              I have displayed id,x co-od,y co-od,color of points.Hope it helps.
                                              struts-config.xml
                                              Code:
                                              <action-mappings>
        <action name="pointForm" path="/add" scope="request" type="com.myapp.sruts.NewAction" validate="false">
            <forward name="success" path="/WEB-INF/add.jspx"/>
        </action>
        <action path="/addSubmit" name="pointForm" scope="request" input="/add.do" type="com.myapp.struts.AddAction">
            <forward name="success" path="/WEB-INF/list.jsp"/>
            
        </action>
                                              list.jsp
                                              Code:
                                              <%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<html>
<head>
<title>display data from the table using jsp</title>
</head>
<body>
<h2>Data from the table point </h2>
<%
try {
/* Create string of connection url within specified format with machine
name, port number and database name. Here machine name id localhost and
database name is student. */
String connectionURL = "jdbc:odbc:poi";
// declare a connection by using Connection interface
Connection connection = null;
/* declare object of Statement interface that is used for executing sql
statements. */
Statement statement = null;
// declare a resultset that uses as a table for output data from tha table.
ResultSet rs = null;
// Load JBBC driver "com.mysql.jdbc.Driver"
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
/* Create a connection by using getConnection() method that takes parameters
of string type connection url, user name and password to connect to database.*/
connection = DriverManager.getConnection(connectionURL, "s", "s");
/* createStatement() is used for create statement object that is used for
sending sql statements to the specified database. */
statement = connection.createStatement();
// sql query to retrieve values from the secified table.
String QueryString = "SELECT * from point";
rs = statement.executeQuery(QueryString);
%>
<TABLE cellpadding="15" border="1" style="background-color: #ffffcc;">
<tr>
    <td>id</td>
    <td>x</td>
    <td>y</td>
    <td>color</td>
 </tr>
<%
while (rs.next()) {
%>
<TR>
<TD><%=rs.getInt(1)%></TD>
<TD><%=rs.getDouble(2)%></TD>
<TD><%=rs.getDouble(3)%></TD>
<TD><%=rs.getString(4)%></TD>
</TR>
<% } %>
<%
// close all the connections.
rs.close();
statement.close();
connection.close();
} catch (Exception ex) {
%>


<%
out.println("Unable to connect to database.");
}
%>
</TABLE><TABLE>
<TR>
<TD>
<button type="submit"><-- back</button></TD>
</TR>
</TABLE>
</body>
</html>

                                                Comment

                                                • abhijitbhopale
                                                  New Member
                                                  • May 2013
                                                  • 1
                                                  #13
                                                  http://r4r.co.in/java/struts/basic/tutorial/struts_basic_tutorials.php?id=286&option=Struts%20Basic


                                                  go with this link this will help you solve your problem

                                                    Comment

                                                    Previous template Next
                                                    Working...