使用JdbcTemplate的queryForList遇到的诡异问题

0 0

使用JdbcTemplate的queryForList遇到的诡异问题10

近日遇到一个诡异问题，先上点代码：

public AdGroup getPromotionAdGroup(Integer promotionCampaignId,Integer channelAccountId,Integer channelId,Integer accountId)
	{
		AdGroup adGroup = new AdGroup();
		ChannelAccount channelAccount=new ChannelAccount();
		channelAccount.setChannelAccountId(channelAccountId);
		/**
		 *   If there is no adGroup under the promotion campaign which size is less than the 
		  *  MAX_ADGOURP_KEYWORD_NUM,then create a new adGroup         
		 */
		String sql="select t1.AD_GROUP_ID as AD_GROUP_ID,t1.NAME as NAME from"+"\n"
		 +"AD_GROUP t1"+"\n"
		 +"left join AD_KEYWORD t2 on t1.AD_GROUP_ID=t2.AD_GROUP_ID"+"\n"
		 +"where t1.AD_CAMPAIGN_ID="+promotionCampaignId+"\n"
		 +"and t1.status="+Constants.STATUS_ACTIVE+"\n"
		 //+"and t1.action_flag="+Constants.ACTION_FLAG_NORMAL+"\n"
		 +"group by t1.AD_GROUP_ID"+"\n"
		 +"having count(t2.AD_KEYWORDS_ID)<"+Constants.MAX_ADGOURP_KEYWORD_NUM+"\n";
		List adGroupList=jdbcTemplate.queryForList(sql);
		if(adGroupList!=null && !adGroupList.isEmpty())
		{
			Map adGroupMap=(Map)adGroupList.get(0);
		    adGroup.setAdGroupId((Integer)adGroupMap.get("AD_GROUP_ID"));
		}
		else
		{
			adGroup.setAdCampaignId(promotionCampaignId);
			adGroup.setActionFlag(Constants.ACTION_FLAG_NEW);
			adGroup.setStatus(Constants.STATUS_ACTIVE);
			adGroup.setActionReason(Constants.RULE_OPERATION);
			adGroup.setName("促销活动投放"+new Date());
			adGroup.setChannelAccountId(channelAccountId);
			adGroup.setChannelId(channelId);
			adGroup.setDefaultPrice(String.valueOf(Constants.PROMOTION_BID_LIMIT));
			adGroup.setCreateTime(new Date());
			adGroup.setUpdateTime(null);
			adGroup.setAccountId(accountId);
			try {
				adGroupService.save(adGroup);
			} catch (Exception e) {
                adGroup=null;
				e.printStackTrace();
			}		
		}
		return adGroup;	
	}

2012年1月10日 18:03

luxury_zh
20
0 0 1

3个答案按时间排序按投票排序

0 0

同上问！

不过我猜应该是下面的代码有问题

引用

String sql="select t1.AD_GROUP_ID as AD_GROUP_ID,t1.NAME as NAME from"+"\n"
         +"AD_GROUP t1"+"\n"
         +"left join AD_KEYWORD t2 on t1.AD_GROUP_ID=t2.AD_GROUP_ID"+"\n"
         +"where t1.AD_CAMPAIGN_ID="+promotionCampaignId+"\n"
         +"and t1.status="+Constants.STATUS_ACTIVE+"\n"
         //+"and t1.action_flag="+Constants.ACTION_FLAG_NORMAL+"\n"
         +"group by t1.AD_GROUP_ID"+"\n"
         +"having count(t2.AD_KEYWORDS_ID)<"+Constants.MAX_ADGOURP_KEYWORD_NUM+"\n";

SQL字符串中加\n换行，执行时有问题吧！

2012年1月10日 19:36