Example usage for org.springframework.jdbc.core.namedparam MapSqlParameterSource 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:org.runway.users.repository.JdbcUserProfileDaoImpl.java

public UserProfile getUserProfile(String userid, String key) {

    MapSqlParameterSource mapSql = new MapSqlParameterSource();
    mapSql.addValue("id", userid);

    String querySql = "SELECT id, key1, value, em_time from EM_USER_PROFILE where id=:id AND key1=:key";

    UserProfile profile = jdbcTemplate.queryForObject(querySql, new UserProfileMapper(), mapSql);

    return profile;
}

From source file:com.example.securelogin.selenium.loginform.SecureLoggingTest.java

private void isLogged(long start, long end, String username, String message) {
    NamedParameterJdbcOperations jdbcOperations = dbLogAssertOperations.getJdbcOperations();

    StringBuilder sql = new StringBuilder();
    StringBuilder where = new StringBuilder();
    sql.append("SELECT COUNT(e.*) FROM logging_event e");
    where.append(" WHERE e.formatted_message REGEXP :message");
    where.append(" AND e.timestmp BETWEEN :start AND :end");
    sql.append(" JOIN logging_event_property ep ON ep.event_id = e.event_id");
    if (username != null) {
        where.append(" AND ep.mapped_key = 'USER' AND ep.mapped_value = :username");
    }/*  w w w  .ja va2  s .com*/
    sql.append(where);

    MapSqlParameterSource params = new MapSqlParameterSource();
    params.addValue("start", start);
    params.addValue("end", end);
    params.addValue("username", username);
    params.addValue("message", message);
    Long count = jdbcOperations.queryForObject(sql.toString(), params, Long.class);
    assertThat(count, is(not(0L)));
}

From source file:org.sakuli.services.receiver.database.dao.impl.DaoTestCaseStepImpl.java

@Override
public void saveTestCaseSteps(List<TestCaseStep> steps, int primaryKeyOfTestCase) {
    for (TestCaseStep step : steps) {
        logger.info("============== save STEP \"" + step.getName() + "\" ==============");
        MapSqlParameterSource stepParameters = new MapSqlParameterSource();
        stepParameters.addValue("sahi_cases_id", primaryKeyOfTestCase);
        stepParameters.addValue("result", step.getState().getErrorCode());
        stepParameters.addValue("result_desc", step.getState());
        stepParameters.addValue("name", step.getName());
        stepParameters.addValue("start", step.getStartDateAsUnixTimestamp());
        stepParameters.addValue("stop", step.getStopDateAsUnixTimestamp());
        stepParameters.addValue("warning", step.getWarningTime());
        stepParameters.addValue("duration", step.getDuration());

        logger.info("write the following values to 'sahi_steps': " + stepParameters.getValues()
                + "\n now execute ....");

        //generate the sql-statement
        SimpleJdbcInsert insertStepResults = new SimpleJdbcInsert(getDataSource()).withTableName("sahi_steps")
                .usingGeneratedKeyColumns("id");

        //execute the sql-statement and save the primary key
        int dbPrimaryKey = insertStepResults.executeAndReturnKey(stepParameters).intValue();
        logger.info("test case step '" + step.getName() + "' has been written to 'sahi_steps' with  primaryKey="
                + dbPrimaryKey);//from w  ww  .ja  v  a2  s .c o m
        step.setDbPrimaryKey(dbPrimaryKey);
    }
}

From source file:org.terasoluna.gfw.functionaltest.app.DBLogProvider.java

public long countContainsMessageAndLevelsAndLogger(String message, String level, String loggerName) {

    StringBuilder sql = new StringBuilder();
    sql.append(//from  ww  w. j a v a 2 s.c  om
            "SELECT COUNT(e.*) FROM logging_event e WHERE e.formatted_message REGEXP :message AND e.level_string = :level");

    if (StringUtils.hasText(loggerName)) {
        sql.append(" AND e.logger_name = :loggerName");
    }

    MapSqlParameterSource params = new MapSqlParameterSource();
    params.addValue("message", message);
    params.addValue("level", level);
    params.addValue("loggerName", loggerName);

    Long count = jdbcOperations.queryForObject(sql.toString(), params, Long.class);
    return count;
}

From source file:de.langmi.spring.batch.examples.readers.file.csv.FieldSetSqlParameterSourceProvider.java

/** {@inheritDoc} */
@Override/* ww w .  ja v a 2s.  c  om*/
public SqlParameterSource createSqlParameterSource(FieldSet item) {
    MapSqlParameterSource sps = new MapSqlParameterSource();
    for (Entry<Object, Object> entry : item.getProperties().entrySet()) {
        sps.addValue(entry.getKey().toString(), entry.getValue());
    }
    return sps;
}

