package com.BIM.actions;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.util.List;

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 org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;

import com.BIM.embean.Userinfo;
import com.BIM.factorys.HibernateSessionFactory;
import com.BIM.forms.QuForm;

public class QuAction extends Action {

	@Override
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		QuForm qukuan = (QuForm) form;
		float money = qukuan.getMoney();
		String num = qukuan.getNum();
		String card_id = qukuan.getCard_id();
		Session session = HibernateSessionFactory.getSession();
		session.beginTransaction();
		Query query = session.createQuery("from Userinfo where num='" + num
				+ "'");
		List list = query.list();
		if (list.size() > 0) {
			Userinfo user = (Userinfo) list.get(0);
			if (user.getCard_id().equals(card_id)) {
				float mon = user.getMoney() - money;
				if (mon >= 0) {
					user.setMoney(mon);
					request.getSession().setAttribute("money", mon);
					
					session.update(user);
					session.beginTransaction().commit();
					session.close();

					
					return mapping.findForward("succ");
				}
				return mapping.findForward("error");
			}
			return mapping.findForward("error");
		}
		return mapping.findForward("error");
	}
}