foodinfodao.java

java网上订餐系统java网上订餐系统java网上订餐系统

package com.dao;

import java.sql.SQLException;
import java.util.List;
import java.util.ArrayList;

import com.vo.FoodInfo;

public class FoodInfoDao extends IBaseDaoAdapter {

	//查询食物信息
	public List selectInfo() {
		// TODO 自动生成方法存根
		ArrayList<FoodInfo> list = new ArrayList<FoodInfo>();
		String sql = "select * from foodInfo";
		try {
			pstmt = getConn().prepareStatement(sql);
			rs = pstmt.executeQuery();
			while(rs.next()){
				FoodInfo food = new FoodInfo();
				food.setFoodID(rs.getString(1));
				food.setFoodName(rs.getString(2));
				food.setRemark(rs.getString(3));
				food.setFoodPrice(rs.getDouble(4));
				food.setDescription(rs.getString(5));
				food.setFoodImage(rs.getString(6));
				list.add(food);
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}finally{
			closeAll();
		}
		return list;
	}
	//根据食物ID查询信息
	public List selectInfo(FoodInfo info) {
		// TODO 自动生成方法存根
		ArrayList<FoodInfo> list = new ArrayList<FoodInfo>();
		String sql = "select * from foodInfo where foodID = ?";
		try {
			pstmt = getConn().prepareStatement(sql);
			pstmt.setString(1, info.getFoodID());
			rs = pstmt.executeQuery();
			while(rs.next()){
				FoodInfo food = new FoodInfo();
				food.setFoodID(rs.getString(1));
				food.setFoodName(rs.getString(2));
				food.setRemark(rs.getString(3));
				food.setFoodPrice(rs.getDouble(4));
				food.setDescription(rs.getString(5));
				food.setFoodImage(rs.getString(6));
				list.add(food);
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}finally{
			closeAll();
		}
		return list;
	}
}