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

Introduction

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

Prototype

public RowMapperResultSetExtractor(RowMapper<T> rowMapper) 

Source Link

Document

Create a new RowMapperResultSetExtractor.

Usage

From source file:com.gzj.tulip.jade.dataaccess.DataAccessImpl.java

@Override
public <T> List<T> select(String sql, Object[] args, RowMapper<T> rowMapper) {
    PreparedStatementCreator csc = getPreparedStatementCreator(sql, args, false);
    return jdbcTemplate.query(csc, new RowMapperResultSetExtractor<T>(rowMapper));
}

---

From source file:com.skycloud.management.portal.admin.sysmanage.dao.impl.UserManageDaoImpl.java

@Override
public List<TUserBO> userALL() throws SQLException {
    //      String sql="select u.ID,u.ACCOUNT,u.PWD,u.NAME,u.DEPT_ID,u.ROLE_ID,u.EMAIL,u.PHONE,u.MOBILE," +
    //          "u.FAX,u.POSITION,u.STATE,u.COMMENT,u.CHECK_CODE,u.IS_AUTO_APPROVE," +
    //          "u.CREATOR_USER_ID,u.CREATE_DT,u.LASTUPDATE_DT,c.NAME CREATOR_USER_NAME " +
    //          "from T_SCS_USER u " +
    //          "LEFT JOIN T_SCS_USER c on u.CREATOR_USER_ID=c.ID order by u.ID desc;";
    String sql = "select u.* from T_SCS_USER u where u.DEPT_ID<>1 order by u.ID desc;";
    BeanPropertyRowMapper<TUserBO> userRowMapper = new BeanPropertyRowMapper<TUserBO>(TUserBO.class);
    List<TUserBO> returnList = null;
    try {//from   w ww.  j  a v  a2 s  .c om
        returnList = this.getJdbcTemplate().query(sql, new RowMapperResultSetExtractor<TUserBO>(userRowMapper));
    } catch (Exception e) {
        throw new SQLException("" + e.getMessage());
    }
    return returnList;
}

---

From source file:architecture.common.spring.jdbc.core.ExtendedJdbcTemplate.java

public <T> List<T> query(String sql, List<ParameterMapping> parameterMappings, Object[] args,
        RowMapper<T> rowMapper) throws DataAccessException {

    return query(sql, newMappedArrayPreparedStatementSetter(args, parameterMappings),
            new RowMapperResultSetExtractor<T>(rowMapper));
}

---

From source file:architecture.common.spring.jdbc.core.ExtendedJdbcTemplate.java

public <T> List<T> queryForList(String sql, List<ParameterMapping> parameterMappings,
        Map<String, Object> parameters, RowMapper<T> rowMapper) throws DataAccessException {
    return query(sql, newMappedPreparedStatementSetter(parameters, parameterMappings),
            new RowMapperResultSetExtractor<T>(rowMapper));
}

---

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

@SuppressWarnings("unchecked")
public List query(String sql, RowMapper rowMapper) throws DataAccessException {
    return (List) query(sql, new RowMapperResultSetExtractor(rowMapper));
}

---

From source file:architecture.common.spring.jdbc.core.ExtendedJdbcTemplate.java

protected Object runScript(Connection conn, boolean stopOnError, Reader reader)
        throws SQLException, IOException {

    StringBuffer command = null;//from  w  w  w.jav a  2  s .co  m
    List<Object> list = new ArrayList<Object>();
    try {
        LineNumberReader lineReader = new LineNumberReader(reader);
        String line = null;
        while ((line = lineReader.readLine()) != null) {
            if (command == null) {
                command = new StringBuffer();
            }
            String trimmedLine = line.trim();
            if (trimmedLine.startsWith("--")) {
                if (logger.isDebugEnabled())
                    logger.debug(trimmedLine);
            } else if (trimmedLine.length() < 1 || trimmedLine.startsWith("//")) {
                // Do nothing
            } else if (trimmedLine.length() < 1 || trimmedLine.startsWith("--")) {
                // Do nothing
            } else if (trimmedLine.endsWith(";")) {
                command.append(line.substring(0, line.lastIndexOf(";")));
                command.append(" ");

                Statement statement = conn.createStatement();
                if (logger.isDebugEnabled()) {
                    logger.debug("Executing SQL script command [" + command + "]");
                }

                boolean hasResults = false;
                if (stopOnError) {
                    hasResults = statement.execute(command.toString());
                } else {
                    try {
                        statement.execute(command.toString());
                    } catch (SQLException e) {
                        if (logger.isDebugEnabled())
                            logger.error("Error executing: " + command, e);
                        throw e;
                    }
                }
                ResultSet rs = statement.getResultSet();
                if (hasResults && rs != null) {
                    RowMapperResultSetExtractor<Map<String, Object>> rse = new RowMapperResultSetExtractor<Map<String, Object>>(
                            getColumnMapRowMapper());
                    List<Map<String, Object>> rows = rse.extractData(rs);
                    list.add(rows);
                }
                command = null;
            } else {
                command.append(line);
                command.append(" ");
            }
        }

        return list;
    } catch (SQLException e) {
        logger.error("Error executing: " + command, e);
        throw e;
    } catch (IOException e) {
        logger.error("Error executing: " + command, e);
        throw e;
    }
}

---

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

@SuppressWarnings("unchecked")
public List query(PreparedStatementCreator psc, RowMapper rowMapper) throws DataAccessException {
    return (List) query(psc, new RowMapperResultSetExtractor(rowMapper));
}

---

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

@SuppressWarnings("unchecked")
public List query(String sql, PreparedStatementSetter pss, RowMapper rowMapper) throws DataAccessException {
    return (List) query(sql, pss, new RowMapperResultSetExtractor(rowMapper));
}

---

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

@SuppressWarnings("unchecked")
public List query(String sql, Object[] args, int[] argTypes, RowMapper rowMapper) throws DataAccessException {
    return (List) query(sql, args, argTypes, new RowMapperResultSetExtractor(rowMapper));
}

---

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

@SuppressWarnings("unchecked")
public List query(String sql, Object[] args, RowMapper rowMapper) throws DataAccessException {
    return (List) query(sql, args, new RowMapperResultSetExtractor(rowMapper));
}

---

• «
• 1
• 2
• »