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

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

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

Introduction

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

Prototype

public Map<String, Object> getValues()

Source Link

Document

Expose the current parameter values as read-only Map.

Usage

From source file:com.esa.infocontrol.data.jdbc.BaseDataJDBC.java

static int updateData(DataSource dataSource, String query, MapSqlParameterSource params) {
    LOG.debug("QUERY: {}", query);
    if (params != null) {
        LOG.debug("\tPARAMETERS: {}", params.getValues().toString());
    }/*from www  .  j a  v  a  2  s . c  om*/
    NamedParameterJdbcTemplate jdbcTemplate = new NamedParameterJdbcTemplate(dataSource);
    int affectedRows = jdbcTemplate.update(query, params);
    return affectedRows;
}

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

@SuppressWarnings("unchecked")
public static void logParameters(MapSqlParameterSource paramSource) {
    DaoUtils.LogParameters(paramSource.getValues());
}

From source file:com.esa.infocontrol.data.jdbc.BaseDataJDBC.java

public static DataArrayWrapper getList(DataSource dataSource, String query, MapSqlParameterSource params) {
    LOG.debug("QUERY: {}", query);
    if (params != null) {
        LOG.debug("\tPARAMETERS: {}", params.getValues().toString());
    }/*from www.  j  a  v a 2 s  .  c  o  m*/
    NamedParameterJdbcTemplate jdbcTemplate = new NamedParameterJdbcTemplate(dataSource);
    SqlRowSet rs = jdbcTemplate.queryForRowSet(query, params);
    SqlRowSetMetaData md = rs.getMetaData();
    LOG.debug("\tCOLUMNS: {}", Arrays.toString(md.getColumnNames()));
    List<DataRow> dataList = new ArrayList<>();
    ColumnMetaData[] columnMetaData = new ColumnMetaData[md.getColumnCount()];
    for (int i = 1; i <= md.getColumnCount(); ++i) {
        columnMetaData[i - 1] = new ColumnMetaData(md.getColumnLabel(i), md.getColumnType(i));
    }
    while (rs.next()) {
        DataRow row = new DataRow(md.getColumnCount());
        for (int i = 1; i <= md.getColumnCount(); ++i) {
            row.add(rs.getString(i));
        }
        dataList.add(row);
    }
    return new DataArrayWrapper(dataList, columnMetaData);
}

From source file:com.qualogy.qafe.business.resource.rdb.query.QueryToStringCreator.java

private static String manageDynamicQueryReplacement(MapSqlParameterSource namedParameters, String sql) {
    if (namedParameters == null || namedParameters.getValues() == null) {
        return sql;
    }//from   w w w  .  j  av  a 2  s  .  c om
    Iterator keySet = namedParameters.getValues().keySet().iterator();
    while (keySet.hasNext()) {
        String key = (String) keySet.next();
        if (key.startsWith(DYNAMIC_VARS_PREFIX) && sql.contains(key)) {
            sql = sql.replace(key, (String) namedParameters.getValues().get(key));
        }
    }
    return sql;
}

From source file:com.qualogy.qafe.business.resource.rdb.query.QueryToStringCreator.java

/**
 *
 * @param namedParameters/*from   w ww  .  ja v  a  2  s  . c o  m*/
 * @param inputMap
 * @return
 */
private static String getColumnName(MapSqlParameterSource namedParameters, String inputMap) {
    String columnName = "";
    if (namedParameters.getValues().keySet().contains(inputMap)) {
        columnName = inputMap;
    } else if (namedParameters.getValues().keySet().contains(inputMap.toLowerCase())) {
        columnName = inputMap.toLowerCase();
    } else if (namedParameters.getValues().keySet().contains(inputMap.toUpperCase())) {
        columnName = inputMap.toUpperCase();
    }
    return columnName;
}

From source file:com.joliciel.talismane.terminology.postgres.PostGresTerminologyBase.java

