Example usage for org.springframework.jdbc.core.namedparam NamedParameterJdbcTemplate update

List of usage examples for org.springframework.jdbc.core.namedparam NamedParameterJdbcTemplate update

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

Introduction

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

Prototype

@Override
    public int update(String sql, Map<String, ?> paramMap) throws DataAccessException

Source Link

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());
    }//  w w  w .j  a v  a2s  .c  o  m
    NamedParameterJdbcTemplate jdbcTemplate = new NamedParameterJdbcTemplate(dataSource);
    int affectedRows = jdbcTemplate.update(query, params);
    return affectedRows;
}

From source file:com.github.dactiv.common.unit.Fixtures.java

/**
 * , disable.// w  w  w .j  a  v a  2  s .  c  om
 */
public static void deleteTable(DataSource h2DataSource, String... tableNames) {
    NamedParameterJdbcTemplate template = new NamedParameterJdbcTemplate(h2DataSource);

    template.update("SET REFERENTIAL_INTEGRITY FALSE", new HashMap<String, Object>());

    for (String tableName : tableNames) {
        template.update("DELETE FROM " + tableName, new HashMap<String, Object>());
    }

    template.update("SET REFERENTIAL_INTEGRITY TRUE", new HashMap<String, Object>());
}

From source file:com.netsteadfast.greenstep.sys.SysLoginLogSupport.java

public static void log(String userId) {
    if (StringUtils.isBlank(userId)) {
        log.warn("null userId");
        return;/*  ww w .  j av  a2s  .  co m*/
    }
    NamedParameterJdbcTemplate namedParameterJdbcTemplate = (NamedParameterJdbcTemplate) AppContext
            .getBean("namedParameterJdbcTemplate");
    Map<String, Object> paramMap = new HashMap<String, Object>();
    paramMap.put("oid", SimpleUtils.getUUIDStr());
    paramMap.put("user", userId);
    paramMap.put("cuserid", "SYS");
    paramMap.put("cdate", new Date());
    try {
        namedParameterJdbcTemplate.update(
                "insert into tb_sys_login_log(OID, USER, CUSERID, CDATE) values(:oid, :user, :cuserid, :cdate)",
                paramMap);
    } catch (Exception e) {
        e.printStackTrace();
        log.error(e.getMessage().toString());
    }
}

From source file:com.netsteadfast.greenstep.sys.SysEventLogSupport.java

public static void log(String userId, String sysId, String executeEventId, boolean permit) {
    if (StringUtils.isBlank(userId) || StringUtils.isBlank(sysId) || StringUtils.isBlank(executeEventId)) {
        log.warn("null userId=" + userId + ", sysId=" + sysId + ", executeEventId=" + executeEventId);
        return;//from  ww w.  ja  v  a  2  s  .  c om
    }
    if (executeEventId.indexOf(Constants._COMMON_LOAD_FORM_ACTION) > -1) {
        log.warn("Common load form no need event log : " + executeEventId + " , permit = " + permit);
        return;
    }
    NamedParameterJdbcTemplate namedParameterJdbcTemplate = (NamedParameterJdbcTemplate) AppContext
            .getBean("namedParameterJdbcTemplate");
    Map<String, Object> paramMap = new HashMap<String, Object>();
    paramMap.put("oid", SimpleUtils.getUUIDStr());
    paramMap.put("user", userId);
    paramMap.put("sysId", sysId);
    paramMap.put("executeEvent",
            (executeEventId.length() > 255 ? executeEventId.substring(0, 255) : executeEventId));
    paramMap.put("isPermit", (permit ? "Y" : "N"));
    paramMap.put("cuserid", "SYS");
    paramMap.put("cdate", new Date());
    try {
        namedParameterJdbcTemplate.update(
                "insert into tb_sys_event_log(OID, USER, SYS_ID, EXECUTE_EVENT, IS_PERMIT, CUSERID, CDATE) "
                        + "values(:oid, :user, :sysId, :executeEvent, :isPermit, :cuserid, :cdate)",
                paramMap);
    } catch (Exception e) {
        e.printStackTrace();
        log.error(e.getMessage().toString());
    }
}

From source file:org.openlmis.performancetesting.DBCleaner.java

private void run() {
    ApplicationContext ctx = new ClassPathXmlApplicationContext("applicationContext-performance.xml");
    NamedParameterJdbcTemplate template = (NamedParameterJdbcTemplate) ctx.getBean("template");
    template.update(truncateQuery, (Map<String, ?>) null);
}

From source file:com.flipkart.aesop.hbasedatalayer.upsert.HBaseUpsertDataLayer.java

@Override
protected ConsumerCallbackResult upsert(AbstractEvent event) {
    String upsertQuery = generateUpsertQuery(event);
    NamedParameterJdbcTemplate jdbcTemplate = jdbcTemplateMap.get(event.getNamespaceName());
    jdbcTemplate.update(upsertQuery, event.getFieldMapPair());
    return ConsumerCallbackResult.SUCCESS;
}

From source file:cherry.foundation.etl.ExtractorImplTest.java

private void cleanupData() {
    NamedParameterJdbcTemplate template = getTemplate();
    Map<String, String> paramMap = new HashMap<>();
    template.update("DELETE FROM etl_extr_ldr_test", paramMap);
}

From source file:com.flipkart.aesop.mysqldatalayer.delete.MySQLDeleteDataLayer.java

@Override
protected ConsumerCallbackResult delete(AbstractEvent event) {
    String deleteQuery = getDeleteQuery(event);
    NamedParameterJdbcTemplate jdbcTemplate = jdbcTemplateMap.get(event.getNamespaceName());
    Map<String, Object> nullValueColumnMapping = DataLayerHelper
            .generateColumnMappingWithNullValues(event.getFieldMapPair(), event.getPrimaryKeySet());
    jdbcTemplate.update(deleteQuery, nullValueColumnMapping);
    return ConsumerCallbackResult.SUCCESS;
}

From source file:org.smart.migrate.dao.impl.DefaultImportDao.java

@Override
public void deleteTargetDataByPrimaryKeys(TableSetting tableSetting, List<String> primaryKeys) {
    String sql = "DELETE FROM " + tableSetting.getTargetTable() + " WHERE " + tableSetting.getTargetPK()
            + " in (:ids)";
    NamedParameterJdbcTemplate namedParameterJdbcTemplate = new NamedParameterJdbcTemplate(targetJdbcTemplate);
    MapSqlParameterSource parameters = new MapSqlParameterSource();
    parameters.addValue("ids", primaryKeys);
    namedParameterJdbcTemplate.update(sql, parameters);
}

From source file:com.flipkart.aesop.hbasedatalayer.delete.HBaseDeleteDataLayer.java

@Override
protected ConsumerCallbackResult delete(AbstractEvent event) {
    String deleteQuery = generateDeleteQuery(event);
    NamedParameterJdbcTemplate jdbcTemplate = jdbcTemplateMap.get(event.getNamespaceName());
    Map<String, Object> nullValueColumnMapping = DataLayerHelper
            .generateColumnMappingWithNullValues(event.getFieldMapPair(), event.getPrimaryKeySet());
    jdbcTemplate.update(deleteQuery, nullValueColumnMapping);
    return ConsumerCallbackResult.SUCCESS;
}