www.pudn.com > BuyFlowers.rar > AdminGoodsBean.java

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