orderdao.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.ArrayList;
import java.util.List;

import com.yy.bean.OrderBean;

public class OrderDao extends DButils{
	Connection con=null;
	PreparedStatement ps=null;
	ResultSet rs=null;
	String sql;
	public boolean addOrderPerson(OrderBean order){
		boolean bool=false;
		try {
			con=this.getDataSource().getConnection();
			sql="insert into foodOrderInfo values (?,?,?,?,?,?,?,?,?)";
			ps=con.prepareStatement(sql);
			ps.setString(1, order.getFoodId());
			ps.setString(2,order.getCustomerName() );
			ps.setString(3,order.getAddress());
			ps.setString(4,order.getZipCode());
			ps.setString(5,order.getTelephone());
			ps.setString(6,order.getMovPhone());
			ps.setString(7,order.getSend());
			ps.setString(8,order.getNotice());
			ps.setInt(9, order.getUId());
			int num=ps.executeUpdate();
			if(num>0){
				bool=true;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			this.closePs();
			this.closeCon();
		}
		return bool;
	}
	public List getOrderPerson(){
		List list=new ArrayList();
		try {
			con=this.getDataSource().getConnection();
			sql="select * from foodOrderInfo";
			ps=con.prepareStatement(sql);
			rs=ps.executeQuery();
			while(rs.next()){
				OrderBean bean=new OrderBean();
				bean.setFoodId(rs.getString("foodId"));
				bean.setMovPhone(rs.getString("movPhone"));
				bean.setAddress(rs.getString("address"));
				bean.setCustomerName(rs.getString("customerName"));
				bean.setNotice(rs.getString("notice"));
				bean.setSend(rs.getString("send"));
				bean.setTelephone(rs.getString("telephone"));
				bean.setZipCode(rs.getString("zipCode"));
				bean.setUId(rs.getInt("uId"));
				list.add(bean);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			this.closeRs();
			this.closePs();
			this.closeCon();
		}
		return list;
	}

}