chdlbaction.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.SendBeans;

/** 
 * MyEclipse Struts
 * Creation date: 09-10-2007
 * 
 * XDoclet definition:
 * @struts.action scope="request" validate="true"
 */
public class ChdlbAction 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
		//String warehouse=(String)request.getSession(true).getAttribute("ware");    //获得当前登陆的仓库名称
		//Integer warehouseid = new Integer((String) request.getSession()
		//		.getAttribute("wareID"));  //获得当前登陆的仓库ID
		String name=request.getParameter("name");
		String warehouseID=request.getParameter("warehouseID");
        String warehouse="青岛仓库";
        request.getSession(true).setAttribute("name", name);    //当前登陆的仓库ID和仓库整个过程都有效
        request.getSession(true).setAttribute("wareID", warehouseID);
        request.getSession(true).setAttribute("ware", warehouse);
        Integer warehouseid = new Integer(warehouseID);
        
        
		String target="error";  //此仓库中没有出货单
		Connection conn=null;
		conn=DBConn.getconn();
		PreparedStatement sta=null;
		ResultSet rs=null;
		 String sendlb=CKSql.cksendlbsql;    //发货单列表查询语句,查询没有出库的发货单
		 
         try {
			sta=conn.prepareStatement(sendlb);
			System.out.print(warehouseid);
	         sta.setInt(1, warehouseid.intValue());
	         sta.setString(2, warehouse);
	         sta.setString(3, "否");
             rs=sta.executeQuery();
 
             List alist=new ArrayList();    //存储出货单信息
	         while(rs.next()){
	         	SendBeans sendBeans=new SendBeans();
	         	sendBeans.setID(new Integer(rs.getInt("ID")));
	         	sendBeans.setOrderID(new Integer(rs.getInt("orderID")));
	         	sendBeans.setPrincipalID(new Integer(rs.getInt("principalID")));
	         	sendBeans.setPrincipal(rs.getString("principal"));
	         	sendBeans.setConsignee(rs.getString("consignee"));
	         	sendBeans.setWarehouse(rs.getString("warehouse"));
	         	sendBeans.setWarehouseID(new Integer(rs.getInt("warehouseID")));
	         	sendBeans.setStatus(rs.getString("status"));
	         	alist.add(sendBeans);
	         	
	         	System.out.print(new Integer(rs.getInt("orderID")));
	         	target="success";   //有记录显示
	         }
	         rs.close();
	         sta.close();
	         conn.close();
	         request.setAttribute("ckchdlist", alist);
		} 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);
	}
}