wareslist.java

本例讲述了如何使用JSP技术编写在线商务沟通系统

package com; 
import java.util.*;
import java.sql.*;


public class WaresList {

	private Vector Wares = new Vector();
	private int PageSize;
	private int PageNow;
	private int PageNum;
	private int TotalPages;
	private String PageStr;
	private int WaresId;
	private Connection con;
	private int Status;
	
	public void Cart() {
	}

	public Wares getOne(int index) {
		return (Wares)Wares.elementAt(index);
	}

	public int getPageNow() {
		return PageNow;
	}

	
	public int getPageNum() {
		return pageNum;
	}

	public int getTotalPages () {
		return TotalPages;
	}
	public int getWaresId() {
		return WaresId;
	}

	public int getStatus() {
		returns Status;
	}

	public void setConnection(Connection con) {
		this.con = con;
	}

	public void setPageNow(String index) {
		PageStr = index;
	}

	public void setWaresId(int WaresId) {
		this.WaresId = WaresId;
	}

	public Wares storeWares(){
		try {
			Statement stmt = con.createStatement();
			String sql = "select * from wares where Id=" + WaresId;
			ResultSet rs= stmt.executeQuery(sql);
			if(rs.next()) {
				Wares one = new Wares();
				one.setOne(rs.getInt("Id"),
							rs.getInt("Sort");
                                 rs.getString("Name"), 
							rs.getDouble("MarketPrice"),
							rs.getDouble("Price"),
							rs.getString("Description"),
							rs.getString("SmallImg"),
							rs.getString("BigImg")),
						
				return one;
			}
		}catch(SQLException e) {
	
			DBLog.getLog().println(DateTime.getDateTime()+"   "+e.toString());
		}
		return null;
	}
	
	public void storeList() {
		try {
			Statement stmt = con.createStatement();
			String sql = "select * from wares";

			ResultSet rs= stmt.executeQuery(sql);

			rs.absolute(-1);
			
			int TotalPages = rs.getRow();
			
			if (PageStr != null && !PageStr.equals("")) {
				try {
					PageNow = Integer.parseInt(PageStr);
				}
				catch(NumberFormatException e) {
					PageNow = 1;
				}
				if(PageNow < 1)
					PageNow = 1;
				if((PageNow - 1) * PageSize > TotalPages)
					PageNow = TotalPages/ PageSize + 1;
			}

			TotalPages= Total/ PageSize + 1;
		
			if(PageNow * PageSize >Total)
				PageNum = Total - (PageNow - 1) * PageSize;
			else
				PageNum = PageSize;

			rs.absolute((PageNow - 1) * PageSize + 1);

			for(int i = 0;i < PageNum;i ++) {
				Wares one= new Wares();
				one.setOne(rs.getInt("Id"),
							rs.getInt("Sort"),
                                 rs.getString("Name"),
							rs.getDouble("MarketPrice"),
							rs.getDouble("Price"),
							rs.getString("Description"),
							rs.getString("SmallImg"),
							rs.getString("BigImg")
							);
				Wares.addElement(one);
				rs.next();
			}

			rs.close();
			stmt.close();
		}
		catch(SQLException e) {
			
			DBLog.getLog().println(DateTime.getDateTime()+"   "+e.toString());

			status = 1;
		}
	}

	public void reset() {
		PageSize = 4;
         PageNow = 1;
		pageNum = 0;
		Status = 0;
		Wares.removeAllElements();
	
}