bookaction.java

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

/**
 * 
 */
package com.qrsx.shop.action;

import java.sql.SQLException;
import java.util.ArrayList;
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.JdbcUtil;
import com.qrsx.shop.model.Book;

/**
 *@Author:李世海	
 *@Address:青岛软件园
 *@Date: Apr 3, 2009
 */
public class BookAction extends BaseAction<BookDAO , Book>{
	private Book book;
	public BookAction(HttpServletRequest request,
			HttpServletResponse response,
			Book book){
		super(request,response,new BookDAO(),book);
		this.book = entity;
	}
	
	/**
	 * 保存图书：更新，创建
	 */
	public void save(){
		try{
			Integer id = book.getId();
			if(id == null){
				dao.create(book);
				saveMessage("创建'" + book.getName() + "'成功！");
			}else{
				dao.update(book);
				saveMessage("更新'" + book.getName() + "'成功！");
			}
			JdbcUtil.commitTransaction();
		}catch(SQLException e) {
			e.printStackTrace();
			JdbcUtil.rollbackTransaction();
			saveError("保存'" + book.getName() + "'失败！");
		}finally{
			JdbcUtil.closeCurrentConnection();
		}
	}
	
	/**
	 * 编辑图书：进入新建界面，进入更新页
	 */
	public void edit(){
		try{
			if(book.getId() != null){
				book = dao.findById(book.getId());
				request.setAttribute("book", book);
				saveMessage("编辑'" + book.getName() + "'成功！");
			}else{
				
				if(book.getName()!=null){
					request.setAttribute("book", book);
					saveMessage("添加" + book.getName() + "'成功！");
				}
			}
			JdbcUtil.commitTransaction();
		}catch(Exception e){
			e.printStackTrace();
			JdbcUtil.rollbackTransaction();
			saveError("编辑失败！");
		}finally{
			JdbcUtil.closeCurrentConnection();
		}
	}
	
	/**
	 * 删除图书
	 */
	public void delete(){
		try{
			if(book.getId() != null){
				dao.delete(book.getId());
				saveMessage("删除成功！");
				JdbcUtil.commitTransaction();
			}
		}catch(SQLException e){
			e.printStackTrace();
			JdbcUtil.rollbackTransaction();
			saveError("删除失败！");
		}finally{
			JdbcUtil.closeCurrentConnection();
		}
	}
	/**
	 * 
	 */
	public List<Book> findAll(){
		List<Book> list = null;
		try{
			list = dao.findAll();
			request.setAttribute("books", list);
			JdbcUtil.commitTransaction();
		}catch(Exception e){
			e.printStackTrace();
			JdbcUtil.rollbackTransaction();
		}finally{
			JdbcUtil.closeCurrentConnection();
		}
		return list;
	}
	
	public List<Book> list(){
		List<Book> list = new ArrayList<Book>();
		try{
			list = dao.list(book);
			request.setAttribute("books", list);
			JdbcUtil.commitTransaction();
		}catch(SQLException e){
			e.printStackTrace();
			JdbcUtil.rollbackTransaction();
		}finally{
			JdbcUtil.closeCurrentConnection();
		}
		return list;
	}
	
	public void test(){
		int i = 0;
		try{
			i = dao.test();
			request.setAttribute("i",i);
		}catch(SQLException e){
			e.printStackTrace();
		}finally{
			JdbcUtil.closeCurrentConnection();
		}
	}
}