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

List of usage examples for org.springframework.jdbc.core RowMapper RowMapper

  1. HOME
  2. Java
  3. org.springframework
  4. org.springframework.jdbc.core.*
  5. RowMapper
  6. 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:eionet.meta.dao.mysql.SiteCodeDAOImpl.java

/**
 * {@inheritDoc}//  www.  j a  v a2s .c o  m
 */
@Override
public SiteCodeResult searchSiteCodes(SiteCodeFilter filter) {

    Map<String, Object> params = new HashMap<String, Object>();
    String sql = getSiteCodesSql(filter, params);

    List<SiteCode> resultList = getNamedParameterJdbcTemplate().query(sql.toString(), params,
            new RowMapper<SiteCode>() {
                @Override
                public SiteCode mapRow(ResultSet rs, int rowNum) throws SQLException {
                    SiteCode sc = new SiteCode();
                    sc.setId(rs.getInt("vc.VOCABULARY_CONCEPT_ID"));
                    sc.setIdentifier(rs.getString("vc.IDENTIFIER"));
                    sc.setLabel(rs.getString("vc.LABEL"));
                    sc.setDefinition(rs.getString("vc.DEFINITION"));
                    sc.setNotation(rs.getString("vc.NOTATION"));
                    sc.setSiteCodeStatus(SiteCodeStatus.valueOf(rs.getString("sc.STATUS")));
                    sc.setCountryCode(rs.getString("sc.CC_ISO2"));
                    sc.setDateCreated(rs.getTimestamp("sc.DATE_CREATED"));
                    sc.setUserCreated(rs.getString("sc.USER_CREATED"));
                    sc.setDateAllocated(rs.getTimestamp("sc.DATE_ALLOCATED"));
                    sc.setUserAllocated(rs.getString("sc.USER_ALLOCATED"));
                    sc.setInitialSiteName(rs.getString("sc.INITIAL_SITE_NAME"));
                    sc.setYearsDeleted(rs.getString("sc.YEARS_DELETED"));
                    sc.setYearsDisappeared(rs.getString("sc.YEARS_DISAPPEARED"));
                    return sc;
                }
            });

    String totalSql = "SELECT FOUND_ROWS()";
    int totalItems = getJdbcTemplate().queryForInt(totalSql);

    SiteCodeResult result = new SiteCodeResult(resultList, totalItems, filter);

    return result;
}

From source file:org.vaadin.spring.sample.security.account.JdbcAccountRepository.java

public Account findAccountByUsername(String username) {
    return jdbcTemplate.queryForObject(
            "select username, password, firstName, lastName, role from Account where username = ?",
            new RowMapper<Account>() {
                public Account mapRow(ResultSet rs, int rowNum) throws SQLException {
                    return new Account(rs.getString("username"), rs.getString("password"),
                            rs.getString("firstName"), rs.getString("lastName"), rs.getString("role"));
                }//from  w  ww .j  av a2 s .  com
            }, username);
}

From source file:dao.CircleDAO.java

public List<Posts> getPosts(int circleId) {
    String q = "SELECT PageId FROM hasa\nWHERE CircleId = " + circleId;
    String query = "SELECT PostId FROM contains" + " WHERE PageId = (" + q + ");";

    List<Posts> posts = this.jdbcTemplate.query(query, new RowMapper<Posts>() {
        @Override/* w w w . j av a  2  s .  co  m*/
        public Posts mapRow(ResultSet rs, int rowNum) throws SQLException {
            Posts post = new Posts();
            post.setPostID(rs.getInt("PostId"));
            setPostData(post);
            post.setComments(getComments(post.getPostID()));

            return post;

        }
    });

    return posts;
}

From source file:com.leapfrog.inventorymanagementsystem.dao.impl.SupplierDAOImpl.java

@Override
public Supplier getById(int id) throws SQLException, ClassNotFoundException {
    String sql = "SELECT * FROM tbl_supplier WHERE supplier_id =?";
    return jdbcTemplate.queryForObject(sql, new Object[] { id }, new RowMapper<Supplier>() {

        @Override/*  w  w w  .jav  a2 s. co  m*/
        public Supplier mapRow(ResultSet rs, int i) throws SQLException {
            Supplier s = new Supplier();
            s.setId(rs.getInt("supplier_id"));
            s.setSupplierName(rs.getString("supplier_name"));
            s.setAddress(rs.getString("address"));
            s.setContact(rs.getString("contact"));
            s.setEmail(rs.getString("email"));
            s.setAddedDate(rs.getDate("added_date"));
            s.setStatus(rs.getBoolean("status"));
            return s;
        }
    });
}

