Apache POI(8):数据库

package com.hthk.iisz.util;import java.io.File;import java.io.FileOutputStream;import java.sql.Connection;import java.sql.ResultSet;import java.sql.Statement;import org.apache.poi.xssf.usermodel.XSSFCell;import org.apache.poi.xssf.usermodel.XSSFRow;import org.apache.poi.xssf.usermodel.XSSFSheet;import org.apache.poi.xssf.usermodel.XSSFWorkbook;public class DBTest {public static void main(String[] args) throws Exception {  excelDatabase();}    public static void excelDatabase() throws Exception{Connection conn = JdbcConn.getConn();Statement stmt = conn.createStatement();ResultSet rs = stmt.executeQuery("select customer, title from reg_form");XSSFWorkbook workbook = new XSSFWorkbook();XSSFSheet sheet = workbook.createSheet("reg_form db");XSSFRow row = sheet.createRow(1);XSSFCell cell;cell = row.createCell(1);cell.setCellValue("customer");cell = row.createCell(2);cell.setCellValue("title");int i=2;while(rs.next()){row = sheet.createRow(i++);cell = row.createCell(1);cell.setCellValue(rs.getString("customer"));cell = row.createCell(2);cell.setCellValue(rs.getString("title"));}FileOutputStream fos = new FileOutputStream(new File("reg_form.xlsx"));workbook.write(fos);fos.close();System.out.println("reg_form.xlsx written successfully");}}