日期:2014-05-18 浏览次数:20640 次
String sql1="select top "+rowBegin+" ID from [user] where 1=1 "
+str+"and loginName in(select loginName from record where records =? or records = ? order by time desc" ;
String sql="select top 12 * from [user] where 1=1 "
+str+"and loginName in(select loginName from record where records =? or records = ?) and ID not in (" +sql1+") order by time desc";