Example usage for org.springframework.jdbc.core JdbcTemplate update

List of usage examples for org.springframework.jdbc.core JdbcTemplate update

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

Introduction

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

Prototype

@Override
    public int update(String sql, @Nullable Object... args) throws DataAccessException

Source Link

Usage

From source file:edu.jhuapl.openessence.web.util.MapQueryUtil.java

public int performUpdate(OeDataEntrySource mapLayerDataEntrySource, LinkedHashMap<String, Object> updateMap,
        Collection<String> placeholders) {
    JdbcTemplate pgdb = new JdbcTemplate(mapDataSource);
    StringBuilder sb = new StringBuilder();
    sb.append("insert into ").append(mapLayerDataEntrySource.getTableName());
    sb.append(" (");
    sb.append(StringUtils.join(updateMap.keySet(), ", "));
    sb.append(") values (");
    sb.append(StringUtils.join(placeholders, ", "));
    sb.append(")");
    String sql = sb.toString();// w  w  w  .ja  v a  2  s . c  om
    log.debug(sql);
    return pgdb.update(sql, updateMap.values().toArray());
}

From source file:net.sourceforge.subsonic.dao.schema.hsql.Schema35.java

private void createAvatar(JdbcTemplate template, String avatar) {
    if (template.queryForInt("select count(*) from system_avatar where name = ?",
            new Object[] { avatar }) == 0) {

        InputStream in = null;//  ww w. j a  v  a 2 s .c  om
        try {
            in = getClass().getResourceAsStream("/net/sourceforge/subsonic/dao/schema/" + avatar + ".png");
            byte[] imageData = IOUtils.toByteArray(in);
            template.update("insert into system_avatar values (null, ?, ?, ?, ?, ?, ?)",
                    new Object[] { avatar, new Date(), "image/png", 48, 48, imageData });
            LOG.info("Created avatar '" + avatar + "'.");
        } catch (IOException x) {
            LOG.error("Failed to create avatar '" + avatar + "'.", x);
        } finally {
            IOUtils.closeQuietly(in);
        }
    }
}

From source file:com.iucosoft.eavertizare.dao.impl.ClientsDaoImpl.java

@Override
public void update(Firma firma, Client client) {
    String query = "update " + firma.getTabelaClientiLocal() + " set"
            + " nume=?, prenume=?, nr_telefon=?, email=?, " + "data_expirare=?, trimis=? where id=?";
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    Object[] args = new Object[] { client.getNume(), client.getPrenume(), client.getNrTelefon(),
            client.getEmail(), new java.sql.Timestamp(client.getDateExpirare().getTime()), client.isTrimis(),
            client.getId() };/*from   www  .  j  a v a  2s.  com*/

    jdbcTemplate.update(query, args);
}

From source file:cn.edu.hfut.dmic.webcollector.example.souplang.nodes.SLSQL.java

@Override
public Object process(Object input, Context context) throws InputTypeErrorException {
    if (input == null) {
        return null;
    }//from   ww  w .j ava  2 s .  c o m
    if (sql == null || template == null) {
        return null;
    }

    JdbcTemplate jdbcTemplate = JDBCHelper.getJdbcTemplate(template);
    if (jdbcTemplate == null) {
        LOG.info("please create jdbctemplate");
        return null;
    }

    int paramsLength = paramarray.length;
    int updates;
    if (params != null) {
        String[] sqlParams = new String[paramsLength];
        for (int i = 0; i < paramsLength; i++) {
            sqlParams[i] = context.getString(paramarray[i]);
        }
        updates = jdbcTemplate.update(sql, sqlParams);

    } else {
        updates = jdbcTemplate.update(sql);
    }
    LOG.info(sql + params + "    result=" + updates);
    return null;
}

From source file:org.cloudfoundry.identity.uaa.scim.ScimUserEndpointsTests.java

