timu.java

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

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

public class timu extends ActionSupport
{
  private String message;
  private String lessonId;
  private String timu;
  private String Q1;
  private String Q2;
  private String Q3;
  private String Q4;
  private String anster;
  private String beizhu;
  private String Del;
  private String Alter;
  private ResultSet rs=null;
  dbcont db=new dbcont();
  public String timu_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 timu values('"+lessonId+"','"+timu
                               +"','"+Q1+"','"+Q2+"','"+Q3+"','"+Q4+"','"+anster
                               +"','"+beizhu+"')");
        rs.close();
        db.close();
      }
      catch(Exception ex){ex.printStackTrace();}
       // 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 setTimu(String timu) {
    this.timu = timu;
  }

  public String getTimu() {
    return this.timu;
  }
  
  public void setQ1(String Q1) {
    this.Q1 = Q1;
  }

  public String getQ1() {
    return this.Q1;
  }
  
  public void setQ2(String Q2) {
    this.Q2 = Q2;
  }

  public String getQ2() {
    return this.Q2;
  }
  
  public void setQ3(String Q3) {
    this.Q3 = Q3;
  }

  public String getQ3() {
    return this.Q3;
  }
  
  public void setQ4(String Q4) {
    this.Q4 = Q4;
  }

  public String getQ4() {
    return this.Q4;
  }
  
  public void setAnster(String anster) {
    this.anster = anster;
  }

  public String getAnster() {
    return this.anster;
  }
  
   public void setBeizhu(String beizhu) {
    this.beizhu = beizhu;
  }

  public String getBeizhu() {
    return this.beizhu;
  }


}