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:act.reports.dao.StorageLocationCurrentInventoryDAO.java

public List<StorageLocationCurrentInventoryDetails> getStorageLocationCurrentInventoryDetails(
        SearchCriteria criteria) {/*from   w  w  w  . jav a2s . c  o m*/
    logger.info("In StorageLocationCurrentInventoryDAO-getStorageLocationCurrentInventoryDetails()...");
    List<StorageLocationCurrentInventoryDetails> storageLocationCurrentInventoryDetailsList = null;
    List<StorageLocationCurrentInventoryDetails> storageLocationCurrentInventoryDetailsListNew = new ArrayList<StorageLocationCurrentInventoryDetails>();
    String ageRangeStart = "";
    String ageRangeEnd = "";
    try {
        ageRangeStart = criteria.getAgeRangeStart();
        ageRangeEnd = criteria.getAgeRangeEnd();
        logger.info("ageRangeStart = " + ageRangeStart);
        logger.info("ageRangeEnd = " + ageRangeEnd);
        final String lotLocation = criteria.getLocation();
        logger.info("lotLocation = " + lotLocation);
        String locationDetailsqQery = "";

        if (lotLocation.trim().equalsIgnoreCase("all")) {
            /*locationDetailsqQery = "select a.name,sc.callCreatedTime,i.invoiceId,i.reason,i.dropOffLocation,iv.vehicle_Year,iv.vehicle_Make,iv.vehicle_Model,iv.vehicle_VIN,iv.vehicle_Country,iv.vehicle_State,iv.vehicle_Plate_No "
                      + "from Account a,ServiceCallInfo sc,Invoice i LEFT OUTER JOIN Invoice_Vehicle iv ON i.invoiceId=iv.invoiceId where i.isImpound='1' and a.idAccount=i.accountId and sc.serviceCallId=i.serviceCallId";*/

            locationDetailsqQery = "select a.name,sc.callCreatedTime,i.invoiceId,i.reason,i.dropOffLocation,iv.vehicle_Year,iv.vehicle_Make,iv.vehicle_Model,iv.vehicle_VIN,iv.vehicle_Country,iv.vehicle_State,iv.vehicle_Plate_No from Invoice_Vehicle iv LEFT OUTER JOIN Invoice i ON "
                    + "i.invoiceId=iv.invoiceId LEFT OUTER JOIN Account a ON a.idAccount=i.accountId LEFT OUTER JOIN ServiceCallInfo sc ON sc.serviceCallId=i.serviceCallId where iv.isImpound='1' and i.dropOffLocation NOT IN ('Accounting','Dispatch','Payless')";
        } else {
            /*locationDetailsqQery = "select a.name,sc.callCreatedTime,i.invoiceId,i.reason,i.dropOffLocation,iv.vehicle_Year,iv.vehicle_Make,iv.vehicle_Model,iv.vehicle_VIN,iv.vehicle_Country,iv.vehicle_State,iv.vehicle_Plate_No from Account a," +
                      "ServiceCallInfo sc,Invoice i LEFT OUTER JOIN Invoice_Vehicle iv ON i.invoiceId=iv.invoiceId where i.isImpound='1' and i.dropOffLocation='"+lotLocation+"' and a.idAccount=i.accountId and sc.serviceCallId=i.serviceCallId";*/

            locationDetailsqQery = "select a.name,sc.callCreatedTime,i.invoiceId,i.reason,i.dropOffLocation,iv.vehicle_Year,iv.vehicle_Make,iv.vehicle_Model,iv.vehicle_VIN,iv.vehicle_Country,iv.vehicle_State,iv.vehicle_Plate_No from Invoice_Vehicle iv,Invoice i "
                    + "LEFT OUTER JOIN Account a ON a.idAccount=i.accountId LEFT OUTER JOIN ServiceCallInfo sc ON sc.serviceCallId=i.serviceCallId where i.dropOffLocation='"
                    + lotLocation + "' and iv.isImpound='1' and i.invoiceId=iv.invoiceId";
        }

        storageLocationCurrentInventoryDetailsList = jdbcTemplate.query(locationDetailsqQery, new Object[] {},
                new RowMapper<StorageLocationCurrentInventoryDetails>() {

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

                        StorageLocationCurrentInventoryDetails storageDetails = new StorageLocationCurrentInventoryDetails();
                        storageDetails.setInvoiceId(
                                (rs.getString("invoiceId") != null) ? rs.getString("invoiceId") : "");

                        String callCreatedTime = rs.getString("callCreatedTime") != null
                                ? rs.getString("callCreatedTime")
                                : "";
                        String serviceCalldate = "";
                        if (!callCreatedTime.trim().isEmpty()) {
                            serviceCalldate = DateUtility.convertToDateTimeFormat(callCreatedTime);
                            serviceCalldate = serviceCalldate.substring(0, 10);
                        }

                        storageDetails.setServiceCallDate(serviceCalldate);
                        storageDetails.setAccount((rs.getString("name") != null) ? rs.getString("name") : "");
                        storageDetails
                                .setReason((rs.getString("reason") != null) ? rs.getString("reason") : "");
                        storageDetails.setLotLocation(
                                (rs.getString("dropOffLocation") != null) ? rs.getString("dropOffLocation")
                                        : "");
                        storageDetails.setYear(
                                (rs.getString("vehicle_Year") != null) ? rs.getString("vehicle_Year") : "");
                        storageDetails.setMake(
                                (rs.getString("vehicle_Make") != null) ? rs.getString("vehicle_Make") : "");
                        storageDetails.setModel(
                                (rs.getString("vehicle_Model") != null) ? rs.getString("vehicle_Model") : "");
                        storageDetails.setVin(
                                (rs.getString("vehicle_VIN") != null) ? rs.getString("vehicle_VIN") : "");
                        storageDetails.setLicensePlateCountry(
                                (rs.getString("vehicle_Country") != null) ? rs.getString("vehicle_Country")
                                        : "");
                        storageDetails.setLicensePlateState(
                                (rs.getString("vehicle_State") != null) ? rs.getString("vehicle_State") : "");
                        storageDetails.setLicensePlate(
                                (rs.getString("vehicle_Plate_No") != null) ? rs.getString("vehicle_Plate_No")
                                        : "");

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

                        storageDetails.setMarkedForSalvage("");
                        return storageDetails;
                    }
                });
        if (!ageRangeStart.isEmpty() && !ageRangeEnd.isEmpty()) {
            for (int i = 0; i < storageLocationCurrentInventoryDetailsList.size(); i++) {
                StorageLocationCurrentInventoryDetails storageLocationCurrentInventoryDetails = storageLocationCurrentInventoryDetailsList
                        .get(i);
                int daysInStorage = Integer.parseInt(storageLocationCurrentInventoryDetails.getDaysInStorage());
                logger.info("daysInStorage = " + daysInStorage);
                if (daysInStorage > Integer.parseInt(ageRangeStart)
                        && daysInStorage <= Integer.parseInt(ageRangeEnd)) {
                    storageLocationCurrentInventoryDetailsListNew.add(storageLocationCurrentInventoryDetails);
                }
            }
            logger.info("storageLocationCurrentInventoryDetailsListNew.size() = "
                    + storageLocationCurrentInventoryDetailsListNew.size());
        }
    } catch (Exception e) {
        logger.error(e);
        e.printStackTrace();
    }

    if (!ageRangeStart.isEmpty() && !ageRangeEnd.isEmpty())
        return storageLocationCurrentInventoryDetailsListNew;
    else
        return storageLocationCurrentInventoryDetailsList;
}

