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

Introduction

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

Prototype

public MapSqlParameterSource(@Nullable Map<String, ?> values)

Source Link

Document

Create a new MapSqlParameterSource based on a Map.

Usage

From source file:com.github.ferstl.spring.jdbc.oracle.OracleNamedParameterJdbcTemplateTest.java

@Test
public void setNullNoType() throws SQLException {
    Map<String, Object> map = new HashMap<>(2);
    map.put("ten", 10);
    map.put("twenty", null);
    String sql = "SELECT 1 FROM dual WHERE 1 = :ten or 20 = :twenty";
    PreparedStatementCreator preparedStatementCreator = this.namedJdbcTemplate.getPreparedStatementCreator(sql,
            new MapSqlParameterSource(map));

    Connection connection = mock(Connection.class);
    PreparedStatement preparedStatement = mock(PreparedStatement.class);
    OraclePreparedStatement oracleStatement = mock(OraclePreparedStatement.class);

    when(connection.prepareStatement(sql)).thenReturn(preparedStatement);
    when(preparedStatement.unwrap(OraclePreparedStatement.class)).thenReturn(oracleStatement);

    preparedStatementCreator.createPreparedStatement(connection);

    verify(oracleStatement).setObjectAtName("ten", 10);
    verify(oracleStatement).setNullAtName("twenty", Types.NULL);
}

From source file:ru.mystamps.web.dao.impl.JdbcUserDao.java

@Override
public Integer add(AddUserDbDto user) {
    Map<String, Object> params = new HashMap<>();
    params.put("login", user.getLogin());
    params.put("role", String.valueOf(user.getRole()));
    params.put("name", user.getName());
    params.put("email", user.getEmail());
    params.put("registered_at", user.getRegisteredAt());
    params.put("activated_at", user.getActivatedAt());
    params.put("hash", user.getHash());

    KeyHolder holder = new GeneratedKeyHolder();

    int affected = jdbcTemplate.update(addUserSql, new MapSqlParameterSource(params), holder);

    Validate.validState(affected == 1, "Unexpected number of affected rows after creation of user: %d",
            affected);/*from   www. ja  va  2s .c  o m*/

    return Integer.valueOf(holder.getKey().intValue());
}

From source file:ru.mystamps.web.dao.impl.JdbcCountryDao.java

@Override
public Integer add(AddCountryDbDto country) {
    Map<String, Object> params = new HashMap<>();
    params.put("name", country.getName());
    params.put("name_ru", country.getNameRu());
    params.put("slug", country.getSlug());
    params.put("created_at", country.getCreatedAt());
    params.put("created_by", country.getCreatedBy());
    params.put("updated_at", country.getUpdatedAt());
    params.put("updated_by", country.getUpdatedBy());

    KeyHolder holder = new GeneratedKeyHolder();

    int affected = jdbcTemplate.update(addCountrySql, new MapSqlParameterSource(params), holder);

    Validate.validState(affected == 1, "Unexpected number of affected rows after creation of country: %d",
            affected);//from  www.  ja v  a2 s  . c o  m

    return Integer.valueOf(holder.getKey().intValue());
}

From source file:ru.mystamps.web.dao.impl.JdbcCategoryDao.java

@Override
public Integer add(AddCategoryDbDto category) {
    Map<String, Object> params = new HashMap<>();
    params.put("name", category.getName());
    params.put("name_ru", category.getNameRu());
    params.put("slug", category.getSlug());
    params.put("created_at", category.getCreatedAt());
    params.put("created_by", category.getCreatedBy());
    params.put("updated_at", category.getUpdatedAt());
    params.put("updated_by", category.getUpdatedBy());

    KeyHolder holder = new GeneratedKeyHolder();

    int affected = jdbcTemplate.update(addCategorySql, new MapSqlParameterSource(params), holder);

    Validate.validState(affected == 1, "Unexpected number of affected rows after creation of category: %d",
            affected);/*w  w  w .  j  a v  a 2  s .com*/

    return Integer.valueOf(holder.getKey().intValue());
}

