class_add.java

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

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

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

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

  public String getClass_name() {
    return class_Name;
  }
  
  public void setLstbx1(String upperId) {
    this.upperId = upperId;
  }

  public String getLstbx1() {
    return upperId;
  }

}