oderdaotianjia.java

贯穿案例JSP+JavaBean+Servlet网上订餐系统.希望大家下载下来研究

package com.restrant.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

import com.restrant.entity.FoodBean;
import com.restrant.entity.FoodOderBean;

public class OderDaoTianjia implements OderDao {

	private Connection conn = null;

	private PreparedStatement ps = null;

	int num = 0;

	public int addFoodOders(FoodOderBean fob) {
		String sql = "INSERT INTO foodOrderInfo  VALUES(?,?,?,?,?,?,?)";
		try {
			conn = ConnectionManager.getConnection();
			ps = conn.prepareStatement(sql);
			ps.setString(1, fob.getCustomerName());
			ps.setString(2, fob.getAddress());
			ps.setString(3, fob.getZipCode());
			ps.setString(4, fob.getTelephone());
			ps.setString(5, fob.getMovePhone());
			ps.setString(6, fob.getNotice());
			ps.setFloat(7, fob.getTotalPrice());
			num = ps.executeUpdate();
		} catch (Exception ex) {
			ex.printStackTrace();
		}
		return num;
	}

}