addsendaction.java

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

/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package chuyun.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 chuyun.form.SendForm;
import chuyun.javabeans.*;
import chuyun.operatedata.*;
import chuyun.form.*;

import java.io.UnsupportedEncodingException;
import java.lang.*;
import java.util.*;
import java.text.*;
/** 
 * MyEclipse Struts
 * Creation date: 09-09-2007
 * 
 * XDoclet definition:
 * @struts.action path="/addsend" name="sendForm" scope="request" validate="true"
 */
public class AddsendAction extends Action {
	/*
	 * Generated Methods
	 */

	/** 
	 * Method execute
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 * @throws ParseException 
	 * @throws UnsupportedEncodingException 
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) throws ParseException, UnsupportedEncodingException {
		SendForm sendForm = (SendForm) form;// TODO Auto-generated method stub
		  OpOrders opoders = new OpOrders();
		  OperateDataBase opD=new OperateDataBase();
		  
		String target="adderror";
		//int orderID=new Integer((String)request.getSession(true).getAttribute("orderId"));
		//int orderID=(Integer)request.getSession(true).getAttribute("orderId");
		//System.out.println(orderID);
		
		
		int orderID=sendForm.getOrderID();
	

		
		int warehouseID=Integer.parseInt(sendForm.getWarehouse());
		System.out.println();
	
	
		System.out.println("仓库ID"+warehouseID);
		System.out.println("定单ID"+orderID);
		Ordersentiy  order = opoders.selectordersBYID(orderID);
		warehouse wh=opoders.selectwarehouseBYID(warehouseID);
		String sendtime=sendForm.getSendtime();
		String arrivetime=sendForm.getArrivetime();
		
		
	//	SimpleDateFormat myFormatter = new SimpleDateFormat("yyyy-MM-dd");
		
		//  java.util.Date date1=       myFormatter.parse("2004-12-12");
		//  java.util.Date date2=       myFormatter.parse("2003-12-12");
		//  long   a=((date1.getTime()-date2.getTime())/(24*60*60*1000));
		
		 
		  
		//Date date=new Date(sendForm.getSendtime());
	//	DateFormat df=DateFormat.getDateInstance();
	
		    
		//SimpleDateFormat myFormatter = new SimpleDateFormat("yyyy-MM-dd");
		//java.sql.date date= myFormatter.parse(sendForm.getSendtime()); 
		//myFormatter.p
		
		 
		 
				//java.sql.date  date1
		String status="待发货";
	
	
	
		String warehouse=wh.getWarehouse();
     	warehouse = new String(warehouse.getBytes("iso8859_1"),"GB2312");
		//request.setCharacterEncoding("gb2312");
     	String statuses="terminamed";
        String sqlupdate = "update [order] set status = '"+statuses+"' where ID = "+orderID;
		opD.updateDataBase(sqlupdate);
        String sql ="insert into send(orderID,sendtime,principalID,principal,consignee,arrivetime,status,warehouseID,warehouse) values(";
      sql=sql+orderID+","+"'"+sendtime+"'"+","+order.getPrincipalID()+","+"'"+order.getPrincipal()+"',"+"'"+sendForm.getConsignee()+"',"+"'"+arrivetime+"',"+"'"+status+"',"+warehouseID+",'"+wh.getWarehouse()+"'"+")";
		if(opD.insertsends(sql)>0){target="ok";}
		
		
		
		Opsend  ops=new Opsend();
		ArrayList  listbill=ops.querysendBYID(orderID);
		if(request.getSession().getAttribute("listbill")!=null)
		{request.getSession(true).removeAttribute("listbill");}
		
		
		
		request.getSession(true).setAttribute("listbill", listbill);
		
		 
		return mapping.findForward(target);
		
	}
}