コード例 #1
0
 /** 获得组内所有的用户 */
 public User[] getUsers(String twhere) {
   String strSql;
   try {
     strSql = "select strUserId,strMobile,strName from " + strTableName + "  ".concat(twhere);
     ResultSet rs = db.executeRollQuery(strSql);
     if (rs.last()) {
       int total = rs.getRow();
       rs.beforeFirst();
       User[] users = new User[total];
       int i = 0;
       while (rs.next()) {
         users[i] =
             new User(
                 rs.getString("strUserId"), rs.getString("strMobile"), rs.getString("strName"));
         i++;
       }
       rs.close();
       return users;
     } else {
       rs.close();
       return null;
     }
   } catch (Exception e) {
     e.printStackTrace();
     return null;
   }
 }
コード例 #2
0
 // ����û�?
 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;
   }
 }
コード例 #3
0
 // 生成同一个单位上报单位的用户名
 public String creatUserId(String tStrUnitId) {
   ResultSet rs = null;
   String tStrUserId = "";
   try {
     Unit unit0 = new Unit(globa, false).show(" WHERE strId='" + tStrUnitId + "'");
     //            if(unit0.getIntUnitType()!=2)
     //                    return "";
     // System.out.println("SELECT Max(strUserId)  FROM " + strTableName + " WHERE  strUnitId='" +
     // tStrUnitId + "'");
     rs =
         db.executeQuery(
             "SELECT Max(strUserId)  FROM "
                 + strTableName
                 + " WHERE  strUnitId='"
                 + tStrUnitId
                 + "'");
     if (rs != null && rs.next()) {
       tStrUserId = rs.getString(1);
     }
     rs.close();
     rs = null;
     if (tStrUserId == null || tStrUserId.equals("")) {
       tStrUserId = unit0.getStrUnitCode() + "00";
     } else {
       tStrUserId = String.valueOf(Long.parseLong(tStrUserId) + 1);
     }
     return tStrUserId;
   } catch (Exception ee) {
     ee.printStackTrace();
     return "";
   }
 }
コード例 #4
0
  // 列表记录集
  public Vector<User> list(String where, int startRow, int rowCount) {
    Vector<User> beans = new Vector<User>();
    try {
      String sql = "SELECT *  FROM  " + strTableName + " ";
      if (where.length() > 0) sql = String.valueOf(sql) + String.valueOf(where);
      Statement s =
          db.getConnection()
              .createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
      if (startRow != 0 && rowCount != 0) s.setMaxRows((startRow + rowCount) - 1);

      ResultSet rs = s.executeQuery(sql);
      if (rs != null && rs.next()) {
        if (startRow != 0 && rowCount != 0) rs.absolute(startRow);
        do {
          User theBean = new User();
          theBean = load(rs, false);
          beans.addElement(theBean);
        } while (rs.next());
      }
      rs.close();
      s.close();
    } catch (Exception ee) {
      ee.printStackTrace();
    }
    return beans;
  }
コード例 #5
0
 // ɾ删除部门用户部门联系表中的一条数据
 public boolean delUnitUser(String where) {
   try {
     String sql = "DELETE FROM " + strTableName2 + "  ".concat(where);
     db.executeUpdate(sql);
     return true;
   } catch (Exception ee) {
     ee.printStackTrace();
     return false;
   }
 }
コード例 #6
0
 // ɾ删除该用户的权限
 public boolean delRight(String where) {
   try {
     String sql = "DELETE FROM " + strTableName3 + "  ".concat(where);
     System.err.println(sql + "========+++++++");
     db.executeUpdate(sql);
     return true;
   } catch (Exception ee) {
     ee.printStackTrace();
     return false;
   }
 }
コード例 #7
0
 // 判断用户信息是否冲突
 public void bCheckAccount(String tStrAccount) throws UserUnitIdException, SQLException {
   String strSql =
       "select strUserId  from " + strTableName + "   where strUserId='" + tStrAccount + "'";
   try {
     ResultSet rs = db.executeQuery(strSql);
     if (rs.next()) {
       globa.closeCon();
       throw new UserUnitIdException("已经存在'" + tStrAccount + "' 用户", "请输入其他用户名");
     }
   } catch (Exception e) {
     e.printStackTrace();
   }
 }
コード例 #8
0
 // 记录集转化为对象
 public User load2(ResultSet rs, boolean isView) {
   User theBean = new User();
   try {
     theBean.setStrId(rs.getString(1));
     theBean.setStrUserId(rs.getString(2));
     theBean.setStrName(rs.getString(3));
     theBean.setStrCaNO(rs.getString(4));
     theBean.setStrUnitId(rs.getString(5));
   } catch (Exception e) {
     e.printStackTrace();
   }
   return theBean;
 }
