goodsdao.java

来自「点餐系统 非常好的 jsp mysql 我也是别人那里下载来的」· Java 代码 · 共 88 行

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;
		
	}
}