joinbydbaction.java

利用poi插件和Java语言在web中实现excel的合并功能

package com.Control.JoinByDB;

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

import java.util.*;

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 com.dao.JoinByDB.JoinByDBControl;

public class JoinByDBAction extends Action {
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
	//启动数据库合并excel的动作	
		
		JoinByDBControl objControl=new JoinByDBControl();
		List course=new ArrayList();//定义获取课程信息的列表对象
		List data=new ArrayList();//定义获取姓名和成绩信息的列表对象
		List average=new ArrayList();//定义获取平均成绩信息的列表对象
		List total=new ArrayList();//定义获取总成绩信息的列表对象
		try {
			String[] filenames={"e:\\CalculateCell\\English.xls","e:\\CalculateCell\\Chinese.xls","e:\\CalculateCell\\mathematics.xls"};
			//定义要合并的excel文件名称数组
			for(int i=0;i<filenames.length;i++) {
				objControl.readsourcefile(filenames[i]);
				//依次将excel文件内容读入数据库
				course=objControl.getCourse();//获取页面显示课程信息
				data=objControl.getnameandscore();//获取页面显示姓名和成绩信息
				average=objControl.getAverage();//获取页面显示平均成绩信息
				total=objControl.getTotal();//获取页面显示总成绩信息
			}
			objControl.WriteCell();//通过数据库，将统计后数据录入excel表格
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		request.setAttribute("course",course);
		request.setAttribute("list",data);
		request.setAttribute("average",average);
		request.setAttribute("total",total);
		return mapping.findForward("success");
		
	}
}