📄 newsmain.jsp.svn-base
字号:
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%>"><%=strNewsTitle%></a><font color="<%=mainFontColor%>"> [<%=iNewsReCnt%>]</font><br>
<%}
}
rs.close();
pstmt.close();
}
else
{
%>殿废等 弥辟 春胶啊 绝嚼聪促.<%
}
%>
</td>
</tr>
<tr height="4">
<td width="6"></td>
<td></td>
</tr>
<tr>
<td width="6"></td>
<%if (count > 0)
{ %>
<td align="right"><font color="#928279" size="3"><a href="<%=url_path%>/news/friendNewsList.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>">歹焊扁⒑</a> </font></td>
<%}
else{
if (mphone.equals(gphone)) {
GregorianCalendar currentDay = new GregorianCalendar();
int year = currentDay.get(Calendar.YEAR);
int month = currentDay.get(Calendar.MONTH) + 1;
int today = currentDay.get(Calendar.DATE);
%>
<td align="right"><font color="#928279" size="3"><a href="<%=url_path%>/news/ProfileSearch.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>&year=<%=year%>&month=<%=month%>&day=<%=today%>">模备茫扁⒑</a> </font></td>
<%} }%>
</tr>
<tr height="8">
<td width="6"></td>
<td></td>
</tr>
<!-- 模备春胶 牧刨明 场 -->
<!-- 眠玫 鸥款春胶 鸥捞撇 矫累 -->
<tr height="17">
<td width="6" bgcolor="<%=mainBgColor%>"></td>
<td bgcolor="<%=mainBgColor%>"><font color="#ffffff">::: 眠玫 鸥款春胶 BEST</font></td>
</tr>
<tr height="8">
<td width="6"></td>
<td></td>
</tr>
<!-- 眠玫 鸥款春胶 鸥捞撇 场 -->
<!-- 眠玫 鸥款春胶 牧刨明 矫累 -->
<tr height="17">
<td width="6"></td>
<td>
<table border="0" cellspacing="0" cellpadding="0">
<!-- 春胶 海胶飘 鸥捞撇 矫累 -->
<tr>
<td width="2"></td>
<td><b>春胶</b><font color="<%=mainFontColor%>"><b>BEST</b></font></td>
<td width="6"></td>
</tr>
<!-- 春胶 海胶飘 鸥捞撇 场 -->
<!-- 备盒急 矫累 -->
<tr height="2">
<td colspan="3"></td>
</tr>
<tr height="1">
<td colspan="2" bgcolor="#ffcbb9"></td>
<td width="6"></td>
</tr>
<tr height="2">
<td colspan="3"></td>
</tr>
<!-- 备盒急 场 -->
<!-- 春胶 海胶飘 牧刨明 矫累 -->
<%
sql = "SELECT a.kind, a.title, a.reCnt, a.phonenum FROM GT_NSNEWS a WITH (READUNCOMMITTED) ,(SELECT TOP 1 * FROM GT_NsBest WITH (READUNCOMMITTED) WHERE board_kind = 1 ORDER BY regdate DESC) b WHERE b.board_idx = a.idx";
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if (rs.next())
{
iNewsKind = rs.getInt("kind");
strNewsTitle = rs.getString("title");
iNewsReCnt = rs.getInt("reCnt");
strFriendPhone = getStrPhone(getLong(rs.getString("phonenum")));
if (iNewsKind == 1)
strNewsKind = "[荤扒/荤绊]";
else if (iNewsKind == 2)
strNewsKind = "[瘤开]";
else if (iNewsKind == 3)
strNewsKind = "[楷抗/胶器明]";
else if (iNewsKind == 4)
strNewsKind = "[扁鸥]";
rs.close();
pstmt.close();
cStringTypeLength = 15 - strNewsKind.length();
strPrintNewsTitle = cStringTypeLength < strNewsTitle.length() ? strNewsTitle.substring(0,cStringTypeLength) + "..." : strNewsTitle;
if (mphone.equals(strFriendPhone))
strJSPLink = "my_news_list_lhl.jsp";
else
strJSPLink = "other_news_list_lhl.jsp";
cBestCount = cBestCount + 1;
%>
<tr>
<td width="2"></td>
<td><font color="<%=mainFontColor%>"><%=strNewsKind%> </font><a href="<%=url_path%>/news/<%=strJSPLink%>?mphone=<%=mphone%>&gphone=<%=returnString(strFriendPhone,mphone)%>"><%=strPrintNewsTitle%></a><font color="<%=mainFontColor%>"> [<%=iNewsReCnt%>]</font></td>
<td width="6"></td>
</tr>
<%
}
else
{
%>
<tr>
<td width="2"></td>
<td>殿废等 春胶啊 绝嚼聪促.</td>
<td width="6"></td>
</tr>
<%
}%>
<!-- 春胶 海胶飘 牧刨明 场 -->
<!-- 咯归 矫累 -->
<tr height="8">
<td colspan="3"></td>
</tr>
<!-- 咯归 场 -->
<!-- 柠令 海胶飘 鸥捞撇 矫累 -->
<tr>
<td width="2"></td>
<td><b>柠令</b><font color="<%=mainFontColor%>"><b>BEST</b></font></td>
<td width="6"></td>
</tr>
<!-- 柠令 海胶飘 鸥捞撇 场 -->
<!-- 备盒急 矫累 -->
<tr height="2">
<td colspan="3"></td>
</tr>
<tr height="1">
<td colspan="2" bgcolor="#ffcbb9"></td>
<td width="6"></td>
</tr>
<tr height="2">
<td colspan="3"></td>
</tr>
<!-- 备盒急 场 -->
<!-- 柠令 海胶飘 牧刨明 矫累 -->
<%sql = "SELECT a.kind, a.title, a.reCnt, a.phonenum FROM GT_NSQuiz a WITH (READUNCOMMITTED) ,(SELECT TOP 1 * FROM GT_NsBest WITH (READUNCOMMITTED) WHERE board_kind = 2 ORDER BY regdate DESC) b WHERE b.board_idx = a.idx";
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if (rs.next())
{
iNewsKind = rs.getInt("kind");
strNewsTitle = rs.getString("title");
iNewsReCnt = rs.getInt("reCnt");
strFriendPhone = getStrPhone(getLong(rs.getString("phonenum")));
if (iNewsKind == 1)
strNewsKind = "[郴秒氢]";
else if (iNewsKind == 2)
strNewsKind = "[郴厚剐]";
else if (iNewsKind == 3)
strNewsKind = "[郴己氢]";
else if (iNewsKind == 4)
strNewsKind = "[扁鸥]";
rs.close();
pstmt.close();
cStringTypeLength = 15 - strNewsKind.length();
strPrintNewsTitle = cStringTypeLength < strNewsTitle.length() ? strNewsTitle.substring(0,cStringTypeLength) + "..." : strNewsTitle;
cBestCount = cBestCount + 1;
%>
<tr>
<td width="2"></td>
<td><font color="<%=mainFontColor%>"><%=strNewsKind%> </font><a href="<%=url_path%>/news/myQuizList.jsp?mphone=<%=mphone%>&gphone=<%=returnString(strFriendPhone,mphone)%>"><%=strPrintNewsTitle%></a><font color="<%=mainFontColor%>"> [<%=iNewsReCnt%>]</font></td>
<td width="6"></td>
</tr><%
}
else
{
%>
<tr>
<td width="2"></td>
<td>殿废等 柠令啊 绝嚼聪促.</td>
<td width="6"></td>
</tr>
<%
}%>
<!-- 柠令 海胶飘 牧刨明 场 -->
<!-- 咯归 矫累 -->
<tr height="8">
<td colspan="3"></td>
</tr>
<!-- 咯归 场 -->
<!-- 汲巩炼荤 海胶飘 鸥捞撇 矫累 -->
<tr>
<td width="2"></td>
<td><b>汲巩炼荤</b><font color="<%=mainFontColor%>"><b>BEST</b></font></td>
<td width="6"></td>
</tr>
<!-- 汲巩炼荤 海胶飘 鸥捞撇 场 -->
<!-- 备盒急 矫累 -->
<tr height="2">
<td colspan="3"></td>
</tr>
<tr height="1">
<td colspan="2" bgcolor="#ffcbb9"></td>
<td width="6"></td>
</tr>
<tr height="2">
<td colspan="3"></td>
</tr>
<!-- 备盒急 场 -->
<!-- 汲巩炼荤 海胶飘 牧刨明 矫累 -->
<%sql = "SELECT a.title, a.Provision1Cnt + a.Provision2Cnt + a.Provision3Cnt + a.Provision4Cnt +a.Provision5Cnt reCnt, a.phonenum FROM GT_NsResearch a WITH (READUNCOMMITTED) ,(SELECT TOP 1 * FROM GT_NsBest WITH (READUNCOMMITTED) WHERE board_kind = 3 ORDER BY regdate DESC) b WHERE b.board_idx = a.idx";
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if (rs.next())
{
strNewsTitle = rs.getString("title");
iNewsReCnt = rs.getInt("reCnt");
strFriendPhone = getStrPhone(getLong(rs.getString("phonenum")));
strNewsKind = "Q.";
rs.close();
pstmt.close();
cStringTypeLength = 15 - strNewsKind.length();
strPrintNewsTitle = cStringTypeLength < strNewsTitle.length() ? strNewsTitle.substring(0,cStringTypeLength) + "..." : strNewsTitle;
cBestCount = cBestCount + 1;
%>
<tr>
<td width="2"></td>
<td><a href="<%=url_path%>/news/ResearchList.jsp?mphone=<%=mphone%>&gphone=<%=returnString(strFriendPhone,mphone)%>"><%=strNewsKind%> <%=strPrintNewsTitle%></a><font color="<%=mainFontColor%>"> [<%=iNewsReCnt%>]</font></td>
<td width="8"></td>
</tr>
<%
}
else
{
%>
<tr>
<td width="2"></td>
<td>殿废等 汲巩炼荤啊 绝嚼聪促.</td>
<td width="8"></td>
</tr><%
}%>
<!-- 汲巩炼荤 海胶飘 牧刨明 场 -->
</table>
</td>
</tr>
<tr>
<td width="6">
</td>
<td align="right">
<%if (cBestCount > 0){ %>
<font color="#928279" size="3"><a href="<%=url_path%>/news/bestNewsList.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>&SearchType=0">歹焊扁⒑</a> </font>
<%} %>
</td>
</tr>
<!-- 眠玫 鸥款春胶 牧刨明 场 -->
</table>
</td>
</tr>
<!-- 春胶 府胶飘 场 -->
<!-- 咯归 矫累 -->
<tr height="3">
<td></td>
</tr>
<!-- 咯归 场 -->
<tr width="6">
<td align="right"></td>
</tr>
<!-- 咯归 矫累 -->
<tr height="10">
<td></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 returnOtherphone=url_path+"/mypage/my_confirm.jsp?mphone="+mphone+"&gphone="+gphone;
String returnAdminPhone=url_path+"/mypage/my_main_sub.jsp?mphone="+mphone+"&gphone="+mphone;
%>
<!-- 滚瓢 矫累 -->
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr height="16">
<td></td>
<% if (mphone.equals(gphone)) {%>
<td width="75" bgcolor="<%=mainBgColor%>" align="center" ><a href="<%=returnMyphone%>"><font color="#ffffff">郴迄乔啊扁</font></a></td>
<td width="2"></td>
<td width="75" bgcolor="<%=mainBgColor%>" align="center" ><a href="<%=returnAdminPhone%>"><font color="#ffffff">迄乔包府啊扁</font></a></td>
<%} else { %>
<td width="75" bgcolor="<%=mainBgColor%>" align="center" ><a href="<%=returnOtherphone%>"><font color="#ffffff">倒酒啊扁</font></a></td>
<td width="2"></td>
<td width="75" 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">
<a href="<%=step1%>">权</a>><a href="<%=step2%>"><%=nickName%>丛狼迄乔</a>>迄乔春胶
</td>
<td width="8" bgcolor="#BBC7C8"></td>
</tr>
</table>
</td>
</tr>
<!--版肺钎矫 场-->
</table>
</body>
</html>
<%
}catch(Exception e)
{
out.println(e);
}
finally
{
if(rs != null) try{ rs.close(); }catch(Exception se){}
if(pstmt != null) try{ pstmt.close(); }catch(Exception se){}
if(stmt != null) try{ stmt.close(); }catch(Exception se){}
if(con != null) try{ con.close(); }catch(Exception se){}
}
%>
<%!
public String returnString(String type, String phone)
{
return type.isEmpty() ? phone : type;
}
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -