lessons.java

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

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

public class Lessons extends ActionSupport
{
  private String message;
  private String lessonId;
  private String lessonName;
  private String Del;
  private String Alter;
  private ResultSet rs=null;
  dbcont db=new dbcont();
  public String Lesson_Add() {
    if (lessonId == null || "".equals(lessonId)) {
      addFieldError("lessonId","请输入课程编号");
      return INPUT;
    }
    else if (lessonName == null || "".equals(lessonName)) {
      addFieldError("lessonName", "请输入课程名称");
      return INPUT;
    }
    else if(excute()==false){
      addFieldError("flag","此信息已经添加过");
      return INPUT;
    }
    else {
      
      try
      {
      	db.getcon();
        rs=db.stmt.executeQuery("insert into lessons values("+lessonId+",'"+lessonName+"')");
        rs.close();
        db.close();
      }
      catch(Exception ex){}
        message="课程编号："+lessonId+"   课程名称："+lessonName;
        return SUCCESS;
    }

  }
  
  public String Lesson_Del()
  {
  	  try{
  	  
	  db.getcon();
	  rs=db.stmt.executeQuery("select * from terms where termId="+Del);
	  rs.next();
	  lessonId=rs.getString("lessonId");
	  lessonName=rs.getString("lessonName");
	  }
	  catch(Exception ex){}
	  setLessonid(lessonId);
	  setLessonname(lessonName);
	  return SUCCESS;
	
  }

  
  public boolean excute(){
    boolean flag=true;
    try{
    	db.getcon();
      rs = db.stmt.executeQuery("select * from lessons where lessonId='"+
                                lessonId +"' or lessonName='" + lessonName +"'");
     if(rs.next()) {
        flag = false;
      }
      rs.close();
      db.close();
    }
    catch(Exception ex){}
    return flag;
  }//判断是否已经存在学期ID和NAME
  
  public String getMessage() {
    return message;
  }
  
  public void setDel(String Del)
  {
  	this.Del=Del;
  }
  public String getDel()
  {
  	return Del;
  }
  public void setAlter(String Alter)
  {
  	this.Alter=Alter;
  }
  public String getAlter()
  {
  	return Alter;
  }
  public void setLessonid(String lessonId)
  {
  	this.lessonId=lessonId;
  }
  public String getLessonid()
  {
  	return lessonId;
  }
  public void setLessonname(String lessonName) {
    this.lessonName = lessonName;
  }

  public String getLessonname() {
    return this.lessonName;
  }


}