Esempio n. 1
0
  @Button(label = "Okay", validate = true, order = 3)
  public Navigation okayClick() {
    AbstractWebApplication application = (AbstractWebApplication) getApplication();
    JdbcTemplate jdbcTemplate = application.getJdbcTemplate();

    StringBuffer ddl = new StringBuffer();
    ddl.append(
        "update "
            + TableUtilities.getTableName(application.getUserEntity())
            + " set "
            + AbstractUser.PASSWORD
            + " = ?, "
            + AbstractUser.DISABLE
            + " = ? where "
            + AbstractUser.ID
            + " = ?");
    jdbcTemplate.update(ddl.toString(), this.password, this.disable, this.userId);

    jdbcTemplate.update(
        "delete from "
            + TableUtilities.getTableName(RoleUser.class)
            + " where "
            + RoleUser.USER_ID
            + " = ?",
        this.userId);

    if (roles != null && roles.length > 0) {
      SimpleJdbcInsert mapping = new SimpleJdbcInsert(jdbcTemplate);
      mapping.withTableName(TableUtilities.getTableName(RoleUser.class));
      for (Role role : roles) {
        Map<String, Object> pp = new HashMap<String, Object>();
        pp.put(RoleUser.ROLE_ID, role.getId());
        pp.put(RoleUser.USER_ID, this.userId);
        mapping.execute(pp);
      }
    }

    jdbcTemplate.update(
        "delete from "
            + TableUtilities.getTableName(UserGroup.class)
            + " where "
            + UserGroup.USER_ID
            + " = ?",
        this.userId);
    if (groups != null && groups.length > 0) {
      SimpleJdbcInsert mapping = new SimpleJdbcInsert(jdbcTemplate);
      mapping.withTableName(TableUtilities.getTableName(UserGroup.class));
      for (Group group : groups) {
        Map<String, Object> pp = new HashMap<String, Object>();
        pp.put(UserGroup.USER_ID, this.userId);
        pp.put(UserGroup.GROUP_ID, group.getId());
        mapping.execute(pp);
      }
    }
    return new Navigation(application.getUserManagementPage());
  }
Esempio n. 2
0
 public static void insert(
     DataSource dataSource,
     String tableName,
     List<String> usingColumns,
     List<Map<String, Object>> fields) {
   SimpleJdbcInsert jdbcInsert = new SimpleJdbcInsert(dataSource);
   jdbcInsert.withTableName(tableName);
   List<String> pp = new ArrayList<>();
   pp.addAll(usingColumns);
   pp.add(tableName + "_id");
   jdbcInsert.usingColumns(pp.toArray(new String[usingColumns.size()]));
   for (Map<String, Object> field : fields) {
     field.put(tableName + "_id", UUID.randomUUID().toString());
   }
   Map<String, Object>[] batch = fields.toArray(new Map[fields.size()]);
   jdbcInsert.executeBatch(batch);
 }
Esempio n. 3
0
  public synchronized CookingRecipe insertCookingRecipe(CookingRecipe recipe) throws Exception {
    System.out.println("Database: insertCookingRecipe(" + recipe + ")");
    SimpleJdbcInsert insert = new SimpleJdbcInsert(jdbcTemplate);
    insert.withTableName("recipes");
    insert.setGeneratedKeyName("id");
    Map<String, Object> mapa = new HashMap<String, Object>();
    mapa.put("recipe_name", recipe.getName());
    mapa.put("author", recipe.getAuthor());
    mapa.put("guide", recipe.getGuide());
    // mapa.put("incident_ID", incidentID);
    Number insertedRecipeId = insert.executeAndReturnKey(mapa);
    recipe.setId(insertedRecipeId.longValue());

    insertIngredients(recipe.getIngredients(), insertedRecipeId.longValue());
    for (CookingIngredient ci : recipe.getIngredients()) {
      ci.setRecipe_id(insertedRecipeId.longValue());
    }
    return recipe;
  }