Example usage for org.springframework.jdbc.core JdbcTemplate JdbcTemplate

Introduction

In this page you can find the example usage for org.springframework.jdbc.core JdbcTemplate JdbcTemplate.

Prototype

public JdbcTemplate(DataSource dataSource)

Source Link

Document

Construct a new JdbcTemplate, given a DataSource to obtain connections from.

Usage

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:org.brickhouse.impl.DatabaseImpl.java

public DatabaseImpl(BasicDataSource ds) {
    this.ds = ds;
    jt = new JdbcTemplate(ds);
}

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

@Override
@Transactional//from  www.  j  a  v  a 2 s  .  c  om
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.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:com.webproject.checkpoint.DataRepository.java

@PostConstruct
public void postConstruct() {
    dbt = new JdbcTemplate(dataSource);
}

From source file:lydichris.smashbracket.persistence.EntrantPersistence.java

@Autowired
@Qualifier("dataSource")
public void setDataSource(DataSource dataSource) {
    this.jdbcTemplateObject = new JdbcTemplate(dataSource);
}

From source file:com.softserveinc.internetbanking.dao.jdbctemplate.AccountJDBCTemplate.java

@Override
public void setDataSource(DataSource ds) {
    this.dataSource = ds;
    this.jdbcTemplateObject = new JdbcTemplate(dataSource);
}

From source file:org.smart.migrate.setting.DataSourceTest.java

@Test
public void testDataSource() {
    DBSetting dbs = new DBSetting(DBType.MySQL, "localhost", "3306", "smartData", "root", null);
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(dbs.getdBType().getDriver());
    dataSource.setUrl(dbs.getConnectUrl());
    dataSource.setUsername(dbs.getUsername());
    dataSource.setPassword(dbs.getPassword());
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    List<Map<String, Object>> dataList = jdbcTemplate.queryForList("select * from gen_fawen");
    for (Map<String, Object> map : dataList) {
        for (Map.Entry<String, Object> entry : map.entrySet()) {
            String string = entry.getKey();
            Object object = entry.getValue();
            System.out.println(string + "," + object);
        }/*from  ww w  . j  a v a 2  s .  co m*/
    }

}

From source file:com.javacodegags.waterflooding.model.CaptionImplemented.java

public CaptionImplemented(DataSource dataSource) {
    jdbcTemplate = new JdbcTemplate(dataSource);
}

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() });

}