ATM.rar_atm java_oracle

package cn.icar.control; import java.io.*; import java.sql.Connection; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import cn.icar.model.Acount; import cn.icar.model.DBoperate; import cn.icar.model.User; import cn.icar.model.DBcon; public class DoGetMoney extends HttpServlet { private static final int EXCHANGE_RATE=7; @Override protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { // TODO Auto-generated method stub HttpSession hs=req.getSession(); String moneyin=req.getParameter("moneyin"); int moneyintr=Integer.parseInt(moneyin.trim()); String username=(String)hs.getAttribute("seusername");//用户 String acountname=(String)hs.getAttribute("acountname");//账户名 String ugmoneykind=(String)hs.getAttribute("ugmoneykind");//币种 System.out.println(moneyintr); Connection con=null; Acount ac=new Acount(username,acountname); System.out.println(ac.toString()); DBoperate dbo=new DBoperate(); //取款 try { con=new DBcon().getCon(); if(con==null){ resp.sendRedirect("errordb.jsp"); } else{ int dbbalance=dbo.getAcbalaceFromAc(ac, con);//现有金额 单位RMB System.out.println(dbbalance); System.out.println(ugmoneykind); //人民币处理 if(ugmoneykind.equals("RMB")){ if(moneyintr>dbbalance||moneyintr<0){//输入金额大于账户余额或者小于0 resp.sendRedirect("errorinput.jsp"); } else {//更新数据库 dbbalance-=moneyintr; Acount accopl=new Acount(username,acountname,dbbalance); con=new DBcon().getCon();//创建连接 boolean isok=dbo.UpdateAcount(accopl, con);//取款 System.out.println("取款机吐出中.."); if(isok){ // resp.sendRedirect("success.jsp"); } else{ resp.sendRedirect("errordb.jsp"); } } } //美元处理 1:7的汇率 else if(ugmoneykind.equals("Dollar")){ if(moneyintr*EXCHANGE_RATE>dbbalance||moneyintr<0){//输入金额大于账户余额或者小于0 resp.sendRedirect("errorinput.jsp"); } else {//更新数据库 dbbalance-=moneyintr*EXCHANGE_RATE; Acount accopl=new Acount(username,acountname,dbbalance); con=new DBcon().getCon();//创建连接 boolean isok=dbo.UpdateAcount(accopl, con);//取款 System.out.println("取款机吐出中.."); if(isok){ // resp.sendRedirect("success.jsp"); } else{ resp.sendRedirect("errordb.jsp"); } } } else{ //其他币种，待完善 } } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } @Override protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { // TODO Auto-generated method stub doGet(req,resp); } }