From source file:net.algem.security.UserDaoImpl.java

@Override
public User find(String login) {
    String query = "SELECT l.idper,l.login,l.profil,per.nom,per.prenom,coalesce(prof.actif, false),coalesce(e.idper,0),coalesce(tech.idper,0)"
            + " FROM " + TABLE + " l INNER JOIN " + PersonIO.TABLE + " per ON (l.idper = per.id)"
            + " LEFT OUTER JOIN prof ON (l.idper = prof.idper)"
            + " LEFT OUTER JOIN eleve e ON (l.idper = e.idper)"
            + " LEFT OUTER JOIN technicien tech ON (l.idper = tech.idper)" + " WHERE trim(l.login) = ?";
    return jdbcTemplate.queryForObject(query, new RowMapper<User>() {
        @Override// w  ww .j  a  v a2 s.c om
        public User mapRow(ResultSet rs, int rowNum) throws SQLException {
            User u = new User();
            u.setId(rs.getInt(1));
            u.setLogin(getLoginFromStringResult(rs.getString(2)));
            u.setProfile(getProfileFromId(rs.getShort(3)));
            u.setName(rs.getString(4));
            u.setFirstName(rs.getString(5));
            u.setTeacher(rs.getBoolean(6));// active teachers only
            u.setStudent(rs.getInt(7) > 0);
            u.setTech(rs.getInt(8) > 0);

            return u;
        }
    }, login);

}

