图书购物车(session+JAVABean+Servlet)

package com.book.dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.List; import com.book.bean.Book; import com.db.DBCon; public class BookDAOImp implements BookDAO{ DBCon db=new DBCon(); Connection con=null; Statement stmt=null; PreparedStatement pstmt=null; ResultSet rs=null; public BookDAOImp() { super(); } public List<Book> seleceAll() { //查询所有图书信息 List<Book> list=new ArrayList<Book>(); con=db.getConnection(); if(con!=null) { try { stmt=con.createStatement(); String sql="select * from tb_book"; rs=stmt.executeQuery(sql); while(rs.next()) { int bid=rs.getInt(1); String bookname=rs.getString(2); String writer=rs.getString(3); String publisher=rs.getString(4); String pubdate=rs.getString(5); double yprice=rs.getDouble(6); double tprice=rs.getDouble(7); String tupian=rs.getString(8); String pingjia=rs.getString(9); Book b=new Book(); b.setBid(bid); b.setBookname(bookname); b.setPingjia(pingjia); b.setPubdate(pubdate); b.setPublisher(publisher); b.setTprice(tprice); b.setTupian(tupian); b.setWriter(writer); b.setYprice(yprice); list.add(b); } if(rs!=null) rs.close(); if(stmt!=null) stmt.close(); if(con!=null) con.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return list; } public boolean addBook(Book book) { // 添加图书 boolean result=false; con=db.getConnection(); if(con!=null){ String sql="insert into tb_book(bookname,writer,publisher,pubdate,yprice,tprice,tupian,pingjia) values(?,?,?,?,?,?,?,?)"; try { pstmt=con.prepareStatement(sql); pstmt.setString(1, book.getBookname()); pstmt.setString(2, book.getWriter()); pstmt.setString(3, book.getPublisher()); pstmt.setString(4, book.getPubdate()); pstmt.setDouble(5, book.getYprice()); pstmt.setDouble(6, book.getTprice()); pstmt.setString(7, book.getTupian()); pstmt.setString(8, book.getPingjia()); int i=pstmt.executeUpdate(); if(i>0){ result =true; }else{ result=false; } if(pstmt!=null) pstmt.close(); if(con!=null) con.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return result; } public boolean removeBook(int id) { // 根据序号删除图书信息 boolean result=false; con=db.getConnection(); if(con!=null){ String sql="delete from tb_book where bid=?"; try { pstmt=con.prepareStatement(sql); pstmt.setInt(1, id); int i=pstmt.executeUpdate(); if(i>0){ result =true; }else{ result=false; } if(pstmt!=null) pstmt.close(); if(con!=null) con.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return result; } public boolean updateBook(int id,Book book) { // 根据编号修改图书信息 boolean result=false; con=db.getConnection(); if(con!=null){ String sql="update tb_book set bookname=?,writer=?,publisher=?,pubdate=?,yprice=?,tprice=?,pingjia=? where bid=?"; try { pstmt=con.prepareStatement(sql); pstmt.setString(1, book.getBookname()); pstmt.setString(2, book.getWriter()); pstmt.setString(3, book.getPublisher()); pstmt.setString(4, book.getPubdate()); pstmt.setDouble(5, book.getYprice()); pstmt.setDouble(6, book.getTprice()); pstmt.setString(7, book.getPingjia()); pstmt.setInt(8, id); int i=pstmt.executeUpdate(); if(i>0){ result =true; }else{ result=false; } if(pstmt!=null) pstmt.close(); if(con!=null) con.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return result; } public Book getBookbyId(int id) { //根据编号查找图书信息 Book b=new Book(); con=db.getConnection(); if(con!=null){ String sql="select * from tb_book where bid=?"; try { pstmt=con.prepareStatement(sql); pstmt.setInt(1, id); ResultSet rs=pstmt.executeQuery(); while(rs.next()){ b.setBid(rs.getInt(1)); b.setBookname(rs.getString(2)); b.setWriter(rs.getString(3)); b.setPublisher(rs.getString(4)); b.setPubdate(rs.getString(5)); b.setYprice(rs.getDouble(6)); b.setTprice(rs.getDouble(7)); b.setTupian(rs.getString(8)); b.setPingjia(rs.getString(9)); } if(rs!=null) rs.close(); if(pstmt!=null) pstmt.close(); if(con!=null) con.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return b; } }