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:com.triage.springweb.ShowUser.java

public List<Map<String, Object>> listUsers(String userId) {
    List<Map<String, Object>> data = this.template.query("select * from users where id = " + userId,
            new ColumnMapRowMapper());
    return data;//w  ww  .ja  va2s.c  om
}

---

From source file:net.sourceforge.subsonic.controller.DBController.java

protected ModelAndView handleRequestInternal(HttpServletRequest request, HttpServletResponse response)
        throws Exception {
    Map<String, Object> map = new HashMap<String, Object>();

    String query = request.getParameter("query");
    if (query != null) {
        map.put("query", query);

        try {//ww w  . ja v a  2  s.c om
            List<?> result = daoHelper.getJdbcTemplate().query(query, new ColumnMapRowMapper());
            map.put("result", result);
        } catch (DataAccessException x) {
            map.put("error", ExceptionUtils.getRootCause(x).getMessage());
        }
    }

    ModelAndView result = super.handleRequestInternal(request, response);
    result.addObject("model", map);
    return result;
}

---

From source file:fr.acxio.tools.agia.item.database.MapJdbcLookupProcessor.java

public MapJdbcLookupProcessor() {
    jdbcCursorItemReader.setRowMapper(new ColumnMapRowMapper());
    jdbcCursorItemReader.setPreparedStatementSetter(preparedStatementSetter);
}

---

From source file:org.cloudfoundry.identity.uaa.scim.JdbcPagingListTests.java

@Test
public void testIterationOverPages() throws Exception {
    list = new JdbcPagingList<Map<String, Object>>(template, "SELECT * from foo where id>=:id",
            Collections.<String, Object>singletonMap("id", 0), new ColumnMapRowMapper(), 3);
    assertEquals(5, list.size());/*from   ww  w  .j  av a2 s.  c om*/
    Set<String> names = new HashSet<String>();
    for (Map<String, Object> map : list) {
        String name = (String) map.get("name");
        assertNotNull(name);
        names.add(name);
    }
    assertEquals(5, names.size());
    names = new HashSet<String>();
    for (Map<String, Object> map : list) {
        String name = (String) map.get("name");
        assertNotNull(name);
        names.add(name);
    }
    assertEquals(5, names.size());
}

---

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

@Test
public void testIterationOverPages() throws Exception {
    list = new JdbcPagingList<Map<String, Object>>(template, limitSqlAdapter, "SELECT * from foo where id>=:id",
            Collections.<String, Object>singletonMap("id", 0), new ColumnMapRowMapper(), 3);
    assertEquals(5, list.size());/*from w  w  w.ja  v a  2s .  c om*/
    Set<String> names = new HashSet<String>();
    for (Map<String, Object> map : list) {
        String name = (String) map.get("name");
        assertNotNull(name);
        names.add(name);
    }
    assertEquals(5, names.size());
    names = new HashSet<String>();
    for (Map<String, Object> map : list) {
        String name = (String) map.get("name");
        assertNotNull(name);
        names.add(name);
    }
    assertEquals(5, names.size());
}

---

From source file:org.cloudfoundry.identity.uaa.scim.JdbcPagingListTests.java

@Test
public void testIterationWithDeletedElements() throws Exception {
    list = new JdbcPagingList<Map<String, Object>>(template, "SELECT * from foo where id>=:id",
            Collections.<String, Object>singletonMap("id", 0), new ColumnMapRowMapper(), 3);
    template.update("DELETE from foo where id>3");
    assertEquals(5, list.size());//from   ww w. j av a  2  s.  c o  m
    Set<String> names = new HashSet<String>();
    for (Map<String, Object> map : list) {
        String name = (String) map.get("name");
        assertNotNull(name);
        names.add(name);
    }
    assertEquals(4, names.size());
}

---

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

@Test
public void testIterationWithDeletedElements() throws Exception {
    list = new JdbcPagingList<Map<String, Object>>(template, limitSqlAdapter, "SELECT * from foo where id>=:id",
            Collections.<String, Object>singletonMap("id", 0), new ColumnMapRowMapper(), 3);
    template.update("DELETE from foo where id>3");
    assertEquals(5, list.size());/*from  w w  w. j a v  a  2s  .c o  m*/
    Set<String> names = new HashSet<String>();
    for (Map<String, Object> map : list) {
        String name = (String) map.get("name");
        assertNotNull(name);
        names.add(name);
    }
    assertEquals(4, names.size());
}

---

From source file:com.wantscart.jade.core.RowMapperFactoryImpl.java