From source file:com.abcd.employeemaven.dao.impl.DepartmentDaoImpl.java

@Override
public List<Department> getAll() {
    return jdbcTemplate.query(DepartmentSQL.GETALL, new RowMapper<Department>() {
        @Override//w  w  w.  jav a2 s  .  c  om
        public Department mapRow(ResultSet rs, int i) throws SQLException {
            return mapData(rs);
        }
    });
}

From source file:org.smigo.comment.JdbcCommentDao.java

@Override
public List<Comment> getComments(String receiver) {
    return jdbcTemplate.query(SELECT, new Object[] { receiver }, new RowMapper<Comment>() {
        @Override/*w  w  w .  j a  v a2s  .c  o  m*/
        public Comment mapRow(ResultSet rs, int rowNum) throws SQLException {
            return new Comment(rs.getInt("ID"), rs.getString("TEXT"), rs.getString("SUBMITTER"),
                    rs.getInt("YEAR"), rs.getDate("CREATEDATE"), rs.getBoolean("UNREAD"));
        }
    });
}

From source file:CRM.repository.InteractionsDAO.java

public List<interactions> getInteractionsList() {
    return template.query("SELECT * FROM interactions", new RowMapper<interactions>() {
        @Override/*ww w . j  a v  a  2s  .  c o m*/
        public interactions mapRow(ResultSet rs, int row) throws SQLException {
            interactions i = new interactions();
            i.setInteraction_id(rs.getInt("interaction_id"));
            i.setFirst_name(rs.getString("first_name"));
            i.setLast_name(rs.getString("last_name"));
            i.setNotes(rs.getString("notes"));

            return i;

        }
    });
}

From source file:com.epam.repository.book.BookRepository.java

public List<Book> findAll() {
    List<Book> books = jdbcTemplate.query(GET_ALL_BOOKS, new RowMapper<Book>() {
        public Book mapRow(ResultSet rs, int rowNum) throws SQLException {
            Book book = new Book();
            int authorID = rs.getInt("Author");
            int genreID = rs.getInt("Genre");
            book.setId(rs.getInt("ID"));
            book.setGenre(new Genre(genreID, null));
            book.setStock(rs.getInt("Stock"));
            book.setAuthor(new Author(authorID, null, null));
            book.setTitle(rs.getString("Title"));
            return book;
        }/*from   w  ww .  j  a va 2s  .  c o  m*/
    });
    return books;
}

From source file:bd.gov.forms.dao.ListDaoImpl.java

public ListData getListData(String sysId) {
    return (ListData) jdbcTemplate.queryForObject("SELECT * FROM list_data WHERE sys_id = ?",
            new Object[] { sysId }, new RowMapper() {

                public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
                    ListData list = new ListData();

                    list.setId(rs.getInt("id"));
                    list.setSysId(rs.getString("sys_id"));
                    list.setName(rs.getString("name"));
                    list.setDetail(rs.getString("detail"));
                    list.setValues(rs.getString("list_values"));

                    return list;
                }/*from w w w.ja  v  a2s .  co m*/
            });
}

From source file:org.ohmage.query.impl.SurveyResponseImageQueries.java

public List<UUID> getImageIdsFromSurveyResponse(UUID surveyResponseId) throws DataAccessException {
    try {// w  w  w.  ja v  a 2s  . c  o m
        return getJdbcTemplate().query(SQL_GET_IMAGE_IDS_FROM_SURVEY_RESPONSE,
                new Object[] { surveyResponseId.toString() }, new RowMapper<UUID>() {
                    @Override
                    public UUID mapRow(ResultSet rs, int rowNum) throws SQLException {

                        String response = rs.getString("response");
                        try {
                            return UUID.fromString(response);
                        } catch (IllegalArgumentException notUuid) {
                            try {
                                NoResponse.valueOf(response.toUpperCase());
                                return null;
                            } catch (IllegalArgumentException notNoResponse) {
                                throw new SQLException("The response value is not a valid UUID.",
                                        notNoResponse);
                            }
                        }
                    }
                });
    } catch (org.springframework.dao.DataAccessException e) {
        throw new DataAccessException("Error executing SQL '" + SQL_GET_IMAGE_IDS_FROM_SURVEY_RESPONSE
                + "' with parameter: " + surveyResponseId, e);
    }
}