基于Struts2的OA系统

package com.oa.Action; import java.io.File; import java.sql.Struct; import java.text.DateFormat; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Date; import java.util.HashMap; import java.util.Iterator; import java.util.List; import java.util.Map; import java.util.Set; import jxl.Cell; import jxl.Workbook; import com.oa.ORM.Departement; import com.oa.ORM.Students; import com.oa.ORM.Teachers; import com.oa.ORM.Users; import com.oa.Service.TeachersService; import com.opensymphony.xwork2.ActionContext; import com.opensymphony.xwork2.ActionSupport; public class TeachersAction extends ActionSupport { private TeachersService teachersService; public TeachersService getTeachersService() { return teachersService; } public void setTeachersService(TeachersService teachersService) { this.teachersService = teachersService; } // 查询教师属性 private Integer teacherId; private String time; private String depa; private String major; Set<Students> students; private List<Students> listS; private Map mapset = new HashMap(); // 查询方法 public String getAllStudent() { Teachers teacher = this.teachersService.findById(this.getTeacherId()); this.setTeacherId(teacher.getTeacherId()); Set<Students> sets = teacher.getStudentses(); Iterator<Students> iters = sets.iterator(); this.setStudents(sets); return "success"; } // 级联方法 public String loadme() { /* * ActionContext ctx = ActionContext.getContext(); Map session = * ctx.getContextMap(); session.put(arg0, arg1) */; /* * List<Users> list = new ArrayList<Users>(); for(int i = 0;i<list.size();i++){ * Users user = list.get(i); * mapset.put(user.getUserid(),user.getUsername()); } */ List<Students> list = new ArrayList<Students>(); Students stu = new Students(); stu.setStudentId(new Long(1)); stu.setStudentName(new String("fds")); list.add(stu); try { for (int i = 0; i < list.size(); i++) { Students st = list.get(i); mapset.put(st.getStudentId(), st.getStudentName()); System.out.println(stu.getStudentName()); } mapset.keySet(); } catch (Exception e) { e.printStackTrace(); } return "success"; } // 按条件查询学生 public String getAllS() { System.out.println(getTime() + "a" + this.getDepa() + "a" + this.getMajor()); return "success"; } public Integer getTeacherId() { return teacherId; } public void setTeacherId(Integer teacherId) { this.teacherId = teacherId; } public Set<Students> getStudents() { return students; } public void setStudents(Set<Students> students) { this.students = students; } public String getTime() { return time; } public void setTime(String time) { this.time = time; } public String getDepa() { return depa; } public void setDepa(String depa) { this.depa = depa; } public String getMajor() { return major; } public void setMajor(String major) { this.major = major; } public Map getMapset() { return mapset; } public void setMapset(Map mapset) { this.mapset = mapset; } public List<Students> getListS() { return listS; } public void setListS(List<Students> listS) { this.listS = listS; } // 以下是管理员功能函数 private List<Teachers> teachers; private Teachers teacher; private String tipInfo; public Teachers getTeacher() { return teacher; } public void setTeacher(Teachers teacher) { this.teacher = teacher; } public List<Teachers> getTeachers() { return teachers; } public void setTeachers(List<Teachers> teachers) { this.teachers = teachers; } public String getAllTeacher() { List<Teachers> list = this.teachersService.getAllTeachers(); this.setTeachers(list); return "success"; } // 查询某个教师 public String teacherDetail() throws Exception { Teachers teacher = this.teachersService.findById(this.getTeacherId()); this.setTeacher(teacher); return "success"; } // 确认更新教师信息 public String confirmTeacher() throws Exception { Teachers teacher = new Teachers(); teacher = this.getTeacher(); if (this.teachersService.mdoradTeacher(teacher)) { this.setTipInfo("修改或添加成功"); } else { this.setTipInfo("修改或添加失败"); } return "success"; } // 删除教师信息 public String delTeacher() throws Exception { if (this.teachersService.delTeacher(this.getTeacherId())) { this.setTipInfo("删除成功"); } else { this.setTipInfo("删除失败"); } return "success"; } public String getTipInfo() { return tipInfo; } public void setTipInfo(String tipInfo) { this.tipInfo = tipInfo; } // 读取excel表 private File excelName; public File getExcelName() { return excelName; } public void setExcelName(File excelName) { this.excelName = excelName; } public String readContent() throws Exception { File file = this.getExcelName(); Workbook wb = Workbook.getWorkbook(file); // 一个工作溥中有三个工作表wb.getNumberOfSheets()取得工作表数量 System.out.println(wb.getNumberOfSheets() + "num"); /* * 以下是读取所有内容 for (int i = 0; i < wb.getNumberOfSheets(); i++) { // * 取得工作表中的行数wb.getSheet(i).getRows(); if (wb.getSheet(i).getRows() > 0) { * for (int j = 0; j < wb.getSheet(i).getRows(); j++) { // * 取得工作表中的列数wb.getSheet(i).getRows(); // 新建一个Teacher对象 Teachers teacher = * new Teachers(); for (int k = 0; k < wb.getSheet(i).getColumns(); k++) { // * 定要注意,单元格的读取是按(列，行)进行读取wb.getSheet(i).getCell(列，行); * * Cell cell = wb.getSheet(i).getCell(k, j); * * System.out.println(cell.getContents()); } } } } */ // 以下是插入数据库 // 向方法中插一个集合，采用Hibernate的缓存机制进行批量数据库 DateFormat df = new SimpleDateFormat("MM/dd/yyyy"); List<Teachers> tlist = new ArrayList<Teachers>(); for (int i = 0; i < wb.getNumberOfSheets(); i++) { for (int j = 0; j < wb.getSheet(i).getRows(); j++) { Teachers teacher = new Teachers(); // 姓名 teacher.setTeacherName(wb.getSheet(i).getCell(0, j) .getContents()); // 性别 teacher.setSex(wb.getSheet(i).getCell(1, j).getContents()); // 住址 teacher.setAddress(wb.getSheet(i).getCell(2, j).getContents()); // 民族 teacher.setOriginal(wb.getSheet(i).getCell(3, j).getContents()); // 参加工作时间 teacher.setIntoTime(df.parse(wb.getSheet(i).getCell(4, j) .getContents().trim())); System.out.println(wb.getSheet(i).getCell(4, j).getContents() .trim()); // 出生年月 teacher.setBirthd(df.parse(wb.getSheet(i).getCell(5, j) .getContents().trim())); // 籍贯 teacher.setNation(wb.getSheet(i).getCell(6, j).getContents()); // 邮箱 teacher.setEmail(wb.getSheet(i).getCell(7, j).getContents()); tlist.add(teacher); } } if (this.teachersService.bathSizeAdd(tlist)) { this.setTipInfo("批量插入成功了"); } else { this.setTipInfo("插入失败"); } // 调用批量插入函数 return "success"; } }