转载自: https://www.iteye.com/blog/billxiatian-2391213
一.准备阶段:
所需要的jar包:
(1) MySQL-connector-java-5.1.12-bin.jar
(2) poi-3.17-beta1.jar
这两个jar包请在以下网址下载:
链接: http://pan.baidu.com/s/1dFeVOHj 提取密码: sgl1
二.将指定数据库中指定数据表导出到Excel中
import java.io.FileOutputStream;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import com.mysql.jdbc.Connection;