Esempio n. 1
0
  /**
   * 保存(新增、更新)用户信息
   *
   * @param user
   * @return
   */
  public boolean saveUser(User user) {

    boolean saveFlag = false;
    String updSql = null;

    if (isExist(user.getUserName())) {
      // 更新用户信息
      updSql =
          "UPDATE SYJK_CCS_USER SET PASSWORD = '******', MENUJSON = '"
              + user.getMenujson()
              + "' WHERE USERNAME= '******'";
    } else {
      // 新增用户
      String userId =
          String.valueOf(Integer.parseInt(es.getOneValue("select max(id) from syjk_ccs_user")) + 1);
      updSql =
          "INSERT INTO SYJK_CCS_USER (ID,USERNAME, PASSWORD, MENUJSON) VALUES ('"
              + userId
              + "','"
              + user.getUserName()
              + "','"
              + user.getPassWord()
              + "','"
              + user.getMenujson()
              + "') ";
    }

    if (null != updSql) {
      saveFlag = es.execUpdateSQL(updSql);
    }

    return saveFlag;
  }