cartdao.java

JSP+Mysql的网上订餐,用户有增删改除等功能,订单模块

package com.yy.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Map;
import java.util.Set;

import com.yy.bean.CartBean;
import com.yy.bean.FoodBean;
import com.yy.bean.OrderBean;

public class CartDao extends DButils{
	Connection con=null;
	PreparedStatement ps=null;
	ResultSet rs=null;
	String sql;
	public boolean saveOrderInfo(Map map,String oId){
		boolean bool=true;
		try {
			con=this.getDataSource().getConnection();
			sql="insert into shopCart values (?,?,?,?,?)";
			ps=con.prepareStatement(sql);
			Set<Integer> keys=map.keySet();
			for(Integer i:keys){
				FoodBean bean=(FoodBean)map.get(i);
				ps.setString(1,bean.getFoodname());
				ps.setInt(2,bean.getCount());
				ps.setDouble(3,bean.getFoodprice());
				ps.setString(4, oId);
				ps.setInt(5,bean.getId());			
				int num=ps.executeUpdate();
				if(num<=0){
					bool=false;
				}
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			this.closePs();
			this.closeCon();
		}
		return bool;
	}
}