From source file:com.sfs.whichdoctor.dao.OnlineApplicationDAOImpl.java

/**
 * Used to get a OnlineApplicationBean for the the specified online application key.
 * Returns null if no online application found
 *
 * @param key the online application key
 * @param type the online application type
 *
 * @return the online application bean/*from w w  w .ja va2s  .  c  o  m*/
 *
 * @throws WhichDoctorDaoException the which doctor dao exception
 */
public final OnlineApplicationBean load(final String key, final String type) throws WhichDoctorDaoException {

    dataLogger.info("Online application key: " + key + " requested");

    OnlineApplicationBean onlineApplication = null;

    try {
        onlineApplication = (OnlineApplicationBean) this.getJdbcTemplateReader().queryForObject(
                this.getSQL().getValue("onlineapplication/loadKey"), new Object[] { key, type },
                new RowMapper() {
                    public Object mapRow(final ResultSet rs, final int rowNum) throws SQLException {
                        return loadOnlineApplicationBean(rs);
                    }
                });

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

From source file:shell.framework.cache.SystemCacheInitializer.java

/**
 * userRoleCache?//from  www . j  a  v  a  2s. co  m
 * ???(?idlist)
 * ?@SHELL??
 *  <id,ID>  => <user_id,roleIDs>  
 */
@SuppressWarnings("all")
public void userRoleInitial() {
    //?
    String sql = "select * from TBL_SYS_USER_ROLE";
    List<?> userRoleList = this.jdbcBaseDao.query(sql, new RowMapper<Object>() {
        String tempUserID = "";
        List<String> roleIDList = null;

        /* (non-Javadoc)
         * @see org.springframework.jdbc.core.RowMapper#mapRow(java.sql.ResultSet, int)
         */
        public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
            if (!tempUserID.equals(rs.getString("USER_ID"))) {
                tempUserID = rs.getString("USER_ID");
                roleIDList = new ArrayList<String>();
                CacheUtil.putValue(CacheUtil.USER_ROLE_CACHE, rs.getString("USER_ID"), roleIDList);
            }
            Object _roleIdList = CacheUtil.getValue(CacheUtil.USER_ROLE_CACHE, rs.getString("USER_ID"));
            if (_roleIdList != null) {
                ((List<String>) _roleIdList).add(rs.getString("ROLE_ID"));
            }
            return null;
        }
    });
    //?
    String depSQL = "select ud.USER_ID,rd.ROLE_ID from TBL_SYS_USER_DEPARTMENT ud join TBL_SYS_ROLE_DEPARTMENT rd on rd.DEPARTMENT_ID=ud.DEPARTMENT_ID";
    List<?> userDepRoleList = this.jdbcBaseDao.query(depSQL, new RowMapper<Object>() {
        String tempUserID = "";
        List<String> roleIDList = null;

        /* (non-Javadoc)
         * @see org.springframework.jdbc.core.RowMapper#mapRow(java.sql.ResultSet, int)
         */
        public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
            if (!tempUserID.equals(rs.getString("USER_ID"))) {
                tempUserID = rs.getString("USER_ID");
                //??
                if (CacheUtil.getValue(CacheUtil.USER_ROLE_CACHE, tempUserID) != null) {
                    roleIDList = (List) CacheUtil.getValue(CacheUtil.USER_ROLE_CACHE, tempUserID);
                    //??
                } else {
                    roleIDList = new ArrayList<String>();
                    CacheUtil.putValue(CacheUtil.USER_ROLE_CACHE, rs.getString("USER_ID"), roleIDList);
                }
            }
            //????????
            if (!roleIDList.contains(rs.getString("ROLE_ID"))) {
                roleIDList.add(rs.getString("ROLE_ID"));
            }
            return null;
        }
    });
}

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

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

        @Override//from   w w w. j a va 2s .c om
        public ProjectArticle mapRow(ResultSet rs, int rowNum) throws SQLException {
            return interactionRowMapper(rs);
        }
    });

    return list;
}

From source file:com.sfs.whichdoctor.dao.OnlineToolDAOImpl.java

