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

Introduction

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

Prototype

ColumnMapRowMapper

Source Link

Usage

From source file:org.cloudfoundry.identity.uaa.rest.jdbc.JdbcPagingListTests.java

@Test
public void testSubListFromDeletedElements() throws Exception {
    list = new JdbcPagingList<Map<String, Object>>(template, limitSqlAdapter, "SELECT * from foo",
            new ColumnMapRowMapper(), 3);
    template.update("DELETE from foo where id>3");
    list = list.subList(1, list.size());
    assertEquals(4, list.size());/*from w w w .  j  a va2s.c  om*/
    int count = 0;
    for (Map<String, Object> map : list) {
        count++;
        assertNotNull(map.get("name"));
    }
    assertEquals(3, count); // count is less than original size estimate
}

---

From source file:architecture.ee.jdbc.sqlquery.factory.impl.SqlQueryImpl.java

public <T> T queryForObject(String statement, Object[] params, int[] paramTypes, Class<T> elementType) {
    BoundSql sql = getBoundSql(statement, params);

    if (elementType == Map.class) {
        return (T) jdbcTemplate.queryForObject(sql.getSql(), params, paramTypes, new ColumnMapRowMapper());
    } else {//from ww w  .  j  a va 2  s  .c  o  m
        return jdbcTemplate.queryForObject(sql.getSql(), params, paramTypes, elementType);
    }
}

---

From source file:gov.nih.nci.cabig.caaers.CaaersDbTestCase.java

protected final void dumpResults(final String sql) {
    List<Map<String, Object>> rows = new JdbcTemplate(getDataSource()).query(sql, new ColumnMapRowMapper() {
        @Override// w  ww . java  2  s .  co  m
        protected Object getColumnValue(ResultSet rs, int index) throws SQLException {
            Object value = super.getColumnValue(rs, index);
            return value == null ? "null" : value.toString();
        }
    });
    StringBuffer dump = new StringBuffer(sql).append('\n');
    if (rows.size() > 0) {
        Map<String, Integer> colWidths = new HashMap<String, Integer>();
        for (String colName : rows.get(0).keySet()) {
            colWidths.put(colName, colName.length());
            for (Map<String, Object> row : rows) {
                colWidths.put(colName, Math.max(colWidths.get(colName), row.get(colName).toString().length()));
            }
        }

        for (String colName : rows.get(0).keySet()) {
            StringUtils.appendWithPadding(colName, colWidths.get(colName), false, dump);
            dump.append("   ");
        }
        dump.append('\n');

        for (Map<String, Object> row : rows) {
            for (String colName : row.keySet()) {
                StringUtils.appendWithPadding(row.get(colName).toString(), colWidths.get(colName), false, dump);
                dump.append(" | ");
            }
            dump.append('\n');
        }
    }
    dump.append("  ").append(rows.size()).append(" row").append(rows.size() != 1 ? "s\n" : "\n");

    System.out.print(dump);
}

---

From source file:com.springsource.greenhouse.events.load.NFJSLoaderTest.java

private void assertVenueData(String name, String postalAddress, double latitude, double longitude,
        String locationHint, long createdBy) {
    Map<String, Object> eventVenueData = jdbcTemplate
            .queryForObject("select event, venue from EventVenue where event=?", new ColumnMapRowMapper(), 1);
    assertEquals(Long.valueOf(1), eventVenueData.get("event"));
    Long venueId = (Long) eventVenueData.get("venue");
    assertEquals(Long.valueOf(1), venueId);

    Map<String, Object> venueData = jdbcTemplate.queryForObject(
            "select id, name, postalAddress, latitude, longitude, locationHint, createdBy from Venue where id=?",
            new ColumnMapRowMapper(), venueId);
    assertEquals(Long.valueOf(1), venueData.get("id"));
    assertEquals(name, venueData.get("name"));
    assertEquals(postalAddress, venueData.get("postalAddress"));
    assertEquals(latitude, venueData.get("latitude"));
    assertEquals(longitude, venueData.get("longitude"));
    assertEquals(locationHint, venueData.get("locationHint"));
    assertEquals(createdBy, venueData.get("createdBy"));
}

---

From source file:com.springsource.greenhouse.events.load.NFJSLoaderTest.java

private void assertLeaderData(String name, String bio, String personalUrl, String twitterUsername) {
    Map<String, Object> externalLeaderData = jdbcTemplate.queryForObject(
            "select leader, sourceId, source from ExternalLeader where source='NFJS' and sourceId=?",
            new ColumnMapRowMapper(), 38);
    Long leaderId = (Long) externalLeaderData.get("leader");
    assertEquals(Long.valueOf(15), leaderId);
    assertEquals(38L, externalLeaderData.get("sourceId"));
    assertEquals("NFJS", externalLeaderData.get("source"));

    Map<String, Object> leaderData = jdbcTemplate.queryForObject(
            "select id, name, company, title, location, bio, personalUrl, companyUrl, twitterUsername, member from Leader where id=?",
            new ColumnMapRowMapper(), leaderId);
    assertEquals(leaderId, leaderData.get("id"));
    assertEquals(name, leaderData.get("name"));
    assertNull(leaderData.get("company"));
    assertNull(leaderData.get("title"));
    assertNull(leaderData.get("location"));
    assertEquals(bio, leaderData.get("bio").toString().trim());
    assertEquals(personalUrl, leaderData.get("personalUrl"));
    assertNull(leaderData.get("companyUrl"));
    assertEquals(twitterUsername, leaderData.get("twitterUsername"));
    assertNull(leaderData.get("member")); // TODO: Might want to figure out how to associate this with GH member table
}

