What might be the possible cause ?
I have created a website using struts framework, jsp
In my transaction page the money is not getting transferred..
When I hit the submit button in my Transaction.jsp page , no transaction happens ..
Only the url changes from
to this
Below are my files
struts-config.xml
transaction.jsp
TransactionActi on.java
Why is nothing happening ????????
I have created a website using struts framework, jsp
In my transaction page the money is not getting transferred..
When I hit the submit button in my Transaction.jsp page , no transaction happens ..
Only the url changes from
to this
Below are my files
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" />
<set-property property="maxActive" value="40" />
<set-property property="maxWait" value="5000" />
<set-property property="defaultAutoCommit" value="true" />
<set-property property="defaultReadOnly" value="false" />
<set-property property="maxActive" value="10" />
<set-property property="maxWait" value="5000" />
<set-property property="defaultReadOnly" value="false" />
</data-source>
</data-sources>
<form-beans>
<form-bean name="searchCustomerForm"
type="com.kmg.bank.form.SearchCustomerForm" />
<form-bean name="editCustomerForm"
type="com.kmg.bank.form.EditCustomerForm" />
<form-bean name="searchEmpForm"
type="com.kmg.bank.form.SearchEmpForm" />
<form-bean name="editEmpForm"
type="com.kmg.bank.form.EditEmpForm" />
<form-bean name="index1Form"
type="com.kmg.bank.form.Index1Form" />
<form-bean name="index2Form"
type="com.kmg.bank.form.Index2Form" />
<form-bean name="newEmployeeForm"
type="com.kmg.bank.form.NewEmployeeForm" />
<form-bean name="newCustomerForm"
type="com.kmg.bank.form.NewCustomerForm" />
<form-bean name="transactionForm"
type="com.kmg.bank.form.TransactionForm" />
<form-bean name="activateForm"
type="com.kmg.bank.form.ActivateForm" />
</form-beans>
<global-forwards>
<forward name="/transac" path="/jsp/transaction.jsp"></forward>
<forward name="activate" path="/jsp/accntList.jsp"></forward>
</global-forwards>
<action-mappings>
<action attribute="searchCustomerForm"
input="/jsp/searchCustomer.jsp" name="searchCustomerForm"
path="/searchCustomer" scope="request" validate="true"
type="com.kmg.bank.action.SearchCustomerAction">
<forward name="result" path="/jsp/customerSearchResult.jsp" />
</action>
<action attribute="editCustomerForm"
input="/jsp/editCustomer.jsp" parameter="do" name="editCustomerForm"
path="/editCustomer" scope="request" validate="true"
type="com.kmg.bank.action.EditCustomerAction">
<forward name="changed" path="/jsp/updatedCustomer.jsp" />
<forward name="edit" path="/jsp/editCustomer.jsp" />
</action>
<action attribute="searchEmpForm" input="/jsp/searchEmp.jsp"
name="searchEmpForm" path="/searchEmp" scope="request" validate="true"
type="com.kmg.bank.action.SearchEmpAction">
<forward name="resultEmp" path="/jsp/empSearchResult.jsp" />
</action>
<action attribute="editEmpForm" input="/jsp/editEmp.jsp"
name="editEmpForm" parameter="do" path="/editEmp" scope="request" validate="true"
type="com.kmg.bank.action.EditEmpAction">
<forward name="updatedEmp" path="/jsp/updatedEmp.jsp" />
<forward name="editEmp" path="/jsp/editEmp.jsp" />
</action>
<action path="/index1" type="com.kmg.bank.action.Index1Action" validate="true"
name="index1Form" input="/jsp/index1.jsp">
<forward name="accountDetail" path="/jsp/accountDetail.jsp" />
</action>
<action path="/index2" type="com.kmg.bank.action.Index2Action" validate="true"
parameter="do" name="index2Form" input="/jsp/index2.jsp">
<forward name="employeeDetail"
path="/jsp/employeeDetail.jsp" />
<forward name="logout"
path="/jsp/logout.jsp" />
</action>
<action attribute="newEmployeeForm" input="/jsp/newEmployee.jsp" validate="true"
name="newEmployeeForm" path="/newEmployee" scope="request"
type="com.kmg.bank.action.NewEmployeeAction">
<forward name="success1"
path="/jsp/success1.jsp" />
</action>
<action attribute="newCustomerForm" input="/jsp/newCustomer.jsp"
name="newCustomerForm" path="/newCustomer" scope="request" validate="true"
type="com.kmg.bank.action.NewCustomerAction">
<forward name="success" path="/jsp/success.jsp" />
</action>
<action attribute="accntListForm" input="/jsp/accntList.jsp"
name="accntListForm" parameter="do" path="/accntList" scope="request" validate="true"
type="com.kmg.bank.action.AccntListAction">
<forward name="showList" path="/jsp/accntList.jsp" />
</action>
<action attribute="transactionForm" input="/jsp/transaction.jsp"
name="transactionForm" path="/transaction" scope="request" validate="true"
type="com.kmg.bank.action.TransactionAction" >
<forward name="accountDetail" path="/jsp/accountDetail.jsp" />
</action>
<action attribute="activateForm" input="/jsp/activate.jsp"
path="/activate" scope="request" name="activateForm" validate="true"
type="com.kmg.bank.action.ActivateAction">
<forward name="activated"
path="/jsp/activated.jsp" />
</action>
</action-mappings>
<message-resources parameter="com.kmg.bank.ApplicationResources" />
<plug-in className="org.apache.struts.validator.ValidatorPlugIn">
<set-property property="pathnames"
value="/WEB-INF/validator-rules.xml,
/WEB-INF/validation.xml" />
</plug-in>
</struts-config>
transaction.jsp
Code:
<%@ page language="java" pageEncoding="ISO-8859-1"%>
<%@ taglib uri="http://struts.apache.org/tags-bean" prefix="bean"%>
<%@ taglib uri="http://struts.apache.org/tags-html" prefix="html"%>
<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="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.jsp">Products</a>
</li>
<li>
<a href="loans.jsp">Easy loans</a>
</li>
<li>
<a href="aboutus.jsp">About us</a>
</li>
<li>
<a href="contact.jsp">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.jsp">Branches</a>
</li>
<li>
<a href="atm.jsp">ATMs</a>
</li>
<li>
<a href="foreignBranches.jsp">Overseas Branches</a>
</li>
<li>
<a href="phoneNumbers.jsp">Phone banking numbers</a>
</li>
</ul>
</div>
<div class="bottom"></div>
<h2>
Information
</h2>
<div class="back">
<ul>
<li>
<a href="interestRates.jsp">Interest rates on FD</a>
</li>
<li>
<a href="associateBanks.jsp">Associate Banks</a>
</li>
<li>
<a href="faq.jsp">FAQ's</a>
</li>
</ul>
<br>
<br>
</div>
<div class="bottom"></div>
</div>
<!-- end leftbar -->
<!-- start content -->
<div id="content">
<div class="post">
<h1 class="title">
Transaction
</h1>
<br>
<br>
<html:form action="/transaction">
<center>
<table>
<tr>
<td>
Accnt No:
</td>
<td>
${accntNo}
</td>
</tr>
<tr></tr>
<tr></tr>
<tr></tr>
<tr></tr>
<tr></tr>
<tr>
<td>
Amount to be transfered:
</td>
<td>
<html:text property="amnt" />
</td>
</tr>
<tr>
<td colspan=2>
<center>
<html:messages id="err_amnt" property="amnt">
<font color="red"><bean:write name="err_amnt" /> </font>
</html:messages>
</center>
</td>
</tr>
<tr></tr>
<tr></tr>
<tr></tr>
<tr></tr>
<tr>
<td>
Pay to Account No:
</td>
<td>
<html:text property="payTo" />
</tr>
<tr>
<td colspan=2>
<center>
<html:messages id="err_payTo" property="payTo">
<font color="red"><bean:write name="err_payTo" />
</font>
</html:messages>
</center>
</td>
</tr>
<tr></tr>
<tr></tr>
<tr></tr>
<tr></tr>
<tr></tr>
<tr></tr>
<tr>
<td>
Re-enter Account No:
</td>
<td>
<html:text property="rePayTo" />
</td>
</tr>
<tr></tr>
<tr>
<td colspan=2>
<center>
<html:messages id="err_rePayTo" property="rePayTo">
<font color="red"><bean:write name="err_rePayTo" />
</font>
</html:messages>
</center>
</td>
</tr>
<tr></tr>
<tr></tr>
<tr></tr>
<tr></tr>
<tr></tr>
<tr>
<td>
<center>
<html:submit value="Transfer" />
</center>
</td>
<td>
<center>
<html:reset />
</center>
</td>
</tr>
</table>
</center>
</html:form>
<br>
<br>
<br>
<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="award.jsp">CNN-IBN Indian of the Year Award</a>
</li>
<li>
<a href="tieup.jsp">Corporate Bank Ties up with Indian
Institute of Human Rights</a>
</li>
</ul>
</div>
<div class="bottom"></div>
</div>
<!-- end rightbar -->
<div style="clear: both;">
</div>
</div>
<!-- end page -->
<div id="footer">
<p>
Copyright © 2009.
<a href="privacyPolicy.jsp">Privacy Policy</a> |
<a href="faq.jsp">FAQs</a>
</p>
<p>
Created by Anuj, Gaytri, Simrat
</p>
</div>
</div>
</body>
</html>
TransactionActi on.java
Code:
package com.kmg.bank.action;
import java.io.PrintWriter;
import java.sql.Connection;
import java.util.ArrayList;
import java.util.Iterator;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import javax.sql.DataSource;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import com.kmg.bank.form.*;
import com.kmg.bank.service.AccountDAO;
import com.kmg.bank.service.TransactionDAO;
import com.kmg.bank.*;
public class TransactionAction extends Action {
public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response)
throws Exception {
TransactionForm transactionForm = (TransactionForm) form;
TransactionDAO service = new TransactionDAO();
Connection con = null;
Transaction transaction=new Transaction();
HttpSession session= request.getSession();
AccountDAO accountDAO=new AccountDAO();
ArrayList list=null;
Iterator iterator=null;
Integer accntNo=(Integer)session.getAttribute("accntNo");
transaction.setAccntNo(accntNo.intValue());
transaction.setAmnt(transactionForm.getAmnt());
transaction.setPayTo(transactionForm.getPayTo());
System.out.println(transaction.getAmnt());
DataSource ds = getDataSource(request);
con=service.getConnection(ds);
int a=service.editAccnt(con, transaction);
int b=service.editPayToAccnt(con, transaction);
int c=service.addRecord(con, transaction);
list=accountDAO.searchByAccntNo(con, transaction.getAccntNo());
float bal=0;
iterator=list.iterator();
while(iterator.hasNext())
{
Account account=(Account)iterator.next();
bal=account.getBalance();
}
session.setAttribute("balance", Float.valueOf(bal));
if(a>0 && b>0 && c>0)
System.out.println("transaction successful");
//service.closeConnection(con);
return mapping.findForward("accountDetail");
}
}
Why is nothing happening ????????
Comment