<%
String id=request.getParameter("id");
String sql="select * from news where id="+id;
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {
%>阅读次数:<%=rs.getString("hits")%>---
<%
String hits=rs.getString("hits");
String sql2="update news set hits = hits+1 where id =" +id;
stmt.executeUpdate(sql2);}
rs.close();
stmt.close();
conn.close();
%>
提示:ResultSet is closed.//ResultSet rst=stmt.executeUpdate(sql2);看看错在什么地方了?
String id=request.getParameter("id");
String sql="select * from news where id="+id;
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {
%>阅读次数:<%=rs.getString("hits")%>---
<%
String hits=rs.getString("hits");
String sql2="update news set hits = hits+1 where id =" +id;
stmt.executeUpdate(sql2);}
rs.close();
stmt.close();
conn.close();
%>
提示:ResultSet is closed.//ResultSet rst=stmt.executeUpdate(sql2);看看错在什么地方了?
可以先把链接连到一个中间页面或servlet,在中间页面执行增加点击次数,然后再转到新闻页面