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.plexobject.testplayer.dao.hibernate.MethodDaoHibernate.java

public static void createTable() {
    try {// w w  w .  ja  va  2  s.com
        JdbcTemplate jdbc = new JdbcTemplate(getDataSource());
        jdbc.update(CREATE, new Object[0]);
    } catch (Exception e) {
    }
}

From source file:com.taobao.tddl.sample.base.BaseSampleCase.java

protected static void clearData(JdbcTemplate tddlJTX, String sql, Object[] args) {
    if (args == null) {
        args = new Object[] {};
    }// w w  w  . j a va2 s.co  m
    // 
    try {
        tddlJTX.update(sql, args);
    } catch (Exception e) {
        tddlJTX.update(sql, args);
    }
}

From source file:com.taobao.tddl.sample.base.BaseSampleCase.java

protected static void prepareData(JdbcTemplate tddlJTX, String sql, Object[] args) {
    if (args == null) {
        args = new Object[] {};
    }/* w  w  w .  j  a  v  a 2  s. c  o m*/

    // 
    try {
        int rs = tddlJTX.update(sql, args);
        if (rs <= 0) {
            tddlJTX.update(sql, args);
        }
    } catch (Exception e) {
        int rs = tddlJTX.update(sql, args);
        if (rs <= 0) {
            tddlJTX.update(sql, args);
        }
    }
}

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

@Override
public void novoJogo(Jogo jogo) {

    String sql = "INSERT INTO jogo "
            + "( localJogo, dataJogo,resultadoJogo, horaJogo,competicao) VALUES (?, ?, ?, ?, ?)";

    JdbcTemplate template = new JdbcTemplate(dataSource);

    template.update(sql, new Object[] { jogo.getLocal(), jogo.getData(), jogo.getResultado(), jogo.getHora(),
            jogo.getCompeticao() });/*from   ww  w  . j a  va  2s  .  c  o m*/

}

From source file:com.faisal.jdbc.dao.CustomerDAOImpl.java

@Override
@Transactional/* ww w  .ja va 2  s  . co  m*/
public void create(Customer customer) {

    String queryCustomer = "insert into Customer (id, name) values (?,?)";
    String queryAddress = "insert into Address (id, address,country) values (?,?,?)";

    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

    jdbcTemplate.update(queryCustomer, new Object[] { customer.getId(), customer.getName() });
    System.out.println("Inserted into Customer Table Successfully");
    jdbcTemplate.update(queryAddress, new Object[] { customer.getId(), customer.getAddress().getAddress(),
            customer.getAddress().getCountry() });
    System.out.println("Inserted into Address Table Successfully");

}

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

@Override
public void adicionaSL(SelecaoJogo sl) {

    String sql = "INSERT INTO selecaoJogo " + "( utilizador_idutilizador, jogo_idjogo) VALUES (?, ?)";

    JdbcTemplate template = new JdbcTemplate(dataSource);

    template.update(sql, new Object[] { sl.getIdUtilizador(), sl.getIdJogo() });

}

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

@Override
public void adicionaCompeticao(Competicao competicao) {

    String sql = "INSERT INTO competicao " + "( designacaoCompeticao, escalao_idEscalao_c) VALUES (?,?)";

    JdbcTemplate template = new JdbcTemplate(dataSource);

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

}

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

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

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

@Override
public void adicionaEA(EquipaAdversaria ea) {

    String sql = "INSERT INTO equipaAdversaria " + "( nomeEquipaAdversaria, escalao_idEscalao_ea) VALUES (?,?)";

    JdbcTemplate template = new JdbcTemplate(dataSource);

    template.update(sql, new Object[] { ea.getNome(), ea.getidEscalao() });

}

From source file:com.beezas.dao.EventDaoImpl.java

public void insertData(User user) {

    String sql = "insert into events"
            + "(title,paidevent,privateevent,webinar,weburl,sub_category_id,description) VALUES (?,?,?,?,?,?,?)";

    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

    jdbcTemplate.update(sql, new Object[] { user.getTitle(), user.getPaidEvent(), user.getPrivateEvent(),
            user.getWebinar(), user.getWeburl(), user.getCategoryId(), user.getEventDescription(),
            //user.getWebAttend(),

    });//from   ww w . j a v  a2  s.c om

    System.out.println("get category id" + user.getSubCategoryId());

}