Example usage for org.springframework.jdbc.core.namedparam MapSqlParameterSource addValue

List of usage examples for org.springframework.jdbc.core.namedparam MapSqlParameterSource addValue

  1. HOME
  2. Java
  3. org.springframework
  4. org.springframework.jdbc.core.namedparam.*
  5. MapSqlParameterSource
  6. addValue

Introduction

In this page you can find the example usage for org.springframework.jdbc.core.namedparam MapSqlParameterSource addValue.

Prototype

public MapSqlParameterSource addValue(String paramName, @Nullable Object value)

Source Link

Document

Add a parameter to this parameter source.

Usage

From source file:com.joliciel.jochre.security.SecurityDaoJdbc.java

@Override
public User loadUser(int userId) {
    NamedParameterJdbcTemplate jt = new NamedParameterJdbcTemplate(this.getDataSource());
    String sql = "SELECT " + SELECT_USER + " FROM ocr_user WHERE user_id=:user_id";
    MapSqlParameterSource paramSource = new MapSqlParameterSource();
    paramSource.addValue("user_id", userId);

    LOG.info(sql);//from   w w w .  j  a  va  2 s  .  com
    logParameters(paramSource);
    User user = null;
    try {
        user = (User) jt.queryForObject(sql, paramSource, new UserMapper(this.getSecurityServiceInternal()));
    } catch (EmptyResultDataAccessException ex) {
        ex.hashCode();
    }
    return user;
}

From source file:com.joliciel.jochre.security.SecurityDaoJdbc.java

@Override
public User findUser(String username) {
    NamedParameterJdbcTemplate jt = new NamedParameterJdbcTemplate(this.getDataSource());
    String sql = "SELECT " + SELECT_USER + " FROM ocr_user WHERE user_username=:user_username";
    MapSqlParameterSource paramSource = new MapSqlParameterSource();
    paramSource.addValue("user_username", username);

    LOG.info(sql);//from  ww w.j a v a 2  s .co  m
    logParameters(paramSource);
    User user = null;
    try {
        user = (User) jt.queryForObject(sql, paramSource, new UserMapper(this.getSecurityServiceInternal()));
    } catch (EmptyResultDataAccessException ex) {
        ex.hashCode();
    }
    return user;
}

From source file:com.stehno.sjdbcx.reflection.DefaultParamMapper.java

private void addBean(final MapSqlParameterSource source, final Object beanObj) {
    final BeanPropertySqlParameterSource beanSource = new BeanPropertySqlParameterSource(beanObj);

    for (final String name : beanSource.getReadablePropertyNames()) {
        source.addValue(name, beanSource.getValue(name));
    }/*from   w w w  .  j a  va2  s  .  c  o  m*/
}

From source file:com.joliciel.jochre.security.SecurityDaoJdbc.java

@Override
public Parameters loadParameters(int parametersId) {
    NamedParameterJdbcTemplate jt = new NamedParameterJdbcTemplate(this.getDataSource());
    String sql = "SELECT " + SELECT_PARAM + " FROM ocr_param WHERE param_id=:param_id";
    MapSqlParameterSource paramSource = new MapSqlParameterSource();
    paramSource.addValue("param_id", parametersId);

    LOG.info(sql);//from   w  ww.  jav a 2  s  . c om
    logParameters(paramSource);
    Parameters parameters = null;
    try {
        parameters = (Parameters) jt.queryForObject(sql, paramSource,
                new ParametersMapper(this.getSecurityServiceInternal()));
    } catch (EmptyResultDataAccessException ex) {
        ex.hashCode();
    }
    return parameters;
}

From source file:com.github.dbourdette.glass.log.execution.jdbc.JdbcJobExecutions.java

@Override
public Page<JobExecution> find(Query query) {
    String sql = "from " + getTableName();

    MapSqlParameterSource params = new MapSqlParameterSource();

    if (query.getResult() != null) {
        sql += " where result = :result";

        params.addValue("result", query.getResult().name());
    }//from ww w.j a va  2  s  .  c o  m

    return getLogs(sql, params, query);
}

From source file:airport.database.services.users.UsersDaoOnlineImpl.java