@Override
public RowMapper getRowMapper(Modifier modifier) {
    RowHandler rowHandler = modifier.getAnnotation(RowHandler.class);
    if (rowHandler != null) {
        if (rowHandler.rowMapper() != RowHandler.ByDefault.class) {
            try {
                RowMapper rowMapper = rowHandler.rowMapper().newInstance();
                if (logger.isInfoEnabled()) {
                    logger.info("using rowMapper " + rowMapper + " for " + modifier);
                }//w w  w  . j  a va2  s.  c  o  m

                return rowMapper;
            } catch (Exception ex) {
                throw new BeanInstantiationException(rowHandler.rowMapper(), ex.getMessage(), ex);
            }
        }
    }
    //

    Class<?> returnClassType = modifier.getReturnType();
    Class<?> rowType = getRowType(modifier);

    // BUGFIX: SingleColumnRowMapper ?  Primitive Type 
    if (rowType.isPrimitive()) {
        rowType = ClassUtils.primitiveToWrapper(rowType);
    }

    // ?  RowMapper
    RowMapper rowMapper;

    // ?(?2Map)
    if (TypeUtils.isColumnType(rowType)) {
        if (returnClassType == Map.class) {
            rowMapper = new MapEntryColumnRowMapper(modifier, rowType);
        } else {
            rowMapper = new SingleColumnRowMapper(rowType);
        }
    }
    // Bean??????
    else {
        if (rowType == Map.class) {
            rowMapper = new ColumnMapRowMapper();
        } else if (rowType.isArray()) {
            rowMapper = new ArrayRowMapper(rowType);
        } else if ((rowType == List.class) || (rowType == Collection.class)) {
            rowMapper = new ListRowMapper(modifier);
        } else if (rowType == Set.class) {
            rowMapper = new SetRowMapper(modifier);
        } else {
            boolean checkColumns = (rowHandler == null) ? false : rowHandler.checkColumns();
            boolean checkProperties = (rowHandler == null) ? false : rowHandler.checkProperties();
            String key = rowType.getName() + "[checkColumns=" + checkColumns + "&checkProperties="
                    + checkProperties + "]";
            rowMapper = rowMappers.get(key);
            if (rowMapper == null) {
                rowMapper = new BeanPropertyRowMapper(rowType, checkColumns, checkProperties); // jade's BeanPropertyRowMapper here
                rowMappers.put(key, rowMapper);
            }
        }
        // DAOMaprowMapper?Map.Entry
        if (returnClassType == Map.class) {
            rowMapper = new MapEntryRowMapper(modifier, rowMapper);
        }
    }

    if (logger.isInfoEnabled()) {
        logger.info("using rowMapper " + rowMapper + " for " + modifier);
    }

    return rowMapper;
}

---

From source file:org.cloudfoundry.identity.uaa.scim.JdbcPagingListTests.java

@Test
public void testOrderBy() throws Exception {
    list = new JdbcPagingList<Map<String, Object>>(template, "SELECT * from foo order by id asc",
            Collections.<String, Object>singletonMap("id", 0), new ColumnMapRowMapper(), 3);
    assertEquals(5, list.size());//from   ww w  . jav a  2s  .  co  m
    Set<String> names = new HashSet<String>();
    for (Map<String, Object> map : list) {
        String name = (String) map.get("name");
        assertNotNull(name);
        names.add(name);
    }
    assertEquals(5, names.size());
}

---

From source file:net.paoding.rose.jade.rowmapper.DefaultRowMapperFactory.java

@Override
public RowMapper getRowMapper(StatementMetaData modifier) {
    RowHandler rowHandler = modifier.getAnnotation(RowHandler.class);
    if (rowHandler != null) {
        if (rowHandler.rowMapper() != RowHandler.ByDefault.class) {
            try {
                RowMapper rowMapper = rowHandler.rowMapper().newInstance();
                if (logger.isInfoEnabled()) {
                    logger.info("using rowMapper " + rowMapper + " for " + modifier);
                }/*from  w w  w.  j ava  2 s  .c  om*/

                return rowMapper;
            } catch (Exception ex) {
                throw new BeanInstantiationException(rowHandler.rowMapper(), ex.getMessage(), ex);
            }
        }
    }
    //

    Class<?> returnClassType = modifier.getMethod().getReturnType();
    Class<?> rowType = getRowType(modifier);

    // BUGFIX: SingleColumnRowMapper ?  Primitive Type 
    if (rowType.isPrimitive()) {
        rowType = ClassUtils.primitiveToWrapper(rowType);
    }

    // ?  RowMapper
    RowMapper rowMapper;

    // ?(?2Map)
    if (TypeUtils.isColumnType(rowType)) {
        if (returnClassType == Map.class) {
            rowMapper = new MapEntryColumnRowMapper(modifier, rowType);
        } else {
            rowMapper = new SingleColumnRowMapper(rowType);
        }
    }
    // Bean??????
    else {
        if (rowType == Map.class) {
            rowMapper = new ColumnMapRowMapper();
        } else if (rowType.isArray()) {
            rowMapper = new ArrayRowMapper(rowType);
        } else if ((rowType == List.class) || (rowType == Collection.class)) {
            rowMapper = new ListRowMapper(modifier);
        } else if (rowType == Set.class) {
            rowMapper = new SetRowMapper(modifier);
        } else {
            boolean checkColumns = (rowHandler == null) ? true : rowHandler.checkColumns();
            boolean checkProperties = (rowHandler == null) ? false : rowHandler.checkProperties();
            String key = rowType.getName() + "[checkColumns=" + checkColumns + "&checkProperties="
                    + checkProperties + "]";
            rowMapper = rowMappers.get(key);
            if (rowMapper == null) {
                rowMapper = new BeanPropertyRowMapper(rowType, checkColumns, checkProperties); // jade's BeanPropertyRowMapper here
                rowMappers.put(key, rowMapper);
            }
        }
        // DAOMaprowMapper?Map.Entry
        if (returnClassType == Map.class) {
            rowMapper = new MapEntryRowMapper(modifier, rowMapper);
        }
    }

    if (logger.isInfoEnabled()) {
        logger.info("using rowMapper " + rowMapper + " for " + modifier);
    }

    return rowMapper;
}

---

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