goodsbeanbo.java

用MVC实现JSP购物车案例说明详细设计方案

package com.shop.model;
import java.sql.*;
import java.util.ArrayList;

public class GoodsBeanBo {

	private Connection conn;
	private PreparedStatement pstmt;
	private ResultSet rs=null;
	/**
	 * @author 让痛苦痛苦
	 * @return 返回有多少页
	 */
	public int getpageCount(int pageSize){
		
		int rowCount=0;
		int pageCount=0;
		
		try {
			String sql="select count(*) from goods";
			conn=new Conn().getConn();
			pstmt=conn.prepareStatement(sql);
			rs=pstmt.executeQuery();
			if(rs.next())
			{
				rowCount =rs.getInt(1);
				
			}
			if(rowCount%pageSize==0)
			{
				pageCount=rowCount/pageSize;
			}
			else
			{
				pageCount=rowCount/pageSize+1;
			}
			
		} catch (Exception e) {
			e.printStackTrace();
			// TODO: handle exception
		}
		finally
		{
			try {
				rs.close();
				pstmt.close();
				conn.close();
				
			} catch (Exception e) {
				e.printStackTrace();
				// TODO: handle exception
			}
		}
		return pageCount;
	}
	/**
	 * @author 让痛苦痛苦
	 * @return 分页数据
	 */
	
	public ArrayList showGoodsByPage(int pageNow,int pageSize)
	{
		ArrayList al=new ArrayList();
		try {
			String sql="select top "+pageSize+" * from goods where s_id"+
			" not in (select top "+pageSize*(pageNow-1)+" s_id from goods)";
			
			
			conn=new Conn().getConn();
			
			pstmt=conn.prepareStatement(sql);
			
			rs=pstmt.executeQuery();
			
			while(rs.next()){
				GoodsBean gb=new GoodsBean();
				gb.setS_id(rs.getInt(1));
				gb.setS_name(rs.getString(2));
				gb.setS_price(rs.getFloat(3));
				gb.setS_more(rs.getInt(4));
				gb.setS_house(rs.getString(5));
				al.add(gb);
				
			}
			
		} catch (Exception e) {
			e.printStackTrace();
			// TODO: handle exception
		}
		finally
		{
			try {
				rs.close();
				pstmt.close();
				conn.close();
			} catch (Exception e) {
				// TODO: handle exception
			}
			
		}
		return al;
	}
	
	
}