示例#1
0
  public List<User> getUserList() {

    List<User> userList = new ArrayList();
    SSRS ssrs = es.execSQL("SELECT ID, USERNAME, PASSWORD, MENUJSON FROM SYJK_CCS_USER ");
    if (ssrs.MaxRow > 0) {
      for (int i = 0; i < ssrs.MaxRow; i++) {
        User user = new User();
        user.setId(Integer.parseInt(ssrs.GetText(i + 1, 1)));
        user.setUserName(ssrs.GetText(i + 1, 2));
        user.setPassWord(ssrs.GetText(i + 1, 3));
        user.setMenujson(ssrs.GetText(i + 1, 4));
        userList.add(user);
      }
    }
    return userList;
  }
示例#2
0
  /**
   * 用户名是否存在
   *
   * @param username
   * @return
   */
  public boolean isExist(String username) {

    SSRS ssrs = es.execSQL("SELECT 1 FROM SYJK_CCS_USER WHERE USERNAME = '******'");
    return ssrs.getMaxRow() > 0;
  }