Examples of org.springframework.jdbc.core.RowMapper

org.springframework.jdbc.core.RowMapper

An interface used by {@link JdbcTemplate} for mapping rows of a{@link java.sql.ResultSet} on a per-row basis. Implementations of thisinterface perform the actual work of mapping each row to a result object, but don't need to worry about exception handling. {@link java.sql.SQLException SQLExceptions} will be caught and handledby the calling JdbcTemplate.

Typically used either for {@link JdbcTemplate}'s query methods or for out parameters of stored procedures. RowMapper objects are typically stateless and thus reusable; they are an ideal choice for implementing row-mapping logic in a single place.

Alternatively, consider subclassing {@link org.springframework.jdbc.object.MappingSqlQuery} from thejdbc.object package: Instead of working with separate JdbcTemplate and RowMapper objects, you can build executable query objects (containing row-mapping logic) in that style. @author Thomas Risberg @author Juergen Hoeller @see JdbcTemplate @see RowCallbackHandler @see ResultSetExtractor @see org.springframework.jdbc.object.MappingSqlQuery


public abstract class BaseBean {


  @SuppressWarnings("unchecked")
  public static RowMapper mapRow(final Class clazz) throws Exception{
    return new RowMapper(){
      public Object mapRow(ResultSet resultset, int rowNum)
          throws SQLException {
        Field[] fields = clazz.getDeclaredFields();
        Object o = null;
        try {

    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);
                    }


                    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;


        // 返回单列的查询的(或者返回只有2列的Map类型查询的)
        if (TypeUtils.isColumnType(rowType)) {
            if (returnClassType == Map.class) {
                rowMapper = new MapEntryColumnRowMapper(modifier, rowType);

Examples of org.springframework.jdbc.core.RowMapper

Related Classes of org.springframework.jdbc.core.RowMapper