/**
 * Loads an array of online tool beans for the supplied rotation GUID.
 *
 * @param rotationGUID the rotation GUID
 *
 * @return the collection< online tool bean>
 *
 * @throws WhichDoctorDaoException the which doctor dao exception
 *//*from   ww w  .j  a  va 2s  .c  o  m*/
@SuppressWarnings("unchecked")
public final Collection<OnlineToolBean> loadRotation(final int rotationGUID) throws WhichDoctorDaoException {

    Collection<OnlineToolBean> onlineTools = new ArrayList<OnlineToolBean>();

    try {
        onlineTools = this.getJdbcTemplateReader().query(this.getSQL().getValue("onlineTool/loadRotation"),
                new Object[] { rotationGUID }, new RowMapper() {
                    public Object mapRow(final ResultSet rs, final int rowNum) throws SQLException {
                        return loadOnlineTool(rs);
                    }
                });

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

    return onlineTools;
}

From source file:com.expedia.seiso.domain.repo.impl.ServiceInstanceRepoImpl.java

@Override
public List<BreakdownItem> getServiceInstanceHealthBreakdown(@NonNull Long id) {
    val mapper = new RowMapper<BreakdownItem>() {
        @Override/*  ww  w  . ja  v  a 2 s  .  c o m*/
        public BreakdownItem mapRow(ResultSet rs, int rowNum) throws SQLException {
            return new BreakdownItem(rs.getString(1), rs.getString(2), rs.getInt(3));
        }
    };
    return jdbcTemplate.query(HEALTH_BREAKDOWN_SQL, args(id), mapper);
}

From source file:com.sfs.whichdoctor.dao.IsbEntityDAOImpl.java

/**
 * Loads an IsbEntityBean for an identified target/guid combination. If none
 * found returns null/*from www .  j av  a 2  s  .  c om*/
 *
 * @param target the target
 * @param guid the guid
 *
 * @return the isb entity bean
 *
 * @throws WhichDoctorDaoException the which doctor dao exception
 */
public final IsbEntityBean load(final String target, final int guid) throws WhichDoctorDaoException {

    if (target == null) {
        throw new NullPointerException("The supplied target cannot be null");
    }

    dataLogger.info("ISB entities  for target: " + target + " requested");

    IsbEntityBean entity = null;

    try {
        entity = (IsbEntityBean) this.getJdbcTemplateReader().queryForObject(
                this.getSQL().getValue("isbentity/loadTargetId"), new Object[] { target, guid, true },
                new RowMapper() {
                    public Object mapRow(final ResultSet rs, final int rowNum) throws SQLException {
                        return loadIsbEntity(rs);
                    }
                });

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

From source file:cz.dasnet.dasik.plugin.WordCounter.java

private void resetDailyStats(String channel, Dasik bot) {
    bot.describe(channel, getTop10Daily(bot, 0));

    // copy daily spam stats to dailyspam table
    String sql = "SELECT id, words_daily FROM users WHERE words_daily > 0";
    List<DailyInfo> dailyInfo = bot.getUserDao().query(sql, new RowMapper<DailyInfo>() {

        public DailyInfo mapRow(ResultSet rs, int rowNum) throws SQLException {
            DailyInfo d = new DailyInfo();
            d.userId = rs.getInt(1);/*w  w w. ja  v  a2  s. c om*/
            d.wordsDaily = rs.getInt(2);
            return d;
        }
    });

    for (DailyInfo di : dailyInfo) {
        sql = "INSERT INTO dailyspam (user_id, date, words) VALUES (" + di.userId + ", " + lastUpdate + ", "
                + di.wordsDaily + ")";
        bot.getUserDao().update(sql);
    }

    // reset stats
    sql = "UPDATE users SET words_daily = 0";
    int rows = bot.getUserDao().update(sql);
    log.debug(rows + " users affected while reseting daily word stats");
    bot.getUserDao().invalidateCache();
}

From source file:com.ewcms.component.interaction.dao.InteractionDAO.java

@Override
public List<Organ> getOrganRootChildren() {
    String sql = "Select id,name From site_organ "
            + "Where parent_id In (select id From site_organ Where parent_id Is null) Order By id asc";
    return jdbcTemplate.query(sql, new RowMapper<Organ>() {

        @Override/*from  w w  w  .  j a v a 2 s  . c  om*/
        public Organ mapRow(ResultSet rs, int rowNum) throws SQLException {
            return organRowMapper(rs);
        }
    });
}