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

Introduction

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

Prototype

RowMapper

Source Link

Usage

From source file:com.apress.prospringintegration.springenterprise.stocks.dao.jdbc.JdbcTemplateStockDao.java

@Override
public List<Stock> findAvailableStockBySymbol(String symbol) {
    String sql = " SELECT * from STOCKS" + " WHERE SYMBOL = ? order by PRICE_PER_SHARE";
    List<Stock> ret = jdbcTemplate.query(sql, new Object[] { symbol }, new RowMapper<Stock>() {
        public Stock mapRow(ResultSet rs, int rowNum) throws SQLException {
            Stock s = new Stock(rs.getString("SYMBOL"), rs.getString("INVENTORY_CODE"),
                    rs.getString("EXCHANGE_ID"), rs.getFloat("PRICE_PER_SHARE"),
                    rs.getInt("QUANTITY_AVAILABLE"), rs.getDate("PURCHASE_DATE"));
            return s;
        }/*from  ww  w .  j a va  2s .  com*/
    });

    return ret;
}

---

From source file:fr.xebia.springframework.security.core.userdetails.jdbc.ExtendedJdbcUserDetailsManager.java

@Override
protected UserDetails createUserDetails(String username, UserDetails userFromUserQuery,
        List<GrantedAuthority> combinedAuthorities) {
    final User user = (User) super.createUserDetails(username, userFromUserQuery, combinedAuthorities);
    List<UserDetails> users = getJdbcTemplate().query(selectUserExtraColumns, new String[] { username },
            new RowMapper<UserDetails>() {
                public UserDetails mapRow(ResultSet rs, int rowNum) throws SQLException {
                    ExtendedUser extendedUser = new ExtendedUser(user.getUsername(), user.getPassword(),
                            user.isEnabled(), user.isAccountNonExpired(), user.isCredentialsNonExpired(),
                            user.isAccountNonLocked(), user.getAuthorities());
                    extendedUser.setAllowedRemoteAddresses(rs.getString(1));
                    extendedUser.setComments(rs.getString(2));

                    return extendedUser;
                }/* w ww.  j  a  va2  s . c  om*/
            });
    if (users.size() == 0) {
        throw new UsernameNotFoundException(messages.getMessage("JdbcDaoImpl.notFound",
                new Object[] { username }, "Username {0} not found"), username);
    }
    return users.get(0);
}

---

From source file:com.example.spring.jdbc.template.CustomerDao.java

public List<Customer> getAllCustomersRowMapper() {
    return jdbcTemplate.query("select * from customer", new RowMapper<Customer>() {
        @Override/*from  w  ww  .j  a va  2 s. com*/
        public Customer mapRow(ResultSet rs, int rownumber) throws SQLException {
            Customer e = new Customer();
            e.setCutomerId(rs.getString(1));
            e.setName(rs.getString(2));
            e.setEmail(rs.getString(3));
            return e;
        }
    });
}

---

From source file:ru.org.linux.topic.TopicListDaoImpl.java

@Override
public List<Topic> getTopics(TopicListDto topicListDto) {
    logger.debug("TopicListDao.getTopics(); topicListDto = " + topicListDto.toString());
    String where = makeConditions(topicListDto);
    String sort = makeSortOrder(topicListDto);
    String limit = makeLimitAndOffset(topicListDto);

    StringBuilder query = new StringBuilder();

    query.append("SELECT ").append("postdate, topics.id as msgid, topics.userid, topics.title, ")
            .append("topics.groupid as guid, topics.url, topics.linktext, ua_id, ")
            .append("urlname, havelink, section, topics.sticky, topics.postip, ")
            .append("postdate<(CURRENT_TIMESTAMP-sections.expire) as expired, deleted, lastmod, commitby, ")
            .append("commitdate, topics.stat1, postscore, topics.moderate, notop, ")
            .append("topics.resolved, restrict_comments, minor ").append("FROM topics ")
            .append("INNER JOIN groups ON (groups.id=topics.groupid) ")
            .append("INNER JOIN sections ON (sections.id=groups.section) ");
    if (topicListDto.isUserFavs()) {
        query.append("INNER JOIN memories ON (memories.topic = topics.id) ");
    }/*from w w  w  . ja v  a  2 s .  c  om*/
    query.append("WHERE ").append(where).append(sort).append(limit);

    logger.trace("SQL query: " + query.toString());

    return jdbcTemplate.query(query.toString(), new RowMapper<Topic>() {
        @Override
        public Topic mapRow(ResultSet resultSet, int i) throws SQLException {
            return new Topic(resultSet);
        }
    });
}

---

From source file:com.ewcms.content.particular.dao.FrontEnterpriseArticleDAO.java

public List<EnterpriseArticle> findEnterpriseArticleByPage(int page, int row) {
    String sql = "Select * " + "From particular_enterprise_article where release=true "
            + "Order By published desc Limit ? OffSet ?";
    int offset = page * row;
    Object[] params = new Object[] { row, offset };
    List<EnterpriseArticle> list = jdbcTemplate.query(sql, params, new RowMapper<EnterpriseArticle>() {

        @Override// w ww.  j  a  va 2 s. c  o  m
        public EnterpriseArticle mapRow(ResultSet rs, int rowNum) throws SQLException {
            return interactionRowMapper(rs);
        }
    });

    return list;
}

---

