index.jsp

这也是一个java版的留言版

<%@ page contentType="text/html; charset=gb2312" %>
<%@ include file="../include/config.jsp" %>
<%@ include file="../include/global.jsp" %>
<%@ include file="../include/dbUtil.jsp" %>
<%@ include file="../include/dbConnect.jsp" %>
<%@ include file="../include/fieldGroup.jsp" %>
<%!
    int ni=7;
%>
<%
DBConnect dbCon=new DBConnect(dbString,dbClass,dbUser,dbPswd);

try{
    //每页显示的留言条数!
    int pageSize=5;
    int pageID=1;
    if(request.getParameter("pageID")!=null)pageID=Integer.parseInt (request.getParameter("pageID"));
    //存放留言的表名
    String tableName="web_gbook";
    //页面变量定义开始
    String pageLocation="您的位置: <a href='../common/main.php' class=w>酷网首页</a>>>"+navi[ni];

    String strSQL="select * from "+tableName+" order by gbk_id desc";
    FieldGroup fd=new FieldGroup(dbCon,strSQL,pageID,pageSize);
%>

<%@ include file="../include/header.jsp" %>
<!--Page Start-->
<table width="800" border="0" cellspacing="0" cellpadding="0" align=center>
<form name=form1>
    <tr><td align=center>
<input type=button value="我要留言" onclick="location.href='./post.jsp'" style="border:1px dotted #111111; border-collapse: collapse; color:#000000; background-color: #EFEFEF"><br><br>
<%=fd.getNavi("form1")%><br>
<%for(int i=0;i<fd.getTotal();i++){%>
    <table border=1 bordercolor=gray width="500" align="center" cellspacing="0" cellpadding="1"><tr><td align="center">
        <table border="0" width="500" cellspacing="0" cellpadding="0"><tr bgcolor="007CD3" height=20>
           <td width=50% align=left> <font color="ffffff"><a name="<%=fd.getString("gbk_name",i)%>"><b>来宾:</b></a><%=fd.getString("gbk_name",i)%></font></td>
           <!--td width=33% align=center><font color="ffffff"><b>时间:</b><%=fd.getString("gbk_date",i)%></font></td-->
           <td width=50% align=right><font color="ffffff"><b>来自:</b><%=getHideIP(fd.getString("gbk_ip",i))%></font></td>
        </tr>
        <tr><td colspan=3 align=center><br>
              <table border="1" bordercolor=#efefef width="80%" cellspacing="0" cellpadding="0">
                <tr><td colspan=3 align=left bgcolor="silver" height=20><table width=100%><tr><td align=left nowrap><font color="ffffff"><b>主题:</b></font><font color=000000><%=fd.getString("gbk_subject",i)%></font></td><td colspan=1 align=right bgcolor="silver" height=20 width=50%><font color="ffffff"><b>时间:</b></font><font color=000000><%=fd.getString("gbk_date",i).substring(2,16)%></font></td></tr></table></td></tr>
                <tr><td colspan=3 align=center>
                    <br>
                    <table border="0" width="85%" cellspacing="0" cellpadding="0">
                        <tr>
                            <td align=left><font color="#000000"><%=replaceContent(fd.getString("gbk_content",i))%></pre></font></td>
                        </tr>
                    </table>
                    <br>
                </td></tr>
              </table>
<%if(fd.getString("gbk_reply",i).length()>0){%>
              <br>
              <table border="1" bordercolor=#efefef width="80%" cellspacing="0" cellpadding="0">
                <tr><td colspan=3 align=left bgcolor="silver" height=20><table width=100%><tr><td align=left nowrap><font color="ffffff"><b>回复:</b></font><font color=000000>Re:<%=fd.getString("gbk_subject",i)%></font></td><td colspan=1 align=right bgcolor="silver" height=20 width=50%><font color="ffffff"><b>时间:</b></font><font color=000000><%=fd.getString("gbk_replydate",i).substring(2,16)%></font></td></tr></table></td></tr>
                <tr><td colspan=3 align=center>
                    <br>
                    <table border="0" width="85%" cellspacing="0" cellpadding="0">
                        <tr>
                            <td align=left><font color="#000000"><%=replaceContent(fd.getString("gbk_reply",i))%></font></td>
                        </tr>
                    </table>
                    <br>
                </td></tr>
              </table>
<%}%>
              <br>
        </td></tr>
        <tr bgcolor="cccccc">
          <td colspan=3 align=center>
            <a href=mailto:<%=fd.getString("gbk_mail",i)%> title="<%=fd.getString("gbk_name",i)%>的e-mail地址是:<%=fd.getString("gbk_mail",i)%>"><img src="../image/gbook/mail.gif" border="0" width="15" length="15">邮件</a>
            <a href="<%=fd.getString("gbk_website",i)%>" target="_blank" title="<%=fd.getString("gbk_name",i)%>的主页地址是:<%=fd.getString("gbk_website",i)%>"><img src="../image/gbook/home.gif" border="0" width="14" length="14" >主页</a>
            <a href="http://search.tencent.com/cgi-bin/friend/user_show_info?ln=<%=fd.getString("gbk_qq",i)%>" target=_blank title="<%=fd.getString("gbk_name",i)%>的ＱＱ是:<%=fd.getString("gbk_qq",i)%>"><img src="../image/gbook/qq.gif" border="0" width="14" length="14" >ＱＱ</font>
            <a href=admin.jsp?theID=<%=fd.getString("gbk_id",i)%> title="只有管理员才有回复的权限哦"><img src="../image/gbook/replay.gif" border="0" width="14" length="14">回复</a>
        </td></tr></table>
    </td></tr></table><br>
<%}%>
<%=fd.getNavi("form1")%>
<br>
<input type=button value="我要留言" onclick="location.href='./post.jsp'" style="border:1px dotted #111111; border-collapse: collapse; color:#000000; background-color: #EFEFEF">
    </td></tr>
</form>
</table>
<!--Page End-->

<%@ include file="../include/footer.jsp" %>
<%}catch(Exception e){alertPage(response,7775,e.toString());}finally{dbCon.close();}%>