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.epam.repository.author.AuthorRepository.java

public Author find(final Integer id) {
    return jdbcTemplate.queryForObject(FIND_AUTHOR_BY_ID, new Object[] { id }, new RowMapper<Author>() {
        public Author mapRow(ResultSet rs, int rowNum) throws SQLException {
            Author author = new Author();
            author.setId(id);/*  w  w  w.j a v  a2 s . c  o m*/
            author.setName(rs.getString("Name"));
            author.setSurname(rs.getString("Surname"));
            return author;
        }
    });
}

---

From source file:com.leapfrog.project.DAO.Impl.ProductDAOImpl.java

@Override
public List<Product> getById(int id) throws SQLException, ClassNotFoundException {

    String sql = "SELECT * FROM product WHERE id=?";

    return jdbcTemplate.query(sql, new RowMapper<Product>() {
        @Override/*  w  ww .  jav  a 2 s. c o m*/
        public Product mapRow(ResultSet rs, int i) throws SQLException {

            Product p = new Product();
            p.setId(rs.getInt("id"));
            p.setName(rs.getString("name"));
            p.setDescription(rs.getString("description"));
            p.setCostPrice(rs.getInt("costPrice"));
            p.setSellingPrice(rs.getInt("sellingPrice"));

            return p;
        }
    }, new Object[] { id });

}

---

From source file:net.firejack.platform.core.config.installer.database.MySqlDatabaseManager.java

@Override
public boolean dropDatabase(Database database) {
    DataSource dataSource = getDataSource(database);
    List<String> tables = query(dataSource, "SHOW TABLES;", new RowMapper<String>() {
        @Override/*from   w w  w .  ja  va  2  s.co m*/
        public String mapRow(ResultSet rs, int rowNum) throws SQLException {
            return rs.getString(1);
        }
    });
    return tables.isEmpty() && executeStatement(dataSource,
            "DROP DATABASE IF EXISTS " + StringUtils.wrapWith("`", database.getUrlPath()) + ";");
}

---

From source file:com.digitalchalk.social.googleplus.webtest.common.JdbcAccountRepository.java

@Override
public Account findAccountByUsername(String username) {
    return jdbcTemplate.queryForObject("select username, firstName, lastName from Account where username = ?",
            new RowMapper<Account>() {
                @Override/*from w w w .j  av  a 2 s.  c o m*/
                public Account mapRow(ResultSet rs, int rowNum) throws SQLException {
                    return new Account(rs.getString("username"), null, rs.getString("firstName"),
                            rs.getString("lastName"));
                }
            }, username);
}

---

From source file:com.ewcms.component.rss.dao.RssDAO.java

public List<Item> findItemByChannel(Integer id, Integer row) {
    String sql = "Select t2.title,t2.url,t2.summary,t2.published From content_article_main t1,content_article t2 "
            + " Where t1.article_id = t2.id And t1.channel_id = ? "
            + " And t2.published < now() And t2.status='RELEASE' " + " Order By t2.published Desc Limit ? ";

    return jdbcTemplate.query(sql, new Object[] { id, row }, new RowMapper<Item>() {

        @Override/*from   w w  w .  ja v  a  2 s .  co  m*/
        public Item mapRow(ResultSet rs, int rowNum) throws SQLException {
            Item item = new Item();
            item.setTitle(rs.getString("title"));
            item.setUrl(rs.getString("url"));
            item.setDescription(rs.getString("summary"));
            item.setPublished(rs.getDate("published"));

            return item;
        }
    });
}

---

From source file:com.xinferin.dao.DAOActivationImpl.java

@Override
public List<Activation> list() {
    String sql = "SELECT * FROM activation";
    List<Activation> list = jdbcTemplate.query(sql, new RowMapper<Activation>() {
        @Override//w  ww  .  j a v  a  2s  .co  m
        public Activation mapRow(ResultSet rs, int rowNum) throws SQLException {
            Activation aActivation = new Activation();

            aActivation.setLicence_id(rs.getInt("licence_id"));
            aActivation.setDate(rs.getDate("date"));
            aActivation.setMachine_code(rs.getString("machine_code"));
            aActivation.setIpaddress(rs.getString("ipaddress"));
            aActivation.setSuccess(rs.getInt("success"));

            return aActivation;
        }
    });
    return list;
}

---

From source file:act.reports.dao.NoAbandonedVehicleDAO.java

