shenheaction.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 javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import java.sql.*;
import java.util.ArrayList;

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

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

	//需要上架的所有商品 查找
	public ActionForward execute(
					ActionMapping mapping,
					ActionForm form,
					HttpServletRequest request,
					HttpServletResponse response) {
		
		ProductForm productForm = null;
		
		Connection conn=DBConnection.getConnection();
		
		HttpSession session=request.getSession();
		PreparedStatement psm=null;
		ResultSet rs=null;
		try{
		
			String sql="select * from producttable1 where state='AO'";
			psm=conn.prepareStatement(sql);
			rs=psm.executeQuery();
			ArrayList list=new ArrayList();
			
			while(rs.next()){
				System.out.println("y");
				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.setStore_number(rs.getString("store_number"));
				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);
			System.out.println("没有数据信息");
			return mapping.findForward("shenheUpLoad");
		}catch(Exception ex){
			System.out.println(ex.getMessage());
			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.getMessage());
				}
			}
		

	}
}