定时发Execl到制定邮箱.docVIP

本项目需求如下：每天早上8点从数据库查出昨天收入报表，写Execl中，然后发送到指定邮箱 项目所需要的jar包activation.jar、jxl,jar、mail,jar、msbase.jar、MSSQL-Driver.jar、mssqlserver.jar、msutil.jar、servlet-api.jar 运行方法：启动tomcat，即自动执行。tomcat启动时，会执行一次。所以如果没有技术问题，请勿重启Tomcat，因为每次重启都会发送一封邮件。 1、写一个Servlet，用于实现每天早上8点定时执行发送邮件的任务： package com.email; import java.io.IOException;import java.io.PrintWriter;import java.util.Calendar;import java.util.Date;import java.util.Timer;import java.util.GregorianCalendar; import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse; public class SendMailServlet extends HttpServlet{??? private Timer timer;??? private SendMailTask tt;public SendMailServlet() {?? super();} public void destroy() {?? super.destroy(); } public void doGet(HttpServletRequest request, HttpServletResponse response)??? throws ServletException, IOException {} public void doPost(HttpServletRequest request, HttpServletResponse response)??? throws ServletException, IOException { ?? response.setContentType(text/html);?? PrintWriter out = response.getWriter();?? out.println(!DOCTYPE HTML PUBLIC \-//W3C//DTD HTML 4.01 Transitional//EN\);?? out.println(HTML);?? out.println( HEADTITLEA Servlet/TITLE/HEAD);?? out.println( BODY);?? out.print(??? This is );?? out.print(this.getClass());?? out.println(, using the POST method);?? out.println( /BODY);?? out.println(/HTML);?? out.flush();?? out.close();} public void init() throws ServletException {?? Thread t = new Thread(){??? public void run(){???? timer = new Timer();???? tt = new SendMailTask();???? Calendar cal = new GregorianCalendar(2010, 0, 8, 0, 0, 0);// 从2010年1月8号8点开始执行????????? Date date = cal.getTime();???? timer.schedule(tt, date, 24*60*60*1000);//8点后，每24小时执行一次??? }???? };?? t.start();??} } 2、在web.xml中加入如下配置 servlet??? servlet-nameSendMailServlet/servlet-name!--邮件发送程序--??? servlet-classcom.email.SendMailServlet/servlet-class!-