java 发送邮件

package test;

import java.io.File;
import java.io.IOException;
import java.io.InputStream;
import java.net.HttpURLConnection;
import java.net.URL;
import java.util.ArrayList;
import java.util.List;

import org.apache.commons.mail.EmailAttachment;

import org.apache.commons.mail.MultiPartEmail;


import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.format.Alignment;
import jxl.format.Border;
import jxl.format.BorderLineStyle;
import jxl.format.Colour;
import jxl.format.UnderlineStyle;
import jxl.format.VerticalAlignment;
import jxl.read.biff.BiffException;
import jxl.write.Label;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;

public class FinalTest {

public static void main(String[] args) throws Exception {
// TODO Auto-generated method stub


  String filePath = "src//ArticleRedirects.xls";
        Workbook book;
  try {
book = Workbook.getWorkbook(new File(filePath));

        //get a Sheet object.   

for (int sheeti= 0;sheeti<book.getNumberOfSheets();sheeti++){

        Sheet sheet = book.getSheet(sheeti); 

       
       
        WritableFont font1 = new WritableFont(WritableFont.ARIAL,14,WritableFont.BOLD,false,UnderlineStyle.NO_UNDERLINE,Colour.RED);

WritableCellFormat cellFormat1 = new WritableCellFormat(font1);
//set background color;
cellFormat1.setBackground(Colour.LIGHT_TURQUOISE);
//set the border;
cellFormat1.setBorder(Border.ALL, BorderLineStyle.THIN);
//set wrap automatically;
cellFormat1.setWrap(true);
//set the text align center;
cellFormat1.setAlignment(Alignment.CENTRE);
//set the text align center vertically;
cellFormat1.setVerticalAlignment(VerticalAlignment.CENTRE);
       
       
        System.out.println(sheet.getName());
        List<String> redirectLink301 = new ArrayList<String>();
        List<String> baseLink301 = new ArrayList<String>();
        List<String> notFoundLinks = new ArrayList<String>();
        List<String> movedLink = new ArrayList<String>();
        List<String> otherStatusLink = new ArrayList<String>();
       
            
    for(int k =0;k<sheet.getRows();k++){
  

Cell cell = sheet.getCell(0, k);
   
    String baseLink = cell.getContents(); 
  if(baseLink.trim()!=""){ 
    URL url = new URL(baseLink);
 
     HttpURLConnection connection = (HttpURLConnection)url.openConnection();
       
         connection.setRequestMethod("GET");
         connection.connect();
       
        connection.setInstanceFollowRedirects( false );
        int code = connection.getResponseCode();

        if(code==301){
       
        URL url2 = new URL(baseLink);
        HttpURLConnection connection2 = (HttpURLConnection)url2.openConnection();
          
            connection2.setRequestMethod("GET");
            connection2.connect();
           InputStream is = connection2.getInputStream();
            
        baseLink301.add(baseLink);
        redirectLink301.add(connection2.getURL()+"");
            System.out.println(code + ":  redirect Link: "+baseLink);
        is.close();
      
       
        }else if(code==302){
        movedLink.add(baseLink);
        System.out.println(code+ ":  Moved links: "+baseLink);
         
        }else if(code==404){
        notFoundLinks.add(baseLink);
        System.out.println(code+ ":  NotFound Link: "+baseLink);
        }else{
       
        otherStatusLink.add(baseLink);
        System.out.println(code+ ":  sucess or other Status Links: "+baseLink);
        }

   }  
} 
   
   
   
    //create excel 

   
      WritableWorkbook wwb = null;
  wwb = Workbook.createWorkbook(new File("src//testResults//resultsOf"+sheet.getName()+".xls"));
 
 
  WritableSheet movedws = wwb.createSheet("302 Moved links", 0);
  Label labelA0 = new Label(0, 0, "HERE ARE THE MOVED LINKS",cellFormat1);//set the format of the first line,first column
  movedws.addCell(labelA0);
  movedws.getSettings().setDefaultColumnWidth(60);
 
 
      for (int k =0;k<movedLink.size();k++){
    Label labelA = new Label(0, k+2, movedLink.get(k));
     try {
    movedws.addCell(labelA);
} catch (RowsExceededException e) {

e.printStackTrace();
} catch (WriteException e) {

e.printStackTrace();
}
     
      } 
     
     
      WritableSheet notFoundws = wwb.createSheet("404 not Found links", 0);
      Label labelL0 = new Label(0, 0, "HERE ARE THE NOTFOUND LINKS",cellFormat1);//set the format of the first line,first column
  notFoundws.addCell(labelL0);
  notFoundws.getSettings().setDefaultColumnWidth(60);
 
      for (int l =0;l<notFoundLinks.size();l++){
    Label labelL = new Label(0, l+2, notFoundLinks.get(l));
     try {
      notFoundws.addCell(labelL);
} catch (RowsExceededException e) {

e.printStackTrace();
} catch (WriteException e) {

e.printStackTrace();
}
     
      } 
     
     
      WritableSheet otherStatusws = wwb.createSheet("otherStatusLinks", 0);
  Label labeln0 = new Label(0, 0, "HERE ARE OTHER STATUS LINKS LIKE 200,5XX",cellFormat1);//set the format of the first line,first column
  otherStatusws.getSettings().setDefaultColumnWidth(60);
  otherStatusws.addCell(labeln0);
     
      for (int n =0;n<otherStatusLink.size();n++){
      Label labeln = new Label(0, n+2, otherStatusLink.get(n));
      try {
      otherStatusws.addCell(labeln);
      } catch (RowsExceededException e) {

e.printStackTrace();
      } catch (WriteException e) {

e.printStackTrace();
}
     
      } 
     
     
      WritableSheet redirect301ws = wwb.createSheet("redirect301Links", 1);
      Label labelB10 = new Label(0, 0, "BASE URL: BEFORE REDIRECT",cellFormat1);//set the format of the first line,first column
      redirect301ws.getSettings().setDefaultColumnWidth(60);
  redirect301ws.addCell(labelB10);
     
      for (int p =0;p<baseLink301.size();p++){
      Label labelB1 = new Label(0, p+2, baseLink301.get(p));
      try {
      redirect301ws.addCell(labelB1);
} catch (RowsExceededException e) {

e.printStackTrace();
} catch (WriteException e) {

e.printStackTrace();
}
     
      } 
  

     
      Label labelB0 = new Label(1, 0, "REDIRECED : AFTER REDIRECT",cellFormat1); //set the format of the first line,second column
      redirect301ws.addCell(labelB0);
      for (int m =0;m<redirectLink301.size();m++){
         
          Label labelB = new Label(1, m+2, redirectLink301.get(m)); 
      try {
      redirect301ws.addCell(labelB);
     
      } catch (RowsExceededException e) {

      e.printStackTrace();
      } catch (WriteException e) {

      e.printStackTrace();
      }
     
      }
     
     
      WritableSheet summary = wwb.createSheet("summary", 0);
     
      summary.getSettings().setDefaultColumnWidth(60);
      Label summaryLab = new Label(0, 0, "HERE ARE SUMMARIES OF  " +sheet.getName(),cellFormat1);//set the format of the first line,first column
      summary.addCell(summaryLab);
     
      Label label301redirects = new Label(0, 2, "301redirect links:" + baseLink301.size());
      Label labelNotFoundLinks = new Label(0, 3, "404 not Found links:" + notFoundLinks.size());
      Label labelmovedLinks = new Label(0, 4, "302 Moved links:" + notFoundLinks.size());
      Label otherStatusLinks = new Label(0, 5, "otherStatus links:" + otherStatusLink.size());
     
     
     
     
      summary.addCell(label301redirects);
      summary.addCell(labelNotFoundLinks);
      summary.addCell(labelmovedLinks);
         summary.addCell(otherStatusLinks);
     
      wwb.write();   
     
      wwb.close(); 
                
                
               
}
System.out.println("================DONE====================");

send();



} catch (BiffException e) {

e.printStackTrace();
} catch (IOException e) {

e.printStackTrace();
}        
        

}


public static void send() throws Exception{


MultiPartEmail email = new MultiPartEmail(); 
 
      
        email.setTLS(true); 
        email.setHostName("smtp.163.com"); 
        email.setAuthentication("zhoulihonggood", "16307932923148"); 
 
        EmailAttachment attachment = new EmailAttachment();
       
        CompressBook cbook = new CompressBook();
        cbook.zip("E:\\workspace\\verifyMMLinks\\src\\testResults");
       
        attachment.setPath("c:\\test.zip"); 
        attachment.setDisposition(EmailAttachment.ATTACHMENT);
        attachment.setDescription("result"); 
        attachment.setName("test.zip"); 
 
        email.addTo("[e-mail]"); 
        email.addCc("[e-mail]");
        email.addCc("[e-mail]");
        email.addTo("[e-mail]");
        email.addCc("[e-mail]");
        email.addCc("[e-mail]");
       
        email.setFrom("[e-mail]");
       
        email.setSubject("TestResults"); 
        email.setMsg("hi Calvin, I have attached the tested results"); 
 
        email.attach(attachment); 
        email.send(); 
}









    }