Пример #1
0
  public Integer updateDeveloperCert(Developer developer) {
    StringBuffer sql = new StringBuffer();
    Object[] parametros = new Object[0];
    int[] types = new int[0];

    sql.append("UPDATE developers ");
    sql.append("SET ");

    if (developer.getCertURL() != null) {
      sql.append("certurl = ?");

      parametros = addToObjectArray(parametros, developer.getCertURL());
      types = addToIntArray(types, Types.VARCHAR);
    }

    String username = SecurityContextHolder.getContext().getAuthentication().getName();
    sql.append("WHERE username = ?");

    parametros = addToObjectArray(parametros, username);
    types = addToIntArray(types, Types.VARCHAR);

    System.out.println("jdbcTemplate " + jdbcTemplate.update(sql.toString(), parametros, types));
    if (jdbcTemplate.update(sql.toString(), parametros, types) == 1) {
      Developer dev = getDeveloperByUsername(username);
      createCert(developer.getCertURL(), dev.getKey());
      return 1;
    } else {
      return -1;
    }
  }