本文整理汇总了Java中org.easyrec.store.dao.BaseRecommendationDAO类的典型用法代码示例。如果您正苦于以下问题：Java BaseRecommendationDAO类的具体用法？Java BaseRecommendationDAO怎么用？Java BaseRecommendationDAO使用的例子？那么, 这里精选的类代码示例或许可以为您提供帮助。
BaseRecommendationDAO类属于org.easyrec.store.dao包，在下文中一共展示了BaseRecommendationDAO类的1个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: getRecommendedItemIteratorQueryString
import org.easyrec.store.dao.BaseRecommendationDAO; //导入依赖的package包/类
protected String getRecommendedItemIteratorQueryString(TimeConstraintVO timeConstraints,
ArgsAndTypesHolder holder) {
String recAlias = "rec";
String recItemAlias = "recItem";
// join with recommendation (to retrieve tenantId)
StringBuilder sqlString = new StringBuilder("SELECT ");
sqlString.append(recItemAlias);
sqlString.append(".*, ");
sqlString.append(recAlias);
sqlString.append(".");
sqlString.append(RecommendationDAO.DEFAULT_RECOMMENDATION_TIME_COLUMN_NAME);
sqlString.append(", ");
sqlString.append(recAlias);
sqlString.append(".");
sqlString.append(RecommendationDAO.DEFAULT_TENANT_COLUMN_NAME);
sqlString.append(" FROM ");
sqlString.append(DEFAULT_TABLE_NAME);
sqlString.append(" AS ");
sqlString.append(recItemAlias);
sqlString.append(", ");
sqlString.append(RecommendationDAO.DEFAULT_TABLE_NAME);
sqlString.append(" AS ");
sqlString.append(recAlias);
sqlString.append(" WHERE ");
sqlString.append(recItemAlias);
sqlString.append(".");
sqlString.append(DEFAULT_RECOMMENDATION_COLUMN_NAME);
sqlString.append("=");
sqlString.append(recAlias);
sqlString.append(".");
sqlString.append(RecommendationDAO.DEFAULT_ID_COLUMN_NAME);
if (timeConstraints.getDateFrom() != null) {
sqlString.append(" AND ");
sqlString.append(BaseRecommendationDAO.DEFAULT_RECOMMENDATION_TIME_COLUMN_NAME);
sqlString.append(" >= ?");
holder.getArgs()[0] = timeConstraints.getDateFrom();
if (timeConstraints.getDateTo() != null) {
sqlString.append(" AND ");
sqlString.append(BaseRecommendationDAO.DEFAULT_RECOMMENDATION_TIME_COLUMN_NAME);
sqlString.append(" <= ?");
holder.setArgs(ObjectArrays.concat(holder.getArgs(), timeConstraints.getDateTo()));
holder.setArgTypes(Ints.concat(holder.getArgTypes(), new int[] { Types.TIMESTAMP }));
}
} else {
sqlString.append(" AND ");
sqlString.append(BaseRecommendationDAO.DEFAULT_RECOMMENDATION_TIME_COLUMN_NAME);
sqlString.append(" <= ?");
holder.getArgs()[0] = timeConstraints.getDateTo();
}
return sqlString.toString();
}