index.jsp

1

            <table width="230" border="0" cellspacing="0" cellpadding="0" height="46">
              <tr> 
                <td> 
                  <table width="210" border="0" cellspacing="0" cellpadding="0">
                    <tr> 
                      <td width="90">&nbsp;</td>
                      <td width="120">&nbsp;</td>
                    </tr>
                  </table>
                </td>
              </tr>
            </table>
<!--Button6.Content.End-->



<!--Button7.Content.Begin-->
            <table width="230" border="0" cellspacing="0" cellpadding="0" height="46">
              <tr> 
                <td> 
                  <table width="210" border="0" cellspacing="0" cellpadding="0">
                    <tr> 
                      <td width="90">&nbsp;</td>
                      <td width="120">&nbsp;</td>
                    </tr>
                  </table>
                </td>
              </tr>
            </table>
<!--Button7.Content.End-->



<!--Button8.Content.Begin-->
            <table width="230" border="0" cellspacing="0" cellpadding="0" height="46">
              <tr> 
                <td>&nbsp;</td>
              </tr>
            </table>
<!--Button8.Content.End-->



<!--Button9.Content.Begin-->
            <table width="230" border="0" cellspacing="0" cellpadding="0" height="46">
              <tr> 
                <td> 
                  <table width="90" border="0" cellspacing="0" cellpadding="0">
                    <tr> 
                      <td width="90">&nbsp;</td>
                    </tr>
                  </table>
                </td>
              </tr>
            </table>
<!--Button9.Content.End-->



<!--Button10.Content.Begin-->
            <table width="230" border="0" cellspacing="0" cellpadding="0" height="46">
              <tr> 
                <td> 
                  <table width="210" border="0" cellspacing="0" cellpadding="0">
                    <tr> 
                      <td width="90">&nbsp;</td>
                      <td width="120"><b>
<!--Button10.Link-->
<a href="#">
<!--Button10-->
</a> </b></td>
                    </tr>
                  </table>
                </td>
              </tr>
            </table>
<!--Button10.Content.End-->




          </td>
        </tr>
        <tr> 
          <td valign="top">&nbsp;</td>
        </tr>
      </table>
    </td>
    <td valign="top" rowspan="2"> 
      <table width="525" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr valign="top"> 
          <td>
<!--IndexPage.Content.Begin-->
 
            <table width="94%" border="0" cellspacing="0" cellpadding="0" align="center">
              <tr> 
                <td>
<%
    	if (pageActive==1){
    	%>

    	        <%
    }else{
    	%>    	
    	        <a href="index.jsp?pageActive=1">第一页</a> |<a href="index.jsp?pageActive=<%=pageActive-1%>"> 上一页 </a>|
    	        <%
    	
    	}
    	
    	if(pageActive == pageCount ){
    	%>

    	<%
    }else{
    	
    	%>    	
    	<a href="index.jsp?pageActive=<%=pageActive+1%>"> 下一页 </a>| <a href="index.jsp?pageActive=<%=pageCount%>">尾页</a>|<span class="STYLE6">
    	<%
    	}
    	
    	%>
    	
</td>
              </tr>
              <tr> 
                <td bgcolor="#000000"><img src="images/Spacer.gif" width="1" height="1"></td>
              </tr>
              <tr> 
                <td> 
                  <div align="right">
<!--SubPage.Begin-->
<!--Something Here-->
<!--SubPage.End-->
</div>
                </td>
              </tr>
              <tr> 
                <td valign="top"><br><table width="499" height="43" border="0" align="left" cellpadding="1" cellspacing="1">
			<%
	String title="";
	String content="";
	
	while(rs.next()){	
	title=rs.getString("title")+"";
	content=rs.getString("content")+"";
	if(title.length()>20){
	title=title.substring(0,20)+"...";
	}
	if(content.length()>90){
	content=content.substring(0,90)+"...";
	}
	content=content.replace(" ","&nbsp;");
	
	//for 看简图	
		PreparedStatement ps5=con.prepareStatement("select * from news_file where newsid=? and extension in('gif','jpg','jpeg','png','bmp') limit 1");
		ps5.setString(1,rs.getString("newsid"));
		ResultSet rs5=ps5.executeQuery();
		String src="";
		while(rs5.next()){
			src=rs5.getString("filename2");
		}
		if(src==null||src.equals("")){
			src="images//nophoto.jpg";
		}else{
			src="uploadfiles//"+src;
		}
%>
              <tr>
                <td width="76%" height="20"><span><span ><a  href="vnews.jsp?newsid=<%=rs.getString("newsid")%>" target="_blank" title="<%=content%>"><%=title%></a></span></span></td>
                <td width="24%" rowspan="2"><div align="center"><span ><img src="<%=src%>" onload="DrawImage(this,90,65)"></span></div></td>
              </tr>
              <tr>
                <td height="20" valign="top" >&nbsp;&nbsp;&nbsp;<%=content%></td>
                </tr>
<%
	}
	if(pageCount==0){
%>
		<div align="left">No News! </div>
<%
}
%>
<tr>
<td height="20" colspan="2"><br><%
    	if (pageActive==1){
    	%>

    	        <%
    }else{
    	%>
    	[<a href="index.jsp?pageActive=1">第一页</a>]
    	
    	[<a href="index.jsp?pageActive=<%=pageActive-1%>">上一页</a>]
    	<%
    	
    	}
    	
    	if(pageActive == pageCount ){
    	%>

    	<%
    }else{
    	
    	%>
    	
    	
    	[<a href="index.jsp?pageActive=<%=pageActive+1%>">下一页</a>]
    	[<a href="index.jsp?pageActive=<%=pageCount%>">尾页</a>]<span class="STYLE6">
    	<%
    	}
    	
    	%>
    	总共<%=resultCount%>条新闻   共<%=pageCount%>页</span></td>
</tr>
</table><br>
                  <!--Something Here-->
<!--Page.Content.End--></td>
              </tr>
            </table>
<!--IndexPage.Content.End-->
            <table width="94%" border="0" cellspacing="0" cellpadding="0" align="center">
              <tr> 
                <td> <b><font size="3"><br>
                  </font></b> 
                  <table width="100%" border="0" cellspacing="0" cellpadding="0" align="center" class="englishfont" height="1">
                    <tr> 
                      <td bgcolor="#000000"> </td>
                    </tr>
                  </table>
                  <br>
                  <table width="96%" border="0" cellspacing="0" cellpadding="4" align="center">
                    <tr> 
                      <td> 
                        <div align="center">
<!--Your Company Name-->
胡玉玺JSP新闻系统
<!--TCopyRight-->
 版权所有
@2007<br>
<!--TAddress-->http://www.javaif.com java世界<!--Address-->
<br>
<!--TTelephone-->
有问题请到http://www.javaif.com/ask/
<!--EMail-->
<A HREF='mailto:
<!--Email-->

'>
<!--Email-->
</A></div>
                      </td>
                    </tr>
                  </table>
                </td>
              </tr>
            </table>
            <br>
          </td>
        </tr>
      </table>
    </td>
    <td valign="top" width="20" rowspan="2">&nbsp;</td>
  </tr>
  <tr>
    <td width="230" valign="bottom"><img src="images/index_lmbottom.gif" width="230" height="80"></td>
  </tr>
</table>
</BODY>
</HTML>
<%
con.close();
%>