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网上书店项目
共627个文件
gif:181个
class:148个
java:148个
5星 · 超过95%的资源 需积分: 10 314 下载量 51 浏览量
2009-08-08
01:25:38
上传
评论 3
收藏 2.13MB RAR 举报
温馨提示
一个JSP网上书店项目,通过这个项目你可以学习到登录注册、找回密码、购买商品、购物车、订单、搜索商品、修改个人资料、查看订单等。 后台管理可以完成管理用户、管理商品、管理分类(可以添加大类、小类)、添加公告等一些功能,总算完成了此项目,共享给大家。 SQL脚本文件在WEBROOT/WEB-INF/SQL文件夹里。
资源推荐
资源详情
资源评论
收起资源包目录
一个JSP网上书店项目 (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
yinguiyimingyingui
- 粉丝: 18
- 资源: 6
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
- 1
- 2
前往页