@Override
public List<User> getUsersSour(Date timeDifference, int secondsLimit) {
    MapSqlParameterSource parametrQuery = new MapSqlParameterSource();
    parametrQuery.addValue("difference", new Timestamp(timeDifference.getTime()));
    parametrQuery.addValue("limit", secondsLimit);
    List<User> resultUsers;

    try {//  w  w  w  . j av a  2 s .co m
        resultUsers = jdbcTemplate.query(SQL_QUERY_SELECT_SOUR_USER, parametrQuery, new UserSourMapper());

    } catch (EmptyResultDataAccessException e) {
        if (LOG.isInfoEnabled()) {
            LOG.info("Users aren't exist which not online");
        }

        return new ArrayList<>();
    }

    if (LOG.isInfoEnabled()) {
        LOG.info("get users which not online. Users not online: " + resultUsers);
    }

    return resultUsers;
}

From source file:com.joliciel.jochre.security.SecurityDaoJdbc.java

@Override
public void saveParametersInternal(ParametersInternal parameters) {
    NamedParameterJdbcTemplate jt = new NamedParameterJdbcTemplate(this.getDataSource());
    MapSqlParameterSource paramSource = new MapSqlParameterSource();

    paramSource.addValue("param_last_failed_login", parameters.getLastFailedLoginAttempt());
    paramSource.addValue("param_captcha_interval", parameters.getCaptachaIntervalSeconds());
    String sql = null;/*from  w ww .j ava 2  s  . c om*/

    paramSource.addValue("param_id", parameters.getId());

    sql = "UPDATE ocr_param" + " SET param_last_failed_login = :param_last_failed_login"
            + ", param_captcha_interval = :param_captcha_interval" + " WHERE param_id = :param_id";

    LOG.info(sql);
    logParameters(paramSource);
    jt.update(sql, paramSource);

}

From source file:org.aksw.gerbil.database.ExperimentDAOImpl.java

@Override
public void setExperimentTaskResult(int experimentTaskId, ExperimentTaskResult result) {
    // Note that we have to set the state first if we want to override the
    // automatic timestamp with the one from the
    // result object
    setExperimentState(experimentTaskId, result.state);

    MapSqlParameterSource parameters = new MapSqlParameterSource();
    parameters.addValue("id", experimentTaskId);
    parameters.addValue("microF1", result.getMicroF1Measure());
    parameters.addValue("microPrecision", result.getMicroPrecision());
    parameters.addValue("microRecall", result.getMicroRecall());
    parameters.addValue("macroF1", result.getMacroF1Measure());
    parameters.addValue("macroPrecision", result.getMacroPrecision());
    parameters.addValue("macroRecall", result.getMacroRecall());
    parameters.addValue("errorCount", result.getErrorCount());
    parameters.addValue("lastChanged", new java.sql.Timestamp(result.timestamp));

    this.template.update(SET_EXPERIMENT_TASK_RESULT, parameters);
}

From source file:com.phideltcmu.recruiter.server.dao.RecruitListDao.java

@Override
public List<Person> selectAll(List<Category> desiredCategories) {
    checkSingleton();//from   w  w w. j  a  va2 s  .  co  m

    List<String> list = new ArrayList<String>();
    for (Category c : desiredCategories) {
        list.add(c.getValue());
    }

    NamedParameterJdbcTemplate namedParameterJdbcTemplate = new NamedParameterJdbcTemplate(jdbcTemplate);
    MapSqlParameterSource parameters = new MapSqlParameterSource();
    parameters.addValue("categories", list);
    return namedParameterJdbcTemplate.query("SELECT * FROM recruitList.infolist WHERE status IN (:categories)",
            parameters, new PersonRowMapper());
}

From source file:org.mulima.internal.freedb.FreeDbJdbcDaoImpl.java

/**
 * {@inheritDoc}/*from  www .  java 2  s.  c o  m*/
 */
@Override
@Transactional
public void addDisc(Disc disc) {
    logger.trace("Entering addDisc");
    final String sql = "INSERT INTO `discs` VALUES(null, :artist, :title, :year, :genre)";
    MapSqlParameterSource parms = new MapSqlParameterSource();
    parms.addValue("artist", disc.getFlat(GenericTag.ARTIST));
    parms.addValue("title", disc.getFlat(GenericTag.ALBUM));
    String year = disc.getFirst(GenericTag.DATE);
    if (year == null || "".equals(year) || year.length() > 4) {
        parms.addValue("year", null);
    } else {
        parms.addValue("year", year + "-01-01");
    }

    parms.addValue("genre", disc.getFlat(GenericTag.GENRE));

    KeyHolder keys = new GeneratedKeyHolder();
    this.getNamedParameterJdbcTemplate().update(sql, parms, keys);

    int newDiscId = keys.getKey().intValue();
    addCddbIds(newDiscId, disc);
    addTracks(newDiscId, disc.getTracks());
    logger.trace("Exiting addDisc");
}