下面这句sql语句, 这个top n 的n值, 我想用java传进来的值使他变为变量,想了很多种办法实现不了,求大神帮助!!!!!!
select top n * from weixin_material where enable=1 order by id desc
Integer n = 10;
String sql = "select top "+n+" * from weixin_material where enable=1 order by id desc";
楼上字符串拼接解决了这个问题,占位符很好用,但也不要忘了,最基础的字符串拼接。
String sql = "select top "+ n.toString() +" * from weixin_material where enable=1 order by id desc";