jsp+servlet+javabean开发的购物车

package com.fengjing.store.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.fengjing.store.db.DB; import com.fengjing.store.vo.Book; public class BookDao { //查询全部 @SuppressWarnings("unchecked") public List queryAll(){ Connection conn = null; Statement stmt = null; ResultSet rs = null; List list = null; try { conn = DB.getConnection(); stmt = DB.getStmt(conn); String sql = "select * from titles"; rs = DB.getRs(stmt, sql); list=new ArrayList(); while (rs.next()) { Book book = new Book(); String isbn = rs.getString("isbn"); int isre = rs.getInt("isrecommend"); int subid = rs.getInt("subId"); String title = rs.getString("title"); int ednum = rs.getInt("editionNumber"); String copy = rs.getString("copyright"); int pubid = rs.getInt("publisherID"); double price =rs.getDouble("price"); String imageFile = rs.getString("imageFile"); book.setIsbn(isbn); book.setIsRecommend(isre); book.setSub(new SubCategoryDao().queryById(subid)); book.setTitle(title); book.setEditionNumber(ednum); book.setCopyRight(copy); book.setPrice(price); book.setImageFile(imageFile); list.add(book); } } catch (SQLException e) { // TODO 自动生成 catch 块 e.printStackTrace(); } catch (Exception e) { // TODO 自动生成 catch 块 e.printStackTrace(); }finally{ try { DB.close(conn, stmt, rs); } catch (Exception e) { // TODO 自动生成 catch 块 e.printStackTrace(); } } return list; } public Book queryById(String isbn){ Connection conn = null; PreparedStatement pstmt = null; ResultSet rs = null; Book book = null; try { conn = DB.getConnection(); String sql = "select * from titles where isbn=?"; pstmt = DB.getPstmt(conn, sql); pstmt.setString(1, isbn); rs = pstmt.executeQuery(); if(rs.next()) { book = new Book(); String isb = rs.getString("isbn"); int isre = rs.getInt("isrecommend"); int subid = rs.getInt("subId"); String title = rs.getString("title"); int ednum = rs.getInt("editionNumber"); String copy = rs.getString("copyright"); int pubid = rs.getInt("publisherID"); double price =rs.getDouble("price"); String imageFile = rs.getString("imageFile"); book.setIsbn(isb); book.setIsRecommend(isre); book.setSub(new SubCategoryDao().queryById(subid)); book.setTitle(title); book.setEditionNumber(ednum); book.setCopyRight(copy); book.setPrice(price); book.setImageFile(imageFile); } } catch (SQLException e) { // TODO 自动生成 catch 块 e.printStackTrace(); } catch (Exception e) { // TODO 自动生成 catch 块 e.printStackTrace(); }finally{ try { DB.close(conn, pstmt, rs); } catch (Exception e) { // TODO 自动生成 catch 块 e.printStackTrace(); } } return book; } public int delete(String isbn){ Connection conn = null; Statement stmt = null; int i=0; try { conn = DB.getConnection(); stmt = DB.getStmt(conn); String sql = "delete from titles where isbn='"+isbn+"'"; i = stmt.executeUpdate(sql); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } return i; } public int update(Book book){ Connection conn = null; PreparedStatement pstmt = null; int i = 0; try { conn = DB.getConnection(); String sql="update titles set isrecommend=?,subId=?,title=?,editionNumber=?,copyright=?,imageFile=?,price=? where isbn=? "; pstmt = DB.getPstmt(conn, sql); pstmt.setInt(1,book.getIsRecommend()); pstmt.setInt(2,book.getSub().getSubId()); pstmt.setString(3,book.getTitle()); pstmt.setInt(4,book.getEditionNumber()); pstmt.setString(5, book.getCopyRight()); pstmt.setString(6, book.getImageFile()); pstmt.setDouble(7, book.getPrice()); pstmt.setString(8, book.getIsbn()); i = pstmt.executeUpdate(); } catch (SQLException e) { // TODO 自动生成 catch 块 e.printStackTrace(); } catch (Exception e) { // TODO 自动生成 catch 块 e.printStackTrace(); }finally{ try { DB.close(conn, pstmt); } catch (Exception e) { // TODO 自动生成 catch 块 e.printStackTrace(); } } return i; } public int insert(Book book){ Connection conn = null; PreparedStatement pstmt = null; int i = 0; try { conn = DB.getConnection(); String sql="insert into titles values (?,?,?,?,?,?,?,?,?) "; pstmt = DB.getPstmt(conn, sql); pstmt.setString(1, book.getIsbn()); pstmt.setInt(2, book.getIsRecommend()); pstmt.setInt(3, book.getSub().getSubId()); pstmt.setString(4,book.getTitle()); pstmt.setInt(5,book.getEditionNumber()); pstmt.setString(6, book.getCopyRight()); pstmt.setInt(7, book.getPublisherID()); pstmt.setString(8,book.getImageFile()); pstmt.setDouble(9, book.getPrice()); i = pstmt.executeUpdate(); } catch (SQLException e) { // TODO 自动生成 catch 块 e.printStackTrace(); } catch (Exception e) { // TODO 自动生成 catch 块 e.printStackTrace(); }finally{ try { DB.close(conn, pstmt); } catch (Exception e) { // TODO 自动生成 catch 块 e.printStackTrace(); } } return i; } }