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;  }}