cartaction.java

自己做的毕业设计

package action;

import java.util.List;

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

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.CartForm;

public class CartAction extends Action {

	@Override
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		String target = "fail";
		CartForm cartForm = (CartForm) form;
		float money =0;
		HttpSession session = request.getSession();
		String username = cartForm.getUsername();
		for(int i=0;i<((List<String>) (session.getAttribute("price"))).size();i++)
		{
		money += Float.parseFloat(((List<String>) (session.getAttribute("price"))).get(i));
		}
		Connect c1 = new Connect("Select money from userinfo where username='"+username+"'");
		c1.rs.next();
		money = c1.rs.getFloat("money")-money;
		if (money>=0)
		{
		Connect c2 = new Connect("Update userinfo set money ="+Float.toString(money)+" where username='"+username+"'","insert");
		if (c2.num==1)
		{
			target = "success";
			for(int i = 0;i<((List<String>) (session.getAttribute("price"))).size();i++)
			{
				c2 = new Connect("insert into orderlist(username,oname,oprice) values('"+username+"','"+((List<String>)(session.getAttribute("pname"))).get(i)+"',"+((List<String>)(session.getAttribute("price"))).get(i)+")","insert");
			}
		}
		}
		return mapping.findForward(target);
	}

}