java邮件数据库_java 发送数据库查询的数据作为excel表格邮件

import com.sun.mail.util.MailSSLSocketFactory;

import jxl.Workbook;

import jxl.write.*;

import jxl.write.biff.RowsExceededException;

import org.springframework.util.StringUtils;

import utils.JDBCUtils;

import javax.activation.DataHandler;

import javax.activation.DataSource;

import javax.activation.FileDataSource;

import javax.mail.*;

import javax.mail.internet.*;

import java.io.File;

import java.io.IOException;

import java.io.UnsupportedEncodingException;

import java.security.GeneralSecurityException;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.Properties;

import java.util.Scanner;

/**

* 创建excel表格

*/

public class input {

public static void main(String[] args) throws IOException, RowsExceededException, WriteException {

//1:创建excel文件

File file=new File("d:/xxx.xls");

file.createNewFile();

//2:创建工作簿

WritableWorkbook workbook= Workbook.createWorkbook(file);

//3:创建sheet,设置第二三四..个sheet，依次类推即可

WritableSheet sheet=workbook.createSh