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;
}
if(type==1) {
//热卖书籍
sql = "select * from tb_book where hostBooks=1 limit "+currentPage+","+pageSize;
}
if(type==2){
//新到书籍
sql = "select * from tb_book where newBooks=1 limit "+currentPage+","+pageSize;
}
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;
}
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.getCon().prepareStatement(sql);
rs = pstmt.executeQuery();
if(rs.next()){
//有相关书籍
while(rs.next()){
Book book = new Book();
book.setBookName(rs.getString("bookName"));
book.setPicture(rs.getString("picture"));
searchList.add(book);
}
}else{
//没有找到相�
JSP基于serverlet网上书店系统 （631个子文件） 
BookDaoImpl.class 16KB AdminOrderDaoImpl.class 13KB UserDaoImpl.class 13KB Model.class 12KB AdminBookDaoImpl.class 10KB AdminInformDaoImpl.class 6KB AdminUserDaoImpl.class 6KB OrderDaoImpl.class 5KB AdminNoteDaoImpl.class 5KB AddBookServlet.class 4KB AdminSubTypeDaoImpl.class 4KB AdminSuperTypeDaoImpl.class 4KB DetailSearch.class 4KB Book.class 4KB AddOrderServlet.class 4KB RandomCodeServlet.class 3KB UpdateUserTrue.class 3KB LoginServlet.class 3KB AdminLoginDaoImpl.class 3KB AdminLoginServlet.class 3KB WordsFilter.class 3KB User.class 3KB HttpReqWrapper.class 3KB RegisterServlet.class 3KB PageSearchServlet.class 3KB ShowSubTypeServlet.class 3KB PageServlet.class 3KB IndexServlet.class 3KB GetSubTypeBySuperTypeId.class 3KB FindUser.class 3KB Cart.class 3KB UpdatePassword.class 3KB AdminLoginListener.class 3KB GetOrderNotSendPagerServlet.class 3KB GetOrderFreezePagerServlet.class 2KB GetBookByBookNameServlet.class 2KB GetOrderSendPagerServlet.class 2KB DeleteNoteServlet.class 2KB GetUserPagerServlet.class 2KB AdminUpdatePassword.class 2KB UserLoginListener.class 2KB GetInformPagerServlet.class 2KB PageNoteServlet.class 2KB GetBookPagerServlet.class 2KB GetNotePagerServlet.class 2KB AddNoteServlet.class 2KB DeleteFreezeOrderServlet.class 2KB AdminSendOrderServlet.class 2KB FreezeOrderServlet.class 2KB DeleteOrderServlet.class 2KB BuyBooksServlet.class 2KB DeleteInformServlet.class 2KB DeleteBookServlet.class 2KB DeleteUserServlet.class 2KB UpdataPwd.class 2KB GetOrderPagerServlet.class 2KB GetSuperType.class 2KB AddSubTypeServlet.class 2KB Order.class 2KB SubTypeDaoImpl.class 2KB AddInformServlet.class 2KB GetAllBookNameServlet.class 2KB AdminLoginFilter.class 2KB AddSuperTypeServlet.class 2KB CheckLogin_Note.class 2KB GetOneUserServlet.class 2KB SuperTypeDaoImpl.class 2KB CheckSuperTypeIsExist.class 2KB CheckNameExist.class 2KB CheckSubTypeIsExist.class 2KB CheckBookNameIsExist.class 2KB CheckISBNIsExist.class 2KB InformDaoImpl.class 2KB SearchServlet.class 2KB ShowAllBooksByType.class 2KB CheckRandomCode.class 2KB OneUserManameServlet.class 2KB GetNotSendOrderServlet.class 2KB GetSendOrderServlet.class 2KB GetOneOrderServlet.class 2KB SonOrder.class 2KB CheckCode.class 2KB UpdateBookCount.class 2KB ShowBookByIdServlet.class 2KB GetOneInformServlet.class 2KB ShowNoteServlet.class 2KB SelectOrder.class 2KB CheckLogin.class 2KB ShowSuperTypeServlet.class 2KB DeleteItemServlet.class 2KB GetAllUserServlet.class 2KB FindAnswer.class 2KB OrderNotSendPager.class 2KB OrderFreezePager.class 2KB OrderSendPager.class 2KB InformPager.class 2KB OrderPager.class 2KB UserPager.class 2KB BookPager.class 2KB NotePager.class 2KB共 631 条
- 1
- 2
- 3
- 4
- 5
- 6
- 7
资源评论
wonka4382012-07-10无法运行，不知道怎样发布
萨宾sabine2015-06-29值得借鉴 大家可以学习一下啊
Fortunately2013-04-23很简单的程序。演示用还行。
咬着布丁的龙猫2013-05-21有很多地方报错，不知道什么问题啊，我自己改一下吧
