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.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  w w . ja  v  a 2 s .  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: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;//from   w  w w  .j  a  v  a2 s. c  o m
    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:net.noday.cat.dao.UserDao.java

public int findCount(User condition) {
    StringBuffer sql = new StringBuffer("select count(u.id) from user u where 1=1");
    SqlParameterSource ps = null;// ww  w.  j a  va 2  s.  com
    if (condition != null) {
        ps = new BeanPropertySqlParameterSource(condition);
        sql.append(toConditionSql(condition));
    }
    return namedJdbcTemplate.queryForInt(sql.toString(), ps);
}

---

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

public void insertLossesAndAdjustments(LossesAndAdjustments lossesAndAdjustments) {
    try {//from ww w. ja  va  2 s  .  c om
        template.update(insertAdjustmentsQuery, new BeanPropertySqlParameterSource(lossesAndAdjustments));
    } catch (Exception e) {
        logger.debug(e.getMessage());
    }
}

---

From source file:com.artivisi.iso8583.persistence.dao.MapperDao.java

public void save(Mapper mapper) {
    mapper.setId(UUID.randomUUID().toString());
    SqlParameterSource namedParameters = new BeanPropertySqlParameterSource(mapper);
    namedParameterJdbcTemplate.update(SQL_INSERT_MAPPER, namedParameters);

    for (Integer dataElement : mapper.getDataElement().keySet()) {
        DataElement de = mapper.getDataElement().get(dataElement);

        Map<String, Object> params = new HashMap<String, Object>();
        params.put("id", UUID.randomUUID().toString());
        params.put("id_mapper", mapper.getId());
        params.put("dataelement_number", dataElement);
        params.put("dataelement_type", de.getType().name());
        params.put("dataelement_length_type", de.getLengthType().name());
        params.put("dataelement_length", de.getLength());
        params.put("dataelement_length_prefix", de.getLengthPrefix());

        namedParameterJdbcTemplate.update(SQL_INSERT_DATA_ELEMENT, params);
    }//  ww  w .  j a  v a2 s . c  om
}

---

From source file:com.webstersmalley.countdown.db.JdbcCountdownDao.java

@Override
public List<WordBean> getMatches(String input) {
    WordBean word = new WordBean(input);
    RowMapper mapper = new WordRowMapper();
    String sql = "select theWord from words where length <= :length and countA <= :countA and  countB <= :countB and countC <= :countC and countD <= :countD and countE <= :countE and countF <= :countF and countG <= :countG and countH <= :countH and countI <= :countI and countJ <= :countJ and countK <= :countK and countL <= :countL and countM <= :countM and countN <= :countN and countO <= :countO and countP <= :countP and countQ <= :countQ and countR <= :countR and countS <= :countS and countT <= :countT and countU <= :countU and countV <= :countV and countW <= :countW and countX <= :countX and countY <= :countY and countZ <= :countZ";
    SqlParameterSource namedParameters = new BeanPropertySqlParameterSource(word);
    return namedParameterJdbcTemplate.query(sql, namedParameters, mapper);
}

---

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

@Override
public void store(MeasurementValue information) {
    SqlParameterSource sps = new BeanPropertySqlParameterSource(information);
    getSimpleJdbcTemplate().update(SQL_INSERT, sps);
}

---

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

public long insertGeoLevel(GeographicLevel geoLevel) {
    GeneratedKeyHolder keyHolder = new GeneratedKeyHolder();
    template.update(insertGeoLevelQuery, new BeanPropertySqlParameterSource(geoLevel), keyHolder,
            new String[] { "id" });

    long autoGeneratedKey = keyHolder.getKey().longValue();
    geoLevel.setId(autoGeneratedKey);//from w w  w.j a v  a 2 s.  c o m
    return autoGeneratedKey;
}

---

From source file:com.catt.mobile.repository.jdbc.JdbcAccountRepositoryImpl.java

@Override
public void save(Account account) throws DataAccessException {
    BeanPropertySqlParameterSource parameterSource = new BeanPropertySqlParameterSource(account);
    if (account.isNew()) {
        Number newKey = this.insertAccount.executeAndReturnKey(parameterSource);
        account.setId(newKey.intValue());
    } else {/* ww w .j  av  a2  s. c o m*/
        this.namedParameterJdbcTemplate.update("UPDATE account SET name=:name, address=:address, "
                + "email=:email, telephone=:telephone WHERE id=:id", parameterSource);
    }
}

---

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

public long insertDosageUnit(DosageUnit dosageUnit) {
    GeneratedKeyHolder keyHolder = new GeneratedKeyHolder();
    template.update(insertDosageUnitQuery, new BeanPropertySqlParameterSource(dosageUnit), keyHolder,
            new String[] { "id" });
    long autoGeneratedKey = keyHolder.getKey().longValue();
    dosageUnit.setId(autoGeneratedKey);/* w w  w . ja v a2s  .  com*/
    return autoGeneratedKey;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• »