高手帮我看看这个问题
stmt = con.prepareStatement("select top ? * from v_userandtopic where LMID=? order by CreateTime desc,ReNum desc");
stmt.setInt(1,page.getPageEndRow()-page.getPageStartRow()+1);
stmt.setInt(2,new Integer(lmid).intValue());
报错,只要把第一个?用具体的数字代替就可以通过:
stmt = con.prepareStatement("select top 4 * from v_userandtopic where LMID=? order by CreateTime desc,ReNum desc");
//stmt.setInt(1,page.getPageEndRow()-page.getPageStartRow()+1);
stmt.setInt(1,new Integer(lmid).intValue());
是不是不该这么传参数,那要怎么做