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");
		
	}
}