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

Introduction

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

Prototype

@Override
    public <T> List<T> query(PreparedStatementCreator psc, RowMapper<T> rowMapper) throws DataAccessException

Source Link

Usage

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

@Override
public List<EquipaAdversaria> listaEA() {

    List<EquipaAdversaria> eaList = new ArrayList();

    String sql = "select * from equipaAdversaria";

    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    eaList = jdbcTemplate.query(sql, new EquipaAdversariaRowMapper());
    return eaList;
}

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

@Override
public List<EquipaAdversaria> listaEAporEscalao(int idEscalao) {

    List<EquipaAdversaria> eaList = new ArrayList();

    String sql = "select * from equipaAdversaria where escalao_idEscalao_ea = " + idEscalao;

    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    eaList = jdbcTemplate.query(sql, new EquipaAdversariaRowMapper());
    return eaList;

}

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

@Override
public User getUser(String id) {
    List<User> userList = new ArrayList<User>();
    String sql = "select * from user where user_id= " + id;
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    userList = jdbcTemplate.query(sql, new UserRowMapper());
    return userList.get(0);
}

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

@Override
public List<JogadorEquipaAdversaria> listaJEA(int idEA) {
    List<JogadorEquipaAdversaria> jeaList = new ArrayList();

    String sql = "select * from jogadorEquipaAdversaria where equipaAdversaria_idEquipaAdversaria= " + idEA;

    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    jeaList = jdbcTemplate.query(sql, new JogadorEquipaAdversariaRowMapper());
    return jeaList;
}

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

@Override
public List<User> getUserList() {
    List userList = new ArrayList();

    String sql = "select * from user";

    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    userList = jdbcTemplate.query(sql, new UserRowMapper());
    return userList;
}

From source file:com.ignite.dao.AccountDao.java

public List<Account> getAccountsForClient(Client client) {
    logger.info("Getting clients");

    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    List<Account> products = jdbcTemplate.query(
            "select id, client, balance from account where client=" + "'" + client.getLogin() + "'",
            new AccountMapper());
    return products;
}

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

public List<SelecaoTreino> listaST(int idTreino) {

    List<SelecaoTreino> stList = new ArrayList();

    String sql = "select * from selecaoTreino where treino_idtreino=" + idTreino;

    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    stList = jdbcTemplate.query(sql, new SelecaoTreinoRowMapper());
    return stList;
}

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

public List<SelecaoTreino> listaSTparaPresencas(int idTreino) {

    List<SelecaoTreino> stList = new ArrayList();
    //String sql = "select t1.idUtilizador, t1.nomeUtilizador, t2.treino_idtreino, t2.presenca from utilizador t1 inner join selecaotreino t2 on t1.idutilizador = t2.utilizador_idutilizador_st where treino_idtreino = " + idTreino + " and presenca = null";
    String sql = "select * from selecaotreino where presenca is null and treino_idTreino = " + idTreino;

    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    stList = jdbcTemplate.query(sql, new SelecaoTreinoRowMapper());
    return stList;
}

From source file:org.jtalks.common.migrations.V6__Update_user_passwordsTest.java

@Test
public void testMigrate() throws Exception {

    MessageDigestPasswordEncoder encoder = mock(MessageDigestPasswordEncoder.class);
    when(encoder.encodePassword(anyString(), anyString())).thenReturn(ENCODED_PASSWORD);

    SaltGenerator saltGenerator = mock(SaltGenerator.class);
    when(saltGenerator.generate()).thenReturn(SALT);

    ApplicationContext context = mock(ApplicationContext.class);
    when(context.getBean(MessageDigestPasswordEncoder.class)).thenReturn(encoder);
    when(context.getBean(SaltGenerator.class)).thenReturn(saltGenerator);

    HashMap<String, String> user = new HashMap<String, String>();
    user.put("id", ID);
    user.put("password", PASSWORD);

    List<HashMap<String, String>> users = new ArrayList<HashMap<String, String>>();
    users.add(user);/*from   www  .jav a 2 s  .c  o m*/

    JdbcTemplate jdbc = mock(JdbcTemplate.class);
    when(jdbc.query(anyString(), any(RowMapper.class))).thenReturn(users);

    MIGRATION.setContext(context);

    MIGRATION.migrate(jdbc);

    verify(saltGenerator).generate();
    verify(encoder).encodePassword(PASSWORD, SALT);
    verify(jdbc).update(anyString(), eq(ENCODED_PASSWORD), eq(SALT), eq(Integer.parseInt(ID)));
}

From source file:com.ignite.dao.ClientDao.java

@PreAuthorize("hasRole('ROLE_TELLER')")
public List<Client> getClients() {
    logger.info("Getting clients");

    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    List<Client> products = jdbcTemplate.query("select firstname, lastname, username, pid from users",
            new ClientMapper());
    return products;
}