我想把ACCESS里的数据导入到excel里面但是插入后只有一行显示在excel里面。
try
{
c = DriverManager.getConnection( "jdbc:odbc:students", "","" );
sq1 = c.createStatement();
rs = sq1.executeQuery("select * from stu" );
int index=0;
WritableWorkbook book;
try {
book = Workbook.createWorkbook(new File("e:/atoecel.xls"));
WritableSheet sheet = book.createSheet("Sheet_1", 0); while (rs.next())
{
s1 = rs.getString(1);
s2 = rs.getString(2);
s3 = rs.getString(3);
s4 = rs.getString(4);
Label label1 = new Label (0,index,s1);
sheet.addCell(label1);
Label label2 = new Label (1,index,s2);
sheet.addCell(label2);
Label label3 = new Label (2,index,s3);
sheet.addCell(label3);
Label label4 = new Label (3,index,s4);
sheet.addCell(label4);
book.write();
index++;
}
c.close();
book.close();
}
catch (Exception e)
{
}
}
catch (Exception ex)
{
}
请大家指教,谢谢
try
{
c = DriverManager.getConnection( "jdbc:odbc:students", "","" );
sq1 = c.createStatement();
rs = sq1.executeQuery("select * from stu" );
int index=0;
WritableWorkbook book;
try {
book = Workbook.createWorkbook(new File("e:/atoecel.xls"));
WritableSheet sheet = book.createSheet("Sheet_1", 0); while (rs.next())
{
s1 = rs.getString(1);
s2 = rs.getString(2);
s3 = rs.getString(3);
s4 = rs.getString(4);
Label label1 = new Label (0,index,s1);
sheet.addCell(label1);
Label label2 = new Label (1,index,s2);
sheet.addCell(label2);
Label label3 = new Label (2,index,s3);
sheet.addCell(label3);
Label label4 = new Label (3,index,s4);
sheet.addCell(label4);
book.write();
index++;
}
c.close();
book.close();
}
catch (Exception e)
{
}
}
catch (Exception ex)
{
}
请大家指教,谢谢
解决方案 »
- 将任务在线程池之间传递,对效率影响大吗?
- java 程序设定标签的位置
- 如何得到某个类的实例的调用者类
- 新手求助
- 谁能给我个JIVE的源代码,以前有的,格式化了
- 请教,java.util中的Date和calendar,我不知道它们各自的用处和区别?我看不太懂Document,谢谢!
- System.out.flush();到底有什么用?
- 急救:关于Vecotr类(哪位好心大大帮忙看看)
- 我用JBuilder的XYLayout,比较爽,可是离开了JBuilder环境就不行了,怎么办?
- 在FRAME中添加的PANEL,怎样实现刷新?
- 刚刚解除swt,写了一小段代码,怎么样才能使这个界面里的控件,根据这个shell的大小,自动变化大小呢?
- GridBagLayout的布局问题
放到循环外