From source file:com.ewcms.component.query.dao.QueryDAO.java

@Override
public List<Article> findArtilce(String title, Integer channelId, String beginDate, String endDate,
        Boolean isContent) {/*w  w  w . ja va 2s  . co m*/
    Boolean isIf = false;

    String sql = "Select r.id, a.title, a.author, a.published, a.url, s.name From content_article_main As r Left Join site_channel As s On r.channel_id = s.id Left Join content_article As a On r.article_id = a.id Left Join content_content As c On a.id=c.article_id Where @isIf@ And a.status='RELEASE' ";

    List<Object> params = new ArrayList<Object>();

    if (title != null && !title.trim().equals("")) {
        isIf = true;
        sql += " And a.title Like ? ";
        params.add("%" + title + "%");
    }

    if (isContent != null && isContent) {
        isIf = true;
        sql += " And c.detail Like ? ";
        params.add("%" + title + "%");
    }

    if (channelId != null && channelId.longValue() > 0) {
        isIf = true;
        sql += " And s.id=? ";
        params.add(channelId);
    }

    if (beginDate != null && !beginDate.trim().equals("")) {
        Date _beginDate;
        try {
            _beginDate = DATE_FORMAT.parse(beginDate);
            sql += " And a.published >= ?";
            isIf = true;
            params.add(_beginDate);
        } catch (ParseException e) {
            e.printStackTrace();
        }
    }

    if (endDate != null && !endDate.trim().equals("")) {
        try {
            Date _endDate = DATE_FORMAT.parse(endDate);
            sql += " And a.published <= ? ";
            isIf = true;
            params.add(_endDate);
        } catch (ParseException e) {
            e.printStackTrace();
        }
    }

    if (isIf) {
        sql = sql.replace("@isIf@", "1=1");
    } else {
        sql = sql.replace("@isIf@", "1<>1");
    }

    sql += " Order By a.published Desc";

    return jdbcTemplate.query(sql, params.toArray(), new RowMapper<Article>() {
        @Override
        public Article mapRow(ResultSet rs, int rowNum) throws SQLException {
            return articleRowMapper(rs);
        }
    });
}

---

From source file:co.jirm.spring.SpringJdbcSqlExecutor.java

@Override
protected <T> List<T> doQueryForList(String sql, final JdbcResultSetRowMapper<T> rowMapper, Object[] objects) {
    return jdbcTemplate.query(sql, objects, new RowMapper<T>() {
        @Override/* www . j  a  v  a2  s .co m*/
        public T mapRow(ResultSet rs, int rowNum) throws SQLException {
            return rowMapper.mapRow(rs, rowNum);
        }
    });
}

---

From source file:com.karki.spring.dao.impl.CourseDaoImpl.java

@Override
public Course searchByName(String name) throws ClassNotFoundException, SQLException {

    return jdbcTemplate.queryForObject(CourseSQL.GETBYNAME, new Object[] { name }, new RowMapper<Course>() {

        @Override//from  www. j  a va2 s. c om
        public Course mapRow(ResultSet rs, int i) throws SQLException {
            return mapData(rs);
        }
    });
}

---

From source file:dk.nsi.haiba.lprimporter.dao.impl.LPRDAOImpl.java

private Collection<Codes> getKoder(String sql, final String f1, final String f2) {
    Collection<Codes> returnValue = new ArrayList<Codes>();
    try {/*  w  w w .j a v a 2  s  . c o  m*/
        returnValue = jdbcTemplate.query(sql, new RowMapper<Codes>() {
            @Override
            public Codes mapRow(ResultSet rs, int rowNum) throws SQLException {
                String code = rs.getString(f1);
                String secondaryCode = rs.getString(f2);
                return new CodesImpl(code, secondaryCode);
            }
        });
    } catch (EmptyResultDataAccessException e) {
    } catch (RuntimeException e) {
        throw new DAOException("Error fetching for sql " + sql, e);
    }
    log.trace("getKoder: " + sql + ", " + f1 + ", " + f2 + ":" + returnValue);
    return returnValue;
}

---

From source file:org.cleverbus.core.common.asynch.RepairProcessingMsgServiceDbTest.java

@Test
public void testRepairProcessingMessages() {
    msg.setState(MsgStateEnum.PROCESSING);
    msg.setStartProcessTimestamp(msg.getMsgTimestamp());
    messageDao.insert(msg);//  www  .ja  va 2 s  .c om

    em.flush();

    int msgCount = JdbcTestUtils.countRowsInTable(getJdbcTemplate(), "message");
    assertThat(msgCount, is(1));

    // call repairing
    repairMsgService.repairProcessingMessages();

    em.flush();

    // verify results
    msgCount = JdbcTestUtils.countRowsInTable(getJdbcTemplate(), "message");
    assertThat(msgCount, is(1));

    getJdbcTemplate().query("select * from message", new RowMapper<Message>() {
        @Override
        public Message mapRow(ResultSet rs, int rowNum) throws SQLException {
            // verify row values
            assertThat(rs.getLong("msg_id"), is(1L));
            assertThat((int) rs.getShort("failed_count"), is(1));
            assertThat(rs.getTimestamp("last_update_timestamp"), notNullValue());
            assertThat(MsgStateEnum.valueOf(rs.getString("state")), is(MsgStateEnum.PARTLY_FAILED));

            return new Message();
        }
    });
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »