goodsbean.java

来自「Java + Strut写的网上鲜花购物系统」· Java 代码 · 共 537 行 · 第 1/2 页

			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return collection;
	}

	// 低级查询
	public Collection getGoodsByLowerSelect(String searchkey, String anclassid) {
		String m = anclassid;
		String sql = "select * from goods where goodsName like ? and sortName like ?";
		String s = "%" + searchkey + "%";
		try {
			ptst = con.prepareStatement(sql);
			ptst.setString(1, s);
			ptst.setString(2, anclassid);
			rs = ptst.executeQuery();
			collection = new ArrayList();
			while (rs.next()) {
				goodsClass = new GoodsClass();
				goodsClass.setGoodsId(rs.getString("goodsId"));
				goodsClass.setGoodsName(rs.getString("goodsName"));
				goodsClass.setGoodsmaterial(rs.getString("goodsmaterial"));
				goodsClass.setGoodsPackage(rs.getString("goodsPackage"));
				goodsClass.setGoodsLanguage(rs.getString("goodsLanguage"));
				goodsClass.setGoodsPrice(rs.getFloat("goodsPrice"));
				goodsClass.setGoodsCent(rs.getString("goodsCent"));
				goodsClass.setGoodsScope(rs.getString("goodsScope"));
				goodsClass.setGoodsPlace(rs.getString("goodsPlace"));
				goodsClass.setGoodsHabitus(rs.getString("goodsHabitus"));
				goodsClass.setSortName(rs.getString("sortName"));
				collection.add(goodsClass);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return collection;
	}

	public int getAllPageByMaterial(String goodsmaterial) {
		String sql = "select goodsmaterial from goods ;";
		int count = 0;
		int page = 0;
		try {
			ptst = con.prepareStatement(sql);
			rs = ptst.executeQuery();
			while (rs.next()) {
				count++;
			}
		} catch (SQLException e) {

			e.printStackTrace();
		}
		if (count % 16 != 0) {
			page = (count - count % 16) / 16 + 1;
		} else {
			page = count / 16;
		}
		return page;
	}

	public Collection getGoodsByMaterial(String goodsmaterial, int pageCount) {

		String sql = "select * from goods where goodsmaterial like ? ";
		String s = "%" + goodsmaterial + "%";
		try {
			ptst = con.prepareStatement(sql);
			ptst.setString(1, s);
			rs = ptst.executeQuery();
			collection = new ArrayList();
			rs.next();
			int n = pageCount * 16;
			for (int j = 0; j < n; j++)
				rs.next();
			for (int m = 0; m < 16; m++, rs.next()) {
				goodsClass = new GoodsClass();
				goodsClass.setGoodsId(rs.getString("goodsId"));
				goodsClass.setGoodsName(rs.getString("goodsName"));
				goodsClass.setGoodsmaterial(rs.getString("goodsmaterial"));
				goodsClass.setGoodsPackage(rs.getString("goodsPackage"));
				goodsClass.setGoodsLanguage(rs.getString("goodsLanguage"));
				goodsClass.setGoodsPrice(rs.getFloat("goodsPrice"));
				goodsClass.setGoodsCent(rs.getString("goodsCent"));
				goodsClass.setGoodsScope(rs.getString("goodsScope"));
				goodsClass.setGoodsPlace(rs.getString("goodsPlace"));
				goodsClass.setGoodsHabitus(rs.getString("goodsHabitus"));
				goodsClass.setSortName(rs.getString("sortName"));
				collection.add(goodsClass);
			}

		} catch (SQLException e) {

			e.printStackTrace();
		}
		return collection;
	}

	public int getAllPage() {
		int count = 0;
		int page = 0;
		String sql = "select * from goods";
		try {
			ptst = con.prepareStatement(sql);
			rs = ptst.executeQuery();
			while (rs.next()) {
				count++;
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		if (count % 10 != 0) {
			return page = (count - count % 10) / 10 + 1;
		} else {
			return page = count / 10;
		}
	}
}

/*package com.qrsx.buyflowers.beans;

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

public class GoodsBean extends DBConnection {
	private PreparedStatement ptst = null;

	private Collection collection = null;

	private GoodsClass goodsClass;

	private ResultSet rs = null;

	public GoodsBean() throws ClassNotFoundException, SQLException {
		super();
	}

	public void setGoodsInfo(GoodsClass goodsClass) {
		this.goodsClass = goodsClass;
	}

	public Collection getGoodsInfo(String goodsId) {
		String sql = "select * from goods where goodsId=? ";
		collection = new ArrayList();
		try {
			ptst = con.prepareStatement(sql);
			ptst.setString(1, goodsId);
			rs = ptst.executeQuery();
			while (rs.next()) {
				goodsClass = new GoodsClass();
				goodsClass.setGoodsId(rs.getString("goodsId"));
				goodsClass.setGoodsName(rs.getString("GoodsName"));
				goodsClass.setGoodsPackage(rs.getString("goodsPackage"));
				goodsClass.setGoodsmaterial(rs.getString("goodsmaterial"));
				goodsClass.setGoodsLanguage(rs.getString("goodsLanguage"));
				goodsClass.setGoodsPrice(rs.getFloat("goodsPricefrom"));
				goodsClass.setGoodsCent(rs.getString("goodsCent"));
				goodsClass.setGoodsScope(rs.getString("goodsScope"));
				goodsClass.setGoodsPlace(rs.getString("goodsPlace"));
				goodsClass.setGoodsHabitus(rs.getString("goodsHabitus"));
				goodsClass.setSortName(rs.getString("sortName"));
				collection.add(goodsClass);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return collection;
	}

	public Collection getAllPageByPrice(String goodsPrice) {
		String sql = "select * from goods where goodsPrice=?";
		collection = new ArrayList();
		try {
			ptst.setString(1, goodsPrice);
			rs = ptst.executeQuery();
			while (rs.next()) {
				goodsClass = new GoodsClass();
				goodsClass.setGoodsId(rs.getString("goodsId"));
				goodsClass.setGoodsName(rs.getString("GoodsName"));
				goodsClass.setGoodsPackage(rs.getString("goodsPackage"));
				goodsClass.setGoodsmaterial(rs.getString("goodsmaterial"));
				goodsClass.setGoodsLanguage(rs.getString("goodsLanguage"));
				goodsClass.setGoodsPrice(Float.parseFloat(rs.getString("goodsPricefrom")));
				goodsClass.setGoodsCent(rs.getString("goodsCent"));
				goodsClass.setGoodsScope(rs.getString("goodsScope"));
				goodsClass.setGoodsPlace(rs.getString("goodsPlace"));
				goodsClass.setGoodsHabitus(rs.getString("goodsHabitus"));
				goodsClass.setSortName(rs.getString("sortName"));
				collection.add(goodsClass);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return collection;
	}

	public void getGoodsByPrice(String goodsPrice, String pageCount) {
		String sql = "select * from";
	}

	public Collection getAllPageByMaterial(String goodsmaterial) {
		String sql = "select * from goods where goodsmaterial=?";
		collection = new ArrayList();
		try {
			ptst.setString(1, this.goodsClass.getGoodsmaterial());
			rs = ptst.executeQuery();
			while (rs.next()) {
				goodsClass = new GoodsClass();
				goodsClass.setGoodsId(rs.getString("goodsId"));
				goodsClass.setGoodsName(rs.getString("GoodsName"));
				goodsClass.setGoodsPackage(rs.getString("goodsPackage"));
				goodsClass.setGoodsmaterial(rs.getString("goodsmaterial"));
				goodsClass.setGoodsLanguage(rs.getString("goodsLanguage"));
				goodsClass.setGoodsPrice(Float.parseFloat(rs.getString("goodsPricefrom")));
				goodsClass.setGoodsCent(rs.getString("goodsCent"));
				goodsClass.setGoodsScope(rs.getString("goodsScope"));
				goodsClass.setGoodsPlace(rs.getString("goodsPlace"));
				goodsClass.setGoodsHabitus(rs.getString("goodsHabitus"));
				goodsClass.setSortName(rs.getString("sortName"));
				collection.add(goodsClass);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return collection;
	}

	public void getAllPageBySort(String sortName) {
		String sql = "";

	}

	public void getRowCount() {
		String sql = "";

	}

	public Collection getGoodsByHeightSelect(String searchkey, String action,
			String jiage, String anclassid) {
		return collection;
	}

	public Collection getGoodsByLowerSelect(String searchkey, String anclassid) {
		String sql = "select * from goods where goodsName=? and goodsLanguage=?";
		return collection;
	}

	public Collection getGoodsByMaterial(String goodsmaterial, String pageCount) {
		String sql = "select * from goods where goodsmaterial=? and pageCount=?";
		try {
			ptst = con.prepareStatement(sql);
			ptst.setString(1, goodsmaterial);
			ptst.setString(2, pageCount);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		return collection;
	}
}
*/