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(PreparedStatementCreator psc) throws DataAccessException

Source Link

Usage

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

public void dropTable() {
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    jdbcTemplate.update("drop table messages");
}

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

@Override
public void apagaEA(int idEA) {

    String sql = "delete from equipaAdversaria where idEquipaAdversaria =" + idEA;
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    jdbcTemplate.update(sql);

}

From source file:com.recber.dao.UserDaoImpl.java

@Override
public void deleteData(String id) {
    String sql = "delete from user where user_id=" + id;
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    jdbcTemplate.update(sql);

}

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

@Override
public void apagaJEA(int idJEA) {

    String sql = "delete from jogadorEquipaAdversaria where idJogadorEquipaAdversaria =" + idJEA;
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    jdbcTemplate.update(sql);

}

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

@Override
public void apagaST(int idUtilizador, int idTreino) {

    String sql = "delete from selecaoTreino where utilizador_idUtilizador_st =" + idUtilizador
            + "and treino_idtreino = " + idTreino;
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    jdbcTemplate.update(sql);

}

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

@Override
public void jogadorPresente(int idUtilizador, int idTreino) {

    String sql = "update selecaoTreino set presenca = 1  where utilizador_idUtilizador_st =" + idUtilizador
            + " and treino_idtreino = " + idTreino;
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    jdbcTemplate.update(sql);

}

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

@Override
public void jogadorFaltou(int idUtilizador, int idTreino) {

    String sql = "update selecaoTreino set presenca = 0 where utilizador_idUtilizador_st =" + idUtilizador
            + " and treino_idtreino = " + idTreino;
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    jdbcTemplate.update(sql);

}

From source file:org.activiti.spring.test.transaction.UserBean.java

@Transactional
public void completeTask(String taskId) {

    // First insert a record in the MY_TABLE table
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    int nrOfRows = jdbcTemplate.update("insert into MY_TABLE values ('test');");
    if (nrOfRows != 1) {
        throw new RuntimeException("Insert into MY_TABLE failed");
    }/*from w ww.  j a  v  a2s  .co  m*/

    taskService.complete(taskId);
}

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

@Override
public void apagarTreino(Integer idTreino) {
    String sql = "delete from treino where idTreino=" + idTreino;
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    jdbcTemplate.update(sql);

}

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

public void dropTable() {
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    jdbcTemplate.update("drop table user_roles");
    jdbcTemplate.update("drop table users");
    jdbcTemplate.update("drop table persistent_logins");
}