java sql 查询 导出到excel_java将sql数据导出到excel中?

importjava.io.File;importjxl.Workbook;importjxl.write.Label;importjxl.write.WritableSheet;importjxl.write.WritableWorkbook;importjava.sql.*;importjavax.swing.*;importjava...

import java.io.File;

import jxl.Workbook;

import jxl.write.Label;

import jxl.write.WritableSheet;

import jxl.write.WritableWorkbook;

import java.sql.*;

import javax.swing.*;

import java.awt.*;

import java.awt.event.*;

public class test {

Connection con;

Statement sta;

ResultSet rs;

String sql_driver;

String sql_url;

String user;

String pwd;

int i=1,j=0;

public test(){

try{

// 打开文件

WritableWorkbook book = Workbook.createWorkbook( new File( " test.xls " ));

// 生成名为“第一页”的工作表，参数0表示这是第一页

WritableSheet sheet = book.createSheet( " 第一页 " , 0 );

Label label = new Label( 0 , 0 , " test " );

// 将定义好的单元格添加到工作表中

sheet.addCell(label);

Class.forName(sql_driver);//加载驱动

System.out.println("driver is ok");

con=DriverManager.getConnection(sql_url,user,pwd);

System.out.println("connection is ok");

sta=con.createStatement();

rs=sta.executeQuery("SELECT * FROM TABLE1");

while(rs.next()){

jxl.write.Number number = new jxl.write.Number( i , j , 555.12541 );

sheet.addCell(number);

i++;

j++;

}

}

catch (Exception e)

{

e.printStackTrace();//printStackTrace();

System.out.println(e);

}

}

public static void main(String a[]){

new test();

}

}

怎么错了:?各位高手帮帮忙啊

展开