addnorscore.java

jsp+servlet+javabean实现的学校教务管理系统 (1)系统测试环境: Windows xp sp2 + myEclipse5.5 + Tomcat6.0 + SQLServer2

package com.sevenEleven.servlet.teacher;

import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import com.sevenEleven.Beans.CteacherBean;
import com.sevenEleven.javaBean.teacher.DBO;
import com.sevenEleven.javaBean.teacher.Doing;

 public class AddNorScore extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {

	public AddNorScore() {
		super();
	}   	

	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		HttpSession session=request.getSession();
		String teacherID=String.valueOf(((CteacherBean)session.getAttribute("teacher")).getT_id());
		if (teacherID==null||teacherID==""){
			request.setAttribute("errorMSG","没有登陆或登陆已超时");
			request.getRequestDispatcher("error.jsp").forward(request,response);
			return;
		}
		String UpdateScore=request.getParameter("stuScore");
		int iUpdateScore = Integer.parseInt(UpdateScore);
		String score = request.getParameter("Scored");
		int iScore = Integer.parseInt(score);
		String scorePersent = request.getParameter("scorePersent");
		if(scorePersent == null || scorePersent == ""){
			request.setAttribute("errorMSG","没有给出下时分的百分比!!");
			request.getRequestDispatcher("error.jsp").forward(request,response);
			return;
		}
		int iScorePersent = Integer.parseInt(scorePersent);
		
		 //由平时分和试面分得到总分
		iScore = iScore * (100 - iScorePersent)/100 + iUpdateScore * iScorePersent/100;
		score = String.valueOf(iScore);
		//score = Integer.parseInt(score)*(100-Integer.parseInt(scorePersent))/100 + Integer.parseInt(UpdateScore) * Integer.parseInt(scorePersent)/100;  
		String s_id=request.getParameter("s_id");
		int x = 100-Integer.valueOf("12");
		if (UpdateScore==null||s_id==null){
			request.setAttribute("errorMSG","数据非法");
			request.getRequestDispatcher("error.jsp").forward(request,response);
		}
		Doing DB=DBO.DBODoing();
		if (!DB.IsTeacherStu(teacherID,s_id)){
			request.setAttribute("errorMSG","此学生不是你的学生,无权修改");
			request.getRequestDispatcher("error.jsp").forward(request,response);
			return;
		}
		if (DB.AddStudentScore(teacherID,s_id,score,UpdateScore)){
			request.setAttribute("successMSG","更新学生成绩成功");
			request.setAttribute("location","StuResult?s_id="+s_id);
			request.getRequestDispatcher("success.jsp").forward(request,response);
			return;
		}else{
			request.setAttribute("errorMSG","更新失败,联系系统管理员");
			request.getRequestDispatcher("error.jsp").forward(request,response);
		}
		DB.Close();
	}  	

	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		doGet(request,response);
	}   	  	    
}