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

List of usage examples for org.springframework.jdbc.core BeanPropertyRowMapper BeanPropertyRowMapper

  1. HOME
  2. Java
  3. org.springframework
  4. org.springframework.jdbc.core.*
  5. BeanPropertyRowMapper
  6. BeanPropertyRowMapper

Introduction

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

Prototype

public BeanPropertyRowMapper(Class<T> mappedClass)

Source Link

Document

Create a new BeanPropertyRowMapper , accepting unpopulated properties in the target bean.

Usage

From source file:com.sirti.microservice.hbase.dao.HKpiDaoImpl.java

@Override
public List<HKpi> findFilterHKpi(String filter) {
    String sql = "SELECT * FROM " + hKpiTable + " WHERE " + filter;
    List<HKpi> alarms = this.jdbcTemplate.query(sql, new BeanPropertyRowMapper<HKpi>(HKpi.class));
    return alarms;
}

From source file:nbadb.DAO.PlayerJDBCTemplate.java

public List<PlayerDAO> findPlayerBoxscoresForGame(int gameid) {
    String SQL = "SELECT * FROM vyy1 WHERE gameID=00" + gameid + "";
    List<PlayerDAO> players = template.query(SQL, new BeanPropertyRowMapper(PlayerBoxScore.class));
    return players;
}

From source file:org.easybatch.jdbc.spring.SpringJdbcRecordMapper.java

@Override
@SuppressWarnings(value = "unchecked")
public T mapRecord(Record record) throws Exception {
    ResultSet resultSet = (ResultSet) record.getPayload();
    BeanPropertyRowMapper beanPropertyRowMapper = new BeanPropertyRowMapper(type);
    return (T) beanPropertyRowMapper.mapRow(resultSet, record.getHeader().getNumber().intValue());
}

From source file:net.juniper.titan.model.PrDaoImplementation.java

@Override
public ProblemReport findPrById(int prId) {
    ProblemReport pr = null;/*w  ww.j a v a 2 s .c o  m*/
    String query = "SELECT ID, PRNUM AS pr_id, PR_DESCRIPTION AS description, PR_CONFIDENTIAL AS confidential,"
            + "PR_SYNOPSIS AS synopsis, PR_PLATFORM AS platform, PR_PRODUCT AS product, PR_CLASS AS prClass,"
            + "PR_CATEGORY AS category, PR_FUNCTIONAL_AREA AS functionalArea, TO_DATE(PR_LAST_MODIFIED,'YYYY-MM-DD') AS lastModified,"
            + "PR_PROBLEM_LEVEL AS problemLevel, PR_KEYWORDS AS keywords, PR_FIX AS fix, PR_WORKAROUND AS workaround,"
            + "PR_SUBMITTER_ID AS submitterId, PR_JTAC_CASE_ID AS jtacCaseId, PR_EXTERNAL_ID AS externalId,"
            + "PR_LEGACY_CUSTOMER AS legacyCustomer, PR_ENVIRONMENT AS environment, PR_RELEASE_NOTE AS releaseNote,"
            + "PR_EXTERNAL_DESCRIPTION AS externalDescription, PR_EXTERNAL_TITLE AS externalTitle, PR_SUPPORT_NOTES AS supportNotes,"
            + "PR_RESOLVED_IN AS resolvedIn, PR_DEV_OWNER_BG_BU AS devOwnerBgBu, PR_SUBMITTER_BG_BU AS submitterBgBu, PR_STATE AS state,"
            + "TO_DATE(PR_ARRIVAL_DATE,'YYYY-MM-DD') AS arrivalDate FROM PR_GSA_VIEW WHERE ID=?";

    Object[] inputs = new Object[] { prId };
    pr = (ProblemReport) getJdbcTemplate().queryForObject(query, inputs,
            new BeanPropertyRowMapper(ProblemReport.class));
    return pr;
}

From source file:org.smigo.species.varieties.JdbcVarietyDao.java

@Override
public Collection<Variety> getVarietiesByUser(Integer userId) {
    final String select = SELECT + " WHERE USER_ID = ?";
    return jdbcTemplate.query(select, new BeanPropertyRowMapper<>(Variety.class), userId);
}

From source file:net.noday.cat.dao.UserDao.java

public User findUserByLoginName(String email) {
    String sql = "select * from user u where u.email=? limit 1";
    User u = jdbcTemplate.queryForObject(sql, new BeanPropertyRowMapper<User>(User.class), email);
    return u;//from w w  w  .j a  v  a2 s . c o  m
}

From source file:konditer.client.dao.ContactTypeDao.java

@Override
public ContactType getContactTypeByName(String contactTypeName) {
    String SQL_QUERY = "SELECT CONTACT_TYPE_ID, CONTACT_TYPE_NAME, TIMESTAMP " + "FROM contact_types "
            + "WHERE CONTACT_TYPE_NAME = ? ";

    ContactType contType = (ContactType) jdbcTemplate.queryForObject(SQL_QUERY,
            new Object[] { contactTypeName }, new BeanPropertyRowMapper(ContactType.class));
    return contType;
}

From source file:com.sirti.microservice.hbase.dao.UnicoStoricoDaoImpl.java

@Override
public List<UnicoStorico> findFilterUnicoStorico(String filter) {
    String sql = "SELECT * FROM " + hKpiTable + " WHERE " + filter;
    List<UnicoStorico> alarms = this.jdbcTemplate.query(sql,
            new BeanPropertyRowMapper<UnicoStorico>(UnicoStorico.class));
    return alarms;
}

From source file:org.jasig.cas.adaptors.jdbc.QueryDatabaseAuthenticationHandler.java

protected final boolean authenticateUsernamePasswordInternal(final UsernamePasswordCredentials credentials)
        throws AuthenticationException {
    final String username = getPrincipalNameTransformer().transform(credentials.getUsername());
    final String password = credentials.getPassword();
    try {//from w ww.ja  va2  s. co m
        @SuppressWarnings("deprecation")
        final LoginPassword loginPassword = (LoginPassword) getJdbcTemplate().queryForObject(this.sql,
                new BeanPropertyRowMapper<LoginPassword>(LoginPassword.class),
                new Object[] { username, username });
        final String encryptedPassword = this.getPasswordEncoder()
                .encode(this.getPasswordEncoder().encode(password).concat(loginPassword.getSalt()));
        return loginPassword.getPassword().equals(encryptedPassword);
    } catch (final IncorrectResultSizeDataAccessException e) {
        e.printStackTrace();
        return false;
    }
}

From source file:Spring.Repaso01.ClienteDAO.java

@Override
public ArrayList<Cliente> consultaTodos() {
    String selQuery = "select * from Cliente";
    List cliente = jdbcTemplate.query(selQuery, new BeanPropertyRowMapper(Cliente.class));
    return (ArrayList) cliente;
}