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 web购物网站、SSH架构、SQLserver数据库可以方便地移植到任何数据库上
需积分: 10 178 浏览量
2016-02-20
19:47:58
上传
评论 2
收藏 5.97MB RAR 举报
Java web购物网站、SSH架构、SQLserver数据库可以方便地移植到任何数据库上 （487个子文件） 
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 RegistAction.class 2KB RegistValiAction.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 836B 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
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 dot_shanggan.gif 1KB共 487 条
- 1
- 2
- 3
- 4
- 5
资源评论
zhengwh510
- 粉丝: 64
- 资源: 1981
最新资源
- 人工智能实验四 感知器算法的设计实现
- java小项目多线程多线程 复制文件 冒泡排序 群聊
- 四数之和(java代码).docx
- 701837906919458TapScanner v3.0.10 (Pro).apk
- 青岛大学人工智能实验二 利用α-β搜索的博弈树算法编写一字棋游戏
- ### 1、项目介绍 本项目Scrapy进行数据爬取，并使用Django框架+PyEcharts实现可视化大屏 效果如下：
- # 微信小程序-健康菜谱 基于微信小程序的一个查找检索菜谱的应用 ### 效果 !动态图(./res/gif/demo
- zabbix-get命令包资源
- 289ssm-mysql-jsp 计算机课程实验管理系统.zip（可运行源码+数据库文件+文档）
- 毕业设计，基于PyQt5实现的可视化界面的Python车牌自动识别系统源码
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
