listdateaction.java

java操作Excel的程序

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

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 com.liha.excel;
import com.lihan.struts.form.ListDateForm;
import java.sql.*;

/** 
 * MyEclipse Struts
 * Creation date: 08-01-2008
 * 
 * XDoclet definition:
 * @struts.action path="/listDate" name="listDateForm" input="/form/listDate.jsp" scope="request" validate="true"
 */
public class ListDateAction extends Action {
	/*
	 * Generated Methods
	 */

	/** 
	 * Method execute
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		ListDateForm listDateForm = (ListDateForm) form;// TODO Auto-generated method stub
		
		
		  String[] title={"ID","姓名","密码","测试"};
		String sql="select * from test";
		excel e=new excel();
		e.createEXCEL(title, sql, "e:\\dzl.csv");
		
		return null;
	}
}