---

From source file:architecture.ee.jdbc.sqlquery.factory.impl.SqlQueryImpl.java

public List<Map<String, Object>> queryForList(String statement, Object[] params, int[] paramTypes) {
    BoundSql sql = getBoundSql(statement, params);
    if (this.maxResults > 0) {

        return jdbcTemplate.queryScrollable(sql.getSql(), startIndex, maxResults, params, paramTypes,
                new ColumnMapRowMapper());
    } else {//w w w .j  a v  a2 s. com
        if (params == null || params.length == 0)
            return jdbcTemplate.query(sql.getSql(), new ColumnMapRowMapper());
        else
            return jdbcTemplate.query(sql.getSql(), params, paramTypes, new ColumnMapRowMapper());
    }
}

---

From source file:com.springsource.greenhouse.events.load.NFJSLoaderTest.java

private void assertEventTimeSlotData(long id, long eventId, String label, String startTime, String endTime) {
    Map<String, Object> externalEventTimeSlotData = jdbcTemplate.queryForObject(
            "select timeSlot, sourceId, source from ExternalEventTimeSlot where timeSlot=?",
            new ColumnMapRowMapper(), id);
    assertEquals(id, externalEventTimeSlotData.get("timeSlot"));
    assertEquals(6311L, externalEventTimeSlotData.get("sourceId"));
    assertEquals("NFJS", externalEventTimeSlotData.get("source"));

    Map<String, Object> eventTimeSlotData = jdbcTemplate.queryForObject(
            "select id, event, label, startTime, endTime from EventTimeSlot where id=?",
            new ColumnMapRowMapper(), 16);
    assertEquals(id, eventTimeSlotData.get("id"));
    assertEquals(eventId, eventTimeSlotData.get("event"));
    assertEquals(label, eventTimeSlotData.get("label"));
    assertEquals(startTime, eventTimeSlotData.get("startTime").toString());
    assertEquals(endTime, eventTimeSlotData.get("endTime").toString());
}

---

From source file:architecture.ee.jdbc.sqlquery.factory.impl.SqlQueryImpl.java

public <T> T uniqueResult(String statement, Object parameter, Class<T> elementType) {
    if (elementType == Map.class)
        return (T) uniqueResult(statement, parameter, new ColumnMapRowMapper());
    return uniqueResult(statement, parameter, new SingleColumnRowMapper<T>(elementType));
}

---

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

/**
 * Extract output parameters from the completed stored procedure.
 * @param cs JDBC wrapper for the stored procedure
 * @param parameters parameter list for the stored procedure
 * @return Map that contains returned results
 *//*from  w ww.jav  a  2s  .  c o m*/
@SuppressWarnings("unchecked")
protected Map extractOutputParameters(CallableStatement cs, List parameters) throws SQLException {
    Map returnedResults = new HashMap();
    int sqlColIndex = 1;
    for (int i = 0; i < parameters.size(); i++) {
        SqlParameter param = (SqlParameter) parameters.get(i);
        if (param instanceof SqlOutParameter) {
            SqlOutParameter outParam = (SqlOutParameter) param;
            if (outParam.isReturnTypeSupported()) {
                Object out = outParam.getSqlReturnType().getTypeValue(cs, sqlColIndex, outParam.getSqlType(),
                        outParam.getTypeName());
                returnedResults.put(outParam.getName(), out);
            } else {
                Object out = cs.getObject(sqlColIndex);
                if (out instanceof ResultSet) {
                    if (outParam.isResultSetSupported()) {
                        returnedResults.putAll(processResultSet((ResultSet) out, outParam));
                    } else {
                        String rsName = outParam.getName();
                        SqlReturnResultSet rsParam = new SqlReturnResultSet(rsName, new ColumnMapRowMapper());
                        returnedResults.putAll(processResultSet(cs.getResultSet(), rsParam));
                        ApiLogger.info("Added default SqlReturnResultSet parameter named " + rsName);
                    }
                } else {
                    returnedResults.put(outParam.getName(), out);
                }
            }
        }
        if (!(param.isResultsParameter())) {
            sqlColIndex++;
        }
    }
    return returnedResults;
}

---

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

/**
 * Create a new RowMapper for reading columns as key-value pairs.
 * @return the RowMapper to use/*w  w  w . j  a v  a  2  s. com*/
 * @see ColumnMapRowMapper
 */
protected RowMapper getColumnMapRowMapper() {
    return new ColumnMapRowMapper();
}

---

• «
• 1
• 2
• 3
• 4
• 5
• »