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.dai.dao.JogadorEquipaAdversariaDaoImpl.java

@Override
public void adicionaJEA(JogadorEquipaAdversaria jea) {

    String sql = "INSERT INTO jogadorEquipaAdversaria "
            + "( nomeJogador, posicaoJogador, equipaAdversaria_idEquipaAdversaria) VALUES (?,?,?)";

    JdbcTemplate template = new JdbcTemplate(dataSource);

    template.update(sql, new Object[] { jea.getNome(), jea.getPosicao(), jea.getIdEquipaAdversaria() });

}

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

@Override
public void alteraPosicaoJEA(int idJEA, String novaPosicao) {
    String sql = "UPDATE jogadorEquipaAdversaria set posicaoJogador = ? where idJogadorEquipaAdversaria = "
            + idJEA;/* ww  w . j  av  a  2  s  .  co  m*/
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

    jdbcTemplate.update(sql, new Object[] { novaPosicao });
}

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

@Override
public void alteraClubeJEA(int idJEA, int novoidEA) {
    String sql = "UPDATE jogadorEquipaAdversaria set equipaAdversaria_idEquipaAdversaria = ? where idJogadorEquipaAdversaria = "
            + idJEA;/*from w w  w  .j  a v a 2s .c  o  m*/
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

    jdbcTemplate.update(sql, new Object[] { novoidEA });

}

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

@Override
public void updateData(User user) {

    String sql = "UPDATE user set first_name = ?,last_name = ?, face = ?, city = ? where user_id = ?";
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

    jdbcTemplate.update(sql, new Object[] { user.getFirstName(), user.getLastName(), user.getFace(),
            user.getCity(), user.getUserId() });

}

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

@Override
public void insertData(User user) {

    String sql = "INSERT INTO user " + "(first_name,last_name, face, city) VALUES (?, ?, ?,?)";

    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

    jdbcTemplate.update(sql,
            new Object[] { user.getFirstName(), user.getLastName(), user.getFace(), user.getCity() });

}

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

@Override
public void adicionaST(SelecaoTreino st) {

    String sql = "INSERT INTO selecaoTreino "
            + "( utilizador_idutilizador_st, treino_idtreino, nomeUtilizador_t) VALUES (?, ?, ?)";

    JdbcTemplate template = new JdbcTemplate(dataSource);

    template.update(sql, new Object[] { st.getIdUtilizador(), st.getIdTreino(), st.getNome() });

}

From source file:net.sourceforge.subsonic.backend.dao.schema.Schema10.java

private void createRedirection(JdbcTemplate template, String redirectFrom, String redirectTo) {
    template.update(
            "insert into redirection values (null, 'sindre@activeobjects.no', '-1', ?, ?, false, null, null, null)",
            new Object[] { redirectFrom, redirectTo });
    LOG.info("Creating redirection from " + redirectFrom + " to " + redirectTo);
}

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

@Override
public void inserirTreino(Treino treino) {

    String sql = "INSERT INTO treino "
            + "( duracaoTreino, localTreino, dataTreino, tipoTreino, horaTreino, escalao_idEscalao_t) VALUES (?, ?, ?, ?,?, ?)";

    JdbcTemplate template = new JdbcTemplate(dataSource);

    template.update(sql, new Object[] { treino.getDuracaoTreino(), treino.getLocalTreino(),
            treino.getDataTreino(), treino.getTipoTreino(), treino.getHoraTreino(), treino.getIdEscalao() });

}

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

@Override
public void delete(int idConfiguratie) {

    String query = "delete from configuratii_db where id=?";
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

    jdbcTemplate.update(query, idConfiguratie);

}

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

@Override
public void updateTreino(Treino treino) {

    String sql = "UPDATE treino set duracaoTreino = ?, localTreino = ?, dataTreino = ?, tipoTreino = ?, horaTreino = ?, escalao_idEscalao_t = ?"
            + " where idTreino = ?";
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

    jdbcTemplate.update(sql,
            new Object[] { treino.getDuracaoTreino(), treino.getLocalTreino(), treino.getDataTreino(),
                    treino.getTipoTreino(), treino.getHoraTreino(), treino.getIdEscalao(),
                    treino.getIdTreino() });

}