public NoAbandonedVehicle getNoAbandonedVehicle() {
    logger.info("In NoAbandonedVehicleDAO-getNoAbandonedVehicle()...");
    List<NoAbandonedVehicleDetails> noAbandonedVehicleDetailsList = null;
    List<NoAbandonedVehicleDetails> noAbandonedVehicleDetailsListFinal = new ArrayList<NoAbandonedVehicleDetails>();
    NoAbandonedVehicle noAbandonedvehicle = new NoAbandonedVehicle();

    try {/*w  w  w.  j a v a2 s  . c o m*/
        final String currentDate = DateUtility.getCurrentMysqlDateTime();

        String noabandonedquery = "select distinct a.name,i.reason,i.dropOffTime,i.dropOffLocation,sc.callCreatedTime,ib.PoliceHoldOnce,iv.invoiceId,iv.vehicle_Year,iv.vehicle_Make,iv.vehicle_Model,"
                + "iv.vehicle_VIN,iv.vehicle_Plate_No from Account a,ServiceCallInfo sc,Invoice i,Invoice_Vehicle iv LEFT OUTER JOIN Invoice_Billing ib ON iv.invoiceId=ib.invoiceId LEFT OUTER JOIN "
                + "Invoice_TitleProcess it ON it.avrDate='' where iv.isImpound='1' and a.idAccount=i.accountId and i.serviceCallId=sc.serviceCallId and i.invoiceId=iv.invoiceId order by iv.invoiceId";

        noAbandonedVehicleDetailsList = jdbcTemplate.query(noabandonedquery, new Object[] {},
                new RowMapper<NoAbandonedVehicleDetails>() {

                    public NoAbandonedVehicleDetails mapRow(ResultSet rs, int rowNum) throws SQLException {

                        NoAbandonedVehicleDetails noAbandonedVehicleDetails = new NoAbandonedVehicleDetails();
                        noAbandonedVehicleDetails
                                .setAccount((rs.getString("name") != null) ? rs.getString("name") : "");
                        noAbandonedVehicleDetails
                                .setReason((rs.getString("reason") != null) ? rs.getString("reason") : "");
                        noAbandonedVehicleDetails.setDropOffTime(
                                (rs.getString("dropOffTime") != null) ? rs.getString("dropOffTime") : "");
                        noAbandonedVehicleDetails.setLotLocation(
                                (rs.getString("dropOffLocation") != null) ? rs.getString("dropOffLocation")
                                        : "");

                        String serviceCalldate = rs.getString("callCreatedTime") != null
                                ? rs.getString("callCreatedTime")
                                : "";
                        if (!serviceCalldate.trim().isEmpty())
                            /*serviceCalldate=DateUtility.convertToDateTimeFormat(serviceCalldate);
                            serviceCalldate=serviceCalldate.substring(0, 10);*/
                            noAbandonedVehicleDetails.setServiceCallDate(
                                    DateUtility.convertToDateTimeFormat(serviceCalldate).substring(0, 10));
                        else
                            noAbandonedVehicleDetails.setServiceCallDate(serviceCalldate);

                        noAbandonedVehicleDetails.setPoliceHoldOnce(
                                (rs.getString("PoliceHoldOnce") != null) ? rs.getString("PoliceHoldOnce") : "");
                        noAbandonedVehicleDetails.setInvoice(
                                (rs.getString("invoiceId") != null) ? rs.getString("invoiceId") : "");
                        noAbandonedVehicleDetails.setYear(
                                (rs.getString("vehicle_Year") != null) ? rs.getString("vehicle_Year") : "");
                        noAbandonedVehicleDetails.setMake(
                                (rs.getString("vehicle_Make") != null) ? rs.getString("vehicle_Make") : "");
                        noAbandonedVehicleDetails.setModel(
                                (rs.getString("vehicle_Model") != null) ? rs.getString("vehicle_Model") : "");
                        noAbandonedVehicleDetails.setVin(
                                (rs.getString("vehicle_VIN") != null) ? rs.getString("vehicle_VIN") : "");
                        noAbandonedVehicleDetails.setLicensePlate(
                                (rs.getString("vehicle_Plate_No") != null) ? rs.getString("vehicle_Plate_No")
                                        : "");

                        String daysInStorage = " ";
                        if (!serviceCalldate.trim().isEmpty()) {
                            String daysinStorageQry = "SELECT TIMESTAMPDIFF(DAY,'" + serviceCalldate + "','"
                                    + currentDate + "')";
                            daysInStorage = jdbcTemplate.queryForObject(daysinStorageQry, String.class);
                            logger.info("daysInStorage : " + daysInStorage);
                        }
                        noAbandonedVehicleDetails.setDaysInStorage(daysInStorage);

                        return noAbandonedVehicleDetails;
                    }
                });

        for (int i = 0; i < noAbandonedVehicleDetailsList.size(); i++) {
            NoAbandonedVehicleDetails noAbandonedVehicleDetails = noAbandonedVehicleDetailsList.get(i);
            int daysDiff = 0;
            String policeHoldOnce = noAbandonedVehicleDetails.getPoliceHoldOnce();
            String dropOffTime = noAbandonedVehicleDetails.getDropOffTime();
            if (!dropOffTime.trim().isEmpty()) {
                String daysDiffQry = "SELECT TIMESTAMPDIFF(DAY,'" + dropOffTime + "','" + currentDate + "')";
                daysDiff = jdbcTemplate.queryForObject(daysDiffQry, Integer.class);
                logger.info("daysDiff = " + daysDiff);
            }
            if (policeHoldOnce.equalsIgnoreCase("1") && daysDiff > 40)
                noAbandonedVehicleDetailsListFinal.add(noAbandonedVehicleDetails);
            else if (policeHoldOnce.equalsIgnoreCase("0") && daysDiff > 10)
                noAbandonedVehicleDetailsListFinal.add(noAbandonedVehicleDetails);
        }

        noAbandonedvehicle.setNoAbandonedVehicleDetails(noAbandonedVehicleDetailsListFinal);
        noAbandonedvehicle.setTotalVehicles(Integer.toString(noAbandonedVehicleDetailsList.size()));

    } catch (Exception e) {
        logger.error(e);
        e.printStackTrace();
    }
    return noAbandonedvehicle;
}

