orderbookimpl.java

jsp+servlet网上购物,是一个实现mvc的网站

/*
 * 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;
     }
}