foodorderdao.java

MVC设计+jsp+servlet+sqlserver开发

package com.accp.fan.dao;

import java.sql.SQLException;

import com.accp.fan.db.Basedao;

public class FoodOrderdao extends Basedao {

	public FoodOrderdao() throws ClassNotFoundException, SQLException {

	}

	// 添加订单
	public synchronized int addfoodOrder(String customerName, String address,
			String zipCode, String telephone, String movePhone, String notice,
			double totalPrice) throws ClassNotFoundException, SQLException {
		String sql = "INSERT into foodOrderInfo VALUES(?,?,?,?,?,?,?)";
		Object[] args = new Object[] { customerName, address, zipCode,
				telephone, movePhone, notice, totalPrice };
		super.executeUpdate(sql, args);
		//在这里怎么返回订单编号呢？ 难不成再查询一次？
		int orderID=0;
		orderID++;
		return  orderID;

	}

	// 添加订单项目表
	public void addfoodOrderItem(int orderID, String foodID, int quantity,
			double totalPrice) throws ClassNotFoundException, SQLException {
		String sql = "INSERT into foodOrderItem VALUES(?,?,?,?)";
		Object[] args = new Object[] { orderID, foodID, quantity, totalPrice };
		super.executeUpdate(sql, args);

	}
}