コード例 #9
0
 // 获得制定用户所属的单位
 public HashMap unitUser(String tField, String tWhere) {
   HashMap result = new HashMap();
   String strSql = "SELECT " + tField + " FROM  " + strTableName2 + " ".concat(tWhere);
   try {
     ResultSet rs = db.executeQuery(strSql);
     while (rs.next()) {
       result.put(rs.getString(1), "true");
     }
     rs.close();
   } catch (Exception ee) {
     ee.printStackTrace();
   }
   return result;
 }
コード例 #10
0
 // 列表记录集
 public String retVal(String strField, String where) {
   String val = "''";
   try {
     String sql = "SELECT " + strField + "  FROM  " + strTableName2 + "  ".concat(where);
     ResultSet rs = db.executeQuery(sql);
     while (rs != null && rs.next()) {
       val = val + ",'" + rs.getString(1) + "'";
     }
     rs.close();
   } catch (Exception ee) {
     ee.printStackTrace();
   }
   return val;
 }
コード例 #11
0
 // 修改strCssType
 public boolean setCss(String tCss) {
   try {
     String strSql =
         "update "
             + strTableName
             + "  set strCssType='"
             + tCss
             + "' where strUserId='"
             + globa.loginName
             + "'";
     db.executeUpdate(strSql);
     return true;
   } catch (Exception e) {
     e.printStackTrace();
     return false;
   }
 }
コード例 #12
0
 // 修改密码
 public boolean doSetPwd(String tStrUserId, ServletContext application, HttpSession session) {
   try {
     String sql =
         "UPDATE " + strTableName + " SET strPWD=?,intState=? ,intError=0 WHERE  strUserId=? ";
     db.prepareStatement(sql);
     db.setString(1, MD5.getMD5ofString(strPWD));
     db.setInt(2, Constants.U_STATE_ON);
     db.setString(3, tStrUserId);
     db.executeUpdate();
     // �޸��û���������
     Globa.logger0(
         "修改用户密码", globa.loginName, globa.loginIp, sql, "用户管理", globa.userSession.getStrDepart());
     return true;
   } catch (Exception e) {
     e.printStackTrace();
     return false;
   }
 }
コード例 #13
0
 // 查询符合条件的记录总数
 public int getCount(String where) {
   int count = 0;
   try {
     String sql = "SELECT count(strId) FROM " + strTableName + "  ";
     if (where.length() > 0) {
       where = where.toLowerCase();
       if (where.indexOf("order") > 0) where = where.substring(0, where.lastIndexOf("order"));
       sql = String.valueOf(sql) + String.valueOf(where);
     }
     ResultSet rs = db.executeQuery(sql);
     if (rs.next()) count = rs.getInt(1);
     rs.close();
     return count;
   } catch (Exception ee) {
     ee.printStackTrace();
     return count;
   }
 }
コード例 #14
0
 // 获得制定用户所属的单位
 public HashMap unitUser(String tWhere) {
   HashMap result = new HashMap();
   System.err.println(
       tWhere + "++++++++++_________________----------------------------==========");
   String strSql =
       "SELECT b.strUserId,b.strId FROM sys_unitUser a LEFT JOIN sys_user b ON a.strUserId=b.strUserId   "
           .concat(tWhere);
   try {
     ResultSet rs = db.executeQuery(strSql);
     while (rs != null && rs.next()) {
       // System.err.println(rs.getString(1)+rs.getString(2)+":DDDDDDDDDDDDDDD");
       result.put(rs.getString(1), rs.getString(2));
     }
     rs.close();
   } catch (Exception ee) {
     ee.printStackTrace();
   }
   return result;
 }
コード例 #15
0
 // 修改领导密码用户密码
 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;
   }
 }
コード例 #16
0
 // 用户 认证֤
 public boolean authUser(String oldPwd) {
   String pwd = (new MD5().getMD5ofStr(oldPwd));
   String strSql =
       "SELECT  *  FROM  "
           + strTableName
           + "  WHERE strUserId='"
           + globa.loginName
           + "' and strPWD='"
           + pwd
           + "'";
   try {
     ResultSet rs = db.executeQuery(strSql);
     if (rs != null && rs.next()) {
       return true;
     }
     return false;
   } catch (Exception e) {
     e.printStackTrace();
     return false;
   }
 }
