📄 index.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>简单留言簿Version1.0</title>
<link href="css.css" rel="stylesheet" type="text/css">
<jsp:useBean id="PageCt" scope="page" class="lyb.PageCt" />
<jsp:useBean id="workM" scope="page" class="lyb.jdbc"/>
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<TABLE cellSpacing=1 cellPadding=3 width=98% align=center
background="images/top_line.gif" border=0>
<TR align=middle>
<TD width="20%" align="left" nowrap><FONT color=#78b3f9>
<SCRIPT language=JavaScript>
var day="";
var month="";
var ampm="";
var ampmhour="";
var myweekday="";
var year="";
mydate=new Date();
myweekday=mydate.getDay();
mymonth=mydate.getMonth()+1;
myday= mydate.getDate();
myyear= mydate.getYear();
year=(myyear > 200) ? myyear : 1900 + myyear;
if(myweekday == 0)
weekday=" 星期天 ";
else if(myweekday == 1)
weekday=" 星期一";
else if(myweekday == 2)
weekday=" 星期二 ";
else if(myweekday == 3)
weekday=" 星期三";
else if(myweekday == 4)
weekday=" 星期四 ";
else if(myweekday == 5)
weekday=" 星期五 ";
else if(myweekday == 6)
weekday=" 星期六 ";
document.write(year+"-"+mymonth+"-"+myday+weekday);
</SCRIPT>
</FONT></TD>
<TD width="20%" nowrap> </TD>
<TD width="20%" nowrap> </TD>
<TD width="20%" nowrap> </TD>
<TD width="20%" nowrap> </TD>
</TR>
</TABLE>
<TABLE height=76 cellSpacing=0 cellPadding=0 width=98% align=center
background="images/bottom_line.jpg"
border=0>
<TR>
<TD><TABLE height=72 cellSpacing=0 cellPadding=0 width="99%" align=center
bgColor=#ffffff border=0>
<TR>
<TD width="163" align="center"><IMG
src="images/login.gif"
border=0></TD>
<TD width="476" align=right><img src="images/banner.gif" width="468" height="60" border=0 usemap="#Map" scr="images/banner.gif"></TD>
<TD align=center width=123> <TABLE width="90%" border=0 cellPadding=1 cellSpacing=0>
<TR vAlign=center align=middle>
<TD><IMG height=16
src="images/homepage.gif"
width=16></TD>
<TD> <a href="about.jsp">About Me</a></TD>
</TR>
<TR vAlign=center align=middle>
<TD> </TD>
<TD> </TD>
</TR>
<TR vAlign=center align=middle>
<TD><IMG height=16
src="images/Favorites.gif"
width=16></TD>
<TD> <a href="chen_shengjie@tom.com"> Contact Me</a></TD>
</TR>
</TABLE></TD>
</TR>
</TABLE></TD>
</TR>
</TABLE>
<table width="98%" align="center" cellpadding="0" cellspacing="0" background="images/index-t.gif">
<tr>
<td width="5%" align="left">
</td>
<td height="22" align="left"><a href="say.jsp">我要留言</a>
</td>
</tr>
</table>
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="3"></td>
</tr>
</table>
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#4f81ca">
<tr>
<td><table width="100%" border="0" align="center" cellpadding="1" cellspacing="1">
<%
Connection conn = workM.getConn() ;
Statement stmt = conn.createStatement() ;
ResultSet rs0 = stmt.executeQuery("select count(*) from lyb");
rs0.next();
long data_num=rs0.getLong(1);
long Current_Page = 0;
String currentpage=(String)request.getParameter("currentpage");
if (currentpage != null && !currentpage.equals(""))
{
Current_Page = Integer.parseInt(request.getParameter("currentpage"));
}
String Query_Page=(String)request.getParameter("Query_Page");
if (Query_Page!=null && !Query_Page.equals(""))
{
Current_Page = Integer.parseInt(request.getParameter("Query_Page"))-1;
}
PageCt.Init(Current_Page,data_num);
long l_start = PageCt.getStart();
long l_end = PageCt.getEnd();
//查询记录
ResultSet rs = stmt.executeQuery("select * from lyb order by id desc");
long i=0;
while((i<l_start) && rs.next())
{
i++;
}
//输出查询结果
long j=0;
while(rs.next() && (i<l_end))
{
j=i+1;
String col2 = rs.getString(1);
String col3 = rs.getString(2);
String col4 = rs.getString(3);
String col5 = rs.getString(4);
String col6 = rs.getString(5);
String col7 = rs.getString(5);
String col8 = rs.getString(8);%>
<tr <%if((i%2)!=0){%>bgcolor="#78b3f9"<%}else{%>bgcolor="#BEDAFC"<%}%>>
<td width="20%" align="center" >留言人：<%=rs.getString("name")%> <img src="<%=rs.getString("sex")%>" border="0"></td>
<td> <table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr align="left" <%if((i%2)!=0){%>bgcolor="#78b3f9"<%}else{%>bgcolor="#BEDAFC"<%}%>>
<td width="25%"> <a href="<%=rs.getString("www")%>"><img src="images/HOME.gif" alt="个人主页" width="16" height="16" border="0" align="absmiddle"></a>主页</td>
<td width="25%"> <img src="images/ip.gif" alt="" width="13" height="15" align="absmiddle">IP：<%=rs.getString("IP")%></td>
<td width="25%"> <a href="mailto:<%=rs.getString("email")%>"><img src="images/EMAIL.gif" alt="留言人E-Mail" width="16" height="16" border="0" align="absmiddle"></a>E-Mail</td>
<td width="25%"> <img src="images/oicq.gif" alt="" width="16" height="16" align="absmiddle">QQ:<%=rs.getString("oicq")%></td>
</tr>
</table></td>
</tr>
<tr <%if((i%2)!=0){%>bgcolor="#78b3f9"<%}else{%>bgcolor="#BEDAFC"<%}%>>
<td width="20%" align="center"><img src="<%=rs.getString("face")%>" border="0"></td>
<td><%=rs.getString("memo")%></td>
</tr>
<tr <%if((i%2)!=0){%>bgcolor="#78b3f9"<%}else{%>bgcolor="#BEDAFC"<%}%>>
<td width="20%" align="center">时间：<%=rs.getString("time")%></td>
<td> </td>
</tr>
<tr>
<td colspan="2" align="center" bgcolor="#ffffff"> <hr size="1" color="#000080" width="100%"></td>
</tr>
<%
i++;
}%>
<tr align="right" valign="top">
<form method=GET action=index.jsp>
<td colspan="2" bgcolor="#FFFFFF"> 共 <%=PageCt.getTotalnum()%> 条 <%=PageCt.getCurpage()+1%>/<%=PageCt.getTotalpage()%>
页 查看第
<input type=text name=Query_Page size=3>
页 <a href=index.jsp?currentpage=<%=PageCt.getPrepage()%>>上页</a> <a href=index.jsp?currentpage=<%=PageCt.getNextpage()%>>下页</a>
</td>
</form>
</tr>
</table></td>
</tr>
</table>
<table width="98%" border="0" align="center" cellpadding="2" cellspacing="2" background="images/bottom_line.gif">
<tr>
<td width="27%"> </td>
<td width="73%">圣洁工作室©版权所有（2002-2005）</td>
</tr>
<tr>
<td> </td>
<td>建议800*600 IE5.5以上（推荐6.0）
</td>
</tr>
<tr>
<td> </td>
<td>技术支持<a href="http://www.sc666.com/chc/" target="_blank">圣洁工作室</a></td>
</tr>
</table>
<map name="Map">
<area shape="rect" coords="1,2,468,60" href="http://www.sc666.com/chc/" target="_blank">
</map>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -