Java ItemDAO类代码示例

import org.easyrec.store.dao.core.ItemDAO; //导入依赖的package包/类
public TenantServiceImpl(TenantDAO tenantDAO, TenantConfigVO tenantConfig, ActionTypeDAO actionTypeDAO,
                         AggregateTypeDAO aggregateTypeDAO, AssocTypeDAO assocTypeDAO, ItemTypeDAO itemTypeDAO,
                         SourceTypeDAO sourceTypeDAO, ViewTypeDAO viewTypeDAO,
                         AuthenticationDAO authenticationDAO, ItemAssocDAO itemAssocDAO,
                         ActionDAO actionDAO, ItemDAO itemDAO) {
    this.tenantDAO = tenantDAO;
    this.defaultTenantConfig = tenantConfig;
    this.actionTypeDAO = actionTypeDAO;
    this.aggregateTypeDAO = aggregateTypeDAO;
    this.assocTypeDAO = assocTypeDAO;
    this.itemTypeDAO = itemTypeDAO;
    this.sourceTypeDAO = sourceTypeDAO;
    this.viewTypeDAO = viewTypeDAO;
    this.authenticationDAO = authenticationDAO;
    this.itemAssocDAO  = itemAssocDAO;
    this.actionDAO = actionDAO;
    this.itemDAO = itemDAO;
}
 

import org.easyrec.store.dao.core.ItemDAO; //导入依赖的package包/类
public EasyRec(OperatorDAO operatorDAO, RemoteTenantDAO remoteTenantDAO,
               ShopRecommenderService shopRecommenderService, TenantService tenantService,
               TypeMappingService typeMappingService, ItemDAO itemDAO, RemoteAssocService remoteAssocService,
               IDMappingDAO idMappingDAO,
               //added by FK on 2012-12-18 for enabling profile data in recommendations
               ProfileService profileService,
               ClusterService clusterService,
               String dateFormatString) {
    this.operatorDAO = operatorDAO;
    this.remoteTenantDAO = remoteTenantDAO;
    this.shopRecommenderService = shopRecommenderService;
    this.tenantService = tenantService;
    this.typeMappingService = typeMappingService;
    this.itemDAO = itemDAO;
    this.remoteAssocService = remoteAssocService;
    this.dateFormat = dateFormatString;
    this.profileService = profileService;
    this.idMappingDAO = idMappingDAO;
    this.clusterService = clusterService;
}
 

import org.easyrec.store.dao.core.ItemDAO; //导入依赖的package包/类
public AggregatorServiceImpl(TypeMappingService typeMappingService, TenantService tenantService, AggregatorActionDAO aggregatorActionDAO, JSONProfileServiceImpl jsonProfileService, ItemDAO itemDAO, IDMappingDAO idMappingDAO, ItemTypeDAO itemTypeDAO, AggregatorLogEntryDAO logEntryDAO, ActionTypeDAO actionTypeDAO) {
    this.typeMappingService = typeMappingService;
    this.tenantService = tenantService;
    this.aggregatorActionDAO = aggregatorActionDAO;
    this.jsonProfileService = jsonProfileService;
    this.itemDAO = itemDAO;   
    this.idMappingDAO = idMappingDAO;
    this.itemTypeDAO = itemTypeDAO;
    this.logEntryDAO = logEntryDAO;
    this.actionTypeDAO = actionTypeDAO;
}
 

import org.easyrec.store.dao.core.ItemDAO; //导入依赖的package包/类
@Override
public List<Item> getNonUserItems(SolrSimilarityConfigurationInt configuration) {
    
    Object[] args = {configuration.getTenantId(), SolrSimilarityGenerator.ITEMTYPE_USER, ClusterService.ITEMTYPE_CLUSTER};
    int[] argTypes = {Types.INTEGER, Types.VARCHAR, Types.VARCHAR};

    StringBuilder query  = new StringBuilder();
    query.append(" SELECT ID, TENANTID, ITEMID, ITEMTYPE, DESCRIPTION, PROFILEDATA, ACTIVE, CREATIONDATE ")
            .append(" FROM ").append(ItemDAO.DEFAULT_TABLE_NAME).append(" WHERE ").append(" TENANTID = ? ")
            .append(" AND ITEMTYPE NOT IN (?,?) AND ACTIVE=TRUE");

    return getJdbcTemplate().query(query.toString(), args, argTypes, itemRowMapper);

}
 

import org.easyrec.store.dao.core.ItemDAO; //导入依赖的package包/类
@Override
public List<Item> getUserItems(SolrSimilarityConfigurationInt configuration) {
    
    Object[] args = {configuration.getTenantId(), SolrSimilarityGenerator.ITEMTYPE_USER};
    int[] argTypes = {Types.INTEGER, Types.VARCHAR};

    StringBuilder query  = new StringBuilder();
    query.append(" SELECT ID, TENANTID, ITEMID, ITEMTYPE, DESCRIPTION, PROFILEDATA, ACTIVE, CREATIONDATE ")
            .append(" FROM ").append(ItemDAO.DEFAULT_TABLE_NAME).append(" WHERE ").append(" TENANTID = ? ")
            .append(" AND ITEMTYPE=? AND ACTIVE=TRUE");

    return getJdbcTemplate().query(query.toString(), args, argTypes, itemRowMapper);

}
 

