<%@ page contentType="text/html;charset=gb2312" %>
<%@ include file="top.jsp"%>

<TABLE id=Table1 cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR id=main_section vAlign=top>
<TD>

      <TABLE height="100%" cellSpacing=0 cellPadding=0 width="100%" border=0>
        <TBODY>
        <TR >
          <TD   class=welcomeleft id=left_pane vAlign=top width=155 >
            <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0  background=../images/back.gif height=586>
              <TBODY>
               <TR>
                <TD   valign=top>


<%@ include file="tool_mainmenu.jsp"%>



             </TD></TR>
             </TBODY></TABLE>




</TD><TD id=right_pane  background=../images/adminbodybg8.gif valign=top>
<!----------------------------------------->
<br><br>
<TABLE class="titletable" cellSpacing="0" cellPadding="0" width="99%" border="0">
<TR>
<TD><IMG height="32" src="../images/bbs.jpg" width="31" align="absMiddle">我的通訊錄</TD>
</TR>
</TABLE>

<TABLE class="ToolbarTable" width="100%" cellSpacing="0" cellPadding="0" border="0" align=center>
<tr>
<td colspan="6" class="toolbarsplitline"></td>
</tr>
<tr>
<td colspan="6" class="toolbarsplittr"></td>
</tr>
</TABLE>

<table class="datatable" cellSpacing="0" cellPadding="0" width="99%" border="0"  align=center>
<tr>
<td vAlign="top" align="center">

<table class="dgborder" cellspacing="0" align="Center" rules="rows" border="1" id="dgVehicleInfo" style="width:100%;border-collapse:collapse;">

<tr class="DgHeaderStyle">
<td align="Center" width=8%>姓名</td><td align="Center" width=15%>電話</td><td align="Center" width=30%>住址</td><td align="Center" width=10%>郵件</td>
</tr>

<%int vm=0;
stmt = con.createStatement() ;
rs=stmt.executeQuery("SELECT * from myfriend where myname='"+(String) session.getAttribute("username")+"' order by id desc");
String pages = request.getParameter("page") ;

int pageInt =  1 ,i=0 ,k=1;
if(pages==null){}else{pageInt = Integer.parseInt(pages);}
while(i<20*(pageInt-1)&&rs.next()){i++ ;}
i=0;
while(rs.next()&i<20){
i++ ;
%>


<tr  <%if(vm==0){%> class="DgAlterStyle"<%vm++;}else{vm--;}%> class="dgitemstyle"><td align="Center">
<a href=# onclick="if (confirm('確實(shí)要?jiǎng)h除此條記錄嗎？')) window.location='delfriend.jsp?id=<%=rs.getString("id")%>'"><img src=../images/delete.gif border=0 title="刪除記錄" width=15></a>&nbsp; <b><%=rs.getString("friendname")%></b></td><td align="Center"><%=rs.getString("friendtel")%></td><td align="Center"><%=rs.getString("friendadd")%></td><td align="Center"><a href=mail_main.jsp?mail=<%=rs.getString("friendemail")%>&space=9.0 title="點(diǎn)擊給<%=rs.getString("friendname")%>發(fā)送郵件"><%=rs.getString("friendemail")%>[發(fā)郵件]</a></td></tr>

<%
}
%>
<%
rs=stmt.executeQuery("SELECT count(*) from myfriend  where myname='"+(String) session.getAttribute("username")+"' ");
%>
<tr class="dgpagestyle">
<td colspan="9"><span><%@ include file="page.jsp"%></span></td>
</tr>
</table>

</td>
</tr>
</table>
<!----------------------------------------->
</TD></TR></TBODY></TABLE></TD></TR>
</TBODY>
</table>






<%@ include file="end.jsp"%>
</BODY>
</HTML>