add_administrator.java

jsp管理系统

package com.gbsource.homepage.admin;

import java.sql.*;
/**
 * Title:        华源主页基地管理
 * Description:
 * Copyright:    Copyright (c) 2001
 * Company:      Gbsource Studio
 * @author fishwu
 * @version 1.0
 */

public class Add_Administrator
{
  private String password1;
  private String password2;
  private static BeansConstants CONST;
  private String userid;
  public int doAdd()
  {
    if(userid == null || "".equals(userid))
      return CONST.USERID_NULL_ERR;
    if(password1 == null || "".equals(password1))
      return CONST.PASSWORD_NULL_ERR;
    if(!password1.equalsIgnoreCase(password2))
      return CONST.UNEQUAL_PASSWORD_ERR;
    try{
      String sql = "select userid from admin where userid = ?";
      Database db = new Database(sql);
      db.setString(1,userid);
      ResultSet rs = db.executeQuery();
      if(rs.next())
      {
        rs.close();
        rs = null;
        db.close();
        db = null;
        return CONST.USERID_EXIST_ERR;
      }
      else
      {
        sql = "insert into admin(userid,password) values('" + com.gbsource.util.ToSQL.Replace(userid,"'","''") + "','" + com.gbsource.util.ToSQL.Replace(password1,"'","''") + "')";
        db.prepareStatement(sql);
        //db.setString(1,userid);
        //db.setString(2,password1);
        db.Execute();
      }
      rs.close();
      rs = null;
      db.close();
      db = null;
    }catch(Exception e){return CONST.DB_ERR;}
    return CONST.RUN_OK;
  }
  public void setPassword1(String newPassword1) {
    password1 = newPassword1;
  }
  public String getPassword1() {
    return password1;
  }
  public void setPassword2(String newPassword2) {
    password2 = newPassword2;
  }
  public String getPassword2() {
    return password2;
  }
  public void setUserid(String newUserid) {
    userid = newUserid;
  }
  public String getUserid() {
    return userid;
  }
}