searchaction.java

此项目是实现,增加,删除,修改,查询图书数据库的功能

/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package com.hevttc.book.web.action;

import java.util.List;

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

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import com.hevttc.book.daohibernate.imp.BookDaoHibernateImp;
import com.hevttc.book.daohibernate.imp.Pager;
import com.hevttc.book.daohibernate.imp.PagerHelper;
import com.hevttc.book.factory.Factory;
import com.hevttc.book.service.BookService;
import com.hevttc.book.web.form.SearchForm;

/**
 * MyEclipse Struts Creation date: 10-15-2007
 * 
 * XDoclet definition:
 * 
 * @struts.action path="/search" name="searchForm" scope="request"
 */
public class SearchAction extends Action {
	/*
	 * Generated Methods
	 */

	/**
	 * Method execute
	 * 
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {

		SearchForm searchForm = (SearchForm) form;
		String fn = searchForm.getFn();
		String bookname = searchForm.getBookname();
		String author = searchForm.getAuthor();
		String publish = searchForm.getPublish();
		String selectedBookid = searchForm.getSelectedBookid();
		BookService bookservice = (BookService) Factory
				.getImp("bookserviceimp");

		// 登陆成功后加载主页面,显示数据
		if ("load".equals(fn)) {

			List table = bookservice.find("", "", "");
			searchForm.setTable(table);
			return mapping.findForward("search");

			// 模糊查询数据
		} else if ("find".equals(fn)) {

//			List table = bookservice.find(bookname, author, publish);
//			searchForm.setTable(table);
//			return mapping.findForward("search");
			List clInfos = null;// 用于输出到页面的记录集合
			int totalRows;// 记录总行数
			BookDaoHibernateImp vehicleDAO = new BookDaoHibernateImp();
			// 取得当前表中的总行数
			try {
				totalRows = vehicleDAO.getRowsByTag(bookname, author, publish);
				Pager pager = PagerHelper.getPager(request, totalRows);
				clInfos = vehicleDAO.findWithPageByTag(bookname, author, publish,pager.getPageSize(), pager
						.getStartRow());
				searchForm.setTable(clInfos);
				searchForm.setPager(pager);
				return mapping.findForward("search");
				
			} catch (Exception ex) {
				servlet.log(ex.toString());
			}

			// 删除数据
		} else if ("del".equals(fn)) {

			bookservice.delete(selectedBookid);
			return mapping.findForward("success");

			// 修改数据
		} else if ("mod".equals(fn)) {

			request.setAttribute("selectedBookid", selectedBookid);
			return mapping.findForward("modify");

			// 添加数据
		} else if ("add".equals(fn)) {

			return mapping.findForward("add");

		} else if ("page".equals(fn)) {

			List clInfos = null;// 用于输出到页面的记录集合
			int totalRows;// 记录总行数
			BookDaoHibernateImp vehicleDAO = new BookDaoHibernateImp();
			// 取得当前表中的总行数
			try {
				totalRows = vehicleDAO.getRows();
				Pager pager = PagerHelper.getPager(request, totalRows);
				clInfos = vehicleDAO.findWithPage(pager.getPageSize(), pager
						.getStartRow());
				searchForm.setTable(clInfos);
				searchForm.setPager(pager);
				return mapping.findForward("search");
				
			} catch (Exception ex) {
				servlet.log(ex.toString());
			}

		}
		return null;
	}
}