From source file:com.xinferin.dao.DAOActivationImpl.java

@Override
public int getCount(int licenceId) {

    String sql = "SELECT COUNT(*) FROM activation WHERE licence_id = :id";
    MapSqlParameterSource args = new MapSqlParameterSource();
    args = new MapSqlParameterSource();
    args.addValue("id", licenceId);

    int count = jdbcTemplate.queryForObject(sql, args, Integer.class);

    return count;
}

From source file:org.terasoluna.gfw.functionaltest.app.DBLogProvider.java

public long countContainsByRegexExceptionMessage(String xTrack, String loggerNamePattern, String messagePattern,
        String exceptionMessagePattern) {

    StringBuilder sql = new StringBuilder();
    StringBuilder where = new StringBuilder();
    sql.append("SELECT COUNT(e.*) FROM logging_event e");
    where.append(" WHERE e.formatted_message REGEXP :message");

    sql.append(" JOIN logging_event_exception ee ON ee.event_id = e.event_id");
    where.append(" AND ee.I = '0' AND ee.TRACE_LINE REGEXP :exceptionMessage");

    if (StringUtils.hasText(xTrack)) {
        sql.append(" JOIN logging_event_property ep ON ep.event_id = e.event_id");
        where.append(" AND ep.mapped_key = 'X-Track' AND ep.mapped_value = :xTrack");
    }//from w  w w .  j  a va2 s  . c o m
    if (StringUtils.hasText(loggerNamePattern)) {
        where.append(" AND e.logger_name REGEXP :loggerName");
    }
    sql.append(where);

    MapSqlParameterSource params = new MapSqlParameterSource();
    params.addValue("xTrack", xTrack);
    params.addValue("loggerName", loggerNamePattern);
    params.addValue("message", messagePattern);
    params.addValue("exceptionMessage", exceptionMessagePattern);
    Long count = jdbcOperations.queryForObject(sql.toString(), params, Long.class);
    return count;
}

From source file:de.langmi.spring.batch.templates.importfile.generic.FieldSetSqlParameterSourceProvider.java

@Override
public SqlParameterSource createSqlParameterSource(FieldSet item) {
    // map FieldSet to MapSqlParameterSource
    MapSqlParameterSource sps = new MapSqlParameterSource();
    for (Entry<Object, Object> entry : item.getProperties().entrySet()) {
        sps.addValue(entry.getKey().toString(), entry.getValue());
    }//from   www  . j a  v a2  s .c  om

    return sps;

}

From source file:com.xinferin.dao.DAOCustomerRegistrationImpl.java

private void bindRegistrationAndLicence(int registration_id, int licence_id) {
    String sql = "INSERT INTO licence_registration (registration_id, licence_id)"
            + " VALUES (:registration_id, :licence_id)";

    MapSqlParameterSource args = new MapSqlParameterSource();
    args.addValue("registration_id", registration_id);
    args.addValue("licence_id", licence_id);

    jdbcTemplate.update(sql, args);/*from  ww  w.ja v  a 2s  .c  o m*/
}

From source file:org.terasoluna.gfw.functionaltest.domain.DBLogCleaner.java

private int cleanup(long savedPeriodMinutes) {
    // calculate cutoff date.
    Date cutoffDate = new Date(System.currentTimeMillis() - (TimeUnit.MINUTES.toMillis(savedPeriodMinutes)));

    LOGGER.info("Begin cleanup. cutoffDate is '{}'.", cutoffDate);

    // decide max event id of unnecessary log.
    MapSqlParameterSource queryParameters = new MapSqlParameterSource();
    queryParameters.addValue("cutoffDateMillis", cutoffDate.getTime());
    Long maxEventId = namedParameterJdbcTemplate.queryForObject(
            "SELECT MAX(event_id) FROM logging_event WHERE timestmp < :cutoffDateMillis", queryParameters,
            Long.class);

    // delete unnecessary log.
    int deletedCount = 0;
    if (maxEventId != null) {
        MapSqlParameterSource deleteParameters = new MapSqlParameterSource();
        deleteParameters.addValue("eventId", maxEventId);
        namedParameterJdbcTemplate.update("DELETE FROM logging_event_exception WHERE event_id <= :eventId",
                deleteParameters);/*from   ww w  . j a  va 2  s.  co m*/
        namedParameterJdbcTemplate.update("DELETE FROM logging_event_property WHERE event_id <= :eventId",
                deleteParameters);
        deletedCount = namedParameterJdbcTemplate.update("DELETE FROM logging_event WHERE event_id <= :eventId",
                deleteParameters);
        LOGGER.info("Finished cleanup. Deleted log count is '{}'.", deletedCount);
    } else {
        LOGGER.info("Finished cleanup. Not exists target log.");
    }
    return deletedCount;
}