<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>
<jsp:useBean id="td_gb" class="td.guestbook"/>
<jsp:useBean id="td_date" class="td.mydate"/>
<%-- 包含配置文件 --%>
<%@ include file="config.jsp" %>

<%
	if(td_gb.init(mysqlDriver,mysqlUrl,mysqlUser,mysqlPsw))
	{
	    //獲得留言總數(shù)
	    td_gb.mes_total();
	    int mes_total = td_gb.getmes_total();
	    if(mes_total <= 0)
	    {
	        request.setAttribute("title","天地網(wǎng)絡(luò)--JSP留言薄");
  				request.setAttribute("td_bg_message","<font color=\"#FF0000\">暫無留言！</font><a href=\"postnew.jsp\">點(diǎn)擊這里發(fā)表留言</a>");
%>
          <%@ include file="message.jsp" %>
<%
	    }
			else
			{
          //獲得配置信息
          td_gb.getconfig();
	
	        //每頁(yè)顯示數(shù)
	        int pageshownumber = td_gb.getpageshownumber();
	
	        //獲得得當(dāng)前頁(yè)數(shù)
	        int Page = 1;
	        String p = request.getParameter("Page");
	        if(p==null||p.equals("")||p=="")
	        {
	            Page = 1;
	        }
	        else
	        {
	            Page = Integer.valueOf(p).intValue();
	        }
					
	        //獲得頁(yè)面總數(shù)
	        td_gb.page_total();
	
	        int page_total = td_gb.getpage_total();
          if(Page > page_total)
	        {
	            Page = page_total;
	        }
	        else if(Page <= 0)
	        {
	            Page = 1;
	        }
	        //向JavaBean傳送當(dāng)前頁(yè)面
	        td_gb.currentpage(Page);
	
	        //查詢留言
	        ResultSet res = td_gb.query();
	        if(res==null)
	        {
	            request.setAttribute("title","天地網(wǎng)絡(luò)--JSP留言薄");
      				request.setAttribute("td_bg_message","<font color=\"#FF0000\">產(chǎn)生未知錯(cuò)誤</font>");
%>
              <%@ include file="message.jsp" %>
<%
	        }
					else
					{
						  //上下頁(yè)連接
						  String page_link = null;
						  String last = "------";
						  String next = "------";
						  if(Page < page_total)
						  {
						      next = "<a href=\"index.jsp?Page="+(Page+1)+"\">下一頁(yè)</a>";
						  }

						  if(Page > 1)
						  {
						      last = "<a href=\"index.jsp?Page="+(Page-1)+"\">上一頁(yè)</a>";
						  }
						  page_link = last + "&nbsp;||&nbsp;" + next;
							
%>

							<%@ include file="index_content.jsp" %>
<%
							
					}
	
			}
	}
	else
	{
	      request.setAttribute("title","天地網(wǎng)絡(luò)--JSP留言薄");
				request.setAttribute("td_bg_message","<font color=\"#FF0000\">連接數(shù)據(jù)庫(kù)失敗！</font>");
				
%>
				<%@ include file="message.jsp" %>
<%
			
	}
%>