package com.tarena.dao.impl;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.jsp.tagext.TryCatchFinally;
import com.tarena.dao.ProductDAO;
import com.tarena.entity.Book;
import com.tarena.entity.Product;
import com.tarena.util.DBConnection;
public class BookDAOImpl implements ProductDAO {
private final static String FIND_BY_CAT_ID = "select dp.*,db.* "
+ "from d_category_product dcp "
+ "join d_product dp on (dcp.product_id=dp.id) "
+ "join d_book db on (dp.id=db.id) "
+ "where dcp.cat_id=? limit ?,?";
private final static String FIND_BY_ID = "select p.*,b.* "
+ "from d_product p " + "join d_book b " + "on p.id=b.id "
+ "where p.id=?";
private final static String FIND_BY_HOT = "select sum(product_num) as num,p.*,b.* "
+ "from d_item i "
+ "join d_product p "
+ "ON i.product_id=p.id "
+ "JOIN d_book b "
+ "ON i.product_id=b.id "
+ "GROUP BY product_id " + "ORDER BY num desc LIMIT 0,?";
private final static String FIND_BY_NEW = "SELECT p.*,b.* "
+ "FROM d_product p " + "JOIN d_book b " + "ON p.id=b.id "
+ "ORDER BY p.add_time DESC " + "LIMIT 0,?";
private final static String FIND_BY_NEW_HOT = "select sum(product_num) as num,p.*,b.* "
+ "from d_item i "
+ "join d_product p "
+ "ON i.product_id=p.id "
+ "JOIN d_book b "
+ "ON i.product_id=b.id "
+ "WHERE p.add_time>? "
+ "GROUP BY product_id "
+ "ORDER BY num desc LIMIT 0,?";
public List<Product> findByCatId(int cid, int begin, int size)
throws Exception {
List<Product> pros = new ArrayList<Product>();
Connection conn = null;
PreparedStatement prep = null;
ResultSet rs = null;
try {
prep = DBConnection.getConnection()
.prepareStatement(FIND_BY_CAT_ID);
prep.setInt(1, cid);
prep.setInt(2, begin);
prep.setInt(3, size);
rs = prep.executeQuery();
while (rs.next()) {
Book book = new Book();
book.setId(rs.getInt("id"));
book.setProduct_name(rs.getString("product_name"));
book.setFixed_price(rs.getDouble("fixed_price"));
book.setDang_price(rs.getDouble("dang_price"));
book.setProduct_pic(rs.getString("product_pic"));
book.setAdd_time(rs.getLong("add_time"));
book.setAuthor(rs.getString("author"));
book.setPublishing(rs.getString("publishing"));
book.setPublish_time(rs.getLong("publish_time"));
book.setAuthor_summary(rs.getString("author_summary"));
book.setCatalogue(rs.getString("catalogue"));
book.setDescription(rs.getString("description"));
book.setHas_deleted(rs.getInt("has_deleted"));
book.setIsbn(rs.getString("isbn"));
book.setKeywords(rs.getString("keywords"));
book.setPrint_number(rs.getString("print_number"));
book.setPrint_time(rs.getLong("print_time"));
book.setPublishing(rs.getString("publishing"));
book.setTotal_page(rs.getString("total_page"));
book.setWhich_edtion(rs.getString("which_edtion"));
book.setWord_number(rs.getString("word_number"));
pros.add(book);
}
} finally {
DBConnection.close(rs, prep, conn);
}
return pros;
}
public List<Product> findByHot(int num) throws Exception {
Connection conn = null;
PreparedStatement prep = null;
ResultSet rs = null;
List<Product> pros = new ArrayList<Product>();
try {
prep = DBConnection.getConnection().prepareStatement(FIND_BY_HOT);
prep.setInt(1, num);
rs = prep.executeQuery();
while (rs.next()) {
Book book = new Book();
book.setId(rs.getInt("id"));
book.setProduct_name(rs.getString("product_name"));
book.setFixed_price(rs.getDouble("fixed_price"));
book.setDang_price(rs.getDouble("dang_price"));
book.setProduct_pic(rs.getString("product_pic"));
book.setAdd_time(rs.getLong("add_time"));
book.setAuthor(rs.getString("author"));
book.setPublishing(rs.getString("publishing"));
book.setPublish_time(rs.getLong("publish_time"));
book.setAuthor_summary(rs.getString("author_summary"));
book.setCatalogue(rs.getString("catalogue"));
book.setDescription(rs.getString("description"));
book.setHas_deleted(rs.getInt("has_deleted"));
book.setIsbn(rs.getString("isbn"));
book.setKeywords(rs.getString("keywords"));
book.setPrint_number(rs.getString("print_number"));
book.setPrint_time(rs.getLong("print_time"));
book.setPublishing(rs.getString("publishing"));
book.setTotal_page(rs.getString("total_page"));
book.setWhich_edtion(rs.getString("which_edtion"));
book.setWord_number(rs.getString("word_number"));
pros.add(book);
}
} finally {
DBConnection.close(rs, prep, conn);
}
return pros;
}
public Product findById(int id) throws Exception {
Connection conn = null;
PreparedStatement prep = null;
ResultSet rs = null;
Book book = null;
try {
prep = DBConnection.getConnection().prepareStatement(FIND_BY_ID);
prep.setInt(1, id);
rs = prep.executeQuery();
if (rs.next()) {
book = new Book();
book.setId(rs.getInt("id"));
book.setProduct_name(rs.getString("product_name"));
book.setFixed_price(rs.getDouble("fixed_price"));
book.setDang_price(rs.getDouble("dang_price"));
book.setProduct_pic(rs.getString("product_pic"));
book.setAdd_time(rs.getLong("add_time"));
book.setAuthor(rs.getString("author"));
book.setPublishing(rs.getString("publishing"));
book.setPublish_time(rs.getLong("publish_time"));
book.setAuthor_summary(rs.getString("author_summary"));
book.setCatalogue(rs.getString("catalogue"));
book.setDescription(rs.getString("description"));
book.setHas_deleted(rs.getInt("has_deleted"));
book.setIsbn(rs.getString("isbn"));
book.setKeywords(rs.getString("keywords"));
book.setPrint_number(rs.getString("print_number"));
book.setPrint_time(rs.getLong("print_time"));
book.setPublishing(rs.getString("publishing"));
book.setTotal_page(rs.getString("total_page"));
book.setWhich_edtion(rs.getString("which_edtion"));
book.setWord_number(rs.getString("word_number"));
}
} finally {
DBConnection.close(rs, prep, conn);
}
return book;
}
public List<Product> findByNew(int num) throws Exception {
Connection conn = null;
PreparedStatement prep = null;
ResultSet rs = null;
List<Product> pros = new ArrayList<Product>();
try {
prep = DBConnection.getConnection().prepareStatement(FIND_BY_NEW);
prep.setInt(1, num);
rs = prep.executeQuery();
while (rs.next()) {
Book book = new Book();
book.setId(rs.getInt("id"));
book.setProduct_name(rs.getString("product_name"));
book.setFixed_price(rs.getDouble("fixed_price"));
book.setDang_price(rs.getDouble("dang_price"));
book.setProduct_pic(rs.getString("product_pic"));
book.setAdd_time(rs.getLong("add_time"));
book.setAuthor(rs.getString("author"));
book.setPublishing(rs.getString("publishing"));
book.setPublish_time(rs.getLong("publish_time"));
book.setAuthor_summary(rs.getString("author_summary"));
book.setCatalogue(rs.getString("catalogue"));
book.setDescription(rs.getString("description"));
book.setHas_deleted(rs.getInt("has_deleted"));
book.setIsbn(rs.getString("isbn"));
book.setKeywords(rs.getString("keywords"));
book.setPrint_number(rs.getString("print_number"));
book.setPrint_time(rs.getLong("print_time"));
book.setPublishing(rs.getString("publishing"));
book.setTotal_page(rs.getString("total_page"));
book.setWhich_edtion(rs.getString("which_edtion"));
book.setWord_number(rs.getString("word_number"));
pros.add(book);
}
} finally {
DBConnection.close(rs, prep, conn);
}
return pros;
}
public List<Product> findByNewHot(int num, long time) throws Exception {
Connection conn = null;
PreparedStatement prep = null;
ResultSet rs = null;
List<Product> pros = new ArrayList<Product>();
try {
prep = DBConnection.getCo
没有合适的资源?快使用搜索试试~ 我知道了~
网上书城当当网书店_Java实现网上书城项目_
共497个文件
gif:219个
jpg:75个
java:55个
1.该资源内容由用户上传,如若侵权请联系客服进行举报
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
版权申诉
5星 · 超过95%的资源 4 下载量 61 浏览量
2021-10-01
17:08:20
上传
评论 3
收藏 6.98MB RAR 举报
温馨提示
Java实现网上书城项目 包含数据库文件与源代码
资源推荐
资源详情
资源评论
收起资源包目录
网上书城当当网书店_Java实现网上书城项目_ (497个子文件)
BookDAOImpl.class 7KB
UserDAOImpl.class 5KB
SessionCartServiceImpl.class 4KB
ReceiveAddressDAOImpl.class 4KB
Book.class 3KB
OrderSubmitAction.class 3KB
CategoryDAOImpl.class 3KB
BookListAction.class 3KB
DBConnection.class 3KB
CartAction.class 3KB
ImageUtil.class 3KB
Order.class 3KB
CheckCodeAction.class 2KB
Product.class 2KB
RetainTwoNumTag.class 2KB
User.class 2KB
Category.class 2KB
RegistValiAction.class 2KB
RegistAction.class 2KB
CategoryAction.class 2KB
LoginAction.class 2KB
VerifyAction.class 2KB
Item.class 2KB
ReceiveAddress.class 2KB
CategoryDAOTest.class 2KB
HotAction.class 2KB
AddressAction.class 2KB
NewHotAction.class 2KB
NewAction.class 2KB
CartFactory.class 1KB
RecommendAction.class 1KB
OrderConfirmAction.class 1KB
EmailCode.class 1KB
BookViewAction.class 1KB
Test.class 1KB
Md5Code.class 1KB
LoginInterceptor.class 1KB
UserDAOTest.class 1KB
DAOFactory.class 1KB
CartItem.class 999B
BaseAction.class 961B
PageAction.class 928B
OrderDAOImpl.class 621B
ProductDAO.class 610B
CartRefAction.class 571B
LogoutAction.class 524B
CartService.class 491B
AddressFormAction.class 485B
ReceiveAddressDAO.class 435B
ToRegistAction.class 432B
MainAction.class 427B
ToLoginAction.class 426B
CategoryDAO.class 393B
UserDAO.class 368B
OrderDAO.class 246B
.classpath 661B
org.eclipse.wst.common.component 454B
org.eclipse.wst.jsdt.ui.superType.container 49B
book.css 25KB
second.css 20KB
register_login.css 14KB
book_head090107.css 13KB
login.css 13KB
book1.css 11KB
comm_answer.css 10KB
list.css 10KB
shopping_vehicle.css 9KB
shopping_head.css 5KB
booksaleslist.css 5KB
page_bottom.css 3KB
public_footer.css 2KB
research.css 2KB
secBook_Show.css 1KB
navi.css 1KB
pubsug090107.css 555B
部署讲解.docx 665KB
ancz081216_button05.gif 25KB
xssj_banner.gif 8KB
d_introduce.gif 5KB
cheap4.gif 4KB
cheap3.gif 4KB
cheap2.gif 4KB
cheap1.gif 3KB
logo.gif 3KB
logo.gif 3KB
window_loading.gif 2KB
book_logo.gif 2KB
back_window.gif 2KB
title_bg.gif 2KB
pic_myshopping.gif 2KB
butt_balance.gif 2KB
ddb_1.gif 2KB
label3.gif 1KB
book_dangdang.gif 1KB
bang.gif 1KB
ddb_2.gif 1KB
r-r3new.gif 1KB
validate.gif 1KB
validate.gif 1KB
dot_sale.gif 1KB
共 497 条
- 1
- 2
- 3
- 4
- 5
资源评论
- Hypnus20232022-03-28用户下载后在一定时间内未进行评价,系统默认好评。
- Ududjd2022-12-09资源不错,对我启发很大,获得了新的灵感,受益匪浅。
- m0_618685772022-12-06这个资源对我启发很大,受益匪浅,学到了很多,谢谢分享~
- 腾喵就不是喵了吗?2022-05-10用户下载后在一定时间内未进行评价,系统默认好评。
呼啸庄主
- 粉丝: 74
- 资源: 4702
下载权益
C知道特权
VIP文章
课程特权
开通VIP
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- Unity WebGL(IIS)配置pdf文档
- 三菱PLC例程源码电机高低速变换
- 【matlab / python / tkinter / BasicSR】基于EDVR SRCNN FSRCNN 的超分辨率部署
- 3400-CMN3400-VB一款N-Channel沟道SOT23的MOSFET晶体管参数介绍与应用说明
- 336P-VB一款SOT23封装P-Channel场效应MOS管
- untitled0 - 副本.py
- 基于python+opencv开发的图片批量去黑边+裁剪+压缩工具源码+开发文档+实用教程(期末大作业&课设&项目开发)
- 三菱PLC例程源码电镀线程序
- 从PDF文件中读取表格内容并写入到EXCEL文档的pyton小程序
- 3365-VB一款P-Channel沟道SOT23的MOSFET晶体管参数介绍与应用说明
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功