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:com.sfs.dao.UserDAOImpl.java

/**
 * Load the cached user details./*from   w  w  w .  ja  v a 2  s  . com*/
 *
 * @param dn the distinguished name of the user
 *
 * @return the user bean
 *
 * @throws SFSDaoException the SFS dao exception
 */
public final UserBean loadCached(final String dn) throws SFSDaoException {

    UserBean cachedUser = null;
    try {
        // Create a new entry as none exists...
        cachedUser = (UserBean) this.getJdbcTemplateReader().queryForObject(this.getSQL().getValue("user/load"),
                new Object[] { dn }, new RowMapper() {
                    public Object mapRow(final ResultSet rs, final int rowNum) throws SQLException {
                        UserBean loadedUser = new UserBean();
                        loadedUser.setDN(rs.getString("UserDn"));
                        loadedUser.setPreferredName(rs.getString("FirstName"));
                        loadedUser.setLastName(rs.getString("LastName"));
                        loadedUser.setEmail(rs.getString("Email"));

                        return loadedUser;
                    }
                });

    } catch (IncorrectResultSizeDataAccessException ie) {
        dataLogger.debug("No results found for this search: " + ie.getMessage());
    }
    return cachedUser;
}

From source file:org.gridobservatory.greencomputing.dao.MachineDao.java

@Override
public Machine findById(BigInteger id) {
    return this.getJdbcTemplate().queryForObject(
            "select machine_id, room_id, motherboard_id, middleware_id, date_created, date_retired from machine where machine_id = ?",
            new Object[] { id }, new RowMapper<Machine>() {
                @Override/*www  . ja v a 2 s  . c o  m*/
                public Machine mapRow(ResultSet rs, int rowNum) throws SQLException {
                    int i = 1;
                    Machine machine = new Machine();
                    machine.setMachineID(rs.getBigDecimal(i++).toBigIntegerExact());

                    machine.setRoom(new Room());
                    machine.getRoom().setRoomID(rs.getBigDecimal(i++).toBigIntegerExact());

                    machine.setMotherboard(new Motherboard());
                    machine.getMotherboard().setMotherboardID(rs.getBigDecimal(i++).toBigIntegerExact());

                    machine.setMiddleware(new Middleware());
                    machine.getMiddleware().setMiddlewareID(rs.getBigDecimal(i++).toBigIntegerExact());

                    machine.setDateCreated(BigInteger.valueOf(rs.getTimestamp(i++).getTime()));

                    return machine;
                }
            });
}

From source file:com.havoc.hotel.admin.dao.impl.UserDAOImpl.java

@Override
public List<User> getALL() throws SQLException {
    return jdbcTemplate.query(SQLConstant.USER_GETALL, new RowMapper<User>() {
        @Override//w ww . ja va  2  s.c  o m
        public User mapRow(ResultSet rs, int i) throws SQLException {
            return mapData(rs);
        }
    });
}

From source file:org.terasoluna.gfw.functionaltest.domain.service.download.DownloadServiceImpl.java

@Override
public InputStream findContentsById(int documentId) {
    InputStream contentsStream = jdbcTemplate.queryForObject(FIND_CONTENTS_BY_ID,
            Collections.singletonMap("documentId", documentId), new RowMapper<InputStream>() {
                public InputStream mapRow(ResultSet rs, int i) throws SQLException {
                    InputStream blobStream = lobHandler.getBlobAsBinaryStream(rs, "contents");
                    return blobStream;
                }// w  w  w.java 2 s. c om
            });
    return contentsStream;
}

From source file:repository.ItemsDAO.java

public List<Items> getItemsList() {
    return template.query("SELECT * FROM items", new RowMapper<Items>() {
        public Items mapRow(ResultSet rs, int row) throws SQLException {
            Items a = new Items();
            a.setItemcode(rs.getInt("itemcode"));
            a.setDescription(rs.getString("description"));
            a.setCost(rs.getInt("cost"));
            return a;
        }/*from   w  w  w. jav a 2s.co m*/
    });
}

From source file:com.butler.service.OrderDao.java

