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

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

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

Introduction

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

Prototype

public MapSqlParameterSource()

Source Link

Document

Create an empty MapSqlParameterSource, with values to be added via addValue .

Usage

From source file:org.runway.users.repository.JdbcUserDaoImpl.java

public User getUserById(String id) {

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

    User user = jdbcTemplate.queryForObject("SELECT * from EM_USERS where ID=:id", new UserMapper(), mapSql);

    return user;// ww  w  .j  av  a2  s .co m
}

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

@Override
public void saveTestCaseResult(final TestCase testCase) {
    logger.info("Save results for test case \"" + testCase.getId() + "\"");

    //create a map for the sql parameters
    MapSqlParameterSource tcParameters = new MapSqlParameterSource();
    tcParameters.addValue("sahi_suites_id", testSuite.getDbPrimaryKey());
    tcParameters.addValue("caseID", testCase.getId());
    tcParameters.addValue("result", testCase.getState().getErrorCode());
    tcParameters.addValue("result_desc", testCase.getState());
    tcParameters.addValue("name", testCase.getName());
    tcParameters.addValue("guid", testSuite.getGuid());
    tcParameters.addValue("start", testCase.getStartDateAsUnixTimestamp());
    tcParameters.addValue("stop", testCase.getStopDateAsUnixTimestamp());
    tcParameters.addValue("warning", testCase.getWarningTime());
    tcParameters.addValue("critical", testCase.getCriticalTime());
    tcParameters.addValue("browser", testSuite.getBrowserInfo());
    tcParameters.addValue("lastpage", testCase.getLastURL());

    //try to save the screenshot
    try {//from   www . j av  a2  s .  co  m
        if (testCase.getScreenShotPath() != null) {
            final InputStream blobIs = Files.newInputStream(testCase.getScreenShotPath());
            final int length = (int) testCase.getScreenShotPath().toFile().length();
            tcParameters.addValue("screenshot", new SqlLobValue(blobIs, length, lobHandler), Types.BLOB);
        }
    } catch (IOException e) {
        throw new RuntimeException(e);
    }
    tcParameters.addValue("duration", testCase.getDuration());
    tcParameters.addValue("msg", testCase.getExceptionMessages());

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

    logger.info(
            "write the following values to 'sahi_cases': " + tcParameters.getValues() + " => now execute ....");

    int dbPrimaryKey = insertTCResults.executeAndReturnKey(tcParameters).intValue();

    logger.info("test case '" + testCase.getId() + "' has been written to 'sahi_cases' with  primaryKey="
            + dbPrimaryKey);
    testCase.setDbPrimaryKey(dbPrimaryKey);
}

From source file:org.ext4spring.parameter.dao.JdbcParameterRepository.java

@Override
public boolean parameterExists(Metadata metadata) {
    MapSqlParameterSource namedParameters = new MapSqlParameterSource();
    namedParameters.addValue("domain", metadata.getDomain());
    namedParameters.addValue("parameter", metadata.getFullParameterName());
    return (namedParameterJdbcTemplate.queryForInt(this.countQuery, namedParameters) > 0);
}

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

