shenhedownaction.java

商品管理系统

//Created by MyEclipse Struts
// XSL source (default): platform:/plugin/com.genuitec.eclipse.cross.easystruts.eclipse_4.1.1/xslt/JavaClass.xsl

package com.accp.struts.action;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

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.accp.struts.Bean.DBConnection;
import com.accp.struts.form.ProductForm;

/** 
 * MyEclipse Struts
 * Creation date: 09-09-2007
 * 
 * XDoclet definition:
 * @struts.action path="/shenheDown" name="productForm" scope="request" validate="true"
 */
public class ShenheDownAction extends Action {

	
//		需要下架的所有商品 查找
		public ActionForward execute(
				ActionMapping mapping,
				ActionForm form,
				HttpServletRequest request,
				HttpServletResponse response) {
			
			ProductForm productForm = null;
			
			PreparedStatement psm=null;
			ResultSet rs=null;
			Connection conn=DBConnection.getConnection();
			HttpSession session=request.getSession();
			String sql="select * from producttable1 where state='A0' ";
			try{
				psm=conn.prepareStatement(sql);
				rs=psm.executeQuery();
				ArrayList list=new ArrayList();
				while(rs.next()){
					productForm=new ProductForm();
					productForm.setProduct_id(rs.getString("product_id"));
					productForm.setProduct_name(rs.getString("product_name"));
					productForm.setNew_level(rs.getString("new_level"));
					productForm.setPrice(String.valueOf(rs.getFloat("price")));
					productForm.setStart_date(rs.getString("start_date"));
					productForm.setEnd_date(rs.getString("end_date"));
					productForm.setAddress_picture(rs.getString("address_picture"));
					productForm.setDescription(rs.getString("description"));
					productForm.setShow_main(rs.getString("show_main"));
					productForm.setShow_command(rs.getString("show_command"));
					productForm.setAddress(rs.getString("address"));
					productForm.setMeno(rs.getString("meno"));
					productForm.setCreate_time(rs.getString("create_time"));
					list.add(productForm);
				}
				session.setAttribute("list",list);
				return mapping.findForward("shenheDown");
			}catch(Exception ex){
				System.out.println(ex);
				return mapping.findForward("error");
			}
			
			finally{
					try{
						if(rs!=null) rs.close();
						if(psm!=null) psm.close();
						if(conn!=null) conn.close();
					}catch(SQLException ex){
						System.out.println(ex);
					}
				}
			

		}
	}