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

Introduction

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

Prototype

SqlRowSetResultSetExtractor

Source Link

Usage

From source file:com.fns.grivet.repo.JdbcEntityRepository.java

@Override
public List<EntityAttributeValue> findByCreatedTime(Integer cid, LocalDateTime createdTimeStart,
        LocalDateTime createdTimeEnd) {
    String sql = QueryBuilder.newInstance().appendCreatedTimeRange().build();
    log.trace(String.format("JdbcEntityRepository.findByCreatedTime[sql=%s]", sql));
    return mapRows(jdbcTemplate.query(sql, new SqlRowSetResultSetExtractor(),
            new SqlParameterValue(Types.INTEGER, cid),
            new SqlParameterValue(Types.TIMESTAMP, Timestamp.valueOf(createdTimeStart)),
            new SqlParameterValue(Types.TIMESTAMP, Timestamp.valueOf(createdTimeEnd))));
}

---

From source file:com.fns.grivet.repo.JdbcEntityRepository.java

@Override
public List<EntityAttributeValue> findByEntityId(Long eid) {
    String sql = QueryBuilder.newInstance().obtainValuesForOneEntity().build();
    log.trace(String.format("JdbcEntityRepository.findById[sql=%s]", sql));
    return mapRows(jdbcTemplate.query(sql, new SqlRowSetResultSetExtractor(),
            new SqlParameterValue(Types.BIGINT, eid)));
}

---

From source file:com.fns.grivet.repo.JdbcEntityRepository.java

@Override
public List<EntityAttributeValue> findAllEntitiesByCid(Integer cid) {
    String sql = QueryBuilder.newInstance().obtainValuesForEntitiesByCid().build();
    log.trace(String.format("JdbcEntityRepository.findAllByCid[sql=%s]", sql));
    return mapRows(jdbcTemplate.query(sql, new SqlRowSetResultSetExtractor(),
            new SqlParameterValue(Types.INTEGER, cid)));
}

---

From source file:com.fns.grivet.repo.JdbcEntityRepository.java

@Override
public List<EntityAttributeValue> executeDynamicQuery(Integer cid, DynamicQuery query) {
    Assert.isTrue(query.areConjunctionsHomogenous(),
            "Query cannot be executed! All conjunctions must be homogenous!");
    String sql = QueryBuilder.newInstance().append(query).build();
    log.trace(String.format("JdbcEntityRepository.executeDynamicQuery[sql=%s]", sql));
    List<SqlParameterValue> values = new ArrayList<>();
    values.add(new SqlParameterValue(Types.INTEGER, cid));
    values.addAll(Arrays.asList(query.asSqlParameterValues()));
    return mapRows(jdbcTemplate.query(sql, new SqlRowSetResultSetExtractor(),
            values.toArray(new Object[values.size()])));
}

---

From source file:org.jasig.cas.ticket.registry.support.JdbcLockingStrategy.java

/**
 * @see org.jasig.cas.ticket.registry.support.LockingStrategy#acquire()
 *//*from  ww w. jav a2 s  . c o m*/
@Transactional
public boolean acquire() {
    boolean lockAcquired = false;
    if (this.platform == DatabasePlatform.SqlServer) {
        this.jdbcTemplate.execute("SET TRANSACTION ISOLATION LEVEL SERIALIZABLE");
    }
    try {
        final SqlRowSet rowSet = (SqlRowSet) this.jdbcTemplate.query(this.selectSql,
                new Object[] { this.applicationId }, new SqlRowSetResultSetExtractor());
        final Timestamp expDate = getExpirationDate();
        if (!rowSet.next()) {
            // No row exists for this applicationId so create it.
            // Row is created with uniqueId of this instance
            // which indicates the lock is initially held by this instance.
            this.jdbcTemplate.update(this.createSql,
                    new Object[] { this.applicationId, this.uniqueId, expDate });
            return true;
        }
        lockAcquired = canAcquire(rowSet);
        if (lockAcquired) {
            // Update unique ID of row to indicate this instance holds lock
            this.jdbcTemplate.update(this.updateAcquireSql,
                    new Object[] { this.uniqueId, expDate, this.applicationId });
        }
    } finally {
        // Always attempt to revert current connection to default isolation
        // level on SQL Server
        if (this.platform == DatabasePlatform.SqlServer) {
            this.jdbcTemplate.execute("SET TRANSACTION ISOLATION LEVEL READ COMMITTED");
        }
    }
    return lockAcquired;
}

---

From source file:cc.tooyoung.common.db.JdbcTemplate.java

public SqlRowSet queryForRowSet(String sql) throws DataAccessException {
    return (SqlRowSet) query(sql, new SqlRowSetResultSetExtractor());
}

---

From source file:cc.tooyoung.common.db.JdbcTemplate.java

public SqlRowSet queryForRowSet(String sql, Object[] args, int[] argTypes) throws DataAccessException {
    return (SqlRowSet) query(sql, args, argTypes, new SqlRowSetResultSetExtractor());
}

---

From source file:cc.tooyoung.common.db.JdbcTemplate.java

public SqlRowSet queryForRowSet(String sql, Object[] args) throws DataAccessException {
    return (SqlRowSet) query(sql, args, new SqlRowSetResultSetExtractor());
}

---