package com.tarena.dao.impl;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
import com.tarena.dao.ProductDAO;
import com.tarena.entity.Page;
import com.tarena.entity.Product;
import com.tarena.util.JdbcUtil;
public class ProductDAOImpl implements ProductDAO {
/**
*查询推荐的书
*/
public List<Product> queryCommandProduct() {
Connection conn = null;
PreparedStatement prep = null;
ResultSet rst = null;
List<Product> products = new ArrayList<Product>();
try {
conn = JdbcUtil.getConnection();
String sql = "select id,product_no,product_name,product_price,product_dangdang_price,"
+ "product_author,product_publish,"
+ "product_desc,product_date,product_isbn,product_amount,product_state,product_pic,"
+ "command,amount,shangjia_date,categroy_id,rownum " +
"from t_product_qbc " +
"where command = 'y' and rownum <= 2 ";
prep = conn.prepareStatement(sql);
rst = prep.executeQuery();
while (rst.next()) {
Product product = new Product();
product.setId(rst.getInt(1));
product.setProductNo(rst.getString(2));
product.setProductName(rst.getString(3));
product.setProductPrice(rst.getDouble(4));
product.setProductDangPrice(rst.getDouble(5));
product.setProductAuthor(rst.getString(6));
product.setProductPublish(rst.getString(7));
product.setProductDesc(rst.getString(8));
product.setProductDate(rst.getDate(9));
product.setProductIsbn(rst.getString(10));
product.setProductAmount(rst.getInt(11));
product.setProductState(rst.getString(12));
product.setProductPic(rst.getString(13));
product.setCommand(rst.getString(14));
product.setAmount(rst.getInt(15));
product.setShangJiaDate(rst.getDate(16));
product.setCategroyId(rst.getInt(17));
products.add(product);
}
return products;
} catch (Exception e) {
e.printStackTrace();
return null;
}
}
/**
* 查存热卖的书
*
*/
public List<Product> queryHotProduct() {
Connection conn = null;
PreparedStatement prep = null;
ResultSet rst = null;
List<Product> products = new ArrayList<Product>();
try {
conn = JdbcUtil.getConnection();
String sql = "select id,product_no,product_name,product_price,product_dangdang_price,"
+ "product_author,product_publish,"
+ "product_desc,product_date,product_isbn,product_amount,product_state,product_pic,"
+ "command,amount,shangjia_date,categroy_id ,rownum " +
"from (select * from t_product_qbc p order by amount desc) " +
"where rownum <= 4";
prep = conn.prepareStatement(sql);
rst = prep.executeQuery();
while (rst.next()) {
Product product = new Product();
product.setId(rst.getInt(1));
product.setProductNo(rst.getString(2));
product.setProductName(rst.getString(3));
product.setProductPrice(rst.getDouble(4));
product.setProductDangPrice(rst.getDouble(5));
product.setProductAuthor(rst.getString(6));
product.setProductPublish(rst.getString(7));
product.setProductDesc(rst.getString(8));
product.setProductDate(rst.getDate(9));
product.setProductIsbn(rst.getString(10));
product.setProductAmount(rst.getInt(11));
product.setProductState(rst.getString(12));
product.setProductPic(rst.getString(13));
product.setCommand(rst.getString(14));
product.setAmount(rst.getInt(15));
product.setShangJiaDate(rst.getDate(16));
product.setCategroyId(rst.getInt(17));
products.add(product);
}
return products;
} catch (Exception e) {
e.printStackTrace();
return null;
}
}
/**
* 查询新上架的书，365天以内为新书
*/
public List<Product> queryNewProduct() {
Connection conn = null;
PreparedStatement prep = null;
ResultSet rst = null;
List<Product> products = new ArrayList<Product>();
try {
conn = JdbcUtil.getConnection();
String sql = "select id,product_no,product_name,product_price,product_dangdang_price,"
+ "product_author,product_publish,"
+ "product_desc,product_date,product_isbn,product_amount,product_state,product_pic,"
+ "command,amount,shangjia_date,categroy_id,rownum " +
"from t_product_qbc " +
"where sysdate - shangjia_date <=365 and rownum <=4 order by shangjia_date ";
prep = conn.prepareStatement(sql);
rst = prep.executeQuery();
while (rst.next()) {
Product product = new Product();
product.setId(rst.getInt(1));
product.setProductNo(rst.getString(2));
product.setProductName(rst.getString(3));
product.setProductPrice(rst.getDouble(4));
product.setProductDangPrice(rst.getDouble(5));
product.setProductAuthor(rst.getString(6));
product.setProductPublish(rst.getString(7));
product.setProductDesc(rst.getString(8));
product.setProductDate(rst.getDate(9));
product.setProductIsbn(rst.getString(10));
product.setProductAmount(rst.getInt(11));
product.setProductState(rst.getString(12));
product.setProductPic(rst.getString(13));
product.setCommand(rst.getString(14));
product.setAmount(rst.getInt(15));
product.setShangJiaDate(rst.getDate(16));
product.setCategroyId(rst.getInt(17));
products.add(product);
}
return products;
} catch (Exception e) {
e.printStackTrace();
return null;
}
}
/**
* 通过id得到商品
*
*/
public Product findById(int id) {
Connection conn = null;
PreparedStatement prep = null;
ResultSet rst = null;
Product product = null;
try {
conn = JdbcUtil.getConnection();
String sql = "select id,product_no,product_name,product_price,product_dangdang_price,"
+ "product_author,product_publish,"
+ "product_desc,product_date,product_isbn,product_amount,product_state,product_pic,"
+ "command,amount,shangjia_date,categroy_id "
+ " from t_product_qbc where id=?";
prep = conn.prepareStatement(sql);
prep.setInt(1, id);
rst = prep.executeQuery();
if (rst.next()) {
product = new Product();
product.setId(rst.getInt(1));
product.setProductNo(rst.getString(2));
product.setProductName(rst.getString(3));
product.setProductPrice(rst.getDouble(4));
product.setProductDangPrice(rst.getDouble(5));
product.setProductAuthor(rst.getString(6));
product.setProductPublish(rst.getString(7));
product.setProductDesc(rst.getString(8));
product.setProductDate(rst.getDate(9));
product.setProductIsbn(rst.getString(10));
product.setProductAmount(rst.getInt(11));
product.setProductState(rst.getString(12));
product.setProductPic(rst.getString(13));
product.setCommand(rst.getString(14));
product.setAmount(rst.getInt(15));
product.setShangJiaDate(rst.getDate(16));
product.setCategroyId(rst.getInt(17));
}
return product;
} catch (Exception e) {
e.printStackTrace();
return null;
}
}
/**
* 计算书的总数
*/
public int queryAllProductCount() {
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
int count = -1;
try{
conn = JdbcUtil.getConnection();
String sql = "select count(*) from t_product_qbc";
pstmt = conn.prepareStatement(sql);
rs = pstmt.executeQuery();
if(rs.next()){
count = rs.getInt(1);
}
return count;
}catch(Exception e){
e.printStackTrace();
return -1;
}
}
/**
* 通过页面和排序方法得到所有的书籍
*/
public List<Product> queryAllProducts(Page page, String order) {
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
List<Product> products = new ArrayList<Product>();
int count = this.queryAllProductCount();
page.setTotalItem(count);
try{
conn = JdbcUtil.getConnection();
String sql = " select p.id,p.product_no,p.product_price,p.product_dangdang_price," +
"p.product_name,p.product_author,p.product_desc,p.product_publish," +
"p.product_isbn,p.produ
struts框架当当网
4星 · 超过85%的资源 需积分: 3 167 浏览量
2011-09-03
19:41:39
上传
评论
收藏 10.05MB RAR 举报 
struts框架当当网 （553个子文件） 
ProductDAOImpl.class 7KB Product.class 5KB CartServiceImpl.class 3KB OrderServiceImpl.class 3KB ImageResult.class 3KB CartAction.class 3KB User.class 3KB UserDAOImpl.class 3KB OrderAction.class 3KB Order.class 3KB MainAction.class 2KB RegistAction.class 2KB OrderDAOImpl.class 2KB LoginAction.class 2KB UserServiceImpl.class 2KB ProductServiceImpl.class 2KB JdbcUtil.class 2KB OrderItemDAOImpl.class 2KB Page.class 2KB Cart.class 1KB ImageAction.class 1KB RegistValiAction.class 1KB AuthorInterceptor.class 1KB Categroy.class 1KB CartItem.class 978B LoginOutAction.class 921B DeleteCart.class 879B TestProductDAO.class 878B TestPage.class 692B TestJdacUtil.class 684B ProductDAO.class 584B CartService.class 487B ProductService.class 469B OrderService.class 307B UserService.class 305B UserDAO.class 278B OrderItemDAO.class 188B OrderDAO.class 158B .classpath 2KB 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 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 stylesheet.css 1KB secBook_Show.css 1KB navi.css 1KB pubsug090107.css 555B Thumbs.db 48KB Thumbs.db 38KB Thumbs.db 29KB Thumbs.db 19KB Thumbs.db 16KB Thumbs.db 10KB Thumbs.db 8KB Thumbs.db 7KB Thumbs.db 6KB Thumbs.db 6KB Thumbs.db 6KB Thumbs.db 5KB
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 dot_gandong.gif 1024B dot_shuzhuopang.gif 1023B butt_buy.gif 1022B dot_kafeiguan.gif 1018B tag_bang1.gif 1012B xs.gif 995B ddfyb_3.gif 980B共 553 条
- 1
- 2
- 3
- 4
- 5
- 6
资源评论
Y19504635052012-06-25为什么我下载的程序有错误- BaiDuYY2012-12-04打不开程序不知道怎么回事
