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
当当网 html素材 页面 轮播效果 （627个子文件） 
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 layout.css 20KB 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 template.css 5KB page_bottom.css 3KB public_footer.css 2KB research.css 2KB secBook_Show.css 1KB navi.css 1KB global.css 920B pubsug090107.css 555B Thumbs.db 259KB
ancz081216_button05.gif 25KB product_01.gif 13KB dd_book_right_adver2.gif 12KB product_02.gif 10KB xssj_banner.gif 8KB d_introduce.gif 5KB login_icon_bg_01.gif 4KB cheap4.gif 4KB cheap3.gif 4KB cheap2.gif 4KB cheap1.gif 3KB register_tag_left.gif 3KB dd_scroll_top.gif 3KB dd_logo.gif 3KB register_pic_02.gif 3KB register_tag_right.gif 3KB logo.gif 3KB logo.gif 3KB register_pic_01.gif 3KB register_tag_mid.gif 3KB window_loading.gif 2KB共 627 条
- 1
- 2
- 3
- 4
- 5
- 6
- 7
资源评论
