ibatis mybatis 分页 crud 完整代码

package com.dou.book.action; import java.util.List; import javax.servlet.http.HttpServletRequest; import org.apache.struts2.ServletActionContext; import org.springframework.beans.factory.annotation.Autowired; import com.dou.book.data.pojo.SBook; import com.dou.book.data.services.ISBookServices; import com.opensymphony.xwork2.ActionContext; @SuppressWarnings("unchecked") public class SBookAction { @Autowired ISBookServices bookServices; //@Autowired private SBook sbook; private String tips; private String bookId; private List bookList; private String Id; /** * 添加图书信息 * * @return 返回添加是否成功 */ public String addSBook() { String result = "error"; try { bookServices.saveBook(sbook); this.setTips("添加成功"); result = "success"; } catch (Exception e) { e.printStackTrace(); this.setTips("系统出现问题"); } return result; } /** * 查看所有图书 * * @return */ public String viewSBook() { String result = "error"; try { bookList = bookServices.findAllBook(); //sbook.setTotals(bookServices.getAllCount(sbook)); //bookList = bookServices.findBookByPage(sbook); result = "success"; } catch (Exception e) { e.printStackTrace(); this.setTips("系统出现问题，请稍后访问"); } return result; } /** * 根据综合备件查看所有图书 * * @return */ public String findBookByCondition() { String result = "error"; try { bookList = bookServices.findBookByCondition(sbook); result = "success"; } catch (Exception e) { e.printStackTrace(); this.setTips("系统出现问题，请稍后访问"); } return result; } public String findBookByPage() { String result = "error"; //ActionContext context = ActionContext.getContext(); //HttpServletRequest request = (HttpServletRequest)context.get(ServletActionContext.HTTP_REQUEST); //String pageindex=request.getParameter("pageindex"); //System.out.println("pageindex:="+pageindex); try { if(sbook==null){ sbook=new SBook(); sbook.setDesc("asc"); sbook.setTotals(5); sbook.setPageindex(1); sbook.setPagesize(5); sbook.setOrderby("userid"); sbook.setStart(0); sbook.setPages(1); sbook.setTitle(""); sbook.setAuthor(""); sbook.setPublisher(""); sbook.setIsbn(""); } sbook.setTotals(bookServices.getAllCount(sbook)); bookList = bookServices.findBookByPage(sbook); result = "success"; } catch (Exception e) { e.printStackTrace(); this.setTips("系统出现问题，请稍后访问"); } return result; } /** * 根据书名查看所有图书 * * @return */ public String findBookByName() { String result = "error"; try { bookList = bookServices.findBookByName(sbook.getTitle()); result = "success"; } catch (Exception e) { e.printStackTrace(); this.setTips("系统出现问题，请稍后访问"); } return result; } /** * 修改图书信息 * * @return */ public String modifySBook() { String result = "error"; System.out.println("bookID:"+bookId); try { sbook = bookServices.getBookById(Integer .parseInt(this.getBookId())); System.out.println("title:"+sbook.getTitle()); result = "success"; } catch (Exception e) { e.printStackTrace(); this.setTips("系统出现问题"); } return result; } public String updateSBook() { String result = "error"; try { bookServices.updateBook(sbook); result = "success"; } catch (Exception e) { e.printStackTrace(); this.setTips("更新操作失败"); } return result; } /** * 删除图书 * * @return */ public String removeSBook() { String result = "error"; System.out.println("id:"+this.getBookId()); try { bookServices.removeBook(Integer.parseInt(this.getBookId())); System.out.println("id:"+this.getBookId()); result = "success"; } catch (Exception e) { e.printStackTrace(); this.setTips("删除操作失败"); } return result; } public SBook getSbook() { return sbook; } public void setSbook(SBook sbook) { this.sbook = sbook; } public List getBookList() { return bookList; } public void setBookList(List bookList) { this.bookList = bookList; } public String getTips() { return tips; } public void setTips(String tips) { this.tips = tips; } public String getBookId() { return bookId; } public void setBookId(String bookId) { this.bookId = bookId; } public String getId() { return Id; } public void setId(String id) { Id = id; } }