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

public class TypeDAO {
	OperateDB db=new OperateDB();
	ResultSet rs=null;
	
	public TypeBean GetTypeById(int id)
	{
		TypeBean bean=new TypeBean();
		try
		{
			String sql="select * from TypeGoods where tid="+id;
			rs=db.GetQuery(sql);
			if(rs.next())
			{
				bean.setTid(rs.getInt(1));
				bean.setTname(rs.getString(2));
			}
			
		}
	    catch(Exception ex)
	    {
		   System.out.println("查詢商品的所有的信息出現異常！"+ex.toString());
	    }
	   return bean;		
	}
	public ArrayList<TypeBean> GetTypes()
	{
		ArrayList<TypeBean> list=new ArrayList<TypeBean>();
		try
		{
			
			String sql="select * from TypeGoods";
			rs=db.GetQuery(sql);
			while(rs.next())
			{
				TypeBean bean=new TypeBean();
				bean.setTid(rs.getInt(1));
				bean.setTname(rs.getString(2));
				list.add(bean);				
			}
			
		}
	    catch(Exception ex)
	    {
		   System.out.println("查詢商品的所有的信息出現異常！"+ex.toString());
	    }
	   return list;		
	}

}