balance.java

这是一个网上书站的例子

/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package com.zxf.struts.cart;

import java.io.IOException;
import java.util.Collection;
import java.util.Iterator;

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 com.cart.Book;
import com.cart.BookItem;
import com.cart.Cart;
import com.codechage.YearMonGet;
import com.db.Jdo;

/** 
 * MyEclipse Struts
 * Creation date: 01-11-2008
 * 
 * XDoclet definition:
 * @struts.action validate="true"
 */
public class Balance extends Action {
	/*
	 * Generated Methods
	 */

	/** 
	 * Method execute
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		// TODO Auto-generated method stub
		HttpSession session=request.getSession();
		
		Cart cart=(Cart)session.getAttribute("cart");
		Collection c=cart.getAll();
		Iterator it=c.iterator();
		Cart cart1=new Cart();
		session.setAttribute("cart", cart1);
		String str=YearMonGet.getYearMon();
		String date=YearMonGet.getDate();
		float totalprice=cart.getTotalValue();
		String userid=(String)session.getAttribute("userid");
		//String username=(String)session.getAttribute("username");
		String ordernum=userid+str;
		Jdo jdo=new Jdo();
		System.out.print("()");//insert into `order`(`ordernumber`,`orderdate`,`issend`,`totalprice`,`orderuserid`) values ( '"+ordernum+"','"+date+"','0',"+totalprice+","+userid+")
		jdo.executeUpdate("insert into `orderw`(`ordernumber`,`orderdate`,`issend`,`totalprice`,`orderuserid`) values ( '"+ordernum+"','"+date+"','0',"+totalprice+","+userid+")");
		while(it.hasNext())
		{
			System.out.print("ithasnext()");
			BookItem bookitem=(BookItem)it.next();
			Book book=bookitem.getBook();
			int count=bookitem.getAmount();
			int bookid=book.getBookid();
			jdo.executeUpdate("insert into orderdetail(ordernum,bookid,bookcount) values('"+ordernum+"',"+bookid+","+count+")");
			jdo.executeUpdate("update book set remaincount=remaincount-"+count+",sailcount=sailcount+"+count+" where bookid="+bookid);
			
		}
		jdo.destroy();
		try {
			response.sendRedirect("myorder.jsp");
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return null;
	}
}