orderaction.java

很好的东东 本人随便做的 仅供学习之用

/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package cangku.action;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
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 cangku.javabeans.CKSql;
import cangku.javabeans.DBConn;
import cangku.javabeans.HaulerBean;
import cangku.javabeans.OrderdetailBeans;

/** 
 * MyEclipse Struts
 * Creation date: 09-08-2007
 * 
 * XDoclet definition:
 * @struts.action validate="true"
 */
public class OrderAction 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
		Integer orderID=new Integer(request.getParameter("id"));
		Integer sendID=new Integer(request.getParameter("sendID"));
		request.getSession().setAttribute("sendID", sendID);
		
		System.out.print("ORDERID "+orderID);
		
		
		Connection conn=null;
		 conn=DBConn.getconn();
		
		String target="success";
		
		
		try {
			 PreparedStatement sta=null;
			 ResultSet rs=null;
			 String ckordersql=CKSql.ckordersql;     //调出订单的信息
			 sta=conn.prepareStatement(ckordersql);   
			 sta.setInt(1, orderID.intValue());
			 rs=sta.executeQuery();
			 if(rs.next()){ 
				
			      request.setAttribute("orderID",new Integer(rs.getInt("ID")) );
			      request.setAttribute("customername", rs.getString("customername"));
			      request.setAttribute("address", rs.getString("address"));	
			     
			      System.out.print("aaaaaaa"+rs.getInt("ID"));
			      
			      rs.close();
			      sta.close();
			      //调出所有承运商，填充页面
			      String ckhauler=CKSql.ckhauler;
			      
			      List haulers=new ArrayList();
			      sta=conn.prepareStatement(ckhauler);
			      rs=sta.executeQuery();
			      while(rs.next()){
			    	 
			    	 HaulerBean hb=new HaulerBean();
			    	 hb.setID(new Integer(rs.getInt("ID")));
			    	 hb.setName(rs.getString("name"));
			    	 haulers.add(hb);
			    	  
			    	  System.out.print("hauler" +rs.getInt("ID"));
			      }
			      request.setAttribute("hauler", haulers);
			      
			      rs.close();
			      sta.close();
			      
			      //调出订单明细表，药物名称和数量
			      String ckorderdetail=CKSql.ckorderdetail;
			      List detail=new ArrayList();
			      sta=conn.prepareStatement(ckorderdetail);
			      sta.setInt(1, orderID.intValue());
			      System.out.print("   DRUGID123   "+orderID);
			      rs=sta.executeQuery();
			      System.out.print("   DRUGID123   "+orderID);
			      while(rs.next()){
			    	  OrderdetailBeans ob=new OrderdetailBeans();
			    	  ob.setOrderID(orderID);
			    	  ob.setDrugID(new Integer(rs.getInt("drugID")));
			    	  ob.setDrugname(rs.getString("drugname"));
			    	  ob.setCounts(rs.getInt("counts"));
			    	  detail.add(ob);
			    	  
			    	 System.out.print("BBB  "+rs.getInt("drugID"));
			    	  
			      }
			      rs.close();
			      sta.close();
			      conn.close();
			      request.getSession().setAttribute("orderdetail", detail);
			     
			      
			 }else{
				 target="errorp";
			 }
			 
			 
			 
			 
			 
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally {
            try {
                if ((!conn.isClosed()) && conn == null) {
                    conn.close();
                }
            } catch (Exception e) {
                e.printStackTrace();
            }

        }
		
		
		
		
		return mapping.findForward(target);
	}
}