import org.easyrec.store.dao.core.ItemDAO; //导入依赖的package包/类
public ClusterImportController(ClusterService clusterService, IDMappingDAO idMappingDAO, ItemDAO itemDAO, ItemTypeDAO itemTypeDAO,ViewInitializationService viewInitializationService) {
    this.clusterService = clusterService;
    this.idMappingDAO = idMappingDAO;
    this.itemDAO = itemDAO;
    this.itemTypeDAO = itemTypeDAO;
    this.viewInitializationService = viewInitializationService;
}
 

import org.easyrec.store.dao.core.ItemDAO; //导入依赖的package包/类
public ItemSearchController(ItemDAO itemDAO, String dateFormat, RemoteTenantDAO remoteTenantDAO,
                            ItemTypeDAO itemTypeDAO, AssocTypeDAO assocTypeDAO) {
    this.itemDAO = itemDAO;
    this.dateFormat = dateFormat;
    this.remoteTenantDAO = remoteTenantDAO;
    this.itemTypeDAO = itemTypeDAO;
    this.assocTypeDAO = assocTypeDAO;
}
 

import org.easyrec.store.dao.core.ItemDAO; //导入依赖的package包/类
private ItemDAO.SortColumn tableSortParameterToDatabaseColumnName(int columnIndex) {
    switch (columnIndex) {
        case 0:
            return ItemDAO.SortColumn.ITEM_ID;
        case 1:
            return ItemDAO.SortColumn.DESCRIPTION;
        case 2:
            return ItemDAO.SortColumn.ITEM_TYPE;
        default:
            return ItemDAO.SortColumn.NONE;
    }
}
 

import org.easyrec.store.dao.core.ItemDAO; //导入依赖的package包/类
public ClusterManagerController(ClusterService clusterService, RemoteTenantDAO remoteTenantDAO, ItemDAO itemDAO,
                                ItemTypeDAO itemTypeDAO, IDMappingDAO idMappingDAO,IDMappingService idMappingService, ViewInitializationService viewInitializationService) {
    this.clusterService = clusterService;
    this.remoteTenantDAO = remoteTenantDAO;
    this.itemDAO = itemDAO;
    this.itemTypeDAO = itemTypeDAO;
    this.idMappingDAO = idMappingDAO;
    this.idMappingService = idMappingService;
    this.viewInitializationService = viewInitializationService;
}
 

import org.easyrec.store.dao.core.ItemDAO; //导入依赖的package包/类
public IDMappingServiceImpl(IDMappingDAO idMappingDAO, ItemDAO itemDAO, TenantService tenantService,
                            AssocTypeDAO assocTypeDAO, ItemTypeDAO itemTypeDAO) {
    this.idMappingDAO = idMappingDAO;
    this.itemDAO = itemDAO;
    this.tenantService = tenantService;
    this.assocTypeDAO = assocTypeDAO;
    this.itemTypeDAO = itemTypeDAO;
}
 

import org.easyrec.store.dao.core.ItemDAO; //导入依赖的package包/类
public JSONProfileWebService(JSONProfileServiceImpl profileService, OperatorDAO operatorDAO, ObjectMapper objectMapper, TypeMappingService typeMappingService, ItemDAO itemDAO) {
    this.profileService = profileService;
    this.operatorDAO = operatorDAO;
    this.objectMapper = objectMapper;
    this.typeMappingService = typeMappingService;
    this.itemDAO = itemDAO;
}
 

import org.easyrec.store.dao.core.ItemDAO; //导入依赖的package包/类
public EasyRec(OperatorDAO operatorDAO, RemoteTenantDAO remoteTenantDAO,
               ShopRecommenderService shopRecommenderService, TenantService tenantService,
               TypeMappingService typeMappingService, ItemDAO itemDAO, RemoteAssocService remoteAssocService,
               IDMappingDAO idMappingDAO,
               //added by FK on 2012-12-18 for enabling profile data in recommendations
               ProfileService profileService,
               ClusterService clusterService,
               EasyRecSettings easyrecSettings,
               PluginRegistry pluginRegistry,
               GeneratorContainer generatorContainer,
               String dateFormatString,
               ObjectMapper objectMapper,
               LogEntryDAO logEntryDAO,
               BackTrackingDAO backTrackingDAO) {
    this.operatorDAO = operatorDAO;
    this.remoteTenantDAO = remoteTenantDAO;
    this.shopRecommenderService = shopRecommenderService;
    this.tenantService = tenantService;
    this.typeMappingService = typeMappingService;
    this.itemDAO = itemDAO;
    this.remoteAssocService = remoteAssocService;
    this.dateFormat = dateFormatString;
    this.profileService = profileService;
    this.idMappingDAO = idMappingDAO;
    this.clusterService = clusterService;
    this.easyrecSettings = easyrecSettings;
    this.pluginRegistry = pluginRegistry;
    this.generatorContainer = generatorContainer;
    this.objectMapper = objectMapper;
    this.logEntryDAO = logEntryDAO;
    this.backTrackingDAO = backTrackingDAO;
}
 

