students_add.java

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

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

public class Students_Add extends ActionSupport
{
  private String message;
  private String Student_Id;
  private String Student_Name;
  private String Sex;
  private String Nationality;
  private String Birth;
  private String Family_Place;
  private String Id_Card;
  private String Home_phone;
  private String Residence;
  private String Postcode;
  private String InDate;
  private String Class_Id;
  private String StudentPsw; 
  public ResultSet rs=null;
  dbcont db=new dbcont();
  public String execute() {
    if (Student_Id == null || "".equals(Student_Id)) {
      addFieldError("Student_Id","请输学号");
      return INPUT;
    }
    else if (Student_Name == null || "".equals(Student_Name)) {
      addFieldError("Student_Name", "请输入学生姓名");
      return INPUT;
    }
    else if (Sex == null || "".equals(Sex)) {
      addFieldError("Sex", "请选择性别");
      return INPUT;
    }
    else if (Class_Id == null || "".equals(Class_Id)) {
      addFieldError("Class_Id", "请选择班级");
      return INPUT;
    }
    else if (StudentPsw == null || "".equals(StudentPsw)) {
      addFieldError("StudentPsw", "请输入学生密码");
      return INPUT;
    }
    else if(excute()==false){
      addFieldError("flag","你输入的学号重复了");
      return INPUT;
    }
    else {
      
      try
      {
      	db.getcon();
      	String strsql="insert into students values('"+Student_Id+"','"+Student_Name+"','"+Sex
      	               +"','"+Nationality+"','"+Birth+"','"+Family_Place+"','"+Id_Card+"','"+Home_phone
      	               +"','"+Residence+"','"+Postcode+"','"+InDate+"','"+Class_Id+"','"+StudentPsw+"')";
        rs=db.stmt.executeQuery(strsql);
        rs.close();
        db.close();
      }
      catch(Exception ex){}
        message="学号："+Student_Id+"  姓名："+Student_Name;
        return SUCCESS;
    }

  }
  
  
  public boolean excute(){
    boolean flag=true;
    try{
    	db.getcon();
      rs = db.stmt.executeQuery("select * from students where student_Id='"+Student_Id +"'");
     if(rs.next()) {
        flag = false;
      }
      rs.close();
      db.close();
    }
    catch(Exception ex){}
    return flag;
  }//判断是否已经存在学期ID和NAME
  
  public String getMessage() {
    return message;
  }
//////////////////////////////////////////////////////////////// 
  public void setStudent_Id(String Student_Id)
  {
  	this.Student_Id=Student_Id;
  }
  public String getStudent_Id()
  {
  	return Student_Id;
  }
//////////////////////////////////////////////////////////////// 
  public void setStudent_Name(String Student_Name)
  {
  	this.Student_Name=Student_Name;
  }
  public String getStudent_Name()
  {
  	return Student_Name;
  }
////////////////////////////////////////////////////////////////   
  public void setSex(String Sex) {
    this.Sex = Sex;
  }
  public String getSex() {
    return Sex;
  }
////////////////////////////////////////////////////////////////   
  public void setNationality(String Nationality)
  {
  	this.Nationality=Nationality;
  }
  public String getNationality()
  {
  	return Nationality;
  }
 ////////////////////////////////////////////////////////////////  
  public void setBirth(String Birth)
  {
  	this.Birth=Birth;
  }
  public String getBirth()
  {
  	return Birth;
  }
////////////////////////////////////////////////////////////////  
  public void setFamily_Place(String Family_Place) {
    this.Family_Place = Family_Place;
  }
  public String getFamily_Place() {
    return Family_Place;
  }
//////////////////////////////////////////////////////////////// 
  public void setId_Card(String Id_Card)
  {
  	this.Id_Card=Id_Card;
  }
  public String getId_Card()
  {
  	return Id_Card;
  }
//////////////////////////////////////////////////////////////// 
  public void setHome_phone(String Home_phone)
  {
  	this.Home_phone=Home_phone;
  }
  public String getHome_phone()
  {
  	return Home_phone;
  }
//////////////////////////////////////////////////////////////// 
  public void setResidence(String Residence) {
    this.Residence = Residence;
  }
  public String getResidence() {
    return Residence;
  }
//////////////////////////////////////////////////////////////// 
  public void setPostcode(String Postcode) {
    this.Postcode = Postcode;
  }
  public String getPostcode() {
    return Postcode;
  }
//////////////////////////////////////////////////////////////// 
  public void setInDate(String InDate) {
    this.InDate = InDate;
  }
  public String getInDate() {
    return InDate;
  }
//////////////////////////////////////////////////////////////// 
  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 setStudentPsw(String StudentPsw) {
    this.StudentPsw = StudentPsw;
  }
  public String getStudentPsw() {
    return StudentPsw;
  }
//////////////////////////////////////////////////////////////// 
}