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网站书店项目 v1.5_shoppingbook10_1.zip
版权申诉
110 浏览量
2022-04-04
12:47:06
上传
评论
收藏 2.43MB ZIP 举报
[电子商务]完整的JSP网站书店项目 v1.5_shoppingbook10_1.zip （627个子文件） 
BookDaoImpl.class 14KB UserDaoImpl.class 12KB AdminOrderDaoImpl.class 12KB Model.class 12KB AdminBookDaoImpl.class 9KB AdminInformDaoImpl.class 6KB AdminUserDaoImpl.class 5KB OrderDaoImpl.class 5KB AdminNoteDaoImpl.class 4KB AddBookServlet.class 4KB Book.class 4KB DetailSearch.class 4KB AdminSubTypeDaoImpl.class 4KB AdminSuperTypeDaoImpl.class 4KB AddOrderServlet.class 3KB RandomCodeServlet.class 3KB UpdateUserTrue.class 3KB LoginServlet.class 3KB User.class 3KB AdminLoginServlet.class 3KB WordsFilter.class 3KB AdminLoginDaoImpl.class 3KB HttpReqWrapper.class 3KB RegisterServlet.class 3KB ShowSubTypeServlet.class 3KB PageSearchServlet.class 3KB IndexServlet.class 3KB GetSubTypeBySuperTypeId.class 3KB PageServlet.class 3KB Cart.class 2KB AdminLoginListener.class 2KB FindUser.class 2KB GetBookByBookNameServlet.class 2KB UpdatePassword.class 2KB GetOrderNotSendPagerServlet.class 2KB GetOrderFreezePagerServlet.class 2KB UserLoginListener.class 2KB AdminUpdatePassword.class 2KB GetOrderSendPagerServlet.class 2KB GetUserPagerServlet.class 2KB DeleteNoteServlet.class 2KB GetInformPagerServlet.class 2KB PageNoteServlet.class 2KB AddNoteServlet.class 2KB GetNotePagerServlet.class 2KB GetBookPagerServlet.class 2KB Order.class 2KB BuyBooksServlet.class 2KB UpdataPwd.class 2KB DeleteInformServlet.class 2KB GetSuperType.class 2KB DeleteFreezeOrderServlet.class 2KB AdminSendOrderServlet.class 2KB GetOrderPagerServlet.class 2KB FreezeOrderServlet.class 2KB DeleteOrderServlet.class 2KB DeleteUserServlet.class 2KB DeleteBookServlet.class 2KB GetAllBookNameServlet.class 2KB AddSubTypeServlet.class 2KB AdminLoginFilter.class 2KB CheckLogin_Note.class 2KB AddInformServlet.class 2KB AddSuperTypeServlet.class 2KB GetOneUserServlet.class 2KB SubTypeDaoImpl.class 2KB CheckSuperTypeIsExist.class 2KB CheckSubTypeIsExist.class 2KB CheckNameExist.class 2KB CheckBookNameIsExist.class 2KB CheckISBNIsExist.class 2KB InformDaoImpl.class 2KB SuperTypeDaoImpl.class 2KB ShowAllBooksByType.class 2KB OneUserManameServlet.class 2KB CheckRandomCode.class 2KB SearchServlet.class 2KB GetNotSendOrderServlet.class 2KB GetSendOrderServlet.class 2KB GetOneOrderServlet.class 2KB SonOrder.class 2KB CheckCode.class 2KB SelectOrder.class 2KB UpdateBookCount.class 2KB ShowBookByIdServlet.class 2KB GetOneInformServlet.class 2KB ShowSuperTypeServlet.class 2KB CheckLogin.class 2KB GetAllUserServlet.class 2KB ShowNoteServlet.class 2KB DeleteItemServlet.class 2KB OrderNotSendPager.class 2KB OrderFreezePager.class 2KB OrderSendPager.class 2KB InformPager.class 2KB OrderPager.class 2KB NotePager.class 2KB UserPager.class 2KB BookPager.class 2KB FindAnswer.class 2KB共 627 条
- 1
- 2
- 3
- 4
- 5
- 6
- 7
资源评论
芝麻粒儿
- 粉丝: 5w+
- 资源: 2万+
最新资源
- 基于yolov8的人体动作识别检测项目源码.zip
- 自然语言处理大作业-python的汉语词义自动消歧系统源码+报告.zip
- MT管理器_2.15.3-会员功能解锁.apk
- 基于机器学习的共享单车使用量分析与预测
- 基于Python开发的汉语词义自动消歧系统源码+超详细注释+实验报告（95分以上）.zip
- ５１单片机汇编语言音乐盒＋电子琴，ｐｒｏｔｅｕｓ仿真运行正常，开发板实物运行正常 代码都带有注释，方便理解和学习
- Python项目之django疫情数据可视化分析系统（源码 + 说明文档）
- Python项目之django-新生入学管理系统（源码 + 说明文档）
- Flutter积分或金币领取动画
- Python项目之django新生报到服务管理系统（源码 + 说明文档）
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
