电子银行系统JSP电子银行系统JSP电子银行系统JSP

package internetbank; import org.apache.struts.action.ActionMapping; import org.apache.struts.action.ActionForm; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.apache.struts.action.ActionForward; import org.apache.struts.action.Action; import java.sql.SQLException; public class transferAction extends Action { public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws SQLException { transferActionForm transferActionForm = (transferActionForm) form; javax.servlet.ServletContext context = servlet.getServletContext(); javax.sql.DataSource datasource = (javax.sql.DataSource) context. getAttribute("sql"); BankOperat op = new BankOperat(datasource); javax.servlet.http.HttpSession session = request.getSession(); String id = session.getAttribute("user").toString(); //源ID String tranId = transferActionForm.getTransferId(); //转帐ID Float tranMoney = Float.parseFloat(transferActionForm.getTransferMoney()); //转帐金额 //源帐号余额 float SqlBalance = op.requestBalance( "select Balance from Account where ID='" + id + "'"); System.out.println("sqlBalance" + SqlBalance); if (SqlBalance < 0) { session.setAttribute("error", "源帐号金额不足1元"); return mapping.findForward("error"); } //更改用户源帐户余额 java.sql.Connection con = null; try { con = datasource.getConnection(); java.sql.Statement stm = con.createStatement(); con.setAutoCommit(false); //更改用户源帐户余额 String ysql = "update Account set Balance=Balance-" + tranMoney + " where ID='" + id + "'"; stm.executeUpdate(ysql); System.out.println("源SQL" + ysql); //更改目标用户余额 String tsql = "update Account set Balance=Balance + " + tranMoney + " where ID = '" + tranId + "'"; stm.executeUpdate(tsql); System.out.println("转帐SQL"+tsql); con.commit(); con.setAutoCommit(true); con.close(); return mapping.findForward("succeed"); } catch (Exception ex) { con.rollback(); System.out.println("转帐错误" + ex.toString()); session.setAttribute("error","转帐错误!请联系管理员"); return mapping.findForward("succeed"); } // return mapping.findForward("succeed"); // throw new java.lang.UnsupportedOperationException( // "Method $execute() not yet implemented."); } }