RusultSet row=........;WritableWorkbook wwb = Workbook.createWorkbook(new File(save_path));
jxl.write.WritableSheet ws = wwb.createSheet("Back Up 1", 0);
jxl.write.Label labelC = new jxl.write.Label(0, 0, "操作员编号");
ws.addCell(labelC);
labelC = new jxl.write.Label(1, 0, "操作员姓名");
ws.addCell(labelC);
labelC = new jxl.write.Label(2, 0, "操作类型");
ws.addCell(labelC);
labelC = new jxl.write.Label(3, 0, "操作日期");
ws.addCell(labelC);
labelC = new jxl.write.Label(4, 0, "操作时间");
ws.addCell(labelC);
labelC = new jxl.write.Label(5, 0, "合同编号");
ws.addCell(labelC);
labelC = new jxl.write.Label(6, 0, "操作内容");
ws.addCell(labelC);
while(row.next()){
labelC = new jxl.write.Label(0, i+1, row.getString("op_code"));
ws.addCell(labelC);
labelC = new jxl.write.Label(1, i+1, row.getString("op_name"));
ws.addCell(labelC);
labelC = new jxl.write.Label(2, i+1, row.getString("op_data_type"));
ws.addCell(labelC);
labelC = new jxl.write.Label(3, i+1, row.getString("op_date"));
ws.addCell(labelC);
labelC = new jxl.write.Label(4, i+1, row.getString("op_time"));
ws.addCell(labelC);
labelC = new jxl.write.Label(5, i+1, row.getString("contract_id"));
ws.addCell(labelC);
labelC = new jxl.write.Label(6, i+1, row.getString("op_log"));
ws.addCell(labelC);
}
wwb.write();
wwb.close();
jxl.write.WritableSheet ws = wwb.createSheet("Back Up 1", 0);
jxl.write.Label labelC = new jxl.write.Label(0, 0, "操作员编号");
ws.addCell(labelC);
labelC = new jxl.write.Label(1, 0, "操作员姓名");
ws.addCell(labelC);
labelC = new jxl.write.Label(2, 0, "操作类型");
ws.addCell(labelC);
labelC = new jxl.write.Label(3, 0, "操作日期");
ws.addCell(labelC);
labelC = new jxl.write.Label(4, 0, "操作时间");
ws.addCell(labelC);
labelC = new jxl.write.Label(5, 0, "合同编号");
ws.addCell(labelC);
labelC = new jxl.write.Label(6, 0, "操作内容");
ws.addCell(labelC);
while(row.next()){
labelC = new jxl.write.Label(0, i+1, row.getString("op_code"));
ws.addCell(labelC);
labelC = new jxl.write.Label(1, i+1, row.getString("op_name"));
ws.addCell(labelC);
labelC = new jxl.write.Label(2, i+1, row.getString("op_data_type"));
ws.addCell(labelC);
labelC = new jxl.write.Label(3, i+1, row.getString("op_date"));
ws.addCell(labelC);
labelC = new jxl.write.Label(4, i+1, row.getString("op_time"));
ws.addCell(labelC);
labelC = new jxl.write.Label(5, i+1, row.getString("contract_id"));
ws.addCell(labelC);
labelC = new jxl.write.Label(6, i+1, row.getString("op_log"));
ws.addCell(labelC);
}
wwb.write();
wwb.close();
500 Unhandled exception thrown from /sanju/sanju1010/jh1.jsp:35
Unhandled exception thrown from /sanju/sanju1010/jh1.jsp:35