/* * To change this template, choose Tools | Templates * and open the template in the editor. */package com.ebook.impl;import com.ebook.Entity.*;import java.sql.*;import com.ebook.dao.*;import java.util.ArrayList;/** * * @author 隆科 */public class OrderBookImpl implements OrderBookDao {    Connection con;    public OrderBookImpl(Connection con)    {        this.con=con;    }    public void addBookOrder(BookOrder ob) throws Exception    {       PreparedStatement pstm;       String sql="insert into bookorder(Bookid,Num,Orderid) values(?,?,?)";       pstm=con.prepareStatement(sql);       pstm.setInt(1, ob.getBookId());       pstm.setInt(2, ob.getNum());       pstm.setInt(3, ob.getOrderId());       pstm.executeUpdate();    }     public ArrayList getBookOrder(int orderid) throws Exception     {           PreparedStatement pstm;           ArrayList list=new ArrayList();           String sql=" select book.Bookname,bookorder.Bookid,bookorder.Num,bookorder.Orderid from book,bookorder where book.Bookid=bookorder.Bookid and bookorder.Orderid=?";           pstm=con.prepareStatement(sql);           pstm.setInt(1, orderid);           ResultSet rs=pstm.executeQuery();           while(rs.next())           {               OrderItems oitem=new OrderItems();               oitem.setBookname(rs.getString("book.Bookname"));               oitem.setBookid(rs.getInt("bookorder.Bookid"));               oitem.setBooknum(rs.getInt("bookorder.Num"));               oitem.setOrderid(rs.getInt("bookorder.Orderid"));               list.add(oitem);           }           return list;     }}