java中执行动态sql，求大神们解答

[衫秋墨]

declare @i int
declare @num int
declare @tablename nvarchar(20)
declare @sqlbuff nvarchar(3000)
set @i=1
set @num=229246542
set @sqlbuff=''
while(@i<=10)
begin
set @tablename='Group'+CAST(@i as varchar)
if @sqlbuff <> ''
set @sqlbuff = @sqlbuff + 'union all '
set @sqlbuff=@sqlbuff+'select * from '+@tablename+' where QQNum='+CAST(@num as varchar)
print @tablename
set @i=@i+1
exec sp_executesql @sqlbuff
end
print 'end'
print @sqlbuff
上面的动态sql怎么执行
还有用prepareStatement执行
sqlBuffer.append("SELECT * FROM Group");
sqlBuffer.append(i);
sqlBuffer.append(" where Num = ?");
有什么区别啊

[zhujinqiang]

参考 http://blog.csdn.net/u012388497/article/details/49506735

[衫秋墨]

引用 1 楼 zhujinqiang 的回复:

参考 http://blog.csdn.net/u012388497/article/details/49506735

谢谢，我去看下