import java.io.*;
import java.sql.*;
import jxl.Workbook;
import jxl.write.*;
public class Excel {
public Excel() throws Exception
{
WritableWorkbook writeBook = Workbook.createWorkbook(new File("./write.xls")); //创建名为write的excel表格 在当前目录下
WritableSheet firstSheet = writeBook.createSheet("logon_users_info", 1); // 表名称,页数
Class.forName(DB_link_Info.driverName); //数据库链接
Connection con=DriverManager.getConnection(DB_link_Info.dbURL,DB_link_Info.userName,DB_link_Info.userPwd);
Statement sta=con.createStatement();
ResultSet rs=sta.executeQuery("select * from logon_users_info "); //将logon_users_info整张表写入write文件中
int count = rs.getMetaData().getColumnCount(); //获得数据库中logon_users_info表的列数
for(int j=0;j<count;j++){ //将表logon_users_info的属性输出到excel表第一行
jxl.write.Label label = new jxl.write.Label( j,0,rs.getMetaData().getColumnName(j+1));
firstSheet.addCell(label);
}
int i = 1;
while(rs.next()){ //遍历数据库中的表logon_users_info并写入excel
for(int j=0;j<count;j++){
jxl.write.Label label = new jxl.write.Label( j,i,rs.getString(j+1));
firstSheet.addCell(label);
}
i++;
}
rs.close();
sta.close();
writeBook.write();
writeBook.close();
}
public static void main(String[] args) throws Exception {
new Excel();
}
}
数据库为SQLServer2012
导出的excel表