📄 allleavewords.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" import="java.sql.*,java.io.*" errorPage="" %>
<%@ include file="yeshou.txt"%>
<html>
<meta http-equiv="refresh" content="40"; charset=gb2312" />
<head>
<title>欢迎留言</title>
<style type="text/css">
table{table-layout: fixed;}
td{word-break: break-all; word-wrap:break-word;}
</style>
</head>
<% String windows="window.open('load1.jsp','','height=200, width=200, top=0, lef t=0, toolbar=no, menubar=no, scrollbars=no,resizable=no,location=no, statu s=no')";%>
<body bgcolor="#99CCCC">
<table align="center" border="0" bgcolor="#99CCCC" width="780" bgcolor="">
<div align="left" style="width:780;" ><br>
<span style="font-size: 18px"><a href="liuyanban.jsp">发表留言</a><img src="picture/lyb_write.gif" width="20" height="20"></span></a>
<%if(session.getAttribute("flag1")!="2"){%>
<a href="#" onClick="<%=windows%>" style="font-size: 18px"> 留言管理<img src="picture/lyb_admin.gif" width="20" height="20"></a> <%}else if(session.getAttribute("flag")=="1"){out.print("<script>alert('您已经用户登录状态！');location.href='allleavcwords.jsp';</script>");}else{ %><a href="guanli.jsp" style="font-size: 18px"> 留言管理<img src="picture/lyb_admin.gif" width="20" height="20"></a>
<%}%>
<%
String s=(String)session.getAttribute("customer");
String publisher="";
String content="";
String publishdate="";
int intPageSize; //一页显示的记录数
int intRowCount; //记录总数
int intPageCount; //总页数
int intPage; //待显示页码
String strPage;
int i;
intPageSize = 10;//设置一页显示的记录数
//取得待显示页码
strPage = request.getParameter("page");
if(strPage==null){//表明在QueryString中没有page这一个参数，此时显示第一页数据
intPage = 1;
}
else{//将字符串转换成整型
intPage = Integer.parseInt(strPage);
if(intPage<1) intPage = 1;
}
//装载JDBC驱动程序
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:test","sa","sa");
//设置数据库连接字符串
//连接数据库
Statement st=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
//创建一个可以滚动的只读的SQL语句对象
//准备SQL语句
String sql = "select * from leavewords order by id desc";
//执行SQL语句并获取结果集
ResultSet rs=st.executeQuery(sql);
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()){
String id=rs.getString(1);
String user=(String)rs.getString(2).trim();
if(session.getAttribute("flag1")!="2"&&session.getAttribute("flag")!="1")
{
out.print("<tr><td height='102' bgcolor='#66a88'>"+"用户"+user+"发表留言:<br>");
out.print(rs.getString(3)+"<br>");
out.print("发表日期:"+rs.getString(4)+"</td></tr>");
}
else if(session.getAttribute("flag1")=="2")
{
out.print("<tr><td height='102' bgcolor='#66a88'>"+"用户"+user+"发表留言:<br>");
out.print(rs.getString(3)+"<br>");
out.print("发表日期:"+rs.getString(4));
out.print("<br>以管理员身份");
%>
<a href="deletewords.jsp?id=<%=id%>">删除留言<img src="picture/c.gif" width="20" height="20"></a></td></tr>
<%} else if(session.getAttribute("flag")=="1"){%>
<tr><td height='102' bgcolor='#66a88' width="780">用户<%=user%>发表留言:<br>
<% out.print(rs.getString(3)+"<br>");
out.print("发表日期:"+rs.getString(4));
if(s.equals(user)){out.print("<br>以用户"+s+"自己身份");%>
<a href="deletewords.jsp?id=<%=id%>">删除留言<img src="picture/c.gif" width="20" height="20"></a> </td></tr>
<% } }
rs.next();
i++;
}
}
con.close();
//关闭SQL语句对象
%>
<FORM METHOD=POST ACTION="allleavewords.jsp">
<div align="center" align="left">
<td align="left" width="780">
<div align="left">
<INPUT TYPE="text" size="4" value=<%=intPage%> NAME="page">
<INPUT TYPE="submit" size=4 value="GO!">
第<%=intPage%>页 共<%=intPageCount%>页
<a href="allleavewords.jsp?page=1">首页
<%if(intPage>1){%>
<a href="allleavewords.jsp?page=<%=intPage-1%>">上一页</a>
<%}%>
<%if(intPage<intPageCount){%>
<a href="allleavewords.jsp?page=<%=intPage+1%>">下一页</a>
<%}%>
<a href="allleavewords.jsp?page=<%=intPageCount%>">末页</a>
</div>
</FORM>
</td></div>
</table>
</body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -