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
http://localhost:8080/bankfinalproje...ransaction.jsp
to this
http://localhost:8080/bankfinalproject/transaction.do
Below are my files
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" />
- <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
Expand|Select|Wrap|Line Numbers
- <%@ 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>
TransactionAction.java
Expand|Select|Wrap|Line Numbers
- 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 ????????