查询MySQL数据库,数据输出excel文件并含表头信息

package com.Java.test;

import java.io.File;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.Java.Demo.User;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;


public class ExcelTest {
	private static final String URL = "jdbc:mysql://localhost:3306/goods";
	private static final String NAME = "1234";
	private static final String PASSWORD = "Admin@123";

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

		// 1. 导出Excel的路径
		String filePath = "exportTest.xls";
		WritableWorkbook wwb = null;
		Connection connection = DriverManager.getConnection(URL, NAME, PASSWORD);
		List excelTests = new ArrayList();
		PreparedStatement preparedStatement = null;
		String sql = "select * from user";
		ResultSet resultSet = null;
		User exce = null;
		try {
			wwb = Workbook.createWorkbook(new File(filePath));
		} catch (Exception e) {
			e.printStackTrace();
		}

		// 创建Excel表的"用户信息"区域的数据
		WritableSheet sheet = wwb.createSheet("用户信息", 0);// 或者rwb.getSheet(0)获取第一个区域
		try {
			// 2. 连接数据库的几行代码
			preparedStatement = connection.prepareStatement(sql);

			resultSet = preparedStatement.executeQuery();

			while (resultSet.next()) {
				exce = new User();
				exce.setId(resultSet.getInt("id"));
				exce.setName(resultSet.getString("name"));
				exce.setPwd(resultSet.getString("pwd"));
				excelTests.add(exce);

			}
			// 向单元格添加表头信息
			sheet.addCell(new Label(0, 0, "id"));
			sheet.addCell(new Label(1, 0, "用户名"));
			sheet.addCell(new Label(2, 0, "密码"));
			for (int i = 0; i < excelTests.size(); i++) {
				// Number对应数据库的int类型数据
				sheet.addCell(new jxl.write.Number(0, i + 1, excelTests.get(i).getId()));
				// Label对应数据库String类型数据
				sheet.addCell(new Label(1, i + 1, excelTests.get(i).getName()));
				sheet.addCell(new Label(2, i + 1, excelTests.get(i).getPwd()));

			}
			wwb.write();

		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			wwb.close();
		}
		System.out.println("excel文件输出成功");

	}

}