public List<OrderDetails> getPendingOrders() {
    String sql = "select name, o.number, address, o.feedback,o.product, o.quantity, o.immediate,o.stamp as time from orders o,(select name,address,number from user)as y where o.number = y.number and o.status='TODO' order by time desc";
    //return this.getJdbcTemplate().queryForList(sql, OrderDetails.class);
    return this.getJdbcTemplate().query(sql, new RowMapper() {

        public Object mapRow(ResultSet rs, int i) throws SQLException {
            OrderDetails details = new OrderDetails();
            details.setName(rs.getString("name"));
            details.setNumber(rs.getString("number"));
            details.setAddress(rs.getString("address"));
            details.setProduct(rs.getString("product"));
            details.setQuantity(rs.getString("quantity"));
            Timestamp time = rs.getTimestamp("time");
            details.setTime(Util.getIndianTime(time));
            details.setFeedback(rs.getString("feedback"));
            details.setImmediate(rs.getBoolean("immediate"));
            return details;
        }/*  w  w w. ja va  2 s  .co m*/
    });
}

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

@Override
public List<Product> getALL(boolean inStock) throws SQLException, ClassNotFoundException {
    String sql = "SELECT * FROM tbl_product WHERE 1=1";

    if (inStock) {
        sql += " AND status=1 ";
    }//from   ww w .  jav  a 2s  .c  o  m
    return jdbcTemplate.query(sql, new RowMapper<Product>() {

        @Override
        public Product mapRow(ResultSet rs, int i) throws SQLException {
            Product p = new Product();
            p.setId(rs.getInt("product_id"));
            p.setProductName(rs.getString("product_name"));
            p.setCostPrice(rs.getInt("cost_price"));
            p.setSellingPrice(rs.getInt("selling_price"));
            p.setDiscount(rs.getBigDecimal("discount"));
            p.setQuantity(rs.getInt("quantity"));
            p.setCategoryName(rs.getString("category_name"));
            p.setSupplierId(rs.getInt("supplier_id"));
            p.setAddedDate(rs.getDate("added_date"));
            p.setModifiedDate(rs.getDate("modified_date"));
            p.setStatus(rs.getBoolean("status"));

            return p;
        }
    });
}

From source file:org.trendafilov.odesk.notifier.dao.CacheStateDao.java

public Collection<Job> getAll() {
    return jdbcTemplate.query(SELECT_ALL, new RowMapper<Job>() {
        @Override/*from  ww w  .  j  ava 2s .  co m*/
        public Job mapRow(ResultSet rs, int arg1) throws SQLException {
            return new Job("", "", rs.getString("ID")) {
            };
        }
    });
}

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

public Book find(final Integer id) {
    return jdbcTemplate.queryForObject(FIND_BOOK_BY_ID, new Object[] { id }, 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(id);/*from  ww w . j av  a  2s.c  om*/
            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 source file:com.sfs.dao.ListManagerDAOImpl.java

/**
 * Load the list manager bean./*from  w w  w .ja v a2s  . c  o  m*/
 *
 * @return the list manager bean
 *
 * @throws SFSDaoException the SFS dao exception
 */
@SuppressWarnings("unchecked")
public final ListManagerBean load() throws SFSDaoException {

    ListManagerBean listManager = new ListManagerBean();

    try {
        Collection<ListTypeBean> options = this.getJdbcTemplateReader()
                .query(this.getSQL().getValue("listmanager/load"), new RowMapper() {
                    public Object mapRow(final ResultSet rs, final int rowNum) throws SQLException {
                        ListTypeBean lt = new ListTypeBean();

                        lt.setObjectType(rs.getString("ObjectType"));
                        lt.setClassName(rs.getString("ClassName"));
                        lt.setInstanceName(rs.getString("InstanceName"));
                        lt.setAbbreviation(rs.getString("Abbreviation"));
                        lt.setDescription(rs.getString("Description"));
                        lt.setValue(rs.getString("Value"));
                        lt.setSecurity(rs.getString("Security"));
                        lt.setLdapMapping(1, rs.getString("LdapMapping"));
                        lt.setLdapMapping(2, rs.getString("SecondLdapMapping"));
                        lt.setLdapMapping(3, rs.getString("ThirdLdapMapping"));
                        lt.setListType(rs.getString("ListType"));

                        return lt;
                    }
                });

        listManager.setListTypes(options);

    } catch (IncorrectResultSizeDataAccessException ie) {
        dataLogger.debug("No results found for this search: " + ie.getMessage());
    }
    return listManager;
}