scores_add.java

试题库自动组卷系统试题库自动组卷系统试题库自动组卷系统试题库自动组卷系统试题库自动组卷系统试题库自动组卷系统

package admin;
import java.io.*;
import java.sql.*;
import com.opensymphony.xwork.ActionSupport;

public class Scores_Add extends ActionSupport
{
  private String message;
  private String ArrangeId;
  private String Student_Id;
  private String Score;
  public ResultSet rs=null;
  dbcont db=new dbcont();
  public String execute() {
    if (ArrangeId == null || "".equals(ArrangeId)) {
      addFieldError("ArrangeId","请选择课程安排号");
      return INPUT;
    }
    else if (Student_Id == null || "".equals(Student_Id)) {
      addFieldError("Student_Id", "请输入学号");
      return INPUT;
    }
    else if (Score == null || "".equals(Score)) {
      addFieldError("Score", "请输入分数,没分数请输入0");
      return INPUT;
    }
    else if(excute()==false){
      addFieldError("excute()","此学生成绩已经添加过");
      return INPUT;
    }
    else if(stuIdexcu()==false){
      addFieldError("stuIdexcu()","不存在此学生");
      return INPUT;
    }
    else if(lsn_stu()==false){
      addFieldError("lsn_stu()","此学生没有选这门课程");
      return INPUT;
    }
    else {
      
      try
      {
      	db.getcon();
        db.stmt.executeUpdate("insert into scores values('"+ArrangeId+"','"+Student_Id+"','"
                                +Score+"')");
        
        db.close();
      }
      catch(Exception ex){}
        message="添加成功";
        return SUCCESS;
    }

  }
  
  public boolean lsn_stu()
  {
  	boolean flag=false;
  	String arrange;
  	try{
  	   db.getcon();
  	   rs=db.stmt.executeQuery("select * from students,arrangeld "
				  +"where arrangeld.Class_Id=Students.Class_Id "
				  +"and student_Id='"+Student_Id+"'");
	   while(rs.next())
	   {
	   	arrange=rs.getString("ArrangeId");
	   	if(arrange.equals(ArrangeId)){
	   		flag=true;
	   		break;
	   	}
	   	else{
	    	       flag=false;
	   	}
	   }
	   rs.close();
	   db.close();
         }
         catch(Exception ex){}
         return flag;
  }

  
  public boolean stuIdexcu()
  {
   boolean flag=false;
    try{
    	db.getcon();
      rs = db.stmt.executeQuery("select * from students where Student_Id="+Student_Id);
     if(rs.next()) {
        flag = true;
      }
      rs.close();
      db.close();
    }
    catch(Exception ex){}
    return flag;
  }//判断是否已经存在学期ID和NAME

  public boolean excute(){
    boolean flag=true;
    try{
    	db.getcon();
      rs = db.stmt.executeQuery("select * from scores where ArrangeId="+ArrangeId +
                                 " and Student_Id="+Student_Id);
     if(rs.next()) {
        flag = false;
      }
      rs.close();
      db.close();
    }
    catch(Exception ex){}
    return flag;
  }//判断是否已经存在学期ID和NAME
  
  public String getMessage() {
    return message;
  }
////////////////////////////////////////////////////////
  public void setArrangeId(String ArrangeId)
  {
  	this.ArrangeId=ArrangeId;
  }
  public String getArrangeId()
  {
  	return ArrangeId;
  }
/////////////////////////////////////////////////////////
  public void setStudent_Id(String Student_Id) {
    this.Student_Id = Student_Id;
  }
  public String getStudent_Id() {
    return Student_Id;
  }
//////////////////////////////////////////////////////////
  public void setScore(String Score) {
    this.Score = Score;
  }
  public String getScore() {
    return Score;
  }


}