/*
 * Created on 2006-7-30
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
package org.ug.sztz.webview.structs.actions.oa;

import java.io.FileInputStream;
import java.util.HashMap;
import java.util.List;
import java.util.Vector;

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

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.ug.sztz.domain.assistant.UrlConvertor;
import org.ug.sztz.domain.oa.FuDaoYuan;

/**
 * @author Skywalker
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class ListFdyzhAction extends BaseAction {

	/* (non-Javadoc)
	 * @see org.apache.struts.action.Action#execute(org.apache.struts.action.ActionMapping, org.apache.struts.action.ActionForm, javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse)
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) throws Exception {
		// TODO Auto-generated method stub
		try {
			List list = this.collegeDao.getFuDaoYuanList(new HashMap());
			request.setAttribute("fdyzhlist",list);
			
			//導入輔導員數據使用
			/*
			UrlConvertor urlConvertor = new UrlConvertor(this.getServlet()
					.getServletConfig());
			POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(
					urlConvertor.getAbsoluteFile("/upload/", "fdy.xls")));//打開上傳的文件
			Vector vector = new Vector();
			HSSFWorkbook wb = new HSSFWorkbook(fs);
			HSSFSheet sheet = wb.getSheetAt(0);
			for (int i = 1;; i++) {
				HSSFRow row = sheet.getRow(i);
				if (row == null) //到最后一列時退出
					break;
				if(row.getCell((short) 9)!=null&&!row.getCell((short) 9).getStringCellValue().equals("")){
					
				FuDaoYuan fdy=new FuDaoYuan();
				fdy.setCollege(row.getCell((short) 0).getStringCellValue());
				fdy.setEmail(row.getCell((short) 3).getStringCellValue());
				System.out.println(row.getCell((short) 9).getStringCellValue());
				fdy.setMobile(row.getCell((short) 5).getStringCellValue());
				fdy.setName(row.getCell((short) 1).getStringCellValue());
				fdy.setOther(row.getCell((short) 8).getStringCellValue());
				fdy.setPassword(row.getCell((short) 10).getStringCellValue());
				fdy.setTel(row.getCell((short) 7).getStringCellValue());
				fdy.setUsername(row.getCell((short) 9).getStringCellValue());
				fdy.setXlt(row.getCell((short) 6).getStringCellValue());
				this.collegeDao.insertFuDaoYuan(fdy);
				}
			}
			*/
			return mapping.findForward("success");
		} catch (RuntimeException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			request.setAttribute("info","數據庫操作失??！");
			return mapping.findForward("failure");
		}
		
	}
}