foodorderinfodao.java

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

package com.dao;

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

import com.vo.FoodOrderInfo;

public class FoodOrderInfoDao extends IBaseDaoAdapter {

	//查询食物的所有信息
	public List selectInfo() {
		// TODO 自动生成方法存根
		ArrayList<FoodOrderInfo> list = new ArrayList<FoodOrderInfo>();
		String sql = "select * from foodOrderInfo";
		try {
			pstmt = getConn().prepareStatement(sql);
			rs = pstmt.executeQuery();
			while(rs.next()){
				FoodOrderInfo foodOrder = new FoodOrderInfo();
				foodOrder.setOrderID(rs.getInt(1));
				foodOrder.setCustomerName(rs.getString(2));
				foodOrder.setAddress(rs.getString(3));
				foodOrder.setZipCode(rs.getString(4));
				foodOrder.setTelephone(rs.getString(5));
				foodOrder.setMovePhone(rs.getString(6));
				foodOrder.setNotice(rs.getString(7));
				foodOrder.setTotalPrice(rs.getDouble(8));
				list.add(foodOrder);
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}finally{
			closeAll();
		}
		return list;
	}
	//保存订餐人的信息
	public int insertInfo(FoodOrderInfo orderInfo) {
		// TODO 自动生成方法存根
		int count = 0;
		String sql = "insert into foodOrderInfo values(?,?,?,?,?,?,?)";
		try {
			pstmt = getConn().prepareStatement(sql);
			pstmt.setString(1, orderInfo.getCustomerName());
			pstmt.setString(2, orderInfo.getAddress());
			pstmt.setString(3, orderInfo.getZipCode());
			pstmt.setString(4, orderInfo.getTelephone());
			pstmt.setString(5, orderInfo.getMovePhone());
			pstmt.setString(6, orderInfo.getNotice());
			pstmt.setDouble(7, orderInfo.getTotalPrice());
			count = pstmt.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{	
			closeAll();
		}
		return count;
	}
}