📄 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=gb2312">
<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 + -