deptaction.java

一个简单的excel导入到数据库中。的实例。。。看看吧。。。。。。

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

import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStream;
import java.lang.reflect.InvocationTargetException;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

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

import org.apache.commons.beanutils.BeanUtils;
import org.apache.commons.lang.builder.ToStringBuilder;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.extremecomponents.table.limit.Limit;






import com.javayjm.common.model.SearchModel;
import com.javayjm.common.model.SearchResultModel;
import com.javayjm.common.model.UploadFileModel;
import com.javayjm.common.util.ObjectIDFactory;
import com.javayjm.common.web.action.BaseAction;
import com.javayjm.excel.ExcelManager;
import com.javayjm.test.constant.SystemConstant;
import com.javayjm.test.model.DeptModel;
import com.javayjm.test.web.form.DeptForm;

/**
 * MyEclipse Struts Creation date: 03-11-2007
 * 
 * XDoclet definition:
 * 
 * @struts.action scope="request" validate="true"
 */
public class DeptAction extends BaseAction {
	/*
	 * Generated Methods
	 */

	/**
	 * Method toAdd
	 * 
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward toAdd(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		// TODO Auto-generated method stub
		List list = this.getDeptService().findDeptSelectList();
		request.setAttribute("deptname",list );
		return mapping.findForward("toAdd");
	}

	/**
	 * Method add
	 * 
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward add(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		// TODO Auto-generated method stub
		return mapping.findForward("toAdd");
	}

	/**
	 * Method toUpdate
	 * 
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward toUpdate(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		// TODO Auto-generated method stub
		DeptForm frm = (DeptForm) form;
		int id = Integer.parseInt(frm.getId()) ;
		DeptModel dept = this.getDeptService().findDeptById(id);
		
		try {
			BeanUtils.copyProperties(form, dept);
		} catch (IllegalAccessException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (InvocationTargetException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return mapping.findForward("toUpdate");
	}

	/**
	 * Method update
	 * 
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward update(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		// TODO Auto-generated method stub
		DeptForm frm = (DeptForm) form;
		DeptModel dept = new DeptModel();
		try {
			BeanUtils.copyProperties(dept, frm);
		} catch (IllegalAccessException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (InvocationTargetException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		//form = new DeptForm();
		this.getDeptService().updateDept(dept);
		
		request.setAttribute(SystemConstant.PAGE_ISBACK, "1");
		return mapping.findForward("update");
	}

	/**
	 * Method delete
	 * 
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward delete(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		// TODO Auto-generated method stub
		return null;
	}

	/**
	 * Method toManager
	 * 
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward toManager(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		// TODO Auto-generated method stub
		
		return mapping.findForward("manager");
	}

	/**
	 * Method manager
	 * 
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward manager(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		// TODO Auto-generated method stub
		SearchResultModel searchResult = null;
		//try {

			Limit limit = this.getLimit(request);
			DeptModel dept = null;
			if (limit != null) {
				dept = new DeptModel();
				try {
					BeanUtils.copyProperties(dept, form);
				} catch (IllegalAccessException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				} catch (InvocationTargetException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				SearchModel searchModel = new SearchModel();
				searchModel.setLimit(limit);
				searchModel.setObj(dept);
				request.getSession().setAttribute(
						SystemConstant.PAGE_SEARCH_MODEL, searchModel);
			} else {
				SearchModel searchModel = (SearchModel) request.getSession()
						.getAttribute(SystemConstant.PAGE_SEARCH_MODEL);
				limit = searchModel.getLimit();
				dept = (DeptModel) searchModel.getObj();
				try {
					BeanUtils.copyProperties(form,dept);
				} catch (IllegalAccessException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				} catch (InvocationTargetException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}				
			}
			searchResult = this.getDeptService().findDeptList(dept, limit);
			request.setAttribute(SystemConstant.PAGE_LIST, searchResult.getResultList());
			request.setAttribute(SystemConstant.PAGE_TOTAL_ROWS, searchResult.getCount());
			request.setAttribute(SystemConstant.PAGE_ISBACK, "1");	
			System.out.println("Size = " + searchResult.getResultList().size());
		//} catch (Exception e) {

		//}
		return mapping.findForward("manager");
	}
	/**
	 * Method toFileUpload
	 * 
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward toFileUpload(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		// TODO Auto-generated method stub
		return mapping.findForward("toFileUpload");
	}
	/**
	 * Method fileUpload
	 * 
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 * @throws IOException 
	 */
	public ActionForward fileUpload(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) throws IOException {
		// TODO Auto-generated method stub
		List list = this.doUpload(form, request);
		UploadFileModel model = (UploadFileModel) list.get(0);
		String filePath = request.getSession().getServletContext()
				.getRealPath("/excel");
		filePath = filePath + "\\" + ObjectIDFactory.objectID() + ".xls";
		
		File file = new File(filePath);		
		OutputStream os = new FileOutputStream(file);
		os.write(model.getFileData());		
		os.close();		
		System.out.println("file = " + file.getPath());
		
		
		System.out.println("======");
		Map<String, String> map = new HashMap<String, String>();
		map.put("deptNo", "1");
		map.put("bgqx永久", "Y");
		ExcelManager test = new ExcelManager(file,"deptModel",map);
		List modelList = test.getModelList();
		for(int i = 0;i<modelList.size();i++){
			Object obj = modelList.get(i);
			System.out.println(obj.getClass().getSimpleName());
			System.out.println(ToStringBuilder.reflectionToString(obj));
		}
		
		
		//file.delete();
		
		return mapping.findForward("toFileUpload");
	}

}