NutzCN Logo
问答 nutz里面写sql的时候要转义@怎么转义
发布于 2442天前 作者 qq_39fcc7a4 1716 次浏览 复制 上一个帖子 下一个帖子
标签:
String sql="select t1.id,t1.subject,t1.send_time_number,t1.sender_address,t1.receiver_address " + 
								"  from ZZ_SEND_EMAIL t, zz_send_email t1" + 
								" where "+
								" ( pk_split.fn_is_in_arr(@receiveraddress, ',', t1.sender_address) = 5  " + 
								"	or  pk_split.fn_is_in_arr(t1.RECEIVER_ADDRESS, ',', 'fzpsm@hrwin.net') = 5" +
								" 	or  pk_split.fn_is_in_arr(t1.RECEIVER_ADDRESS, ',', 'shfida@hrwin.net') = 5 " +
								" 	or  pk_split.fn_is_in_arr(t1.RECEIVER_ADDRESS, ',', 'shlda@hrwin.net') = 5 ) " + 
								"   and t1.SEND_TIME_LONG_M = @ORIGINIAL_SEND_TIME_LONG_M" + 
								"   and t.subject = @replySub" + 
								"   and t1.subject = @sub" +
								"   group by t1.id,t1.subject,t1.send_time_number,t1.sender_address,t1.receiver_address";
2 回复

写成@@,或者调用sql.changePlaceholder改变默认占位符

谢谢,搞定了。

添加回复
请先登陆
回到顶部