?? orderbookimpl.java
字號:
/* * 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; }}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -