terms.java

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

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

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

  }
  
  public boolean excute(){
    boolean flag=true;
    try{
    	db.getcon();
      rs = db.stmt.executeQuery("select * from terms where termsId='"+
                                termsId +"' or termsName='" + termsName +"'");
     if(rs.next()) {
        flag = false;
      }
      rs.close();
      db.close();
    }
    catch(Exception ex){}
    return flag;
  }//判断是否已经存在学期ID和NAME
  
  public String getMessage() {
    return message;
  }
  
  public void setTermsid(String termsId)
  {
  	this.termsId=termsId;
  }
  public String getTermsid()
  {
  	return termsId;
  }
  public void setTermsname(String termsName) {
    this.termsName = termsName;
  }

  public String getTermsname() {
    return this.termsName;
  }


}