booksaleaction.java

在线购物 商品管理 用户管理 购物车 订单管理 权限控制

package com.qrsx.shop.action;


import java.sql.SQLException;
import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.qrsx.shop.dao.BookDAO;
import com.qrsx.shop.dao.BookSaleDAO;
import com.qrsx.shop.dao.JdbcUtil;
import com.qrsx.shop.model.Book;
import com.qrsx.shop.model.BookSale;

/**
 *@Author:李世海	
 *@Address:青岛软件园
 *@Date: Mar 31, 2009
 */


public class BookSaleAction extends BaseAction<BookSaleDAO,BookSale >{
	private BookSale bookSale;
	public BookSaleAction(HttpServletRequest request,
			HttpServletResponse response, BookSale bookSale) {
		super(request, response, new BookSaleDAO(), bookSale);
		this.bookSale = entity;
		
	}
	/**
	 * 图书上架
	 */
	public void create(Integer amount){
		try{
			if(bookSale.getId()!=null){
				this.update(amount);
				saveMessage("修改成功！");
			}else{
				dao.create(bookSale,amount);
				saveMessage("上架成功！");
			}
			JdbcUtil.commitTransaction();
			
		}catch(SQLException e){
			e.printStackTrace();
			JdbcUtil.rollbackTransaction();
			saveError("上架失败！");
		}finally{
			JdbcUtil.closeCurrentConnection();
		}
	}
	/**
	 * 图书下架
	 */
	public void delete(){
		try{
			dao.delete(bookSale.getId());
			JdbcUtil.commitTransaction();
		}catch(SQLException e){
			e.printStackTrace();
			JdbcUtil.rollbackTransaction();
		}finally{
			JdbcUtil.closeCurrentConnection();
		}
	}
	/**
	 * 修改上架图书
	 */
	public  void update(Integer amount){
		try{
			dao.update(bookSale,amount);
			JdbcUtil.commitTransaction();
			saveMessage("修改成功！");
		}catch(SQLException e){
			e.printStackTrace();
			JdbcUtil.rollbackTransaction();
			saveError("修改失败！");
		}finally{
			JdbcUtil.closeCurrentConnection();
		}
	}
	/**
	 * 动态检索图书
	 */
	public void list(Book book){
		try{
			List<BookSale> list = dao.list(book);
			request.setAttribute("bookSales", list);
			JdbcUtil.commitTransaction();
		}catch(SQLException e){
			e.printStackTrace();
			JdbcUtil.rollbackTransaction();
		}finally{
			JdbcUtil.closeCurrentConnection();
		}
	}
	/**
	 * 顾客动态检索购物广场的图书
	 */
	public void listU(Book b){
		try{
			List<Book> list = dao.listu(b);
			request.setAttribute("goods", list);
			JdbcUtil.commitTransaction();
		}catch(SQLException e){
			e.printStackTrace();
			JdbcUtil.rollbackTransaction();
		}finally{
			JdbcUtil.closeCurrentConnection();
		}
	}
	/**
	 * 编辑上架图书
	 */
	public void edit(){
		
		try{
			
			
			if(bookSale.getId()!=null){
				bookSale = dao.findById(bookSale.getId());
				request.setAttribute("bookSale", bookSale);
			}else{
				BookSale bs = new BookSale();
				bs = dao.findByBookId(bookSale.getBookId());
				if(bs==null){
					BookDAO bookDAO = new BookDAO();
					Book book = bookDAO.findById(bookSale.getBookId());
					bookSale.setBook(book);
					request.setAttribute("bookSale", bookSale);
				}else{
					request.setAttribute("bookSale", bs);
				}
			}
		
			JdbcUtil.commitTransaction();
		}catch(SQLException e){
			e.printStackTrace();
			JdbcUtil.rollbackTransaction();
		}finally{
			JdbcUtil.closeCurrentConnection();
		}
	}
	/**
	 * 查询所有上架图书
	 */
	public void findAll(){
		try{
			List<BookSale> list = dao.findAll();
			request.setAttribute("bookSales", list);
			JdbcUtil.commitTransaction();
		}catch(SQLException e){
			e.printStackTrace();
			JdbcUtil.rollbackTransaction();
		}finally{
			JdbcUtil.closeCurrentConnection();
		}
	}
	/**
	 * 列出购物广场的书籍
	 */
	public void listGoods(){
		try{
			List<Book> list = dao.listGoods();
			request.setAttribute("goods", list);
			JdbcUtil.commitTransaction();
		}catch(SQLException e){
			e.printStackTrace();
			JdbcUtil.rollbackTransaction();
		}finally{
			JdbcUtil.closeCurrentConnection();
		}
	}
	
}