---

From source file:com.acme.spring.jdbc.JdbcTestHelper.java

/**
 * <p>Retrieves all the stocks from database, using passed {@link JdbcTemplate}.</p>
 *
 * @param jdbcTemplate the jdbc template to use
 *
 * @return list of stocks retrieved from database
 *//*from w  w w .jav a 2  s. c  o  m*/
public static List<Stock> retrieveAllStocks(JdbcTemplate jdbcTemplate) {

    return jdbcTemplate.query("select id, name, symbol, value, date from Stock order by name",
            new RowMapper<Stock>() {
                public Stock mapRow(ResultSet rs, int rowNum) throws SQLException {

                    int index = 1;

                    Stock result = new Stock();
                    result.setId(rs.getLong(index++));
                    result.setName(rs.getString(index++));
                    result.setSymbol(rs.getString(index++));
                    result.setValue(rs.getBigDecimal(index++));
                    result.setDate(rs.getDate(index++));

                    return result;
                }
            });
}

---

From source file:com.javacodegags.waterflooding.model.FloodingImplemented.java

@Override
public List<Flooding> getList() {
    String sql = "SELECT * FROM flooding ;";
    List<Flooding> flooding = jdbcTemplate.query(sql, new RowMapper<Flooding>() {
        @Override/*from ww w . j a va 2  s. c  o m*/
        public Flooding mapRow(ResultSet rs, int i) throws SQLException {
            Flooding flooding = new Flooding();

            flooding.setId(rs.getInt("id"));
            flooding.setName(rs.getString("name"));
            flooding.setImage(rs.getString("image"));
            flooding.setDescription(rs.getString("description"));
            return flooding;
        }
    });
    return flooding;
}

---

From source file:com.sfs.dao.UserPreferencesDAOImpl.java

/**
 * Load the UserPreferencesBean for the supplied dn.
 *
 * @param dn the dn/*from   w  w w  .  j  av  a2s . c o m*/
 *
 * @return the user preferences bean
 *
 * @throws SFSDaoException the SFS dao exception
 */
@SuppressWarnings("unchecked")
public final UserPreferencesBean load(final String dn) throws SFSDaoException {
    if (dn == null) {
        throw new SFSDaoException("Error: DN cannot be null");
    }
    if (dn.compareTo("") == 0) {
        throw new SFSDaoException("Error: DN cannot be an empty string");
    }

    UserPreferencesBean userPreferences = new UserPreferencesBean();
    userPreferences.setDN(dn);

    dataLogger.info("Loading privileges for: " + dn);

    try {
        Collection<String[]> indexValue = this.getJdbcTemplateReader().query(
                this.getSQL().getValue("userPreferences/load"), new Object[] { userPreferences.getDN() },
                new RowMapper() {
                    public Object mapRow(final ResultSet rs, final int rowNum) throws SQLException {
                        final String index = rs.getString("IndexValue");
                        final String value = rs.getString("Value");

                        return new String[] { index, value };
                    }
                });

        for (String[] keyPair : indexValue) {
            if (keyPair[0] != null) {
                userPreferences.setOption(keyPair[0], keyPair[1]);
            }
        }

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

---

• «
• 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
• »