bestnewslist.jsp

用手机浏览的一个类似于聊天室 博克 homepage 等 对这方面有 兴趣的朋友 有所帮助的

	<%
		
          pageurl=url_path+"/news/bestNewsList.jsp?mphone="+mphone+"&gphone="+gphone+"&SearchType="+SearchType;
          
          String [] szSplit = pagePathTop(pageurl, dbcount, pageNUM, pagecount);
    %>
	<tr>
    	<td>
    		<table width="176"  border="0" cellspacing="0" cellpadding="0" bgcolor="<%=pageBgColor %>">
    		<tr>
     		<td width="10"></td>
      
      		<td  width="60" height="19" align="left"><font color="#676767" size="3">⒏ </font><font color="<%=pageFNFontColor %>" size="3">(7)</font><%=szSplit[0]%><font color="<%=pageFNFontColor %>" size="3"><b>捞傈</b></font><%=szSplit[1]%></td>
     
     		<td></td>
     
     		<td   width="60"  height="19" align="right"><%=szSplit[2]%><b><font color="<%=pageFNFontColor%>" size="3">促澜</font></b><%=szSplit[3]%><font color="<%=pageFNFontColor%>" size="3">(9)</font><font color="#676767" size="3"> ⒑</font></td>
     
     		<td width="10"></td>
     		</tr>
     	</table>
    	</td>
    </tr>
	<!--捞傈/促澜 傅农 冠胶 场-->


	<!--咯归 矫累-->
	<tr>
		<td height="4"></td>
	</tr>
	<!--咯归 场-->

	<!-- 府敲 格废 矫累 -->
	<tr>
		<td>
			<table width="176" border="0" cellspacing="0" cellpadding="0">
				<tr>
					<td width="2"></td>
					<td>
						<%
					int count = 0 ; //其捞瘤 墨款磐 函荐
					while(count<pagesize)
					{
						count++;
						iIdx			= rs.getInt("idx");
						strNewsTitle	= rs.getString("title");
						iNewsReCnt		= rs.getInt("reCnt");
						strRegdate		= rs.getString("regdate");
						iNewsKind		= rs.getInt("kind");
						strFriendPhone	= rs.getString("phonenum");
						iQueryType		= rs.getInt("board_kind");
						
						if (iQueryType == 1){
							if (iNewsKind == 1)
								strNewsKind = "[荤扒/荤绊]";
							else if (iNewsKind == 2)
								strNewsKind = "[瘤开]";
							else if (iNewsKind == 3)
								strNewsKind = "[楷抗/胶器明]";
							else if (iNewsKind == 4)
								strNewsKind = "[扁鸥]";	
						} else if (iQueryType == 2) {
							if (iNewsKind == 1)
								strNewsKind = "[郴秒氢]";
							else if (iNewsKind == 2)
								strNewsKind = "[郴厚剐]";
							else if (iNewsKind == 3)
								strNewsKind = "[郴己氢]";
							else if (iNewsKind == 4)
								strNewsKind = "[扁鸥]";	
						} else {
							strNewsKind = "Q.";
						}
						
						 if (iQueryType == 3){
							 strJSPLink = "ResearchList.jsp";							 
						 %>					 	
						 	<font color="#716e63"> <%=strNewsKind%></font><a href="<%=url_path%>/news/<%=strJSPLink%>?mphone=<%=mphone%>&gphone=<%=strFriendPhone%>"><font color="#716e63"><%=strNewsTitle%></font></a><font color="#ff4759"> [<%=iNewsReCnt%>] </font><br>
						 <% }
						 else {
						 	if (iQueryType == 2)
						 		strJSPLink = "myQuizList.jsp";
						 	else
						 		if (mphone.equals(strFriendPhone))
						 			strJSPLink = "my_news_list_lhl.jsp";
						 		else
						 			strJSPLink = "other_news_list_lhl.jsp";
						 %>
						 	<font color="<%=mainFontColor%>"> <%=strNewsKind%> </font><a href="<%=url_path%>/news/<%=strJSPLink%>?mphone=<%=mphone%>&gphone=<%=strFriendPhone%>"><font color="#716e63"><%=strNewsTitle%></font></a><font color="#ff4759"> [<%=iNewsReCnt%>]</font><br>
						 <%}	
						if(rs.isLast())
						{ //盖 付瘤阜 饭内靛 老版快
							 break;
						}
						else
						{
							rs.next();
						}
					} 
				 %>
					</td>
					<td width="2"></td>
				</tr>
			</table>
		</td>
	</tr>	
	<!-- 府敲 格废 场 -->

	<!--咯归 矫累-->
	<tr>
		<td height="4"></td>
	</tr>
	<!--咯归 场-->

	
	<!--其捞瘤 傅农 矫累-->
	<%
    String [] szSplit2 = pagePathBottom(pageurl, dbcount, pageNUM, pagecount);
    %>
   <tr>
    <td>
   <table width="176"  border="0" cellspacing="0" cellpadding="0" bgcolor="<%=pageBgColor %>">
    <tr>
     <td height="16">
      <table width="176" border="0" cellspacing="0" cellpadding="0">
       <tr>
        <td></td>
        <td width="21" align="center"><%=szSplit2[0]%><font color="#676767" size="3"><%=szSplit2[1]%></font><%=szSplit2[2]%></td>
       <%
        String pageColor = "";
        for(int i=1;i<6;i++)
        {
         if(pageNUM%10 ==  Integer.parseInt(szSplit2[i*3+1]))
          pageColor = pageFontColorY;
         else
          pageColor = pageFontColorN;
       %>
         <td width="1" align="center"><font color="<%=pageColor %>" size="3">|</font></td>
         <td width="21" align="center"><%=szSplit2[i*3]%><font color="<%=pageColor%>" size="3"><b><%=szSplit2[i*3+1]%></b></font><%=szSplit2[i*3+2]%></td>
       <%
        }
       %>
        <td width="21" align="center"><%=szSplit2[18]%><font color="#676767" size="3"><%=szSplit2[19]%></font><%=szSplit2[20]%></td>
        <td></td>
       </tr>
      </table>
     </td>
    </tr>
   </table>
   </td>
  </tr>
	<!--其捞瘤 傅农 场-->

	
	<!--咯归 矫累-->
	<tr>
		<td height="4"></td>
	</tr>
	<!--咯归 场-->
	<%	//String step1=url_path+"/main.jsp?mphone="+mphone+"&gphone="+gphone;//权
	String returnMyphone=url_path+"/mypage/my_confirm.jsp?mphone="+mphone+"&gphone="+mphone;
	String returnPhoneNews=url_path+"/news/NewsMain.jsp?mphone="+mphone+"&gphone="+gphone;
 %>
	<!-- 滚瓢 矫累 -->
	<tr> 
		<td>
			<table width="176" border="0" cellspacing="0" cellpadding="0">
				<tr height="16">
					<td></td>
					<td width="65" bgcolor="<%=mainBgColor%>" align="center" ><a href="<%=returnPhoneNews%>"><font color="#ffffff">迄乔春胶肺</font></a></td>
					<td width="2"></td>
					<td width="65" bgcolor="<%=mainBgColor%>" align="center" ><a href="<%=returnMyphone%>"><font color="#ffffff">郴迄乔啊扁</font></a></td>
					<td></td>
				</tr>
			</table>
		</td>
	</tr>
	<!-- 滚瓢 场 -->
	
	<!-- 咯归 矫累 -->
	<tr height="11">
		<td></td>
	</tr>
	<!-- 咯归 场 -->