@After
public void cleanUp() {
    JdbcTemplate jdbcTemplate = new JdbcTemplate(database);
    for (ScimUser user : createdUsers) {
        jdbcTemplate.update("delete from users where id=?", user.getId());
    }//ww w .ja v  a2  s . c  o m
    for (ScimGroup g : createdGroups) {
        jdbcTemplate.update("delete from groups where id=?", g.getId());
        jdbcTemplate.update("delete from group_membership where group_id=?", g.getId());
    }
}

From source file:com.osrdata.etltoolbox.fileloader.FileSpecification.java

/**
 * Deletes existing records from target targetTable with file ID. If source ID is not defined then deletes all
 * records from target targetTable./*from www .j  a  va2  s  .  c  o  m*/
 */
private void deleteExisting(Integer fileId) {
    JdbcTemplate template = new JdbcTemplate(targetDs);
    int count;
    StringBuilder sql = new StringBuilder();
    sql.append("delete from ").append(targetTable);
    if (sourceId != null) {
        sql.append(" where file_id = ?");
        count = template.update(sql.toString(), new Object[] { fileId });
    } else {
        count = template.update(sql.toString());
    }
    log.info("\tDeleted " + getCount(count) + " existing records from " + targetTable);
}

From source file:net.sourceforge.subsonic.dao.schema.hsql.Schema43.java

@Override
public void execute(JdbcTemplate template) {

    // version 16 was used for 4.3.beta1
    if (template.queryForInt("select count(*) from version where version = 16") == 0) {
        LOG.info("Updating database schema to version 16.");
        template.execute("insert into version values (16)");
    }//www  .j a v a 2s . c  o m

    if (template.queryForInt("select count(*) from version where version = 17") == 0) {
        LOG.info("Updating database schema to version 17.");
        template.execute("insert into version values (17)");

        for (String format : Arrays.asList("avi", "mpg", "mpeg", "mp4", "m4v", "mkv", "mov", "wmv", "ogv")) {
            template.update("delete from transcoding where source_format=? and target_format=?",
                    new Object[] { format, "flv" });
            template.execute("insert into transcoding values(null,'" + format + " > flv' ,'" + format
                    + "' ,'flv','ffmpeg -ss %o -i %s -async 1 -b %bk -s %wx%h -ar 44100 -ac 2 -v 0 -f flv -',null,null,true,true)");
            template.execute(
                    "insert into player_transcoding select p.id as player_id, t.id as transaction_id from player p, transcoding t where t.name = '"
                            + format + " > flv'");
        }
        LOG.info("Created video transcoding configuration.");
    }

    if (!columnExists(template, "email", "user")) {
        LOG.info("Database column 'user.email' not found.  Creating it.");
        template.execute("alter table user add email varchar");
        LOG.info("Database column 'user.email' was added successfully.");
    }

}

From source file:cn.com.sims.crawler.souplang.nodes.SLSQL.java

@Override
public Object process(Object input, Context context) throws InputTypeErrorException {
    if (input == null) {
        return null;
    }//www . ja  v a 2s  .c  o m
    if (sql == null || template == null) {
        return null;
    }

    JdbcTemplate jdbcTemplate = JDBCHelper.getJdbcTemplate(template);
    if (jdbcTemplate == null) {
        LOG.info("please create jdbctemplate");
        return null;
    }
    int paramsLength = paramarray.length;
    int updates;
    if (params != null) {
        String[] sqlParams = new String[paramsLength];
        for (int i = 0; i < paramsLength; i++) {
            sqlParams[i] = context.getString(paramarray[i]);
            System.out.println("context.getString(paramarray[i]) :" + context.getString(paramarray[i])
                    + " i?: " + paramarray[i]);
        }
        updates = jdbcTemplate.update(sql, sqlParams);

    } else {
        updates = jdbcTemplate.update(sql);
    }
    LOG.info(sql + params + "    result=" + updates);
    return null;
}

From source file:com.px100systems.data.plugin.persistence.jdbc.Storage.java