@Override
public List<Person> selectAll(List<Category> desiredCategories) {
    checkSingleton();//from ww  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:fi.luontola.cqrshotel.framework.PsqlEventStore.java

@Override
public long saveEvents(UUID streamId, List<Event> newEvents, int expectedVersion) {
    try (Connection connection = DataSourceUtils.getConnection(dataSource)) {
        Array data = connection.createArrayOf("jsonb", serializeData(newEvents));
        Array metadata = connection.createArrayOf("jsonb", serializeMetadata(newEvents));

        long endPosition = jdbcTemplate.queryForObject(
                "SELECT save_events(:stream_id, :expected_version, :data, :metadata)",
                new MapSqlParameterSource().addValue("stream_id", streamId)
                        .addValue("expected_version", expectedVersion).addValue("data", data)
                        .addValue("metadata", metadata),
                Long.class);

        if (log.isTraceEnabled()) {
            for (int i = 0; i < newEvents.size(); i++) {
                int newVersion = expectedVersion + 1 + i;
                Event newEvent = newEvents.get(i);
                log.trace("Saved stream {} version {}: {}", streamId, newVersion, newEvent);
            }//from   www.  jav a 2 s.com
        }
        return endPosition;

    } catch (UncategorizedSQLException e) {
        if (e.getCause() instanceof PSQLException) {
            ServerErrorMessage serverError = ((PSQLException) e.getCause()).getServerErrorMessage();
            Matcher m = OPTIMISTIC_LOCKING_FAILURE_MESSAGE.matcher(serverError.getMessage());
            if (m.matches()) {
                String currentVersion = m.group(1);
                throw new OptimisticLockingException("expected version " + expectedVersion + " but was "
                        + currentVersion + " for stream " + streamId, e);
            }
        }
        throw e;
    } catch (SQLException | JsonProcessingException e) {
        throw new RuntimeException(e);
    }
}

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

@Override
public void delete(int productId) {
    String sql = "DELETE FROM product WHERE id=:id";
    SqlParameterSource args = new MapSqlParameterSource().addValue("id", productId);
    jdbcTemplate.update(sql, args);//from  w  w  w  .  j  a  v a2s. co m
}

From source file:com.github.dbourdette.glass.log.joblog.jdbc.JdbcJobLogStore.java

@Override
public void add(JobLog jobLog) {
    String sql = "insert into " + getTableName()
            + " (id, executionId, logLevel, logDate, jobClass, jobGroup, jobName, triggerGroup, triggerName, message, stackTrace, rootCause)"
            + " values (" + configuration.getTablePrefix()
            + "sequence.nextval, :executionId, :logLevel, :logDate, :jobClass, :jobGroup, :jobName, :triggerGroup, :triggerName, :message, :stackTrace, :rootCause)";

    SqlParameterSource params = new MapSqlParameterSource().addValue("executionId", jobLog.getExecutionId())
            .addValue("logLevel", jobLog.getLevel().name()).addValue("logDate", jobLog.getDate())
            .addValue("jobClass", jobLog.getJobClass()).addValue("jobGroup", jobLog.getJobGroup())
            .addValue("jobName", jobLog.getJobName()).addValue("triggerGroup", jobLog.getTriggerGroup())
            .addValue("triggerName", jobLog.getTriggerName()).addValue("message", jobLog.getMessage())
            .addValue("stackTrace", jobLog.getStackTrace()).addValue("rootCause", jobLog.getRootCause());

    jdbcTemplate.update(sql, params);/*from  w w  w.j a va 2  s.c om*/
}

From source file:org.impotch.calcul.impot.cantonal.ge.param.dao.ParametreCommunalJdbcRTaxPPDao.java

/**************************************************/

//-------- Implmentation de l'interface ParametreCommunalDao

@Override/*ww  w . j  a  v a 2s  .  c o m*/
public BigDecimal getPartPrivilegiee(int annee, int noOFSCommune) {
    String sql = "SELECT PPC.PIC_N_PART_PRIVILEGIEE / 100 " + FROM;
    MapSqlParameterSource param = new MapSqlParameterSource();
    param.addValue("periode", annee);
    param.addValue("noOFS", noOFSCommune);
    return this.getSimpleJdbcTemplate().queryForObject(sql, BigDecimal.class, param);
}

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

@Override
public void delete(int customerId) {
    String sql = "DELETE FROM customer WHERE id=:id";
    SqlParameterSource args = new MapSqlParameterSource().addValue("id", customerId);
    jdbcTemplate.update(sql, args);/*from  ww  w. j  av  a  2s .  c om*/
}

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   w  w w  . j  ava2  s  .c  o  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;
}