@SuppressWarnings("unchecked")
public static void LogParameters(MapSqlParameterSource paramSource) {
    DaoUtils.LogParameters(paramSource.getValues(), LOG);
}

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

@Override
public int saveTestSuiteToSahiJobs() {
    logger.info("save the guid to the table 'sahi_jobs'");
    //build up the statement
    MapSqlParameterSource tcParameters = getGuidParameter();
    logger.info("write the following values to 'sahi_jobs': " + tcParameters.getValues()
            + " ==>  now execute ....");
    SimpleJdbcInsert insertTS = new SimpleJdbcInsert(getDataSource()).withTableName("sahi_jobs")
            .usingGeneratedKeyColumns("id");
    testSuite.setDbJobPrimaryKey(insertTS.executeAndReturnKey(tcParameters).intValue());
    logger.info("the test suite \"" + testSuite.getId() + "\"" + "with the guid \"" + testSuite.getGuid()
            + "\" has been written to 'sahi_jobs' with  primaryKey=" + testSuite.getDbJobPrimaryKey());
    return testSuite.getDbJobPrimaryKey();
}

From source file:org.sakuli.services.forwarder.database.dao.impl.DaoTestSuiteImpl.java

@Override
public int saveTestSuiteToSahiJobs() {
    LOGGER.debug("save the guid to the table 'sakuli_jobs'");
    //build up the statement
    MapSqlParameterSource tcParameters = getGuidParameter();
    LOGGER.debug("write the following values to 'sakuli_jobs': " + tcParameters.getValues()
            + " ==>  now execute ....");
    SimpleJdbcInsert insertTS = new SimpleJdbcInsert(getDataSource()).withTableName("sakuli_jobs")
            .usingGeneratedKeyColumns("id");
    testSuite.setDbJobPrimaryKey(insertTS.executeAndReturnKey(tcParameters).intValue());
    LOGGER.info("the test suite \"" + testSuite.getId() + "\"" + "with the guid \"" + testSuite.getGuid()
            + "\" has been written to 'sakuli_jobs' with  primaryKey=" + testSuite.getDbJobPrimaryKey());
    return testSuite.getDbJobPrimaryKey();
}

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

@Override
public void saveTestSuiteResult() {
    testSuite.refreshState();/*  ww  w  .  j a v  a2 s.c  o  m*/
    logger.info("save the results of the test suite to the table 'sahi_suites'");

    MapSqlParameterSource tcParameters = getCompleteParameters();
    logger.info("write the following values to 'sahi_suites': " + tcParameters.getValues()
            + " ==>  now execute ....");
    String sqlStatement = "UPDATE sahi_suites " + createSqlSetStringForNamedParameter(tcParameters.getValues())
            + " where id=:id";

    logger.debug("SQL-Statement for update 'sahi_suites': " + sqlStatement);
    int affectedRows = getNamedParameterJdbcTemplate().update(sqlStatement, tcParameters);
    logger.info("update 'sahi_suites' affected " + affectedRows + " rows");
}

From source file:org.sakuli.services.forwarder.database.dao.impl.DaoTestSuiteImpl.java

@Override
public void saveTestSuiteResult() {
    testSuite.refreshState();/*from w  w  w .ja  v a  2 s .  c o  m*/
    LOGGER.info("save the results of the test suite to the table 'sakuli_suites'");

    MapSqlParameterSource tcParameters = getCompleteParameters();
    LOGGER.debug("write the following values to 'sakuli_suites': " + tcParameters.getValues()
            + " ==>  now execute ....");
    String sqlStatement = "UPDATE sakuli_suites "
            + createSqlSetStringForNamedParameter(tcParameters.getValues()) + " where id=:id";

    LOGGER.debug("SQL-Statement for update 'sakuli_suites': " + sqlStatement);
    int affectedRows = getNamedParameterJdbcTemplate().update(sqlStatement, tcParameters);
    LOGGER.info("update 'sakuli_suites' affected " + affectedRows + " rows");
}