基于MVC的购物车系统

package com.lovo.cq.shopping10_1.daoimpl; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Date; import java.util.List; import com.lovo.cq.shopping10_1.common.DbUtil; import com.lovo.cq.shopping10_1.dao.BookDao; import com.lovo.cq.shopping10_1.po.Book; import com.lovo.cq.shopping10_1.po.Page; import com.lovo.cq.shopping10_1.po.User; public class BookDaoImpl implements BookDao { /** * 显示书籍 * @param type 显示类别（热卖，新书，降价,特别推荐） * @param flag 表示是否是（热卖，新书，降价） */ public List showBooks(int type,int flag){ List all = new ArrayList(); PreparedStatement pstmt = null; DbUtil dbUtil = null; ResultSet rs = null; String sql = null; if(type==0){ //显示所有书籍 sql = "select * from tb_book"; try { dbUtil = new DbUtil(); pstmt = dbUtil.getCon().prepareStatement(sql); rs = pstmt.executeQuery(); while(rs.next()) { Book book = new Book(); book.setBookId(rs.getInt("bookId")); book.setBookName(rs.getString("bookName")); book.setISBN(rs.getString("ISBN")); book.setPages(rs.getInt("pages")); book.setAuthor(rs.getString("author")); book.setPublisher(rs.getString("publisher")); book.setIntroduce(rs.getString("introduce")); book.setPrice(rs.getFloat("price")); book.setNowPrice(rs.getFloat("nowPrice")); book.setPicture(rs.getString("picture")); all.add(book); } } catch (SQLException e) { e.printStackTrace(); }finally { try { rs.close(); pstmt.close(); dbUtil.close(); } catch (SQLException e) { e.printStackTrace(); } } }else { if(type==1) { //热卖书籍 sql = "select * from tb_book where hostBooks=?"; } if(type==2){ //新到书籍 sql = "select * from tb_book where newBooks=?"; } if(type==3){ //打折书籍 sql = "select * from tb_book where saleBooks=?"; } if(type==4){ //特别推荐 sql = "select * from tb_book where specialBooks=?"; } try { dbUtil = new DbUtil(); pstmt = dbUtil.getCon().prepareStatement(sql); pstmt.setInt(1, flag); rs = pstmt.executeQuery(); while(rs.next()) { Book book = new Book(); book.setBookId(rs.getInt("bookId")); book.setBookName(rs.getString("bookName")); book.setISBN(rs.getString("ISBN")); book.setPages(rs.getInt("pages")); book.setAuthor(rs.getString("author")); book.setPublisher(rs.getString("publisher")); book.setIntroduce(rs.getString("introduce")); book.setPrice(rs.getFloat("price")); book.setNowPrice(rs.getFloat("nowPrice")); book.setPicture(rs.getString("picture")); all.add(book); } } catch (SQLException e) { e.printStackTrace(); }finally { try { rs.close(); pstmt.close(); dbUtil.close(); } catch (SQLException e) { e.printStackTrace(); } } } return all; } /** * 根据书的BookId号来展示该书的详细信息 * @param bookId 书籍号 * @return Book */ public Book showBookById(int bookId){ Book book = new Book(); PreparedStatement pstmt = null; ResultSet rs = null; DbUtil dbUtil = null; String sql = "select * from tb_book where bookId=?"; try { dbUtil = new DbUtil(); pstmt = dbUtil.getCon().prepareStatement(sql); pstmt.setInt(1, bookId); rs = pstmt.executeQuery(); if(rs.next()){ book.setBookId(rs.getInt("bookId")); book.setBookName(rs.getString("bookName")); book.setIntroduce(rs.getString("introduce")); book.setISBN(rs.getString("ISBN")); book.setAuthor(rs.getString("author")); book.setPages(rs.getInt("pages")); book.setPublisher(rs.getString("publisher")); book.setPrice(rs.getFloat("price")); book.setNowPrice(rs.getFloat("nowPrice")); book.setPicture(rs.getString("picture")); } } catch (SQLException e) { e.printStackTrace(); }finally { try { rs.close(); pstmt.close(); dbUtil.close(); } catch (SQLException e) { e.printStackTrace(); } } return book; } /** * 将书本信息录入数据库 */ public boolean addBook(Book book){ boolean flag = false; PreparedStatement pstmt = null; DbUtil dbUtil = null; String sql = "insert into tb_book values(null,?,?,?,?,?,?,?,?,?,?,?,null,?,?,?,?)"; try { dbUtil = new DbUtil(); pstmt = dbUtil.getCon().prepareStatement(sql); pstmt.setInt(1, book.getSuperTypeId()); pstmt.setInt(2, book.getSubTypeId()); pstmt.setString(3, book.getBookName()); pstmt.setString(4, book.getISBN()); pstmt.setString(5, book.getIntroduce()); pstmt.setFloat(6, book.getPrice()); pstmt.setFloat(7, book.getNowPrice()); pstmt.setString(8, book.getPicture()); pstmt.setInt(9, book.getPages()); pstmt.setString(10, book.getPublisher()); pstmt.setString(11, book.getAuthor()); pstmt.setInt(12, book.getNewBooks()); pstmt.setInt(13, book.getSaleBooks()); pstmt.setInt(14, book.getHostBooks()); pstmt.setInt(15, book.getBookNum()); int i = pstmt.executeUpdate(); if(i != 0){ //插入书籍成功 return flag; } } catch (SQLException e) { e.printStackTrace(); } return flag; } /** * 分页显示书籍 * @param type 按要求显示相应的书籍 * @param currentPage 显示出来的当前页码 * @param pageSize 每页显示数目 * @return Page */ public Page doPage(int type,int currentPage,int pageSize){ Page page = new Page(); System.out.println("pagetype="+type); int totalNum = showBooks(type,1).size(); System.out.println("totalNum"+totalNum); List pageList = new ArrayList(); PreparedStatement pstmt = null; ResultSet rs = null; DbUtil dbUtil = null; String sql = null; if(type==0){//显示所有书籍 sql = "select * from tb_book limit "+currentPage+","+pageSize; //sql ="SELECT TOP pageSize * FROM tb_book WHERE (bookId NOT IN (SELECT TOP currentPage bookId FROM tb_book ORDER BY bookId)) ORDER BY bookId "; } if(type==1) { //热卖书籍 sql = "select * from tb_book where hostBooks=1 limit "+currentPage+","+pageSize; //sql = "select * from tb_book where hostBooks=1 "; } if(type==2){ //新到书籍 sql = "select * from tb_book where newBooks=1 limit "+currentPage+","+pageSize; //sql = "select * from tb_book where newBooks=1"; } if(type==3){ //打折书籍 sql = "select * from tb_book where saleBooks=1 limit "+currentPage+","+pageSize; } if(type==4){ //特别推荐 sql = "select * from tb_book where specialBooks=1 limit "+currentPage+","+pageSize; //sql = "select * from tb_book where specialBooks=1"; } System.out.println("sql="+sql); try { dbUtil = new DbUtil(); pstmt = dbUtil.getCon().prepareStatement(sql); rs = pstmt.executeQuery(); while(rs.next()){ Book book = new Book(); book.setBookId(rs.getInt("bookId")); book.setBookName(rs.getString("bookName")); book.setPicture(rs.getString("picture")); book.setPrice(rs.getFloat("price")); book.setNowPrice(rs.getFloat("nowPrice")); pageList.add(book); } System.out.println("pageList="+pageList.size()); } catch (SQLException e) { e.printStackTrace(); }finally { try { rs.close(); pstmt.close(); dbUtil.close(); } catch (SQLException e) { e.printStackTrace(); } } page.setPageList(pageList); page.setTotalNum(totalNum); return page; } /** * 根据用户输入的关键字搜索相关书籍 * @param keywords 用户输入的关键字 */ public List searchBooks(String keywords){ List searchList = new ArrayList(); PreparedStatement pstmt = null; ResultSet rs = null; DbUtil dbUtil = null; String sql = "select * from tb_book where bookName like '%"+keywords+"%'"; try { dbUtil = new DbUtil(); pstmt = dbUtil.