package org.dxc.market.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
import org.dxc.market.entity.Book;
import org.dxc.market.entity.Food;
import org.dxc.market.entity.Product;
import org.dxc.market.entity.Recommend;
import org.dxc.market.util.DBUtil;
public class JdbcProductDAO implements ProductDAO {
private static final String findnew ="select * from d_product where has_deleted=0 order by add_time desc limit 0,?";
private static final String findrecommend =
"select p.id,p.product_name,p.description,p.fixed_price,p.dang_price,p.product_pic,b.author,b.publishing,b.publish_time"+
" from d_product p join d_book b on p.id=b.id where p.has_deleted=0 order by rand() limit 2";
private static final String findBooksByCatId =
"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=? and dp.has_deleted=0 " +
"limit ?,?";
private static final String findHotsale="select * from d_item i join d_product p on i.product_id=p.id group by i.product_id order by sum(i.product_num) desc limit 4";
private static final String fingById="select * from d_product where has_deleted=0 and id=?";
private static final String findNewHot="select *,sum(i.product_num) as num from d_item i join d_product p on i.product_id=p.id where p.has_deleted=0 group by i.product_id order by sum(i.product_num) desc,p.add_time desc limit 8";
private static final String findCountAll="select count(*) from d_product where has_deleted=0";
private static final String BooksOrdeyByAddtimeASC = "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=? and dp.has_deleted=0 "
+ " order by dp.add_time asc limit ?,?";
private static final String BooksOrdeyByAddtimeDESC = "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=? and dp.has_deleted=0 "
+ " order by dp.add_time desc limit ?,?";
private static String findAllProduct ="select * from d_product where has_deleted=0 limit ?,?";
private static String delProductById="update d_product set has_deleted=1 where id=?";
private static String findByProductId="select * from d_Product dp join d_book db on dp.id=db.id where dp.id=? and dp.has_deleted=0 ";
private static String findFoodById="select * from d_Product dp join d_food df on dp.id=df.id where dp.id=? and dp.has_deleted=0 ";
private static final String BooksOrdeyBySaleDESC = "select * from d_item di join (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=? ) dpb on (di.product_id=db.id) " +
"where dp.has_deleted=0 "
+ " order by sum(di.product_num) desc limit ?,?";
private static final String BooksOrdeyByPricetimeASC = "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=? and dp.has_deleted=0 "
+ " order by dp.dang_price asc limit ?,?";
private static final String search="select * from d_product where has_deleted=0 and product_name like ?";
private static final String findFoodsByCatId =
"select dp.*,db.* " +
"from d_category_product dcp " +
"join d_product dp on (dcp.product_id=dp.id) " +
"join d_food db on(dp.id=db.id) " +
"where dcp.cat_id=? and dp.has_deleted=0 " +
"limit ?,?";
private static final String FoodsOrdeyByAddtimeASC = "select dp.*,db.* "
+ "from d_category_product dcp "
+ " join d_product dp on(dcp.product_id = dp.id) "
+ " join d_food db on(dp.id=db.id) "
+ " where dcp.cat_id=? and dp.has_deleted=0 "
+ " order by dp.add_time asc limit ?,?";
private static final String FoodsOrdeyByAddtimeDESC = "select dp.*,db.* "
+ "from d_category_product dcp "
+ " join d_product dp on(dcp.product_id = dp.id) "
+ " join d_food db on(dp.id=db.id) "
+ " where dcp.cat_id=? and dp.has_deleted=0 "
+ " order by dp.add_time desc limit ?,?";
private static final String FoodsOrdeyBySaleDESC = "select * from d_item di join (select dp.*,db.* "
+ "from d_category_product dcp "
+ " join d_product dp on(dcp.product_id = dp.id) "
+ " join d_food db on(dp.id=db.id) "
+ " where dcp.cat_id=? ) dpb on (di.product_id=db.id) "+
"where dp.has_deleted=0 "
+ " order by sum(di.product_num) desc limit ?,?";
private static final String FoodsOrdeyByPricetimeASC = "select dp.*,db.* "
+ "from d_category_product dcp "
+ " join d_product dp on(dcp.product_id = dp.id) "
+ " join d_food db on(dp.id=db.id) "
+ " where dcp.cat_id=? and dp.has_deleted=0 "
+ " order by dp.dang_price asc limit ?,?";
//查找最新商品
public List<Product> findNew(int size) throws Exception {
List<Product> lists=new ArrayList<Product>();
Connection conn=DBUtil.getConnection();
PreparedStatement prep=conn.prepareStatement(findnew);
prep.setInt(1, size);
ResultSet rst=prep.executeQuery();
while(rst.next()){
Product pro=new Product();
pro.setId(rst.getInt("id"));
pro.setProductName(rst.getString("product_name"));
pro.setDescription(rst.getString("description"));
pro.setAddTime(rst.getLong("add_time"));
pro.setFixedPrice(rst.getDouble("fixed_price"));
pro.setDangPrice(rst.getDouble("dang_price"));
pro.setKeywords(rst.getString("keywords"));
pro.setHasDeleted(rst.getInt("has_deleted"));
pro.setProductPic(rst.getString("product_pic"));
lists.add(pro);
}
DBUtil.closeConnection();
return lists;
}
//查找推荐商品
public List<Recommend> findRecommend() throws Exception {
List<Recommend> lists=new ArrayList<Recommend>();
Connection conn=DBUtil.getConnection();
PreparedStatement prep=conn.prepareStatement(findrecommend);
ResultSet rst=prep.executeQuery();
while(rst.next()){
Recommend rec=new Recommend();
rec.setId(rst.getInt("id"));
rec.setProductName(rst.getString("product_name"));
rec.setAuthor(rst.getString("author"));
rec.setDescription(rst.getString("description"));
rec.setPublishing(rst.getString("publishing"));
rec.setPublishTime(rst.getLong("publish_time"));
rec.setFixedPrice(rst.getDouble("fixed_price"));
rec.setDangPrice(rst.getDouble("dang_price"));
rec.setProductPic(rst.getString("product_pic"));
//System.out.println(rec.getFixedPrice());
lists.add(rec);
}
DBUtil.closeConnection();
return lists;
}
//通过cid查找商品
public List<Book> findBooksByCatid(int cid,int page,int pageSize) throws Exception {
Connection conn = DBUtil.getConnection();
PreparedStatement prep =
conn.prepareStatement(findBooksByCatId);
prep.setInt(1, cid);
int begin = (page-1)*pageSize;
prep.setInt(2, begin);
prep.setInt(3, pageSize);
ResultSet rs = prep.executeQuery();
List<Book> lists = new ArrayList<Book>();
while(rs.next()){
Book pro = new Book();
pro.setId(rs.getInt("id"));
pro.setProductName(rs.getString("product_name"));
pro.setDescription(rs.getString("description"));
pro.setAddTime(rs.getLong("add_time"));
pro.setFixedPrice(rs.getDouble("fixed_price"));
pro.setDangPrice(rs.getDouble("dang_price"));
pro.setKeywords(rs.getString("keywords"));
pro.setHasDeleted(rs.getInt("has_deleted"));
pro.setProductPic(rs.getString("product_pic"));
pro.setAuthor(rs.getString("author"));
p
网上超市系统，模拟当当网界面，网店系统，有订单、商品分类展示功能 （647个子文件） 
updatePwd.jsp.bak 4KB .project.bak 1KB JdbcProductDAO.class 19KB JdbcAdminDAO.class 10KB JdbcOrderDAO.class 8KB JdbcUserDAO.class 6KB ListAction.class 5KB OrderOkAction.class 5KB SaveProAction.class 5KB CartServiceImpl.class 5KB SaveFoodAction.class 4KB JdbcCommentDAO.class 3KB ImageUtil.class 3KB Book.class 3KB JdbcCategoryDAO.class 3KB Product.class 3KB AccountAction.class 3KB UpdateOrderAction.class 3KB Order.class 3KB CookieUtil.class 3KB User.class 3KB CartItemAction.class 3KB AllProAction.class 2KB SaveCommentAction.class 2KB DBUtil.class 2KB ProductManageAction.class 2KB ModifyAction.class 2KB Recommend.class 2KB UpdatePwdAction.class 2KB Category.class 2KB MyOrderAction.class 2KB SearchAction.class 2KB ImageCodeAction.class 2KB CheckVerifyCodeAction.class 2KB DelAction.class 2KB Item.class 2KB BaseAction.class 2KB CheckIsVerifyAction.class 2KB LoadAddressAction.class 2KB LoginAction.class 2KB OrderInfoAction.class 2KB RecoverAction.class 2KB AdminLoginAction.class 2KB MainServiceImpl.class 2KB RegisterAction.class 2KB GetAddressAction.class 2KB ReceiveAddress.class 2KB Food.class 2KB CartFactory.class 2KB AddCartAction.class 2KB EncryptUtil.class 2KB ProductDAO.class 2KB VerifyAction.class 2KB LoadProductAction.class 2KB FoodDetailAction.class 2KB OrderDetailAction.class 2KB Comment.class 2KB EmailUtil.class 1KB ManageUserAction.class 1KB ModifyOrderAction.class 1KB NewProAction.class 1KB ShowCommentAction.class 1KB NewHotAction.class 1KB AddAdminAction.class 1KB BookDetailAction.class 1KB CategoryAction.class 1KB CheckEmailAction.class 1KB OrderInfoAction.class 1KB ModifyAction.class 1KB CheckCodeAction.class 1KB RecommendAction.class 1KB CheckLoginInterceptor.class 1KB AdminDAO.class 1KB FileUtil.class 1KB HotSaleAction.class 1KB Admin.class 1KB RecordAction.class 1KB DelOrderAction.class 1KB DelProductAction.class 1KB ApplicationAction.class 1KB OrderDAO.class 1KB CartItem.class 1020B TransactionInterceptor.class 1018B DelUserAction.class 1018B Test.class 924B A.class 916B PayAction.class 889B CategoryProduct.class 889B VerifyUtil.class 809B UserDAO.class 680B CartService.class 644B AdminExitAction.class 589B ExitAction.class 573B Constant.class 511B CommentDAO.class 470B CategoryDAO.class 446B OrderServiceImpl.class 362B MainService.class 297B OrderService.class 128B .classpath 1KB共 647 条
- 1
- 2
- 3
- 4
- 5
- 6
- 7
资源评论
