package DAO;
import Entity.GoodsBean;
import java.util.*;
import java.sql.*;

public class GoodsDAO {
	OperateDB db=new OperateDB();
	ResultSet rs=null;
	TypeDAO td=new  TypeDAO();
	
	public ArrayList<GoodsBean> GetAllGoodsByTypeId(int typeid)
	{	
		ArrayList<GoodsBean> list=new ArrayList<GoodsBean>();
		try{
			String sql="select * from goods where gtype="+typeid;
			System.out.println("查詢商品的所有的信息sql=！"+sql);			
			rs=db.GetQuery(sql);			
			while(rs.next())
			{			
				GoodsBean bean=new GoodsBean();
				bean.setGid(rs.getInt(1));
				bean.setGname(rs.getString(2));
				bean.setGprice(rs.getFloat(3));
				bean.setGtype(td.GetTypeById(rs.getInt(4)));			
				bean.setGimage(rs.getString(5));
				bean.setGremark(rs.getString(6));
				
				list.add(bean);				
					
			}
				
			
		}catch(Exception ex)
		{
			System.out.println("查詢商品的所有的信息出現異常！"+ex.toString());
		}
		return list;
	
	}
	public GoodsBean GetGoodsById(int gid)
	{
		 GoodsBean bean=new GoodsBean();
		try {
			String sql="select * from goods where gid="+gid;
			rs=db.GetQuery(sql);
			if(rs.next())
			{
				bean.setGid(rs.getInt(1));
				bean.setGname(rs.getString(2));
				bean.setGprice(rs.getFloat(3));
				bean.setGtype(td.GetTypeById(rs.getInt(4)));			
				bean.setGimage(rs.getString(5));
				bean.setGremark(rs.getString(6));
			}
			
		} catch (Exception e) {
			System.out.println("根據商品編號查詢商品出現異常！"+e.toString());
		}
		return bean;
		
	}
	public ArrayList<GoodsBean> Search(String sql)
	{
		ArrayList<GoodsBean> list=new ArrayList<GoodsBean>();
		try {
			rs=db.GetQuery(sql);
			while(rs.next())
			{
				GoodsBean bean=new GoodsBean();
				bean.setGid(rs.getInt(1));
				bean.setGname(rs.getString(2));
				bean.setGprice(rs.getFloat(3));
				bean.setGtype(td.GetTypeById(rs.getInt(4)));			
				bean.setGimage(rs.getString(5));
				bean.setGremark(rs.getString(6));
				list.add(bean);
				
			}
			
		} catch (Exception e) {
			System.out.println("模糊查詢商品異常！"+e.toString());
			
		}
		return list;
		
	}
}