// ����û�?
 public boolean addUnitUser(String strUserId, String[] arryUnitId) {
   String strSql = "";
   try {
     // ����Ϣд����ݿ�?
     strSql =
         "INSERT INTO "
             + strTableName2
             + "  (strUserId, strUnitId, intSort, strCreator, dtCreatTime) VALUES (?,?,?,?,str_to_date(?,'%Y-%m-%d %T'))";
     if (arryUnitId != null && arryUnitId.length > 0)
       for (int i = 0; i < arryUnitId.length; i++) {
         db.prepareStatement(strSql);
         db.setString(1, strUserId);
         db.setString(2, arryUnitId[i]);
         db.setInt(3, creatSort(arryUnitId[i])); // intSort
         db.setString(4, globa.loginName);
         db.setString(5, Format.getDateTime());
         db.executeUpdate();
       }
     return true;
   } catch (Exception e) {
     System.out.println("增加单位用户映射时出错!!");
     e.printStackTrace();
     return false;
   }
 }
 // �޸�
 public boolean update(String tStrUserId) {
   try {
     String strSql =
         "UPDATE  "
             + strTableName
             + "  SET  strName = ?, intError = ?, intState = ?, dBirthday = ?, strSex = ?, strIntro = ?, intType = ?, "
             + "strUnitId = ?, strUnitCode = ?,strNation = ?, strMobile = ?, strEmail = ?, strMsnQQ = ?, strOPhone = ?, strHPhone = ?, strDuty = ?, strStation = ?, "
             + " strCaNO = ?, strDepart = ?,  strLinkAdd = ?, strCreator = ?, dtCreatTime = str_to_date(?,'%Y-%m-%d %T') ,strCssType=?  WHERE strUserId=? ";
     db.prepareStatement(strSql);
     db.setString(1, strName);
     db.setInt(2, 0);
     db.setInt(3, intState);
     db.setString(4, dBirthday);
     db.setString(5, strSex);
     db.setString(6, strIntro);
     db.setInt(7, intType);
     db.setString(8, strUnitId);
     db.setString(9, ""); // "strUnitCode
     db.setString(10, strNation);
     db.setString(11, strMobile);
     db.setString(12, strEmail);
     db.setString(13, strMsnQQ);
     db.setString(14, strOPhone);
     db.setString(15, strHPhone);
     db.setString(16, strDuty);
     db.setString(17, strStation);
     db.setString(18, strCaNO);
     db.setString(19, strDepart);
     db.setString(20, strLinkAdd);
     db.setString(21, globa.loginName);
     db.setString(22, Format.getDateTime());
     db.setString(23, strCssType);
     db.setString(24, tStrUserId);
     db.executeUpdate();
     Globa.logger0(
         "修改用户信息",
         globa.loginName,
         globa.loginIp,
         strSql,
         "用户管理",
         globa.userSession.getStrDepart());
     System.out.println("true");
     return true;
   } catch (Exception e) {
     System.out.println("修改用户信息时出错:" + e);
     System.out.println("false");
     return false;
   }
 }
 // 修改领导密码用户密码
 public boolean setPassword(String pwd) {
   try {
     String strSql =
         "update "
             + strTableName
             + "  set strDepart='"
             + Format.enPass(pwd)
             + "' where strUserId='"
             + globa.loginName
             + "'";
     db.executeUpdate(strSql);
     UserSession userSession = globa.userSession;
     userSession.setStrPWD(pwd);
     globa.session.setAttribute(com.ejoysoft.common.Constants.USER_KEY, userSession);
     return true;
   } catch (Exception e) {
     e.printStackTrace();
     return false;
   }
 }
  // 增加用户
  public boolean add(String strUserId) {
    String strSql = "";
    strId = UID.getID();
    try {
      // 把用户信息写入数据库
      strSql =
          "INSERT INTO "
              + strTableName
              + "  (strId, strUserId, strPWD, strName, intError, intState, dBirthday, strSex, strIntro,intType, strUnitId, strUnitCode,"
              + " strNation, strMobile, strEmail, strMsnQQ,strOPhone, strHPhone, strDuty, strStation, intLoginNum, dLatestLoginTime,fOnlineTime, strCaNO, "
              + "strDepart, strCssType,  strLinkAdd, strCreator, dtCreatTime,intUserType) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,str_to_date(?,'%Y-%m-%d %T'),?,?,?,?,?,?,str_to_date(?,'%Y-%m-%d %T'),?)";
      db.prepareStatement(strSql);
      db.setString(1, strId);
      db.setString(2, strUserId.replaceAll(" ", ""));
      db.setString(3, MD5.getMD5ofString(Constants.resetPass)); // strPWD
      db.setString(4, strName);
      db.setInt(5, 0);
      db.setInt(6, 0);
      db.setString(7, dBirthday);
      db.setString(8, strSex);
      db.setString(9, strIntro);
      db.setInt(10, intType);
      db.setString(11, strUnitId);
      db.setString(
          12,
          ""); // strUnitCode                  new Unit(globa, false).retFieldValue("strUnitCode",
               // strUnitId)
      db.setString(13, strNation);
      db.setString(14, strMobile);
      db.setString(15, strEmail);
      db.setString(16, strMsnQQ);
      db.setString(17, strOPhone);
      db.setString(18, strHPhone);
      db.setString(19, strDuty);
      db.setString(20, strStation);
      db.setInt(21, intLoginNum);
      db.setString(22, Format.getDateTime());
      db.setDouble(23, 0);
      db.setString(24, strCaNO);
      db.setString(25, strDepart);
      db.setString(26, strCssType);
      db.setString(27, strLinkAdd);
      db.setString(28, globa.loginName);
      db.setString(29, Format.getDateTime());
      db.setInt(30, intUserType);

      if (db.executeUpdate() > 0) {
        Globa.logger0(
            "增加用户信息",
            globa.loginName,
            globa.loginIp,
            strSql,
            "用户管理",
            globa.userSession.getStrDepart());
        return true;
      } else return false;
    } catch (Exception e) {
      System.out.println("增加用户信息时出错!!");
      e.printStackTrace();
      return false;
    }
  }