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:com.rplt.studioMusik.studioMusik.StudioMusikDAO.java

@Override
public void deleteData(String pKodeStudio) {

    String sql = "DELETE FROM studio_musik WHERE kode_studio = ?";
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    jdbcTemplate.update(sql, pKodeStudio);
}

From source file:com.company.project.service.dao.UserDao.java

public void delete(String username) {
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    jdbcTemplate.update("delete from users where username = ?", username);
}

From source file:com.rplt.studioMusik.studioMusik.StudioMusikDAO.java

@Override
public void updateData(StudioMusik pStudioMusik) {

    String sql = "UPDATE studio_musik SET " + "nama_studio = ?, " + "tarif_per_jam = ?, " + "jam_buka = ?, "
            + "jam_tutup = ?" + "WHERE kode_studio = ?";
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

    jdbcTemplate.update(sql, new Object[] { pStudioMusik.getmNamaStudio(), pStudioMusik.getmTarifPerJam(),
            pStudioMusik.getmKodeStudio(), pStudioMusik.getmJamBuka(), pStudioMusik.getmJamTutup() });
}

From source file:com.dai.dao.PerfilDaoImpl.java

public void inserirPerfil(Perfil perfil) {
    JdbcTemplate template = new JdbcTemplate(dataSource);
    String sql = "INSERT INTO perfil " + "(designacaoPerfil) VALUES (?)";

    template.update(sql, new Object[] { perfil.getDesignacao() });
}

From source file:com.dai.dao.EscalaoDaoImpl.java

public void inserirEscalao(Escalao escalao) {
    JdbcTemplate template = new JdbcTemplate(dataSource);
    String sql = "INSERT INTO escalao " + "(designacaoEscalao) VALUES (?)";

    template.update(sql, new Object[] { escalao.getDesignacao() });
}

From source file:eionet.transfer.dao.MetadataServiceJdbc.java

@Override
public void deleteById(String id) {
    String query = "DELETE FROM uploads WHERE id = ?";
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    jdbcTemplate.update(query, id);
}

From source file:camelinaction.OrderDAO.java

public void insertOrder(InputOrder order, Registry registry) {
    DataSource ds = registry.lookupByNameAndType("myDataSource", DataSource.class);
    JdbcTemplate jdbc = new JdbcTemplate(ds);

    Object[] args = new Object[] { order.getCustomerId(), order.getRefNo(), order.getPartId(),
            order.getAmount() };/* w w  w.  ja  v a  2 s .c  o m*/
    jdbc.update("insert into riders_order (customer_id, ref_no, part_id, amount) values (?, ?, ?, ?)", args);
}

From source file:com.rplt.studioMusik.studioMusik.StudioMusikDAO.java

@Override
public void simpanData(StudioMusik pStudioMusik) {
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

    String sql = "INSERT INTO studio_musik VALUES(?, ?, ?, ?, ?)";

    jdbcTemplate.update(sql, new Object[] { pStudioMusik.getmKodeStudio(), pStudioMusik.getmNamaStudio(),
            pStudioMusik.getmTarifPerJam(), pStudioMusik.getmJamBuka(), pStudioMusik.getmJamTutup() });
}

From source file:org.cloudfoundry.identity.uaa.password.PasswordChangeEndpointTests.java

@After
public void clean() {
    JdbcTemplate jdbcTemplate = new JdbcTemplate(database);
    if (joel != null) {
        jdbcTemplate.update("delete from users where id=?", joel.getId());
    }//from w w w.j av a  2 s  .co m
    if (dale != null) {
        jdbcTemplate.update("delete from users where id=?", dale.getId());
    }
}

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

@Override
public void delete(int id) {
    String query = "delete from firme where id=?";
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

    jdbcTemplate.update(query, id);
}