private void insertRecord(JdbcTemplate jdbc, RawRecord record) {
    try {/*  w  w w.java 2 s .com*/
        byte[] rawData = record.getSerializedEntity().getBytes("UTF-8");

        int count = 0;
        for (int offset = 0, length = rawData.length; offset < length; offset += blockSize) {
            byte[] data = new byte[(length - offset) > blockSize ? blockSize : (length - offset)];
            //noinspection ManualArrayCopy
            for (int i = 0; i < data.length; i++)
                data[i] = rawData[offset + i];

            jdbc.update("INSERT INTO " + table
                    + " (unit_name, generator_name, class_name, id, block_number, data_size, data) "
                    + "VALUES ('" + record.getUnitName() + "', '" + record.getIdGeneratorName() + "', '"
                    + record.getEntityClass().getName() + "', " + record.getId() + ", " + count + ", "
                    + data.length + ", ?)", new Object[] { data }); //, new int[]{java.sql.Types..BINARY});
            count++;
        }
    } catch (Exception e) {
        throw new RuntimeException(e);
    }
}

From source file:com.rplt.studioMusik.dataPersewaan.PersewaanStudioMusikDAO.java

@Override
public void simpanData(PersewaanStudioMusik pPersewaanStudioMusik) {
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    KeyHolder keyHolder = new GeneratedKeyHolder();
    //        String kode = getGeneratedKodeSewa();

    String sql = "insert into PERSEWAAN_STUDIO_MUSIK "
            + "values(?, ?, ?, ?, to_date(?, 'dd-MON-yyyy HH24:MI'), to_date(?, 'dd-MON-yyyy HH24:MI'), ?)";

    final String sqlmysql = "INSERT INTO `studiomusik`.`persewaan_studio_musik` "
            + "(`KODE_STUDIO`, `NAMA_PENYEWA`, `NOMOR_TELEPON`, `MULAI_SEWA`, `SELESAI_SEWA`, `BIAYA_PELUNASAN`) "
            + "VALUES (?, ?, ?, STR_TO_DATE(?, '%d-%b-%Y %k:%S'), " + "STR_TO_DATE(?, '%d-%b-%Y %k:%S'), ?)";

    System.out.println(sql);//from   w ww  .  j  a v a2  s.  co  m

    jdbcTemplate.update(new PreparedStatementCreator() {

        @Override
        public PreparedStatement createPreparedStatement(Connection cnctn) throws SQLException {
            PreparedStatement ps = cnctn.prepareStatement(sqlmysql, Statement.RETURN_GENERATED_KEYS);
            ps.setString(1, pPersewaanStudioMusik.getmKodeStudio());
            ps.setString(2, pPersewaanStudioMusik.getmNamaPenyewa());
            ps.setString(3, pPersewaanStudioMusik.getmNomorTeleponPenyewa());
            ps.setString(4, pPersewaanStudioMusik.getmMulaiSewa());
            ps.setString(5, pPersewaanStudioMusik.getmSelesaiSewa());
            ps.setInt(6, pPersewaanStudioMusik.getmBiayaPelunasan());
            return ps;
        }
    }, keyHolder);

    //        jdbcTemplate.update(sql,
    //                new Object[]{
    //                    kode,
    //                    pPersewaanStudioMusik.getmKodeStudio(),
    //                    pPersewaanStudioMusik.getmNamaPenyewa(),
    //                    pPersewaanStudioMusik.getmNomorTeleponPenyewa(),
    //                    pPersewaanStudioMusik.getmMulaiSewa(),
    //                    pPersewaanStudioMusik.getmSelesaiSewa(),
    //                    pPersewaanStudioMusik.getmBiayaPelunasan()
    //                });
    System.out.println(pPersewaanStudioMusik.getmMulaiSewa() + "sd" + pPersewaanStudioMusik.getmSelesaiSewa());

    pPersewaanStudioMusik.setmKodeSewa(keyHolder.getKey().toString());

    System.out.println("KEYHOLDER : " + pPersewaanStudioMusik.getmKodeSewa());

    System.out.println(pPersewaanStudioMusik.getmKodeSewa());

}