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

List of usage examples for org.springframework.jdbc.core JdbcTemplate query

  1. HOME
  2. Java
  3. org.springframework
  4. org.springframework.jdbc.core.*
  5. JdbcTemplate
  6. 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.ignite.dao.ClientDao.java

@PreAuthorize("hasRole('ROLE_TELLER')")
public Client getClient(String username) {
    logger.info("Getting client");

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

From source file:org.awesomeagile.dao.DatabaseIntegrationTest.java

@Test
public void testUsers() throws Exception {
    JdbcTemplate jdbcTemplate = testDatabase.jdbcTemplate(DATABASE_NAME);
    List<User> users = jdbcTemplate.query("select * from teams.user", new BeanPropertyRowMapper<>(User.class));
    assertEquals(2, users.size());//w w  w .  jav a  2 s  . c om
    assertThat(users, hasItem(new UserWithName("stan")));
}

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

public Treino getTreino(Integer idTreino) {
    List<Treino> treinoList = new ArrayList();

    String sql = "select * from treino where idTreino = " + idTreino;

    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    treinoList = jdbcTemplate.query(sql, new TreinoRowMapper());
    return treinoList.get(0);
}

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

@Override
public List<Treino> listarTreinos() {
    List<Treino> treinoList = new ArrayList();

    String sql = "select * from treino";

    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    treinoList = jdbcTemplate.query(sql, new TreinoRowMapper());
    return treinoList;
}

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

@Override
public List<Treino> listarTreinosEscalao(int idEscalao) {
    List<Treino> treinoList = new ArrayList();

    String sql = "select * from treino where escalao_idEscalao_t = " + idEscalao;

    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    treinoList = jdbcTemplate.query(sql, new TreinoRowMapper());
    return treinoList;
}

From source file:com.rplt.studioMusik.studioMusik.StudioMusikDAO.java

@Override
public List<StudioMusik> getDataList() {
    List studioList = new ArrayList();

    String sql = "SELECT * FROM studio_musik";

    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    studioList = jdbcTemplate.query(sql, new StudioMusikRowMapper());
    return studioList;
}

From source file:edu.wisc.my.stats.query.support.JdbcExtraParameterValuesProvider.java

/**
 * @see edu.wisc.my.stats.query.ExtraParameterValuesProvider#getPossibleValues(edu.wisc.my.stats.domain.ExtraParameter)
 *//*from   w ww . j a  v a2s  .  co  m*/
@SuppressWarnings("unchecked")
public List<String> getPossibleValues(ExtraParameter extraParameter) {
    final String parameterSql = this.parameterSqlMap.get(extraParameter);

    if (parameterSql != null) {
        if (this.logger.isDebugEnabled()) {
            this.logger.debug("Executing '" + parameterSql + "' to get values List for parameter '"
                    + extraParameter + "'");
        }

        final JdbcTemplate jdbcTemplate = this.getJdbcTemplate();
        final List<String> values = jdbcTemplate.query(parameterSql, SIMPLE_ROW_MAPPER);
        return values;
    } else {
        this.logger.warn("Parameter '" + extraParameter + "' has not associated SQL");

        return Collections.emptyList();
    }
}

From source file:org.cloudfoundry.identity.uaa.db.postgresql.V1_5_4__NormalizeTableAndColumnNames.java

@Override
public void migrate(JdbcTemplate jdbcTemplate) throws Exception {
    logger.info("[V1_5_4] Running SQL: " + colQuery);
    List<ColumnInfo> columns = jdbcTemplate.query(colQuery, new ColumnMapper());
    for (ColumnInfo column : columns) {
        if (processColumn(column)) {
            String sql = "ALTER TABLE " + column.tableName + " RENAME \"" + column.columnName + "\" TO \""
                    + column.columnName.toLowerCase() + "\"";
            logger.info("Renaming column: [" + sql + "]");
            jdbcTemplate.execute(sql);//w ww.ja  va 2  s . c  om
        }
    }
}

From source file:com.rplt.studioMusik.pegawai.PegawaiDAO.java

@Override
public List<Pegawai> getDataList() {
    List<Pegawai> pegawaiList = new ArrayList<Pegawai>();

    String sql = "SELECT * FROM pegawai_studio_musik";

    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    pegawaiList = jdbcTemplate.query(sql, new PegawaiRowMapper());
    return pegawaiList;
}

From source file:com.arcane.dao.Impl.UserDaoImpl.java

@Override
public List<User> list() {
    //return all users
    LOG.info("Returning all the users");
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    String sql = "SELECT * from user";
    List<User> listUser = jdbcTemplate.query(sql, new RowMapper<User>() {

        @Override/*  w  w  w.  j  av a 2s .  c  om*/
        public User mapRow(ResultSet rs, int rowNumber) throws SQLException {
            User user = new User();
            user.setUserid(rs.getInt("userid"));
            user.setUsername(rs.getString("username"));
            user.setPassword(rs.getString("password"));
            return user;
        }

    });
    return listUser;
}