SSH框架javaweb学生成绩管理系统源码

package com.action; import java.io.UnsupportedEncodingException; import java.util.ArrayList; import java.util.List; import java.util.Map; import org.apache.struts2.ServletActionContext; import com.dao.TBanjiDAO; import com.dao.TChengjiDAO; import com.dao.TKechengDAO; import com.dao.TLaoshiDAO; import com.dao.TXueshengDAO; import com.dao.TZhuanyeDAO; import com.model.TBanji; import com.model.TChengji; import com.model.TXuesheng; import com.model.TLaoshi; import com.model.TZhuanye; import com.opensymphony.xwork2.ActionSupport; import com.util.Pagination; public class chengjiAction extends ActionSupport { private int zhuanyeId; private int banjiId; private int xueshengId; private int kechengId; private int chengjiId; private String kaoshifenshu; private String kaoshishijian; private String kaoshileixing; private String message; private String path; private TLaoshiDAO laoshiDAO; private TZhuanyeDAO zhuanyeDAO; private TBanjiDAO banjiDAO; private TXueshengDAO xueshengDAO; private TChengjiDAO chengjiDAO; private TKechengDAO kechengDAO; private String key = ""; /* * 没用 public String selectZhuanye() { String sql = * "from TZhuanye where zhuanyeDel='no' "; List zhuanyeList = * zhuanyeDAO.getHibernateTemplate().find(sql); Map request = (Map) * ServletActionContext.getContext().get("request"); * request.put("zhuanyeList", zhuanyeList); return ActionSupport.SUCCESS; } */ // 教师管理成绩 时 按班级显示学生 public String selectBanji() { String sql = "from TBanji where banjiDel='no' "; // 这里是Session判断,获取当前登录的教师的专业ID,然后只选择属于此专业的班级 Map session = ServletActionContext.getContext().getSession(); TLaoshi laoshi = (TLaoshi) session.get("laoshi");// 只显示当前登录教师的 if (laoshi != null) { sql+=" and zhuanyeId='" + laoshi.getZhuanyeId() + "'"; } List banjiList = banjiDAO.getHibernateTemplate().find(sql); Map request = (Map) ServletActionContext.getContext().get("request"); request.put("banjiList", banjiList); return ActionSupport.SUCCESS; } // 教师管理成绩 时 先选择学生 public String selectXuesheng() { String sql = "from TXuesheng where xueshengDel='no' and banjiId=" + banjiId; List xueshengList = xueshengDAO.getHibernateTemplate().find(sql); Map request = (Map) ServletActionContext.getContext().get("request"); request.put("xueshengList", xueshengList); return ActionSupport.SUCCESS; } // 根据所选的学生和教师的课程ID管理成绩 public String chengjiMana() { Map session = ServletActionContext.getContext().getSession(); TLaoshi laoshi = (TLaoshi) session.get("laoshi");// 只显示当前登录教师的课程的学生 String sql = "from TChengji where xueshengId=? and kechengId=?"; Object[] con = { xueshengId, laoshi.getKechengId() }; List chengjiList = chengjiDAO.getHibernateTemplate().find(sql, con); for (int i = 0; i < chengjiList.size(); i++) { TChengji chengji = (TChengji) chengjiList.get(i); int kechengId = chengji.getKechengId(); chengji.setChengjiOne1(kechengDAO.findById(kechengId).getKechengName());// 用于显示课程名称 chengji.setChengjiOne2(xueshengDAO.findById(chengji.getXueshengId()).getXueshengRealname());// 用于显示学生姓名 } Map request = (Map) ServletActionContext.getContext().get("request"); request.put("chengjiList", chengjiList); return ActionSupport.SUCCESS; } // 管理员删除 public String chengjiDel() { TChengji chengji = chengjiDAO.findById(chengjiId); chengjiDAO.delete(chengji); this.setMessage("删除成功"); this.setPath("chengjiChakan.action"); return "succeed"; } // 教师删除 public String chengjiDelQian() { TChengji chengji = chengjiDAO.findById(chengjiId); chengjiDAO.delete(chengji); this.setMessage("删除成功"); this.setPath("chengjiMana.action?xueshengId=" + xueshengId + "&kechengId=" + kechengId); return "succeed"; } // 教师发布成绩 public String chengjiAdd() { TChengji chengji = new TChengji(); chengji.setXueshengId(xueshengId); chengji.setKechengId(kechengId); chengji.setKaoshifenshu(kaoshifenshu ); chengji.setKaoshishijian(kaoshishijian); chengji.setKaoshileixing(kaoshileixing); Map session = ServletActionContext.getContext().getSession(); TLaoshi laoshi = (TLaoshi) session.get("laoshi"); chengji.setChengjiAddUser(laoshi.getLaoshiId().toString()); chengjiDAO.save(chengji); this.setMessage("成绩录入成功"); this.setPath("chengjiMana.action?xueshengId=" + xueshengId + "&kechengId=" + laoshi.getKechengId()); return "succeed"; } // 学生查看成绩 public String chengjiMine() { String sql = "from TChengji where xueshengId=? order by kechengId"; Map session = ServletActionContext.getContext().getSession(); TXuesheng xuesheng = (TXuesheng) session.get("xuesheng"); Object[] con = { xuesheng.getXueshengId() }; List chengjiList = chengjiDAO.getHibernateTemplate().find(sql, con); for (int i = 0; i < chengjiList.size(); i++) { TChengji chengji = (TChengji) chengjiList.get(i); int kechengId = chengji.getKechengId(); chengji.setChengjiOne1(kechengDAO.findById(kechengId).getKechengName());//课程名称 chengji.setChengjiOne2(laoshiDAO.findById( Integer.parseInt(chengji.getChengjiAddUser())).getLaoshiRealname());// 用于显示学生姓名 } Map request = (Map) ServletActionContext.getContext().get("request"); request.put("chengjiList", chengjiList); return ActionSupport.SUCCESS; } // 管理员成绩查看 public String chengjiChakan() throws UnsupportedEncodingException { System.out.println("^^" + zhuanyeId + "^^^^" + banjiId); StringBuffer sql = new StringBuffer("from TXuesheng where xueshengDel='no' "); if (zhuanyeId != 0) { sql.append(" and zhuanyeId=" + zhuanyeId); } if (banjiId != 0) { sql.append(" and banjiId=" + banjiId); } System.out.println(sql.toString()); if (key != null) { // key = new String(key.getBytes("iso8859-1"), "UTF-8"); sql.append(" and xueshengRealname like '%" + key.trim() + "%'"); } sql.append(" order by xueshengId"); List xueshengList = xueshengDAO.getHibernateTemplate().find(sql.toString());// 先检索出学生 List chengjiList = new ArrayList(); for (int i = 0; i < xueshengList.size(); i++) { TXuesheng xuesheng = (TXuesheng) xueshengList.get(i); int xueshengId = xuesheng.getXueshengId(); String SQL2 = "from TChengji where xueshengId=" + xueshengId; if (kechengId != 0) { SQL2 += (" and kechengId=" + kechengId); } List list1 = chengjiDAO.getHibernateTemplate().find(SQL2);// 学生和课程检索成绩 for (int j = 0; j < list1.size(); j++) { chengjiList.add(list1.get(j)); } } for (int i = 0; i < chengjiList.size(); i++) { TChengji chengji = (TChengji) chengjiList.get(i); int kechengId = chengji.getKechengId(); int xueshengId = chengji.getXueshengId(); chengji.setChengjiOne1(kechengDAO.findById(kechengId).getKechengName());// 绑定课程名称 chengji.setChengjiOne2(xueshengDAO.findById(xueshengId).getXueshengRealname());// 绑定学生姓名 TXuesheng xuesheng = xueshengDAO.findById(xueshengId); chengji.setChengjiOne3(zhuanyeDAO.findById(xuesheng.getZhuanyeId()).getZhuanyeName());// 关联专业显示 chengji.setChengjiOne4(banjiDAO.findById(xuesheng.getBanjiId()).getBanjiName());// 关联班级显示 } // 分页信息 int pageSize = 10; int fromIndex = (index - 1) * pageSize; int toIndex = Math.min(fromIndex + pageSize, chengjiList.size()); List chengjiListFenye = chengjiList.subList(fromIndex, toIndex); Pagination p = new Pagination();// 创建 分页对象 p.setIndex(index);// 设置当前页数 p.setPageSize(pageSize); p.setTotle(chengjiList.size());// 设置总共的条数 p.setData(chengjiListFenye);// 设置数据 p.setPath("chengjiChakan.action?");// 跳转的路径 Map request = (Map) ServletActionContext.getContext().get("request