Example usage for org.springframework.jdbc.core JdbcTemplate 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:com.iucosoft.eavertizare.dao.impl.ConfiguratiiDaoImpl.java

@Override
public void save(Configuratii config) {

    String query = "insert into configuratii_db " + "(id, driver, url_db, username, password, tabela_clienti)"
            + " values (?, ?, ?, ?, ?, ?)";

    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

    Object[] args = new Object[] { null, config.getDriver(), config.getUrlDb(), config.getUsername(),
            config.getPassword(), config.getTabelaClienti() };

    jdbcTemplate.update(query, args);

}

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

@Override
public void update(Configuratii config) {

    String query = "update configuratii_db set driver=?, url_db=?, username=?, "
            + "password=?, tabela_clienti=? where id=?";
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    Object[] args = new Object[] { config.getDriver(), config.getUrlDb(), config.getUsername(),
            config.getPassword(), config.getTabelaClienti(), config.getId() };

    jdbcTemplate.update(query, args);

}

From source file:com.taobao.tddl.common.sync.RowBasedReplicationExecutor.java

/**
 * delete ... where WW=? and UU=? and id in(...)
 * update set XX=?, YY=? where WW=? and UU=? and id in(...)
 *///from w w w . j  av  a2  s.c o  m
public static <T> void updateIn(JdbcTemplate template, String sql, List<T> ids, int onceSize,
        Object... externArgs) {
    int index = 0;
    while (index + onceSize <= ids.size()) {
        Object[] param = new Object[externArgs.length + onceSize];
        int i = 0;
        for (; i < externArgs.length; i++) {
            param[i] = externArgs[i];
        }
        for (int j = 0; j < onceSize; j++) {
            param[i++] = ids.get(index++);
        }
        template.update(sql, param);
    }
    if (index == ids.size()) {
        return;
    }
    Object[] param = new Object[onceSize];
    int i = 0;
    for (; i < externArgs.length; i++) {
        param[i] = externArgs[i];
    }
    for (; i < onceSize && index < ids.size(); i++) {
        param[i] = ids.get(index++);
    }
    for (; i < onceSize; i++) {
        param[i] = ids.get(0);
    }
    template.update(sql, param);
}

From source file:db.postgres.V2_0_1__InitializeIdentityZones.java

private Long createDefaultAuthzZone(final JdbcTemplate jdbcTemplate) {
    final String insertZoneSql = "INSERT INTO authorization_zone (name, description, subdomain) "
            + "VALUES (?,?,?)";
    KeyHolder holder = new GeneratedKeyHolder();

    jdbcTemplate.update(new PreparedStatementCreator() {

        @Override/*from  w ww .  ja v  a2  s.  com*/
        public PreparedStatement createPreparedStatement(final Connection connection) throws SQLException {
            PreparedStatement ps = connection.prepareStatement(insertZoneSql, new String[] { "id" });
            ps.setString(1, "apm-migrated");
            ps.setString(2, "APM Migrated Zone from mvp1");
            ps.setString(3, "apm-migrated");
            return ps;
        }
    }, holder);

    Long acsAuthorizationZoneId = holder.getKey().longValue();
    return acsAuthorizationZoneId;
}

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

private void updateAuditFile(Integer fileId) {
    JdbcTemplate template = new JdbcTemplate(auditDs);
    int result = template.update("update audit_file set processed_flag = ? where file_id = ?",
            new Object[] { "N", fileId });
    log.debug("\tUpdate audit_file returned " + result);
}

From source file:com.rplt.studioMusik.member.MemberDAO.java

@Override
public void simpanData(Member pT) {
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    String kode = getGeneratedKodeMember();
    String sql = "INSERT INTO member_studio_musik VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";

    sql = "INSERT INTO `studiomusik`.`member_studio_musik` VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";

    jdbcTemplate.update(sql,
            new Object[] { kode, pT.getmUsernameMember().toUpperCase(), pT.getmPaswordMember(),
                    pT.getmNamaMember().toUpperCase(), pT.getmTempatLahirMember().toUpperCase(),
                    pT.getmTempatTanggalLahir().toUpperCase(), pT.getmAlamatMember(), pT.getmEmailMember(),
                    pT.getmNomorTelepon(), pT.getmSaldoMember(), });

    pT.setmKodeMember(kode);//  w  w w . ja va2s .c o  m
}

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

@Override
public void save(Firma firma) {
    String query = "INSERT INTO firme "
            + "(id, nume_firma, adresa, descriere, tabela_clienti, mesaj_clienti, id_configuratie)"
            + " VALUES (?, ?, ?, ?, ?, ?, ?)";

    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

    Object[] args = new Object[] { null, firma.getNumeFirma(), firma.getAdresaFirma(),
            firma.getDescriereFirma(), firma.getNumeFirma() + "_clienti", firma.getMesajPentruClienti(),
            firma.getConfiguratii().getId() };

    jdbcTemplate.update(query, args);
}

From source file:net.sourceforge.subsonic.dao.schema.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;//from  w  ww .  j a  v  a 2  s.c  o m
        try {
            in = getClass().getResourceAsStream(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.FirmaDaoImpl.java

@Override
public void update(Firma firma) {

    String query = "update firme set nume_firma=?, adresa=?, descriere=?, "
            + "tabela_clienti=?, mesaj_clienti=?, id_configuratie=? where id=?";
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    Object[] args = new Object[] { firma.getNumeFirma(), firma.getAdresaFirma(), firma.getDescriereFirma(),
            firma.getNumeFirma() + "_clienti", firma.getMesajPentruClienti(), firma.getConfiguratii().getId(),
            firma.getId() };//  w w w.j  av  a2 s .co  m

    jdbcTemplate.update(query, args);
}

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

@Override
public void save(Firma firma, Client client) {
    String query = "INSERT INTO " + firma.getTabelaClientiLocal() + " VALUES(?, ?, ?, ?, ?, ?, ?, ?)";

    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

    Object[] args = new Object[] { client.getId(), client.getNume(), client.getPrenume(), client.getNrTelefon(),
            client.getEmail(), new java.sql.Timestamp(client.getDateExpirare().getTime()), firma.getId(), 0 };

    jdbcTemplate.update(query, args);
}