Java-Hibernate-校园管理系统-源码

package com.spring.controller; import java.sql.Date; import java.util.HashMap; import java.util.List; import java.util.Map; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.springframework.web.servlet.ModelAndView; import org.springframework.web.servlet.mvc.multiaction.MultiActionController; import com.hibernate.dao.DAOSupport; import com.hibernate.model.BookBorrowInfo; import com.hibernate.model.BookReginster; import com.hibernate.model.DocuStuInfo; public class BookManager extends MultiActionController { private String addPage; private String searchPage; private String bookDetailPage; private String bookBorrowPage; private String borrowSearchPage; private String borrowReturnPage; private DAOSupport dao; public ModelAndView add(HttpServletRequest req, HttpServletResponse res) { BookReginster bg = modifyBook(req); if (dao.InsertOrUpdate(bg)) return new ModelAndView(getAddPage(), "result", "添加成功，可以继续添加"); else return new ModelAndView(getAddPage(), "result", "添加失败，请检查输入内容或数据库连接"); } public ModelAndView modify(HttpServletRequest req, HttpServletResponse res) { BookReginster bg = modifyBook(req); if (dao.InsertOrUpdate(bg)) return list(req, res); else return new ModelAndView(getSearchPage(), "result", "修改失败，请检查输入内容或数据库连接"); } public ModelAndView list(HttpServletRequest req, HttpServletResponse res) { List list = dao.QueryObject("from BookReginster"); return new ModelAndView(getSearchPage(), "result", list); } public ModelAndView search(HttpServletRequest req, HttpServletResponse res) { List list; String condition = req.getParameter("condition"); if (condition.equals("书号")) condition = "bookId"; else if (condition.equals("书名")) condition = "bookName"; else condition = "bookConcern"; String conditionContent = req.getParameter("conditionContent"); list = dao.QueryObject("from BookReginster where " + condition + " like '" + conditionContent + "%'"); return new ModelAndView(getSearchPage(), "result", list); } public ModelAndView detail(HttpServletRequest req, HttpServletResponse res) { List list; String bookID = req.getParameter("bookID"); list = dao.QueryObject("from BookReginster where bookId=" + bookID); BookReginster bookDetail = (BookReginster) list.get(0); return new ModelAndView(getBookDetailPage(), "result", bookDetail); } public ModelAndView borrow(HttpServletRequest req, HttpServletResponse res) { String submit = req.getParameter("save"); List list = null; Map model = null; DocuStuInfo stuInfo = null; BookReginster bookDetail = null; BookBorrowInfo borrowInfo = null; String stuId = req.getParameter("stu_id"); String bookID = req.getParameter("book_id"); if (stuId != null && !stuId.equals("")) { list = null; list = dao.QueryObject("from DocuStuInfo where stuId=" + stuId); if (list != null && list.size() > 0) stuInfo = (DocuStuInfo) list.get(0); } if (bookID != null && !bookID.equals("")) { list = null; list = dao.QueryObject("from BookReginster where bookId='" + bookID + "'"); if (list != null && list.size() > 0) bookDetail = (BookReginster) list.get(0); } if (stuInfo != null) { list = null; list = dao .QueryObject("from BookBorrowInfo where docuStuInfo.stuId='" + stuInfo.getStuId() + "'"); model = new HashMap(); model.put("stu", stuInfo); model.put("book", bookDetail); model.put("list", list); } String price = req.getParameter("price"); if (submit != null && price != null && !price.equals("")) { System.out.println(req.getParameter("price") + ""); borrowInfo = new BookBorrowInfo(); borrowInfo.setBookName(req.getParameter("book_name")); borrowInfo.setBookReginster(bookDetail); borrowInfo.setBookType("book_type"); borrowInfo.setBorrowDate(new Date(System.currentTimeMillis())); borrowInfo.setCzy(req.getParameter("czy")); borrowInfo.setDocuStuInfo(stuInfo); borrowInfo.setPrice(Double.valueOf(price)); dao.InsertOrUpdate(borrowInfo); list = dao .QueryObject("from BookBorrowInfo where docuStuInfo.stuId='" + stuInfo.getStuId() + "'"); model = new HashMap(); model.put("stu", stuInfo); model.put("list", list); } return new ModelAndView(getBookBorrowPage(), "info", model); } public ModelAndView returnBook(HttpServletRequest req, HttpServletResponse res) { List list = null; Map model = null; DocuStuInfo stuInfo = null; // BookReginster bookDetail = null; BookBorrowInfo borrowInfo = null; String submit = req.getParameter("return"); String stuId = req.getParameter("stu_id"); String bookID = req.getParameter("book_id"); if (stuId != null && stuId != "") { list = null; list = dao.QueryObject("from DocuStuInfo where stuId=" + stuId); if (list != null && list.size() > 0) stuInfo = (DocuStuInfo) list.get(0); } // if (bookID != null && bookID != "") { // list = null; // list = dao.QueryObject("from BookBorrowInfo where // bookReginster.bookId='" + bookID // + "'"); // if (list != null && list.size() > 0) // bookDetail = (BookReginster) list.get(0); // } if (stuInfo != null && bookID != null) { list = null; String sql = "from BookBorrowInfo where docuStuInfo.stuId='" + stuInfo.getStuId() + "' and bookReginster.bookId='" + bookID + "'"; list = dao.QueryObject(sql); if (list != null && list.size() > 0) borrowInfo = (BookBorrowInfo) list.get(0); } if (submit != null && stuId != null) {// 如果是通过按钮提交，删除记录 list = null; list = dao .QueryObject("from BookBorrowInfo where docuStuInfo.stuId='" + stuId + "' and bookReginster.bookId='" + bookID + "'"); if (list != null && list.size() > 0) dao.DeleteObject(list.get(0)); list = dao .QueryObject("from BookBorrowInfo where docuStuInfo.stuId='" + stuId + "'"); System.out.println("submit list=" + list); model = new HashMap(); model.put("stu", stuInfo); model.put("list", list); return new ModelAndView(getBorrowReturnPage(), "info", model); } list = dao.QueryObject("from BookBorrowInfo where docuStuInfo.stuId='" + stuId + "'"); model = new HashMap(); model.put("stu", stuInfo); // model.put("book", bookDetail); model.put("borrow", borrowInfo);// 借阅表的信息 model.put("list", list); return new ModelAndView(getBorrowReturnPage(), "info", model); } public ModelAndView borrowSearch(HttpServletRequest req, HttpServletResponse res) { List list = null; String submit = req.getParameter("Submit"); String showAll = req.getParameter("ShowAll"); if (submit != null) { String conditionContent = req.getParameter("conditionContent"); String condition = req.getParameter("condition"); if (condition.equals("书号")) condition = "bookReginster.bookId"; else if (condition.equals("学号")) condition = "docuStuInfo.stuId"; else { condition = "borrowDate"; } if (!condition.equals("borrowDate")) list = dao.QueryObject("from BookBorrowInfo where " + condition + " = '" + conditionContent + "'"); else list = dao.QueryObject("from BookBorrowInfo where " + condition + " >= '" + conditionContent + " 00:00:00' and " + condition + " <= '" + conditionContent + " 23:59:59'"); System.out.println(list.size()); } if (showAll != null) list = dao.QueryObject("from BookBorrowInfo"); return new ModelAndView(getBorrowSearchPage(), "list", list); } public String getAddPage() { return addPage; } public void setAddPage(String addPage) { this.addPage = addPage; } public void setDao(DAOSupport dao) { th