import org.easyrec.store.dao.core.ItemDAO; //导入依赖的package包/类
public void setItemDAO(ItemDAO itemDAO) {
    this.itemDAO = itemDAO;
}
 

import org.easyrec.store.dao.core.ItemDAO; //导入依赖的package包/类
public ItemDAO getItemDAO() {
    return itemDAO;
}
 

import org.easyrec.store.dao.core.ItemDAO; //导入依赖的package包/类
@Test
@DataSet("/dbunit/core/dao/itemDaoTest.xml")
public void testSearchItems() {
    itemDAO.emptyCache();
    currentItemId = 2;
    Item item1;
    Item item2;
    item1 = createDummyItem(0);
    increaseItemId();
    item2 = createDummyItem(1);
    addItem(item1);
    addItem(item2);


    Calendar calendar = Calendar.getInstance();
    calendar.setTime(new Date());
    calendar.add(Calendar.DAY_OF_MONTH, -1);
    Date startDate = calendar.getTime();
    calendar.add(Calendar.DAY_OF_MONTH, 2);
    Date endDate = calendar.getTime();

    TimeConstraintVO timeConstraint = new TimeConstraintVO(startDate, endDate);
    ArrayList<String> itemTypeList = new ArrayList<String>();
    itemTypeList.add(item1.getItemType());
    List<Item> itemList = itemDAO.searchItems(TENANT_ID, item1.getItemId(),
            itemTypeList, item1.getDescription(), item1.getUrl(), item1.getImageUrl(), true,
            timeConstraint, false, "", ItemDAO.SortColumn.NONE, false, 0, 100);

    Assert.assertEquals(1, itemList.size());
    Assert.assertTrue(isItemInList(item1, itemList));
    Assert.assertFalse(isItemInList(item2, itemList));

    int resultCount = itemDAO.searchItemsTotalCount(TENANT_ID, item1.getItemId(),
            itemTypeList, item1.getDescription(), item1.getUrl(), item1.getImageUrl(), true,
            timeConstraint, false, "");
    Assert.assertEquals(1, resultCount);

    itemList = itemDAO.searchItems(TENANT_ID, item2.getItemId(),
            itemTypeList, item2.getDescription(), item2.getUrl(), item2.getImageUrl(), true,
            timeConstraint, false, "", ItemDAO.SortColumn.NONE, false, 0, 100);

    Assert.assertEquals(1, itemList.size());
    Assert.assertTrue(isItemInList(item2, itemList));
    Assert.assertFalse(isItemInList(item1, itemList));


    resultCount = itemDAO.searchItemsTotalCount(TENANT_ID, item2.getItemId(),
            itemTypeList, item2.getDescription(), item2.getUrl(), item2.getImageUrl(), true,
            timeConstraint, false, "");
    Assert.assertEquals(1, resultCount);

    // with hasRules = true only item1 should be returned

    itemList = itemDAO.searchItems(TENANT_ID, item1.getItemId(),
            itemTypeList, item1.getDescription(), item1.getUrl(), item1.getImageUrl(), true,
            timeConstraint, true, "", ItemDAO.SortColumn.NONE, false, 0, 100);

    Assert.assertEquals(1, itemList.size());
    Assert.assertTrue(isItemInList(item1, itemList));
    Assert.assertFalse(isItemInList(item2, itemList));

    resultCount = itemDAO.searchItemsTotalCount(TENANT_ID, item1.getItemId(),
            itemTypeList, item1.getDescription(), item1.getUrl(), item1.getImageUrl(), true,
            timeConstraint, true, "");
    Assert.assertEquals(1, resultCount);

    itemList = itemDAO.searchItems(TENANT_ID, item2.getItemId(),
            itemTypeList, item2.getDescription(), item2.getUrl(), item2.getImageUrl(), true,
            timeConstraint, true, "", ItemDAO.SortColumn.NONE, false, 0, 100);
    Assert.assertEquals(0, itemList.size());
    resultCount = itemDAO.searchItemsTotalCount(TENANT_ID, item2.getItemId(),
            itemTypeList, item2.getDescription(), item2.getUrl(), item2.getImageUrl(), true,
            timeConstraint, true, "");
    Assert.assertEquals(0, resultCount);
}