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:konditer.client.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_WEIGHT, " + "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;
}

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

public Subdomain findUserBySubdomain(String subdomain) {
    String sql = "select * from subdomain d where d.fullname=? limit 1";
    Subdomain u = jdbc.queryForObject(sql, new BeanPropertyRowMapper<Subdomain>(Subdomain.class), subdomain);
    return u;/*from  w ww  .  j  a  v a2 s.c o  m*/
}

From source file:repository.InteractionsDAO.java

public Interactions getInteractionsById(int interactionid) {

    String sql = "SELECT * FROM interactions WHERE interactionid = ?";
    return template.queryForObject(sql, new Object[] { interactionid },
            new BeanPropertyRowMapper<Interactions>(Interactions.class));
}

From source file:com.pw.ism.controllers.AdminstratorController.java

@RequestMapping("userdetails/{id}")
public ModelAndView viewUserDetails(@PathVariable("id") Long id, RedirectAttributes redirect) {
    User user = userRepository.findOne(id);
    List<UserProfile> userProfiles = jdbcTemplate.query("select ID, TYPE from USER_PROFILE",
            new BeanPropertyRowMapper(UserProfile.class));
    ModelAndView mvc = new ModelAndView("admin/userdetails");
    mvc.addObject("user", userRepository.findOne(id));
    mvc.addObject("profiles", userProfiles);
    return mvc;//w w w .j  a va  2  s.  c om
}

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

public List<DnsRecord> findPage(DnsRecord condition, int pIndex, int pSize) {
    StringBuffer sql = new StringBuffer("select * from dnsrecord r where 1=1");
    SqlParameterSource ps = null;//from w ww.j a  v a 2s .co  m
    if (condition != null) {
        ps = new BeanPropertySqlParameterSource(condition);
        sql.append(toConditionSql(condition));
    }
    sql.append(" order by r.record_type").append(" limit ").append((pIndex - 1) * pSize).append(",")
            .append(pSize);
    List<DnsRecord> list = namedjdbc.query(sql.toString(), ps,
            new BeanPropertyRowMapper<DnsRecord>(DnsRecord.class));
    return list;
}

From source file:CRM.repository.UsersDAO.java

public users getUsersbyUsername(String username) {
    String sql = "SELECT *  FROM users WHERE username = ?";
    return template.queryForObject(sql, new Object[] { username },
            new BeanPropertyRowMapper<users>(users.class));
}

From source file:mylife.respository.interactionsDAO.java

/**
 *
 * @param id//  w ww.  j  a v  a2s . com
 * @return
 */
public interactions getinteractionsById(int id) {
    String sql = "SELECT interactionid, (clientsid, date_of_contact, contact_name, contact_type, conversation,) FROM interactions WHERE interactionid = ?";
    return template.queryForObject(sql, new Object[] { id },
            new BeanPropertyRowMapper<interactions>(interactions.class));
}

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

public List<Domain> findPage(Domain condition, int pIndex, int pSize) {
    StringBuffer sql = new StringBuffer("select * from domain d where 1=1");
    SqlParameterSource ps = null;//  w  ww.  j a  va  2s  . c om
    if (condition != null) {
        ps = new BeanPropertySqlParameterSource(condition);
        sql.append(toConditionSql(condition));
    }
    sql.append(" order by d.regist_time desc").append(" limit ").append((pIndex - 1) * pSize).append(",")
            .append(pSize);
    List<Domain> list = namedJdbc.query(sql.toString(), ps, new BeanPropertyRowMapper<Domain>(Domain.class));
    return list;
}

From source file:au.org.ala.layers.dao.UserDataDAOImpl.java

@Override
public Ud_header get(Long ud_header_id) {
    String sql_select = "SELECT * FROM ud_header WHERE ud_header_id = ? ;";

    Ud_header ud_header = (Ud_header) jdbcTemplate.queryForObject(sql_select,
            new BeanPropertyRowMapper(Ud_header.class), new Object[] { ud_header_id });
    return ud_header;
}

From source file:com.github.jrrdev.mantisbtsync.core.services.JdbcIssuesServiceTest.java

/**
 * Test method for {@link com.github.jrrdev.mantisbtsync.core.services.JdbcIssuesService#insertProjectIfNotExists(biz.futureware.mantis.rpc.soap.client.ObjectRef)}.
 *///from   ww  w. j  a v  a 2s .co  m
@Test
public void testInsertProjectIfNotExists() {
    final ObjectRef item = new ObjectRef(BigInteger.ONE, "item");
    final boolean result = dao.insertProjectIfNotExists(item);
    assertTrue(result);

    final List<ObjectRef> list = getJdbcTemplate().query("SELECT id, name FROM mantis_project_table",
            new BeanPropertyRowMapper<ObjectRef>(ObjectRef.class));

    assertEquals(1, list.size());
    assertEquals(item, list.get(0));

    final boolean result2 = dao.insertProjectIfNotExists(item);
    assertTrue(result2);
}