myjsp JSP ACCESS 简单试用 <%@ page contentType=&quo

文件名称: myjsp JSP ACCESS

所属分类: Access

开发工具:

文件大小: 114kb

下载次数: 0

上传时间: 2011-11-26

提供者: ftx****

下载 (114kb)

不能下载？报告错误

详细说明：简单试用 <%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %> <%@ include file="conn.jsp" %> <%@ include file="top.jsp" %> 留言本 <% try{ String name; name= (String) session.getValue("name"); if(name!=null) { out.print("
管理员"+session.getValue("name")+""); out.print("已登陆退出登陆

"); String loginout=request.getParameter("loginout"); if(loginout!=null) { if(loginout.compareTo("true")==0) { session.removeAttribute("name"); response.sendRedirect("index.jsp"); } } }else{ out.print("管理登陆"); } Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); ResultSet rs=stmt.executeQuery("select * from a order by sj desc"); int i=1; int pagesize=8; int pagecount; int rowcount; int gopage; rs.last(); rowcount = rs.getRow(); pagecount=(rowcount+pagesize-1)/pagesize; if(request.getParameter("page")!=null){ gopage = java.lang.Integer.parseInt(request.getParameter("page")); }else{ gopage=1;// } rs.absolute((gopage-1)*pagesize+1); while(i<=pagesize && !rs.isAfterLast()){ %>

>

<% out.print(rs.getString("username")+" ["+rs.getString("sex")+"]"); %>

<% out.print(rs.getString("sj")); %>

"/>

主题： <% out.print(rs.getString("zt")); %>

<% out.print(rs.getString("nr")); %>

JSP课程设计之留言本 <% if(name!=null){ out.print(" 删除"); } %>
#TOP #BOT

<% rs.next(); i++; } rs.close(); stmt.close(); %>

共<%=pagecount%>页当前第<%=gopage%>页 <% for(int j=1;j<=pagecount;j++){ out.print(" "+j+""); } }catch(Exception e){ out.print("错误页码或无记录"); } %>

...展开收缩