应该是写两个方法。
sql="select top 1 * from tableName where id>"+a1+" order by id"; //这是下一篇
rs = conn.executeQuery(sql);
//a1是当前文章的id=rs.getString("id")
//判断 if(!rs.next())没有下一篇 else
int a2=rs("id");
oup.println("readnews.jsp?id="+a2);
----上一篇一样,关键的sql
sql="select top 1 * from tableName where id<"&a1&" order by id desc";
sql="select top 1 * from tableName where id>"+a1+" order by id"; //这是下一篇
rs = conn.executeQuery(sql);
//a1是当前文章的id=rs.getString("id")
//判断 if(!rs.next())没有下一篇 else
int a2=rs("id");
oup.println("readnews.jsp?id="+a2);
----上一篇一样,关键的sql
sql="select top 1 * from tableName where id<"&a1&" order by id desc";
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货