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简单书店项目完整包
共629个文件
gif:181个
java:148个
class:148个
需积分: 9 17 下载量 31 浏览量
2010-06-04
12:30:50
上传
评论
收藏 1.84MB RAR 举报
温馨提示
大撒旦阿斯顿阿斯顿啊是反对四国富商大贾多方式古风的古风的古风的各地方各地方
资源推荐
资源详情
资源评论
收起资源包目录
jsp简单书店项目完整包 (629个子文件)
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
BuyBooksServlet.class 2KB
Order.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
CheckNameExist.class 2KB
CheckSubTypeIsExist.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
UserPager.class 2KB
BookPager.class 2KB
NotePager.class 2KB
FindAnswer.class 2KB
共 629 条
- 1
- 2
- 3
- 4
- 5
- 6
- 7
资源评论
shell731
- 粉丝: 0
- 资源: 1
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功