arrangeld_add.java

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

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

public class Arrangeld_Add extends ActionSupport
{
  private String message;
  private String ArrangeId;
  private String TermId;
  private String LessonId;
  private String Class_Id;
  private String Teacher;
  private String Hours;
  private String LessonType;
  private String kaoshiTime;
  private String kaoshiType;
  private String examNum;
  public ResultSet rs=null;
  dbcont db=new dbcont();
  public String execute() {
    if (ArrangeId == null || "".equals(ArrangeId)) {
      addFieldError("ArrangeId","请输入课程安排编号");
      return INPUT;
    }
    else if (TermId == null || "".equals(TermId)) {
      addFieldError("TermId", "请选择学期");
      return INPUT;
    }
    else if (LessonId == null || "".equals(LessonId)) {
      addFieldError("LessonId", "请选择课程");
      return INPUT;
    }
    else if (Class_Id == null || "".equals(Class_Id)) {
      addFieldError("Class_Id", "请选择班级");
      return INPUT;
    }
    else if (Teacher == null || "".equals(Teacher)) {
      addFieldError("Teacher", "请输入教师");
      return INPUT;
    }
    else if (Hours == null || "".equals(Hours)) {
      addFieldError("Hours", "请输入学时");
      return INPUT;
    }
    else if (LessonType == null || "".equals(LessonType)) {
      addFieldError("LessonType", "请选择课程类型");
      return INPUT;
    }
    else if(excute()==false){
      addFieldError("flag","课程安排编号已存在");
      return INPUT;
    }
    else {
      
      try
      {
      	db.getcon();
      	

        db.stmt.executeUpdate("insert into arrangeld values("+ArrangeId+",'"+TermId
                              +"','"+LessonId+"','"+Class_Id+"','"+Teacher+"','"
                              +Hours+"','"+LessonType+"','"+kaoshiTime+"','"+kaoshiType+"','"+examNum+"')");
        
        db.close();
      }
      catch(Exception ex){}
        message="添加成功";
        return SUCCESS;
    }

  }
  
  
  public boolean excute(){
    boolean flag=true;
    try{
    	db.getcon();
    	
      rs = db.stmt.executeQuery("select * from arrangeld where ArrangeId='"+
                                ArrangeId+"'");
     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 setTermId(String TermId) {
    this.TermId = TermId;
  }
  public String getTermId() {
    return this.TermId;
  }
////////////////////////////////////////////////////////////  
  public void setLessonId(String LessonId) {
    this.LessonId = LessonId;
  }
  public String getLessonId() {
    return LessonId;
  }
/////////////////////////////////////////////////////////////  
  public void setClass_Id(String Class_Id) {
    this.Class_Id = Class_Id;
  }

  public String getClass_Id() {
    return Class_Id;
  }
////////////////////////////////////////////////////////////  
  public void setTeacher(String Teacher) {
    this.Teacher = Teacher;
  }
  public String getTeacher() {
    return Teacher;
  }
/////////////////////////////////////////////////////////////  
  public void setHours(String Hours) {
    this.Hours = Hours;
  }

  public String getHours() {
    return Hours;
  }
/////////////////////////////////////////////////////////////  
  public void setLessonType(String LessonType) {
    this.LessonType = LessonType;
  }

  public String getLessonType() {
    return LessonType;
  }
  /////////////////////////////////////////////////////////////  
  public void setKaoshiTime(String kaoshiTime) {
    this.kaoshiTime = kaoshiTime;
  }

  public String getKaoshiTime() {
    return kaoshiTime;
  }
  
  public void setKaoshiType(String kaoshiType) {
    this.kaoshiType = kaoshiType;
  }

  public String getKaoshiType() {
    return kaoshiType;
  }
  
  public void setExamNum(String examNum) {
    this.examNum = examNum;
  }

  public String getExamNum() {
    return examNum;
  }

}