📄 ly.jsp
字号:
<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %><html><head><title>留言本</title><meta http-equiv="Content-Type" content="text/html; charset=GBK"><link href="images/web.css" rel="stylesheet" type="text/css"></head><script language="JavaScript">function openw(url) { var newwin=window.open(url,"NewWin","toolbar=no,resizable=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,top=220,left=220,width=500,height=330"); // newwin.focus(); return false;}function opend(url) { var newwin=window.open(url,"NewWin","toolbar=no,resizable=yes,location=no,directories=no,status=no,menubar=no,scrollbars=no,top=100,left=50,width=650,height=350"); // newwin.focus(); return false;}</script><body leftmargin="0" topmargin="1"><%@include file="inc/head.inc"%><jsp:useBean id="wu" scope="page" class="wu.jdbc" /><%Connection con = wu.getConn() ;Statement stmt = con.createStatement() ;String sql = "select * from liuyan_temp order by id desc" ;ResultSet rs = stmt.executeQuery(sql) ;String pages = request.getParameter("page") ;int pageInt = 1 ,i=1;if(pages==null){}else{pageInt = Integer.parseInt(pages);}while(i<20*(pageInt-1)&&rs.next()){i++ ;}%><table width="775" border="0" align="center" cellpadding="0" cellspacing="1"> <tr> <td><table width="100%" border="0" cellpadding="2" cellspacing="1" bgcolor="#16831C"><tr> <td colspan="2" bgcolor="#E8FCE2"><div align="center"> <table width="100%" border="0" cellpadding="1" cellspacing="1"><tr> <td><div align="center"><a href="#" onClick="return opend('ly_new.jsp')">添加留言</a></div></td> <td><div align="center"><a href="http://127.0.0.1:8080/liuyangben/index.jsp">返回主页</a></div></td> <td><div align="center"><a href="login.jsp">留言管理</a></div></td> <td><div align="center"><a href="#" onClick="return opend('my.jsp')">我的介绍</a></div></td> </tr> </table></div></td> </tr> <% i=0 ; String str = "#E8FCE2",str1="" ; java.util.Random rd = new java.util.Random() ; while(rs.next()&i<20){ i++ ; String id = rs.getString("id") ; String sj = rs.getString("sj") ; String url = rs.getString("url") ; String ip = rs.getString("ip") ; String email = rs.getString("email") ; String qq = rs.getString("qq") ; String content = rs.getString("content") ; String xm = rs.getString("xm") ; if(str.equals("#E8FCE2")){ str = "#D1E79E" ;}else{ str = "#E8FCE2" ; } %> <tr><td width="23%" bgcolor="<%=str%>"><div align="center"><%=sj%></div></td> <td width="77%" bgcolor="<%=str%>"> <table width="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <td> <div align="center"><a href="<%=url%>"><img src="images/HOME.gif" alt="个人主页" width="16" height="16" border="0" align="absmiddle"></a>留言人主页</div></td> <td> <div align="center"><img src="images/ip.gif" alt="<%=ip%>" width="13" height="15" align="absmiddle">留言人IP</div></td> <td> <div align="center"><a href="mailto:<%=email%>"><img src="images/EMAIL.gif" alt="<%=email%>" width="16" height="16" border="0" align="absmiddle"></a>留言人email</div></td> <td> <div align="center"><img src="images/oicq.gif" alt="<%=qq%>" width="16" height="16" align="absmiddle">留言人QQ</div></td> <td> <div align="center"><a href="del.jsp?id=<%=id%>"><img src="images/dele_1.gif" alt="删除" width="14" height="16" border="0" align="absmiddle">删除留言</div></a></td> </tr> </table></td> </tr> <tr><td align="center" valign="middle" bgcolor="<%=str%>"><img src="images/tx/<%=rd.nextInt(30)+1%>.gif" width="100" height="100"><br> <br> 留言人： <%=xm%> </td> <td bgcolor="#FFFFFF" style="word-break:break-all"> <%=content%> </td> </tr> <% } %> <tr bgcolor="#F9CDBB"><td> </td><%sql = "select count(*) from liuyan_temp" ;rs = stmt.executeQuery(sql) ;while(rs.next()) i = rs.getInt(1) ;%> <td> <div align="right">总共有留言<%=i%>条/<%=(i+19)/20%>页，这是第<%=pageInt%>页，转到第 <% for(int j=1;j<(i+40)/20;j++){ %> <a href="ly.jsp?page=<%=j%>">^<%=j%>^</a> <% } try { rs.close(); stmt.close(); con.close(); } catch (Exception ex) { } %> 页</div></td> </tr> <tr><td bgcolor="<%=str%>"> </td> <td bgcolor="<%=str%>"> </td> </tr> </table></td> </tr> <tr></table><%@include file="inc/tail.inc"%></body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -