addmoneyaction.java

来自「自己做的毕业设计」· Java 代码 · 共 43 行

package action;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

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 db.Connect;
import form.AddMoneyForm;

public class AddMoneyAction extends Action {

	@Override
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		String target ="fail";
		AddMoneyForm add =(AddMoneyForm) form;
		String username= add.getUsername();
		String cardno = add.getCardno();
		String cardpwd = add.getCardpwd();
		Connect c = new Connect("select * from card");
		while(c.rs.next())
		{
			if(cardno.equals(c.rs.getString("cname"))&&cardpwd.equals(c.rs.getString("cpassword")))
			{
				Connect c1 = new Connect("select money from userinfo where username='"+username+"'");
				c1.rs.next();
				float money = c1.rs.getFloat("money");
				money+=30;
				Connect c2 = new Connect("update userinfo set money = "+Float.toString(money)+"where username ='"+username+"'","insert");
				if (c2.num==1) target ="success";
			}
		}
		// TODO Auto-generated method stub
		return mapping.findForward(target);
	}

}