instructoraction.java

用SPRING做的一个企业信息系统网站

/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package com.enterpriseweb.struts.action;

import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.actions.DispatchAction;

import com.enterpriseweb.bean.DaoSupport;
import com.enterpriseweb.bean.PageBean;
import com.enterpriseweb.bean.UploadBean;
import com.enterpriseweb.struts.form.InstructorForm;
import com.enterpriseweb.util.Constants;

/** 
 * MyEclipse Struts
 * Creation date: 11-14-2007
 * 
 * XDoclet definition:
 * @struts.action path="/instructor" name="instructorForm" scope="request" validate="true"
 * @struts.action-forward name="instructor" path="/instructor.jsp" contextRelative="true"
 * @struts.action-forward name="delelistinstructors" path="/managerview/sendforward.jsp" contextRelative="true"
 * @struts.action-forward name="listinstructors" path="/managerview/instructor_modi_save.jsp" contextRelative="true"
 * @struts.action-forward name="modiupdateinstructors" path="/managerview/sendforward.jsp" contextRelative="true"
 * @struts.action-forward name="listallinstructorsmodi" path="/managerview/instructor_modi_list.jsp" contextRelative="true"
 * @struts.action-forward name="listallinstructorsdele" path="/managerview/instructor_dele_list.jsp" contextRelative="true"
 * @struts.action-forward name="addsucess" path="/managerview/sendforward.jsp" contextRelative="true"
 */
public class InstructorAction extends DispatchAction {
	/*
	 * Generated Methods
	 */
	private DaoSupport dao = null;
	private InstructorForm instructorform = null;
	
	public DaoSupport getDao() {
		return dao;
	}

	public void setDao(DaoSupport dao) {
		this.dao = dao;
	}

	/** 
	 * Method execute
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	/*
	 * 添加技术支持信息情况	 
	 */
	public ActionForward addInstructor(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		instructorform = (InstructorForm) form;// TODO Auto-generated method stub
		String dir = servlet.getServletContext().getRealPath("uploadImage");
		UploadBean upbean = new UploadBean();
		try{
			if(!upbean.upload(dir, instructorform, "InstructorForm")){
				request.setAttribute("name", "overSize");
				return mapping.findForward("addsucess");
			}
		}catch(Exception e ){
			e.printStackTrace();
		}
		String sql = "insert into instructor(title,imagepath) values('"+instructorform.getTitle()+"','"+instructorform.getImagepath()+"')";
		this.dao.saveObject(sql);
		request.setAttribute("name", "instructoradd");
		return mapping.findForward("addsucess");	
	}
	
	//修改技术信息
	public ActionForward updateInstructor(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		instructorform = (InstructorForm) form;// TODO Auto-generated method stub
		String dir = servlet.getServletContext().getRealPath("/uplaodImage");
		UploadBean upbean = new UploadBean();
		try{
			upbean.upload(dir, instructorform, "InstructorForm");
		}catch(Exception e){
			e.printStackTrace();
		}
		String sql = "update instructor ins set title='"+instructorform.getTitle()+"', imagepath='"+instructorform.getImagepath()+"' where ins.ID = '"+instructorform.getId()+"'";
		this.dao.updateObject(sql);
		request.setAttribute("name", "instructorupdate");
		return mapping.findForward("modiupdateinstructors");
	}
	
	//获取所有的技术信息
	public ActionForward listAllInstructor(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		String sql = "select * from instructor";
		List listinstructors = this.dao.getObjectList(sql);		
		request.setAttribute("ListInstructors", listinstructors);		
		String name = request.getParameter("name");
		
		if (name.equals("modi")) {
			return mapping.findForward("listallinstructorsmodi");
		}else if (name.equals("dele")){
			return mapping.findForward("listallinstructorsdele");	
		}else{
			return null;
		}	
	}
	
	//根据id查询出技术信息
	public ActionForward listInstructor(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		String id = request.getParameter("id");
		String sql ="select * from instructor where ID = '"+id+"'";
		List listinstructors = this.dao.getObjectList(sql);
		request.setAttribute("Honours", listinstructors);		
		return mapping.findForward("listhonours");
	}
	
	//删除技术信息
	public ActionForward deleteInstructor(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		String id = request.getParameter("id");
		String sql = "delete from instructor where ID = '"+id+"'";
		this.dao.deleteObject(sql);
		request.setAttribute("name", "instructordele");
		return mapping.findForward("delelistinstructors");
	}
	
	// 控制动态分页
	public ActionForward view(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		int curPage;
		String pageNum = request.getParameter("jumpPage");
		if(pageNum == null ||pageNum.equals("")){
			curPage = 1;
		}else{
			curPage = Integer.parseInt(pageNum);
		}
		System.out.println("过去所有的记录");
		int maxRowCount = this.dao.getTotalPage("SELECT count(*) FROM instructor");
		System.out.println(" view():页面跳转第" + curPage + "页!!!");
		try {
			System.out.println("将查询的值存入request中!");
			if(curPage>1){
				PageBean pb=dao.getPageBean(
						Constants.Instructor_sql1, Constants.Instructor_sql2,
						Constants.Instructor_sql3, Constants.Instructor_sql4,Constants.Instructor_sql5, Constants.Instructor, curPage,
						maxRowCount);
				System.out.println(pb.getMaxRowCount());
				request.setAttribute("PageBean", pb);
				}else{
					String sql = "SELECT top " + Constants.PAGE_LENGTH + " ID, title, imagepath FROM tb_instructor";
					PageBean pb=dao.getPageBean1(sql, curPage, maxRowCount);
					request.setAttribute("PageBean", pb);
				}
		} catch (Exception e) {
			System.out.println("view " + e.getMessage());
		}
		return mapping.findForward("instructor");
	}
}