JAVAWEB在线考试系统项目毕业设计

package com.wei.action.dao.impl; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import javax.servlet.http.HttpServletResponse; import org.apache.struts2.ServletActionContext; import org.springframework.orm.hibernate3.support.HibernateDaoSupport; import com.wei.action.dao.ScoreDao; import com.wei.entity.FinalScore; import com.wei.entity.FinalScoreCount; import com.wei.entity.ManyScore; import com.wei.entity.Paper; import com.wei.entity.Score; import com.wei.entity.Student; import com.wei.util.DBUtil; import com.wei.util.ExcelFileGenerator; public class ScoreDaoImpl extends HibernateDaoSupport implements ScoreDao{ public void saveStudentScore(Score score) throws SQLException { System.out.println("score save succeess!"); this.getHibernateTemplate().save(score); } public Score findStudentScorebyStuId(String StuNumber) throws SQLException { String hql="from Score where stuNumber=?"; Object[] params={StuNumber}; List<Score> scorelist=this.getHibernateTemplate().find(hql,params); if(!scorelist.isEmpty()){ Score s=scorelist.get(0); return s; } return null; } public List<FinalScore> findall() throws SQLException { String hql="from FinalScore"; List<FinalScore> list=this.getHibernateTemplate().find(hql); return list; } public void saveManyChooseScore(ManyScore manyscore) throws SQLException { System.out.println("manyscore save succeess!"); this.getHibernateTemplate().save(manyscore); Score single=findStudentScorebyStuId(manyscore.getStuNumber()); FinalScore finalscore=new FinalScore(); finalscore.setStuScore(single.getStuScore()); finalscore.setStuManyscore(manyscore.getStuManyscore()); finalscore.setStuName(manyscore.getStuName()); finalscore.setStuNumber(manyscore.getStuNumber()); this.getHibernateTemplate().save(finalscore); } public void saveFinalScore(FinalScore finalscore) throws SQLException { System.out.println("finalscore save succeess!"); //this.getHibernateTemplate().save(finalscore); } public void saveFinalScoreCount(FinalScoreCount finalscorecount) throws SQLException { // TODO Auto-generated method stub this.getHibernateTemplate().save(finalscorecount); } public List<FinalScoreCount> findallfinalcount() throws SQLException { String hql="from FinalScoreCount f order by f.sumScore desc"; List<FinalScoreCount> list=this.getHibernateTemplate().find(hql); return list; } public FinalScoreCount findfinalScorecountbyStuId(String StuNumber) throws SQLException { String hql="from FinalScoreCount f where f.stuNumber=?"; Object[] params={StuNumber}; List<FinalScoreCount> scorelist=this.getHibernateTemplate().find(hql,params); if(!scorelist.isEmpty()){ FinalScoreCount s=scorelist.get(0); return s; } return null; } public void deleteallrowsfromFinalScoreCount() throws SQLException { Connection conn=DBUtil.getConnection(); String sql = "DROP TABLE IF EXISTS finalscorecount"; String sql2="create table `onlinexam`.`finalscorecount`(`stuNumber` VARCHAR(255) not null,`stuName` VARCHAR(255) not null,`singleScore` DOUBLE,`manyScore` DOUBLE,`sumScore` DOUBLE,primary key (`stuNumber`))"; PreparedStatement pst = conn.prepareStatement(sql); pst.execute(); System.out.println(sql); pst=conn.prepareStatement(sql2); pst.execute(); System.out.println(sql2); conn.close(); } public void exportExcel(List<FinalScoreCount> users) throws Exception { HttpServletResponse response=ServletActionContext.getResponse(); response.setContentType("application/vnd.ms-excel"); ArrayList<String> fieldName=new ArrayList<String>(); fieldName.add("学号"); fieldName.add("姓名"); fieldName.add("单选题"); fieldName.add("多选题"); fieldName.add("总分"); ArrayList<List<Object>> fieldData=new ArrayList<List<Object>>(); for(FinalScoreCount user:users){ ArrayList<Object> udata=new ArrayList<Object>(); udata.add(user.getStuNumber()); udata.add(user.getStuName()); udata.add(user.getSingleScore()); udata.add(user.getManyScore()); udata.add(user.getSumScore()); fieldData.add(udata); } ExcelFileGenerator excelFileGenerator=new ExcelFileGenerator(fieldName, fieldData); excelFileGenerator.exportExcel(response.getOutputStream()); } public void deleteallscoreinfo(String studentnum) throws Exception { FinalScoreCount n1=findFinalScoreCountbyStuNumber(studentnum); if(n1!=null){ this.getHibernateTemplate().delete(n1); } FinalScore n2=findFinalScorebyStuNumber(studentnum); if(n2!=null){ this.getHibernateTemplate().delete(n2); } ManyScore n3=findManyScorebyStuNumber(studentnum); if(n3!=null){ this.getHibernateTemplate().delete(n3); } Score n4=findScorebyStuNumber(studentnum); if(n4!=null){ this.getHibernateTemplate().delete(n4); } } public FinalScoreCount findFinalScoreCountbyStuNumber(String StuNumber) throws SQLException { String hql="from FinalScoreCount where stuNumber=?"; Object[] params={StuNumber}; List<FinalScoreCount> scorelist=this.getHibernateTemplate().find(hql,params); if(!scorelist.isEmpty()){ FinalScoreCount s=scorelist.get(0); return s; } return null; } public FinalScore findFinalScorebyStuNumber(String StuNumber) throws SQLException { String hql="from FinalScore where stuNumber=?"; Object[] params={StuNumber}; List<FinalScore> scorelist=this.getHibernateTemplate().find(hql,params); if(!scorelist.isEmpty()){ FinalScore s=scorelist.get(0); return s; } return null; } public ManyScore findManyScorebyStuNumber(String StuNumber) throws SQLException { String hql="from ManyScore where stuNumber=?"; Object[] params={StuNumber}; List<ManyScore> scorelist=this.getHibernateTemplate().find(hql,params); if(!scorelist.isEmpty()){ ManyScore s=scorelist.get(0); return s; } return null; } public Score findScorebyStuNumber(String StuNumber) throws SQLException { String hql="from Score where stuNumber=?"; Object[] params={StuNumber}; List<Score> scorelist=this.getHibernateTemplate().find(hql,params); if(!scorelist.isEmpty()){ Score s=scorelist.get(0); return s; } return null; } public void examenddeleteAllscoreinfor() throws SQLException { String hql="from Score"; List<Score> list1=this.getHibernateTemplate().find(hql); String hql1="from ManyScore"; List<ManyScore> list2=this.getHibernateTemplate().find(hql1); String hql2="from FinalScore"; List<FinalScore> list3=this.getHibernateTemplate().find(hql2); String hql3="from FinalScoreCount"; List<FinalScoreCount> list4=this.getHibernateTemplate().find(hql3); String hql4="from Student"; List<FinalScoreCount> list5=this.getHibernateTemplate().find(hql4); this.getHibernateTemplate().deleteAll(list1); this.getHibernateTemplate().deleteAll(list2); this.getHibernateTemplate().deleteAll(list3); this.getHibernateTemplate().deleteAll(list4); this.getHibernateTemplate().deleteAll(list5); } public void examenddeleteAllscoreinforExceptStudentInfo() throws SQLException { String hql="from Score"; List<Score> list1=this.getHibernateTemplate().find(hql); String hql1="from ManyScore"; List<ManyScore> list2=this.getHibernateTemplate().find(hql1); String hql2="from F