Example usage for org.springframework.jdbc.core BeanPropertyRowMapper 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:net.noday.d4c.dao.DnsrecordDao.java

public DnsRecord get(Long id) {
    String sql = "select * from dnsrecord a where a.id=?";
    DnsRecord r = jdbc.queryForObject(sql, new BeanPropertyRowMapper<DnsRecord>(DnsRecord.class), id);
    return r;// www  . ja v a  2 s  . c  o  m
}

From source file:net.noday.d4c.dao.SubdomainDao.java

public Subdomain get(Long id) {
    String sql = "select * from domain where id=?";
    return jdbc.queryForObject(sql, new BeanPropertyRowMapper<Subdomain>(Subdomain.class), id);
}

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

@Override
public CakeAndType getCakeAndType(int cakeAndTypeId) {
    String SQL_QUERY = "SELECT CAKE_AND_TYPE_ID, CAKE_ID, CAKE_TYPE_ID, TIMESTAMP " + "FROM cakes_and_types "
            + "WHERE CAKE_AND_TYPE_ID = ?";
    CakeAndType cakeAndType = (CakeAndType) jdbcTemplate.queryForObject(SQL_QUERY,
            new Object[] { cakeAndTypeId }, new BeanPropertyRowMapper(CakeAndType.class));
    return cakeAndType;
}

From source file:net.noday.core.security.SecurityDao.java

/**
 * id/* w ww  .j a  v  a  2  s.c  o  m*/
 * @param userId
 * @return
 */
public User findUserByDuoshuo(String userId) {
    String sql = "select * from user u where u.duoshuo_id=? limit 1";
    User u = safeQueryForObject(sql, new BeanPropertyRowMapper<User>(User.class), userId);
    return u;
}

From source file:net.noday.d4c.dao.DomainDao.java

public List<Domain> findDomain() {
    String sql = "select * from domain where status=1";
    return jdbc.query(sql, new BeanPropertyRowMapper<Domain>(Domain.class));
}

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

@Override
public Contact getContact(int contactId) {
    String SQL_QUERY = "SELECT CONTACT_ID, CONTACT_TYPE_ID, CUSTOMER_ID, CONTACT_DATA, TIMESTAMP "
            + "FROM contacts " + "WHERE CONTACT_ID = ?";
    Contact contact = (Contact) jdbcTemplate.queryForObject(SQL_QUERY, new Object[] { contactId },
            new BeanPropertyRowMapper(Contact.class));
    return contact;
}

From source file:net.noday.d4c.dao.DnsrecordDao.java

public List<DnsRecord> findBySubdomainId(Long subdomainId) {
    String sql = "select * from dnsrecord a where a.subdomain_id=?";
    return jdbc.query(sql, new BeanPropertyRowMapper<DnsRecord>(DnsRecord.class), subdomainId);
}

From source file:net.noday.d4c.dao.DomainDao.java

public Domain findUserByDomain(String domain) {
    String sql = "select * from domain d where d.name=? limit 1";
    Domain u = jdbc.queryForObject(sql, new BeanPropertyRowMapper<Domain>(Domain.class), domain);
    return u;/*from   www . j  a va  2 s  .  c o m*/
}

From source file:mylife.respository.userDAO.java

/**
 *
 * @param id/*from  w  ww.j  ava  2 s  .c  om*/
 * @return
 */
public user getuserById(int id) {
    String sql = "SELECT username, (username, password, enabled ) FROM users WHERE username = ?";
    return template.queryForObject(sql, new Object[] { id }, new BeanPropertyRowMapper<user>(user.class));
}

From source file:konditer_reorganized_database.dao.OrdereDao.java

@Override
public Ordere getOrdere(int orderId) {
    String SQL_QUERY = "SELECT ORDER_ID, " + "CUSTOMER_ID, " + "ORDER_STATUS_ID, " + "DELIVERY_ID, "
            + "ORDER_DATE_INCOME, " + "ORDER_DATE_END, " + "ORDER_CAKE_PRICE, " + "ORDER_DELIVERY_PRICE, "
            + "ORDER_INSIDES_ID, " + "ORDER_INFO, TIMESTAMP " + "FROM orders " + "WHERE ORDER_ID = ?";
    Ordere order = (Ordere) jdbcTemplate.queryForObject(SQL_QUERY, new Object[] { orderId },
            new BeanPropertyRowMapper(Ordere.class));
    return order;
}