java导出oracle到excel_java导出数据到excel里：直接导出和导出数据库数据

packagecom.ij34.util;importjava.io.FileNotFoundException;importjava.io.FileOutputStream;importjava.io.IOException;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;importjavax.naming.NamingException;importorg.apache.poi.hssf.usermodel.HSSFCell;importorg.apache.poi.hssf.usermodel.HSSFRow;importorg.apache.poi.hssf.usermodel.HSSFSheet;importorg.apache.poi.hssf.usermodel.HSSFWorkbook;/***@authorAdmin

* @date 创建时间：2017年8月29日 上午11:35:28

*@version1.0

*@type_name Test01

*从数据库里导出Excel文件*/

public classTest01 {public static void main(String[] args) throwsFileNotFoundException, IOException, SQLException, NamingException, ClassNotFoundException {

Class.forName("oracle.jdbc.OracleDriver");

Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "lyx", "123456");

String sqlStr="select * from student";

Statement stmt=conn.createStatement();

ResultSet rs=stmt.executeQuery(sqlStr);

HSSFWorkbook wb= newHSSFWorkbook();

HSSFSheet sheet=wb.createSheet("table03");

HSSFRow row;int i=0;

HSSFCell cell;while(rs.next()){

row=sheet.createRow(i);

cell=row.createCell(0); //Excel里第一(A)列

cell.setCellValue(String.valueOf(rs.getInt(1)));

cell=row.createCell(1);

cell.setCellValue(String.valueOf(rs.getString(2)));

cell=row.createCell(2);

cell.setCellValue(String.valueOf(rs.getInt(3)));

cell=row.createCell(3);

cell.setCellValue(String.valueOf(rs.getInt(4)));

cell=row.createCell(4);

cell.setCellValue(String.valueOf(rs.getString(5)));

i++;

}

wb.write(new FileOutputStream("table03.xls"));

System.out.println("导出xls成功!");

rs.close();

stmt.close();

conn.close();

}

}