From source file:com.ebay.pulsar.analytics.dao.RDBMS.java

public int queryForInt(final String sql, Map<String, ?> parameters) {
    return this.namedParameterJdbcTemplate.queryForObject(sql, new MapSqlParameterSource(parameters),
            Integer.class);
}

From source file:com.github.ferstl.spring.jdbc.oracle.OracleNamedParameterJdbcTemplateTest.java

@Test
public void setWithType() throws SQLException {
    MapSqlParameterSource source = new MapSqlParameterSource(new HashMap<String, Object>(2));
    source.addValue("ten", 10, Types.NUMERIC);
    source.addValue("twenty", null, Types.VARCHAR);
    String sql = "SELECT 1 FROM dual WHERE 1 = :ten or 20 = :twenty";
    PreparedStatementCreator preparedStatementCreator = this.namedJdbcTemplate.getPreparedStatementCreator(sql,
            source);/*from ww  w. j  av a  2  s. c  o m*/

    Connection connection = mock(Connection.class);
    PreparedStatement preparedStatement = mock(PreparedStatement.class);
    OraclePreparedStatement oracleStatement = mock(OraclePreparedStatement.class);

    when(connection.prepareStatement(sql)).thenReturn(preparedStatement);
    when(preparedStatement.unwrap(OraclePreparedStatement.class)).thenReturn(oracleStatement);

    preparedStatementCreator.createPreparedStatement(connection);

    verify(oracleStatement).setObjectAtName("ten", 10, Types.NUMERIC);
    verify(oracleStatement).setNullAtName("twenty", Types.VARCHAR);
}

From source file:ru.mystamps.web.dao.impl.JdbcCollectionDao.java

@Override
public Integer add(AddCollectionDbDto collection) {
    Map<String, Object> params = new HashMap<>();
    params.put("user_id", collection.getOwnerId());
    params.put("slug", collection.getSlug());
    params.put("updated_at", collection.getUpdatedAt());
    params.put("updated_by", collection.getOwnerId());

    KeyHolder holder = new GeneratedKeyHolder();

    int affected = jdbcTemplate.update(addCollectionSql, new MapSqlParameterSource(params), holder);

    Validate.validState(affected == 1,/*  www . j ava 2  s .  c  om*/
            "Unexpected number of affected rows after creation of collection of user #%d: %d",
            params.get("user_id"), affected);

    return Integer.valueOf(holder.getKey().intValue());
}

From source file:pl.edu.agh.samm.db.impl.MeasurementValueDAO.java

@Override
public Map<String, Number> getAverageMeasurementValue(String resource, Date beforeActionStartTime,
        Date actionStartTime) {/*ww  w . j  a v  a 2  s  . c om*/
    final Map<String, Number> ret = new HashMap<String, Number>();
    Map<String, Object> params = new HashMap<String, Object>();
    params.put("instance", resource);
    params.put("start", beforeActionStartTime);
    params.put("end", actionStartTime);
    SqlParameterSource sps = new MapSqlParameterSource(params);
    getSimpleJdbcTemplate().getNamedParameterJdbcOperations().query(SQL_QUERY_AVERAGE_BY_CAPABILITY, sps,
            new RowCallbackHandler() {

                @Override
                public void processRow(ResultSet arg0) throws SQLException {
                    ret.put(arg0.getString(1), arg0.getDouble(2));

                }
            });
    return ret;
}

From source file:eu.europa.esig.dss.web.dao.PreferencesJdbcDao.java

@Override
public void update(Preference entity) {
    final String query = "update " + TABLE_NAME + " set " + COLUMN_VALUE + " = :value where " + COLUMN_KEY
            + " = :key";
    final Map<String, Object> parameters = new HashMap<String, Object>();
    parameters.put("key", entity.getKey());
    parameters.put("value", entity.getValue());
    final SqlParameterSource namedParameters = new MapSqlParameterSource(parameters);
    namedParameterJdbcTemplate.update(query, namedParameters);
}