コード例 #17
0
 // 获得制定用户所属的单位
 public String[] arryUnitUser(String tWhere) {
   String[] result = null;
   try {
     String strSql = "SELECT count(*) FROM  " + strTableName2 + " ".concat(tWhere);
     ResultSet rs = db.executeQuery(strSql);
     int iLen = 0;
     if (rs.next()) iLen = rs.getInt(1);
     result = new String[iLen];
     strSql = "SELECT strUnitId FROM  " + strTableName2 + " ".concat(tWhere);
     rs = db.executeQuery(strSql);
     int i = 0;
     while (rs.next()) {
       result[i] = rs.getString(1);
       i++;
     }
     rs.close();
   } catch (Exception ee) {
     ee.printStackTrace();
   }
   return result;
 }
コード例 #18
0
  // 记录集转化为对象
  public User load(ResultSet rs, boolean isView) {
    User theBean = new User();
    try {
      theBean.setStrId(rs.getString("strId"));
      theBean.setStrUserId(rs.getString("strUserId"));
      theBean.setStrPWD(rs.getString("strPWD"));
      theBean.setStrName(rs.getString("strName"));
      theBean.setIntError(rs.getInt("intError"));
      theBean.setIntState(rs.getInt("intState"));
      theBean.setdBirthday(rs.getString("dBirthday"));
      theBean.setStrSex(rs.getString("strSex"));
      theBean.setStrIntro(rs.getString("strIntro"));
      theBean.setIntType(rs.getInt("intType"));
      theBean.setStrUnitId(rs.getString("strUnitId"));
      theBean.setStrUnitCode(rs.getString("strUnitCode"));
      theBean.setStrNation(rs.getString("strNation"));
      theBean.setStrMobile(rs.getString("strMobile"));
      theBean.setStrEmail(rs.getString("strEmail"));
      theBean.setStrMsnQQ(rs.getString("strMsnQQ"));
      theBean.setStrOPhone(rs.getString("strOPhone"));
      theBean.setStrHPhone(rs.getString("strHPhone"));
      theBean.setStrDuty(rs.getString("strDuty"));
      theBean.setStrStation(rs.getString("strStation"));
      theBean.setIntLoginNum(rs.getInt("intLoginNum"));
      theBean.setdLatestLoginTime(rs.getString("dLatestLoginTime"));
      theBean.setfOnlineTime(rs.getFloat("fOnlineTime"));
      theBean.setStrCaNO(rs.getString("strCaNO"));
      theBean.setStrDepart(rs.getString("strDepart"));
      theBean.setStrCssType(rs.getString("strCssType"));
      theBean.setStrLinkAdd(rs.getString("strLinkAdd"));
      theBean.setStrCreator(rs.getString("strCreator"));
      theBean.setDtCreatTime(rs.getString("dtCreatTime"));
      theBean.setIntUserType(rs.getInt("intUserType"));

    } catch (Exception e) {
      e.printStackTrace();
    }
    return theBean;
  }
コード例 #19
0
 // 生成同一个单位下的下级单位(组)的 排序号
 public int creatSort(String tStrUnitId) {
   ResultSet rs = null;
   int tIntSort = 0;
   try {
     rs =
         db.executeQuery(
             "SELECT  Max(intSort)  FROM "
                 + strTableName2
                 + " WHERE  strUnitId='"
                 + tStrUnitId
                 + "' ");
     if (rs != null && rs.next()) {
       tIntSort = rs.getInt(1);
     }
     rs.close();
     rs = null;
     return tIntSort + 1;
   } catch (Exception ee) {
     ee.printStackTrace();
     return 0;
   }
 }
コード例 #20
0
 // ɾ��
 public boolean delete(String where, String strId) {
   try {
     String strUserId = "";
     String where2 = " where strId = '" + strId + "'";
     String sql2 = "select strUserId from  " + strTableName + " ".concat(where2);
     ResultSet rs = db.executeQuery(sql2);
     if (rs != null && rs.next()) {
       strUserId = rs.getString("strUserId");
     }
     String sql = "DELETE FROM " + strTableName + "  ".concat(where);
     db.executeUpdate(sql);
     // ɾ���û�ӳ����?
     String where3 = "where strUserId =  '" + strUserId + "'";
     String where4 = "where strUserId =  '" + strId + "'";
     delUnitUser(where3);
     delRight(where4);
     Globa.logger0("删除用户信息", globa.loginName, globa.loginIp, sql, "用户管理", globa.unitCode);
     return true;
   } catch (Exception ee) {
     ee.printStackTrace();
     return false;
   }
 }
コード例 #21
0
  // 增加用户
  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;
    }
  }