java+mysql学生学籍后台管理系统OA源码

package com.two.studentRoll.service.impl; import java.io.File; import java.io.IOException; import java.io.InputStream; import java.io.OutputStream; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Enumeration; import java.util.List; import java.util.Map; import java.util.UUID; import javax.annotation.Resource; import org.apache.commons.compress.archivers.zip.ZipArchiveEntry; import org.apache.commons.compress.archivers.zip.ZipFile; import org.apache.commons.io.FileUtils; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import com.my.ms.framework.persistence.hibernate.IBaseDao; import com.my.ms.framework.persistence.model.Page; import com.two.studentRoll.model.Classes; import com.two.studentRoll.model.Degree; import com.two.studentRoll.model.Student; import com.two.studentRoll.service.IClassService; import com.two.studentRoll.service.IStudentService; /** * 学生 * * @author The bird is my most loving smile * @version 1.0 * @updated 19-二月-2014 20:46:09 * */ @Service("studentService") @Transactional(readOnly = true) public class StudentServiceImpl implements IStudentService { @Resource(name = "ClassService") private IClassService classService; @Resource private IBaseDao dao; // 用来输出日志 private static final Logger LOG = LoggerFactory .getLogger(StudentServiceImpl.class); @Override @Transactional(readOnly = false) public void addStudent(Student student, int classId, int degreeId) { Degree degree = dao.queryEntityById(Degree.class, degreeId); Classes classes = dao.queryEntityById(Classes.class, classId); student.setDegree(degree); student.setCla(classes); dao.addEntity(student); } @Override public void exportStudentBasic(Map<String, Object> outPutMap, OutputStream out, InputStream templateFile) { String fileName = (String) outPutMap.get("fileName"); int classId = (Integer) outPutMap.get("classId"); String className = (String) outPutMap.get("className"); List<Student> list = dao.queryEntitys("from Student where cla.id=? ", new Object[] { classId }); this.outputString(list, className, fileName, out, templateFile); } @SuppressWarnings("deprecation") public void outputString(List<Student> list, String className, String filteName, OutputStream out, InputStream templateFile) { HSSFWorkbook wb; try { wb = new HSSFWorkbook(templateFile); HSSFSheet sheet = wb.getSheetAt(0); // 设置标题 sheet.getRow(0).getCell(0).setCellValue(className + "学生信息表"); // 取得模板行数据 HSSFRow templateRow = sheet.getRow(2); int startRow = 2; for (Student s : list) { HSSFRow row = sheet.createRow(startRow); // ID HSSFCell cell_id = row.createCell(0); cell_id.setCellStyle(templateRow.getCell(0).getCellStyle()); cell_id.setCellValue(s.getId()); // 学生姓名 HSSFCell cell_name = row.createCell(1); cell_name.setCellStyle(templateRow.getCell(1).getCellStyle()); cell_name.setCellValue(s.getName()); // 学生性别 HSSFCell cell_sex = row.createCell(2); cell_sex.setCellStyle(templateRow.getCell(2).getCellStyle()); cell_sex.setCellValue(s.getSex()); // 学生年龄 HSSFCell cell_age = row.createCell(3); cell_age.setCellStyle(templateRow.getCell(3).getCellStyle()); cell_age.setCellValue(s.getAge()); // 学生报名编号 HSSFCell cell_code = row.createCell(4); cell_code.setCellStyle(templateRow.getCell(4).getCellStyle()); cell_code.setCellValue(s.getSchoolStartCode()); // 学生报名时间 HSSFCell cell_stadeTime = row.createCell(5); cell_stadeTime.setCellStyle(templateRow.getCell(5) .getCellStyle()); cell_stadeTime.setCellValue(new SimpleDateFormat("yyyy-mm-dd") .format(s.getSchoolStartTime())); // 学生所在班级 HSSFCell cell_classes = row.createCell(6); cell_classes .setCellStyle(templateRow.getCell(6).getCellStyle()); cell_classes.setCellValue(s.getCla().getClassName()); // 计算机程度 HSSFCell cell_computerKnow = row.createCell(7); cell_computerKnow.setCellStyle(templateRow.getCell(7) .getCellStyle()); cell_computerKnow.setCellValue(s.getComputerKnow()); // 毕业学院 HSSFCell cell_graduateSchool = row.createCell(8); cell_graduateSchool.setCellStyle(templateRow.getCell(8) .getCellStyle()); cell_graduateSchool.setCellValue(s.getGraduateSchool()); // 身份证号 HSSFCell cell_iDcard = row.createCell(9); cell_iDcard.setCellStyle(templateRow.getCell(9).getCellStyle()); cell_iDcard.setCellValue(s.getiDcard()); // 专业 HSSFCell cell_major = row.createCell(10); cell_major.setCellStyle(templateRow.getCell(10).getCellStyle()); cell_major.setCellValue(s.getMajor()); // 家长电话 HSSFCell cell_partentPhone = row.createCell(11); cell_partentPhone.setCellStyle(templateRow.getCell(11) .getCellStyle()); cell_partentPhone.setCellValue(s.getPartentPhone()); // 学生电话 HSSFCell cell_studentPhone = row.createCell(12); cell_studentPhone.setCellStyle(templateRow.getCell(12) .getCellStyle()); cell_studentPhone.setCellValue(s.getStudentPhone()); // 信产部考试 HSSFCell cell_seTest = row.createCell(13); cell_seTest .setCellStyle(templateRow.getCell(13).getCellStyle()); cell_seTest.setCellValue(s.getSeTest()); // 是否住宿 HSSFCell cell_isDormitory = row.createCell(14); cell_isDormitory.setCellStyle(templateRow.getCell(14) .getCellStyle()); cell_isDormitory.setCellValue(s.getIsDormitory()); // 学历 HSSFCell cell_degree = row.createCell(15); cell_degree .setCellStyle(templateRow.getCell(15).getCellStyle()); cell_degree.setCellValue(s.getDegree().getDegreeName()); // 备注 HSSFCell cell_remark = row.createCell(16); cell_remark .setCellStyle(templateRow.getCell(16).getCellStyle()); cell_remark.setCellValue(s.getRemark()); startRow = startRow + 1; } wb.write(out); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } } @Override public Student findByStudentId(int studentId) { Student stu = dao.queryEntityById(Student.class, studentId); return stu; } // @Override public Page<Student> findByStudentItem(Map queryMap, int pageNO) { StringBuffer hql = new StringBuffer("from Student s where 1=1 "); List<Object> params = new ArrayList<Object>(); if (queryMap.containsKey("studentName")) { hql.append("and s.name like ?"); params.add(queryMap.get("studentName")); } if (queryMap.containsKey("classesId")) { hql.append("and s.cla.id = ?"); params.add(queryMap.get("classesId")); } if (queryMap.containsKey("age")) { hql.append("and s.age = ?"); params.add(queryMap.get("age")); } if (queryMap.containsKey("degreeId")) { hql.append("and s.degree.id = ?"); params.add(queryMap.get("degreeId")); } if (queryMap.containsKey("sex")) { hql.append("and s.sex = ?"); params.add(queryMap.get("sex")); } if (queryMap.containsKey("state")) { hql.append("and s.state = ?"); params.add(queryMap.get("state")); } if (queryMap.containsKey("isDormitory")) { hql.append("and s.isDormitory = ?"); params.add(queryMap.get("isDormitory")); } Page p = this.dao.queryEntityByPage(pageNO, pageCount, hql.toString(), params.toArray()); return p; }