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
基于JSP的当当购书网源码 （488个子文件） 
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共 488 条
- 1
- 2
- 3
- 4
- 5
资源评论
