Example usage for org.springframework.jdbc.core.namedparam BeanPropertySqlParameterSource BeanPropertySqlParameterSource

Introduction

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

Prototype

public BeanPropertySqlParameterSource(Object object)

Source Link

Document

Create a new BeanPropertySqlParameterSource for the given bean.

Usage

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

public long save(User user) {
    String sql = "insert into user(email,password,regist_ip,salt,role) values(:email,:password,:registIp,:salt,:role)";
    KeyHolder keyHolder = new GeneratedKeyHolder();
    namedJdbcTemplate.update(sql, new BeanPropertySqlParameterSource(user), keyHolder);
    return keyHolder.getKey().longValue();
}

From source file:com.xinferin.dao.DAOLicenceImpl.java

@Override
public void update(Licence licence) {
    String sql = "UPDATE licence SET key_info = :key_info, generated_key = :generated_key, "
            + "customer_key = :customer_key, expiry_date = :expiry_date, comments = :comments, can_revoke = 0 WHERE id = :id";

    SqlParameterSource sqlParameters = new BeanPropertySqlParameterSource(licence);
    jdbcTemplate.update(sql, sqlParameters);
}

From source file:org.openlmis.performancetesting.dao.RequisitionGroupDAO.java

public long insertRequisitionGroup(RequisitionGroup requisitionGroup) {
    GeneratedKeyHolder keyHolder = new GeneratedKeyHolder();
    template.update(insertRequisitionGroupQuery, new BeanPropertySqlParameterSource(requisitionGroup),
            keyHolder, new String[] { "id" });

    long id = keyHolder.getKey().longValue();
    requisitionGroup.setId(id);//from  ww  w  .j  a v  a2  s.  c o  m
    return id;
}

From source file:org.openlmis.performancetesting.dao.UserDAO.java

public long insertUser(User user) {
    GeneratedKeyHolder keyHolder = new GeneratedKeyHolder();
    template.update(insertUserQuery, new BeanPropertySqlParameterSource(user), keyHolder,
            new String[] { "id" });

    long userId = keyHolder.getKey().longValue();
    user.setId(userId);//from   w w  w  .  j a v  a 2 s .c om

    return userId;
}

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

public long save(DnsRecord obj) {
    String sql = "insert into dnsrecord(id,sub_domain,record_type,record_line,value,mx,ttl,subdomain_id,dnspod_record_id,dnspod_domain_id)"
            + " values(:id,:subDomain,:recordType,:recordLine,:value,:mx,:ttl,:subdomainId,:dnspodRecordId,:dnspodDomainId)";
    KeyHolder keyHolder = new GeneratedKeyHolder();
    namedjdbc.update(sql, new BeanPropertySqlParameterSource(obj), keyHolder);
    return keyHolder.getKey().longValue();
}

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

public long save(Domain obj) {
    String sql = "insert into domain(name,password,salt,dnspod_domain_id,status)"
            + " values(:name,:password,:salt,:dnspodDomainId,:status)";
    KeyHolder keyHolder = new GeneratedKeyHolder();
    namedJdbc.update(sql, new BeanPropertySqlParameterSource(obj), keyHolder);
    return keyHolder.getKey().longValue();
}

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

public long save(Subdomain obj) {
    String sql = "insert into subdomain(name,fullname,password,salt,dnspod_domain_id) values(:name,:fullname,:password,:salt,:dnspodDomainId)";
    KeyHolder keyHolder = new GeneratedKeyHolder();
    namedJdbc.update(sql, new BeanPropertySqlParameterSource(obj), keyHolder);
    return keyHolder.getKey().longValue();
}

From source file:pl.edu.agh.samm.db.impl.MetricValueDAO.java

@Override
public void store(MetricValue metricValue) {
    SqlParameterSource sps = new BeanPropertySqlParameterSource(metricValue);
    getSimpleJdbcTemplate().update(SQL_INSERT, sps);

}

From source file:com.xinferin.dao.DAOProductImpl.java

@Override
public void edit(Product product) {
    if (product.getId() > 0) {
        String sql = "UPDATE product SET name=:fname WHERE id=:id";

        SqlParameterSource sqlParameters = new BeanPropertySqlParameterSource(product);
        jdbcTemplate.update(sql, sqlParameters);
    }// ww w .j  av a2 s . c  o  m
}

From source file:com.xinferin.dao.DAOCustomerImpl.java

@Override
public void edit(Customer customer) {
    if (customer.getId() > 0) {
        String sql = "UPDATE customer SET fname=:fname, lname=:lname, company=:company, street=:street, "
                + "city=:city, state=:state, country=:country, postcode=:postcode, "
                + "telephone=:telephone, email=:email, comments=:comments WHERE id=:id";

        SqlParameterSource sqlParameters = new BeanPropertySqlParameterSource(customer);
        jdbcTemplate.update(sql, sqlParameters);
    }//from  ww  w.  ja  v a2 s . c  om
}