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:airport.database.services.users.UsersDaoOnlineImpl.java

@Override
public void updateTimer(User user) {
    MapSqlParameterSource parameterSource = new MapSqlParameterSource();
    parameterSource.addValue("last_visit", new Timestamp(new Date().getTime()));
    parameterSource.addValue("id_session", user.getId());

    jdbcTemplate.update(SQL_QUERY_UPDATE_LAS_VISIT, parameterSource);

    if (LOG.isInfoEnabled()) {
        LOG.info("update time of user. User : " + user);
    }/*from   ww  w .j  a  v  a2s .  com*/
}

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

private void connectToExperiment(String experimentId, Integer taskId) {
    MapSqlParameterSource parameters = new MapSqlParameterSource();
    parameters.addValue("id", experimentId);
    parameters.addValue("taskId", taskId);
    this.template.update(CONNECT_TASK_EXPERIMENT, parameters);
}

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

@Override
public List<ExperimentTaskResult> getResultsOfExperiment(String experimentId) {
    MapSqlParameterSource parameters = new MapSqlParameterSource();
    parameters.addValue("id", experimentId);
    List<ExperimentTaskResult> result = this.template.query(GET_EXPERIMENT_RESULTS, parameters,
            new ExperimentTaskResultRowMapper());
    return result;
}

From source file:com.joliciel.jochre.boundaries.BoundaryDaoJdbc.java

@Override
public void saveSplit(Split split) {
    NamedParameterJdbcTemplate jt = new NamedParameterJdbcTemplate(this.getDataSource());
    MapSqlParameterSource paramSource = new MapSqlParameterSource();
    SplitInternal iSplit = (SplitInternal) split;

    paramSource.addValue("split_shape_id", split.getShapeId());
    paramSource.addValue("split_position", split.getPosition());
    String sql = null;//from w  w w.  j av a2  s  .  c  o  m

    if (split.isNew()) {
        sql = "SELECT nextval('ocr_split_id_seq')";
        LOG.debug(sql);
        int splitId = jt.queryForInt(sql, paramSource);
        paramSource.addValue("split_id", splitId);

        sql = "INSERT INTO ocr_split (split_id, split_shape_id, split_position) "
                + "VALUES (:split_id, :split_shape_id, :split_position)";

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

        iSplit.setId(splitId);
    } else {
        paramSource.addValue("split_id", split.getId());

        sql = "UPDATE ocr_split" + " SET split_shape_id = :split_shape_id"
                + ", split_position = :split_position" + " WHERE split_id = :split_id";

        LOG.debug(sql);
        logParameters(paramSource);
        jt.update(sql, paramSource);
    }
}

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

private MapSqlParameterSource createTaskParameters(String annotatorName, String datasetName,
        String experimentType, String matching) {
    MapSqlParameterSource parameters = new MapSqlParameterSource();
    parameters.addValue("annotatorName", annotatorName);
    parameters.addValue("datasetName", datasetName);
    parameters.addValue("experimentType", experimentType);
    parameters.addValue("matching", matching);
    return parameters;
}

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

@Override
public void setExperimentState(int experimentTaskId, int state) {
    MapSqlParameterSource parameters = new MapSqlParameterSource();
    parameters.addValue("id", experimentTaskId);
    parameters.addValue("state", state);
    java.util.Date today = new java.util.Date();
    parameters.addValue("lastChanged", new java.sql.Timestamp(today.getTime()));
    this.template.update(SET_TASK_STATE, parameters);
}

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

@Override
protected void setRunningExperimentsToError() {
    MapSqlParameterSource parameters = new MapSqlParameterSource();
    parameters.addValue("unfinishedState", TASK_STARTED_BUT_NOT_FINISHED_YET);
    parameters.addValue("state", ErrorTypes.SERVER_STOPPED_WHILE_PROCESSING.getErrorCode());
    java.util.Date today = new java.util.Date();
    parameters.addValue("lastChanged", new java.sql.Timestamp(today.getTime()));
    this.template.update(SET_UNFINISHED_TASK_STATE, parameters);
}

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

@Override
public List<ExperimentTaskResult> getLatestResultsOfExperiments(String experimentType, String matching) {
    MapSqlParameterSource parameters = new MapSqlParameterSource();
    parameters.addValue("experimentType", experimentType);
    parameters.addValue("matching", matching);
    parameters.addValue("unfinishedState", TASK_STARTED_BUT_NOT_FINISHED_YET);
    return this.template.query(GET_LATEST_EXPERIMENT_TASK_RESULTS, parameters,
            new ExperimentTaskResultRowMapper());
}

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

@Override
public int getExperimentState(int experimentTaskId) {
    MapSqlParameterSource parameters = new MapSqlParameterSource();
    parameters.addValue("id", experimentTaskId);
    List<Integer> result = this.template.query(GET_TASK_STATE, parameters, new IntegerRowMapper());
    if (result.size() > 0) {
        return result.get(0);
    } else {/*  w ww.ja v  a  2 s .  com*/
        return TASK_NOT_FOUND;
    }
}

From source file:com.ebay.pulsar.analytics.dao.service.BaseDBService.java

public List<T> getAllByColumnIn(String column, List<?> in, int maxSize) {
    Set<?> unique = Sets.newHashSet(in);
    if (unique.size() == 0)
        return Lists.newArrayList();
    String sql = "select * from " + QUTOA + getTableName() + QUTOA + " where " + QUTOA + column + QUTOA
            + " in (:INPARAMETER)";
    MapSqlParameterSource parameters = new MapSqlParameterSource();
    parameters.addValue("INPARAMETER", unique);
    return this.getDB().query(sql, parameters, maxSize, mapper());
}