admins_add.java

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

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

public class Admins_Add extends ActionSupport
{
  private String userName;
  private String userPwd;
  public ResultSet rs=null;
  dbcont db=new dbcont();
  private String message;
  public String execute() {
    if (userName == null || "".equals(userName)) {
      addFieldError("userName","请输入用户名！");
      return INPUT;
    }
    else if (userPwd == null || "".equals(userPwd)){
      addFieldError("userPwd", "请输入密码!");
      return INPUT;
    }
    else if(excute()==false){
      addFieldError("flag","此用户已存在");
      return INPUT;
    }
    else {
      try
      {
      	db.getcon();
        db.stmt.executeUpdate("insert into login_admins (userName,userPwd) values('"+userName+"','"+userPwd+"')");
        db.close();
      }
      catch(Exception ex){}   
      message="用户名：" + userName + "   密码：" + userPwd;
        return SUCCESS;
    }

  }
  
  
  public boolean excute(){
    boolean flag=true;
    try{
    	db.getcon();
      rs =db.stmt.executeQuery("select * from login_admins where userName='"+userName +"'");
     if(rs.next()) {
        flag = false;
      }
      rs.close();
      db.close();
    }
    catch(Exception ex){}
    return flag;
  }//判断是否已经存在学期ID和NAME

    public String getUserName() {
        return userName;
    }

    public void setUserName(String userName) {
        this.userName = userName;
    }

    public String getUserPwd() {
        return userPwd;
    }

    public void setUserPwd(String userPwd) {
        this.userPwd = userPwd;
    }

    public String getMessage() {
        return message;
    }

}