📄 handledisplay.jsp
字号:
<%-- Document : handledisplay Created on : 2008-3-16, 17:27:40 Author : Administrator--%><%@page contentType="text/html" pageEncoding="GB2312"%><%@page import="java.sql.*"%><%@page import="java.io.*;"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html> <head> <meta http-equiv="Content-Type" content="text/html; charset=GB2312"> <title>handle display</title> </head> <body> <a href="addmess.jsp">留言</a> <a href="index.jsp">首页</a> <a href="login.jsp">管理登陆</a><br> <% try{ Class.forName("com.mysql.jdbc.Driver").newInstance(); } catch(Exception e){ } ResultSet rs=null; Connection conn; String url="jdbc:mysql://localhost/taotao"; String user="taotao"; String password=".nothing"; conn=DriverManager.getConnection(url,user,password); Statement stmt; String sql="select * from messages "+" Order By number Desc"; stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); rs=stmt.executeQuery(sql); %> <% int intPageSize; int intRowCount; int intPageCount; int intPage; String strPage; int i; intPageSize = 10; strPage = request.getParameter("page"); if(strPage==null){ intPage = 1; } else { intPage = Integer.parseInt(strPage); if(intPage<1){ intPage = 1;} } rs.last(); intRowCount = rs.getRow(); intPageCount =(intRowCount+intPageSize-1) / intPageSize; if(intPage>intPageCount) intPage = intPageCount; if(intPageCount>0){ rs.absolute((intPage-1) * intPageSize+1); i = 0; while(i< intPageSize && !rs.isAfterLast()){ int num=rs.getInt("number"); String name=rs.getString("id"); name=name.replaceAll("<","<"); name=name.replaceAll(">",">"); String content=rs.getString("content"); content=content.replaceAll("<","<"); content=content.replaceAll(">",">"); String recontent=rs.getString("recontent"); if(recontent!=null){ recontent=recontent.replaceAll("<","<"); recontent=recontent.replaceAll(">",">"); } %> <table border=1 bgcolor="cyan" > <tr><td><%=num%></td><td><%=name%></td><td><%=content%></td><td><%=recontent%></td> </tr> </table> <% rs.next(); i++; } } rs.close(); stmt.close(); conn.close(); %> <a href="handledisplay.jsp?page=<%=intPage-1%>" class="style3">上一页</a> <a href="handledisplay.jsp?page=<%=intPage+1%>" class="style3">下一页</a> <% //String s=(String)session.getAttribute("rootid"); if(session.getAttribute("rootid")!=null){ out.print( "<form action=\"handledelete.jsp\" method=psot name=form>"+ "<input type=\"text\" name=\"todel\" value=\"\">toDe" + "<input type=submit value=submit><br>"+ "</form>"+ "<form action=\"handlemodify.jsp\" method=psot name=form>"+ "<input type=\"text\" name=\"tomod\" value=\"\">toMo<br>" + "<textarea name=newcontent cols=30 rows=4>"+"</textarea>"+ "<input type=submit value=submit>"+ "</form>"+ "<form action=\"handlere.jsp\" method=\"psot\" name=form>"+ "<input type=\"text\" name=\"tore\" value=\"\">toRe<br>" + "<textarea name=recontent cols=30 rows=4>"+"</textarea>"+ "<input type=submit value=submit>"+ "</form>" ); } %> </body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -