orderbookdao.java

在线购物 商品管理 用户管理 购物车 订单管理 权限控制

/**
 * 
 */
package com.qrsx.shop.dao;

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

import com.qrsx.shop.model.Book;
import com.qrsx.shop.model.OrderBook;

/**
 *@Author:李世海	
 *@Address:青岛软件园
 *@Date: Mar 31, 2009
 */
public class OrderBookDAO extends BaseDAO{
	/**
	 * 根据订单编号查询订单明细
	 * @throws SQLException 
	 */
	public List<OrderBook> findById(Integer orderId) throws SQLException{
		String sql = "select * from orderbook where orderId=?";
		ps = conn.prepareStatement(sql);
		ps.setInt(1, orderId);
		ResultSet rs = ps.executeQuery();
		List<OrderBook> list = new ArrayList<OrderBook>();
		while(rs.next()){
			OrderBook orderBook = new OrderBook();
			orderBook.setId(rs.getInt("id"));
			orderBook.setOrderId(rs.getInt("orderId"));
			orderBook.setBookId(rs.getInt("bookId"));
			orderBook.setPrice(rs.getDouble("price"));
			orderBook.setAmount(rs.getInt("amount"));
			BookDAO bookDAO= new BookDAO();
			Book book = bookDAO.findById(orderBook.getBookId());
			orderBook.setBook(book);
			list.add(orderBook);
		}
		return list;
	}
}