package com.mathlab.action;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import javax.swing.JFileChooser;
import javax.swing.filechooser.FileFilter;
import jxl.Workbook;
import jxl.format.Alignment;
import jxl.format.Colour;
import jxl.format.UnderlineStyle;
import jxl.format.VerticalAlignment;
import jxl.write.Label;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;
import com.mathlab.model.Student;
import com.mathlab.service.StuService;
import com.opensymphony.xwork2.ActionSupport;
public class ModelToExcelAction extends ActionSupport {
StuService stuService;
public StuService getStuService() {
return stuService;
}
public void setStuService(StuService stuService) {
this.stuService = stuService;
}
@Override
public String execute() throws Exception {
JFileChooser jfc = new JFileChooser();
jfc.setAcceptAllFileFilterUsed(false);
jfc.setFileSelectionMode(JFileChooser.DIRECTORIES_ONLY);//只是针对文件夹有效
jfc.setFileFilter(
new FileFilter(){
public boolean accept(File f) {
// TODO Auto-generated method stub
return f.getName().toLowerCase().endsWith(".xls");
}
public String getDescription() {
// TODO Auto-generated method stub
return "Excel File";
}
}
);
jfc.showSaveDialog(null);
String filePath = jfc.getSelectedFile().getPath();
System.out.println(filePath);
WritableWorkbook wwb;
FileOutputStream fos;
try{
fos = new FileOutputStream(filePath+"\\"+"学生名单"+".xls");
wwb = Workbook.createWorkbook(fos);
WritableSheet ws = wwb.createSheet("sheet1", 0); // 创建一个工作表
// 设置单元格的文字格式
WritableFont wf = new WritableFont(WritableFont.ARIAL,12,WritableFont.NO_BOLD,false,
UnderlineStyle.NO_UNDERLINE,Colour.BLUE);
WritableCellFormat wcf = new WritableCellFormat(wf);
wcf.setVerticalAlignment(VerticalAlignment.CENTRE);
wcf.setAlignment(Alignment.CENTRE);
ws.setRowView(1, 500);
ws.addCell(new Label(0, 0, "记录编号",wcf));
ws.addCell(new Label(1, 0, "用户名", wcf));
ws.addCell(new Label(2, 0, "用户密码", wcf));
ws.addCell(new Label(3, 0, "学生姓名", wcf));
ws.addCell(new Label(4, 0, "学号", wcf));
ws.addCell(new Label(5, 0, "所属班级", wcf));
ws.addCell(new Label(6, 0, "权限", wcf));
//填充数据的内容
Student[] stu = new Student[stuService.listStu().size()];
for (int i = 0; i < stuService.listStu().size(); i++){
stu[i] = (Student)stuService.listStu().get(i);
ws.addCell(new Label(0, i + 1, stu[i].getStuID().toString()));
System.out.println(stu[i].getStuID().toString());
ws.addCell(new Label(1, i + 1, stu[i].getStuName()));
ws.addCell(new Label(2, i + 1, stu[i].getStuPwd()));
ws.addCell(new Label(3, i + 1, stu[i].getRealName()));
ws.addCell(new Label(4, i + 1, stu[i].getStuNum()));
ws.addCell(new Label(5, i + 1, stu[i].getGrade()));
ws.addCell(new Label(6, i + 1, stu[i].getAuthority()));
if(i == 0)
wcf = new WritableCellFormat();
}
wwb.write();
wwb.close();
} catch (IOException e){
} catch (RowsExceededException e){
} catch (WriteException e){}
return "success";
}
}
毕设&课程作业_基于SSH的在线实验系统。在线实验部分用matlab库实现.zip （579个子文件） 
ModelToExcelAction.class 5KB QueryUserByNameAction.class 4KB UploadConfigurationRead.class 4KB StuDaoImpl.class 4KB UploadAction.class 3KB ListExpForStuAction.class 3KB DrawWebMagicAction.class 3KB ExcelToModelAction.class 3KB AddExpAction.class 3KB LoginAction.class 3KB TeaDaoImpl.class 3KB PreAddStuAndCourseAction.class 3KB EditStuAction.class 3KB ListGradeAuthAction.class 2KB PreAddExpAction.class 2KB AddStuAction.class 2KB DownloadAction.class 2KB DisplayFilesAction.class 2KB ReplyNoteAction.class 2KB ManDaoImpl.class 2KB AuthDaoImpl.class 2KB ExperimentDaoImpl.class 2KB AddNoteAction.class 2KB StuAndCourseDaoImpl.class 2KB Experiment.class 2KB EditTeaAction.class 2KB NoteDaoImpl.class 2KB AddCourseAction.class 2KB AddStuAndCourseAction.class 2KB EditAuthAction.class 2KB StuServiceImpl.class 2KB Student.class 2KB AddAuthAction.class 2KB LoginServiceImpl.class 2KB AddManagerAction.class 2KB AddTeacherAction.class 2KB AddGradeAction.class 2KB ListTeaAuthAction.class 2KB ListManAuthAction.class 2KB ListCourseTeaAction.class 2KB ListGradeAction.class 2KB ListAuthAction.class 2KB TeaServiceImpl.class 2KB PreReplyNoteAction.class 2KB ListNoteAction.class 2KB ListTeaAction.class 2KB ListStuAction.class 2KB PreEditStuAction.class 2KB PreEditTeaAction.class 2KB PreEditAuthAction.class 1KB ListExpAction.class 1KB ExpServiceImpl.class 1KB DataAccessUtil.class 1KB AuthServiceImpl.class 1KB Course.class 1KB TimeGenerator.class 1KB ManServiceImpl.class 1KB LoginOutAction.class 1KB NoteServiceImpl.class 1KB StuAndCourseServiceImpl.class 1KB DeleteNoteAction.class 1KB DeleteAuthAction.class 1KB DeleteStuAction.class 1KB DeleteTeaAction.class 1KB Manager.class 1KB Teacher.class 1KB Grade.class 1KB Note.class 1KB CourseServiceImpl.class 1KB CourseDaoImpl.class 1KB GradeServiceImpl.class 1KB GradeDaoImpl.class 1KB UploadFiles.class 1009B StuAndCourse.class 999B ExcelToModelAction$1.class 962B ModelToExcelAction$1.class 962B Authority.class 931B ExportDB.class 761B StuDao.class 639B StuService.class 588B TeaDao.class 569B TeaService.class 521B ManDao.class 445B ExperimentDao.class 403B ExpService.class 398B ManService.class 397B AuthService.class 392B AuthDao.class 381B StuAndCourseService.class 364B StuAndCourseDao.class 357B NoteService.class 354B NoteDao.class 345B CourseService.class 290B GradeService.class 284B CourseDao.class 281B GradeDao.class 275B LoginService.class 236B fox.css 7KB skin.css 4KB addExp.ftl 2KB共 579 条
- 1
- 2
- 3
- 4
- 5
- 6
资源评论
学术菜鸟小晨
- 粉丝: 2w+
- 资源: 5662
最新资源
- Springboot + mybatis-plus + layui 实现的博客系统源代码全套技术资料.zip
- 基于SpringBoot的毕业设计选题系统源代码项目包含全套技术资料.zip
- GGJGJGJGGDGGDGG
- 基于JSP+Servlet的网上书店系统源代码项目包含全套技术资料.zip
- BlurAdmin 是一款使用 AngularJs + Bootstrap实现的单页管理端模版，视觉冲击极强的管理后台，各种动画效果
- 各种排序算法 Python 实现的源代码
- 自动化应用驱动的容器弹性管理平台解决方案
- 基于springboot+element的校园服务平台源代码项目包含全套技术资料.zip
- 金山PDF教育版编辑器
- 各种排序算法java实现的源代码.zip
- 毕业设计- 基于溯源图的APT攻击检测方法优化文档+源码+全部资料+高分项目.zip
- 基于 Kotlin 和 Quarkus 的后台管理系统脚手架，文档+源码+全部资料+高分项目.zip
- 本科毕设-基于超级账本fabric的茶叶溯源系统文档+源码+全部资料+高分项目.zip
- 基于 Vue 2 + Uni-app + Spring Boot 2 的农产品溯源系统，实现了农场管理、农产品 管理、农产品溯源管理、⽤⼾扫码溯源等功能。文档+源码+全部资料+高分项目.zip
- 基于Fabric超级账本为底层的企业资产管理、交易、防伪、溯源一体化的开源区块链解决方案文档+源码+全部资料+高分项目.zip
- 基于babylonjs和这个库，你可以进行联机调试材质，并提供光源调试，版本回溯，版本保存，材质库，聊天室等一系列功能文档+源码+全部资料+高分项目.zip
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
