admingoodsbean.java

j2ee框架下的mvc模式的一个网上销售系统

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 AdminGoodsBean extends DBConnection {
	private PreparedStatement pstat = null;

	private ResultSet rs = null;

	private GoodsClass goodsClass;

	private Collection collection;

	public AdminGoodsBean() throws ClassNotFoundException, SQLException {
		super();
		// TODO Auto-generated constructor stub
	}

	// 添加商品
	public void addGoods(GoodsClass goodsClass) {
		String sql = "insert into goods (goodsId,goodsName,goodsmaterial,goodsPackage,goodsLanguage,goodsPrice,goodsCent,goodsScope,goodsPlace,goodsHabitus,sortName) values(?,?,?,?,?,?,?,?,?,?,?)";
		try {
			pstat = con.prepareStatement(sql);
			pstat.setString(1, goodsClass.getGoodsId());
			pstat.setString(2, goodsClass.getGoodsName());
			pstat.setString(3, goodsClass.getGoodsmaterial());
			pstat.setString(4, goodsClass.getGoodsPackage());
			pstat.setString(5, goodsClass.getGoodsLanguage());
			pstat.setFloat(6, goodsClass.getGoodsPrice());
			pstat.setString(7, goodsClass.getGoodsCent());
			pstat.setString(8, goodsClass.getGoodsScope());
			pstat.setString(9, goodsClass.getGoodsPlace());
			pstat.setString(10, goodsClass.getGoodsHabitus());
			pstat.setString(11, goodsClass.getSortName());
			pstat.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	// 按goodsId删除商品
	public void deleteGoods(String goodsId) {
		String sql = "delete from goods where goodsId=?";
		try {
			pstat = con.prepareStatement(sql);
			pstat.setString(1, goodsId);
			pstat.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	// 设置Goods信息
	public void setGoodsInfo(GoodsClass goodsClass) {
		this.goodsClass = goodsClass;
	}

	// 按GoodsId进行查询
	public Collection getGoodsByGoodsId(String goodsId) {
		String sql = "select * from goods where goodsId=?";
		try {
			pstat = con.prepareStatement(sql);
			pstat.setString(1, goodsId);
			rs = pstat.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) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return collection;
	}

	// 按ByGoodsName查询
	public Collection getGoodsByGoodsName(String goodsName) {
		String sql = "select * from goods where goodsName=?";
		try {
			pstat = con.prepareStatement(sql);
			pstat.setString(1, goodsName);
			rs = pstat.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) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return collection;
	}

	// 按GoodsPrice进行查询
	public Collection getGoodsByGoodsPrice(String goodsPrice) {
		float price = Float.parseFloat(goodsPrice);
		String sql = "select * from goods where goodsPrice=?";
		try {
			pstat = con.prepareStatement(sql);
			pstat.setFloat(1, price);
			rs = pstat.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) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return collection;
	}

	// 显示商品种类数
	public int getRowCount() {
		int count = 0;
		String sql = "select * from goods";
		try {
			pstat = con.prepareStatement(sql);
			rs = pstat.executeQuery();
			while (rs.next()) {
				count++;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return count;
	}

	// 显示商品展示页数
	public int getAllPage() {
		int count = 0;
		int page = 0;
		String sql = "select * from goods";
		try {
			pstat = con.prepareStatement(sql);
			rs = pstat.executeQuery();
			while (rs.next()) {
				count++;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		if (count % 10 != 0) {
			return page = (count - count % 10) / 10 + 1;
		} else {
			return page = count / 10;
		}
	}

	// 按页显示全部商品
	public Collection getAllGoods(int pageCount) {
		String sql = "select * from goods";
		try {
			pstat = con.prepareStatement(sql);
			rs = pstat.executeQuery();
			collection = new ArrayList();
			rs.next();
			int n=pageCount*10;
			for(int j=0;j<n;j++)rs.next();
			
			for(int i=0;i<10;i++,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) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return collection;
	}
}