goodaction.java

课程设计期间开发的JSP系统,后台采用SQL.这是一个很好的系统,适合初学者研究

package act;

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 model.booksmn;
import org.pan.web.book.books;

public class GoodAction extends Action {
    private int action;
	@Override
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		action = Integer.parseInt(request.getParameter("action"));
		switch(action){
		case 1:
			return selectBook(mapping, form, request, response);
		case 2:
			return addBook(mapping, form, request, response);
		case 3:
			return selectBook1(mapping, form, request, response);
		
		}
		return super.execute(mapping, form, request, response);
	}

	private ActionForward selectBook1(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		try {
			booksmn bookmodel = new booksmn();
			if(bookmodel.execute(request)){
			List<books> booklist = bookmodel.getBooklist();
			request.setAttribute("books", booklist);
			return mapping.findForward("selectbook1");
			}
			
			return mapping.findForward("selectbook1");
		} catch (Exception e) {
			e.printStackTrace();
			return mapping.findForward("selectbook1");
		}
	}
	private ActionForward addBook(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		String mesg = "11";
		String submit = request.getParameter("Submit");
		try {
			booksmn bookmodel = new booksmn();
			if (submit!=null && !submit.equals("")){		
				if(bookmodel.getRequest(request)){
					if(bookmodel.insert()){
						mesg = "新图书资料提交成功！";
					} else {
						mesg = "数据库操作失败";
					}
				}else {
					mesg = "对不起，你提交的参数有错误";
				}
				request.setAttribute("mesg", mesg);
				return mapping.findForward("addbook");
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		return mapping.findForward("addbook");
	}
	private ActionForward selectBook(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		try {
			booksmn bookmodel = new booksmn();
			if(bookmodel.execute(request)){
			List<books> booklist = bookmodel.getBooklist();
			request.setAttribute("books", booklist);
			return mapping.findForward("selectbook");
			}
			
			return mapping.findForward("selectbook");
		} catch (Exception e) {
			e.printStackTrace();
			return mapping.findForward("selectbook");
		}
		
	}

}