<%
String step1=url_path+"/main.jsp?mphone="+mphone+"&gphone="+gphone;//权
String step2=url_path+"/mypage/my_confirm.jsp?mphone="+mphone+"&gphone="+gphone;
String step3=url_path+"/news/NewsMain.jsp?mphone="+mphone+"&gphone="+gphone;
%>
	<!--版肺钎矫 矫累-->
	<tr>
		<td>
			<table width="176" border="0" cellspacing="0" cellpadding="0">
				<tr height="15">
					<td width="8" bgcolor="#BBC7C8"></td>
					<td bgcolor="#DAE6E8">
						&nbsp;<a href="<%=step1%>">权</a>&gt;<a href="<%=step2%>">硅萍丛狼迄乔</a>&gt;<a href="<%=step3%>">春胶</a>&gt;眠玫春胶
					</td>
					<td width="8" bgcolor="#BBC7C8"></td>
				</tr>
			</table>
		</td>
	</tr>
	<!--版肺钎矫 场-->
</table>

</body>
</html>

<%
		}
	catch(Exception e)
	{
		throw e;
	}
	finally
	{ 
		if ( rs != null ) { try { rs.close(); } catch ( Exception e ) { } }
		if ( stmt != null ) { try { stmt.close(); } catch ( Exception e ) { } }
		if ( con != null ) { try { con.close(); } catch ( Exception e ) { } }
	}
%>