bbsdata" scope="page" class="bbsdata.jdbc"> <%! String User_Name,User_Id,sql,Not_Title,Not_Content,Submit_Button;%> <% 7 Submit_Button=request.getParameter("Submit"); User_Name=request.getParameter("username"); int PageSize=10; int RecordCount=0; int PageCount=0; int ShowPage=1; Connection con=bbsdata.getConn(); Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR _READ_ONLY); ResultSet rs=null; sql="Select * from 用户表 order by 用户 id desc"; if (Submit_Button!=null) { if (Submit_Button.equals("删除该用户的所有贴子")) { sql="delete from 贴子 where 贴子作者='"+User_Name+"'"; stmt.executeUpdate(sql); sql="Select * from 用户表 order by 用户 id desc"; } else if (Submit_Button.equals("搜索")) { sql="Select * from 用户表 where 用户名='"+User_Name+"'"; } } rs=stmt.executeQuery(sql); rs.last(); RecordCount=rs.getRow(); PageCount=(RecordCount % PageSize==0)?(RecordCount/PageSize):(Record