📄 ly1.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"><jsp:useBean id="wu" scope="page" class="wu.jdbc" /><%Connection con = wu.getConn() ;Statement stmt = con.createStatement() ;String sql = "select xm,content,email,ip,qq 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++ ;}%><%=i%> <% i=0 ; String str = "#E8FCE2",str1="" ; java.util.Random rd = new java.util.Random() ; while(rs.next()&i<20){ i++ ; String xm = rs.getString("xm"); String content = rs.getString("content") ; String email = rs.getString("email") ; String ip = rs.getString("ip"); String qq = rs.getString("qq"); //String id = rs.getString("id"); //String url = rs.getString("url"); if(str.equals("#E8FCE2")){ str = "#D1E79E" ;}else{ str = "#E8FCE2" ; } %> <%=ip%> <%=qq%> <%//=id%> <%//=url%> <%=content%> <%=email%> <%=xm%> <tr></td> </tr> <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> <td> </td> </tr></table></body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -