📄 newsmain.jsp
字号:
<%}if (!strMusic.isEmpty()) {%>
<font color="#928279" size="3">- 坷疵 甸篮 澜厩 : </font><a href="<%=strJSPLink%>&news=<%=strMusic%>&colum_num=7"><%=strMusic%></a><font color="<%=mainFontColor%>" size="3"> [<%=iMusicReCnt%>]</font><br>
<%}if (!strAgony.isEmpty()){ %>
<font color="#928279" size="3">- 坷疵狼 绊刮 : </font><a href="<%=strJSPLink%>&news=<%=strAgony%>&colum_num=8"><%=strAgony%></a><font color="<%=mainFontColor%>" size="3"> [<%=iAgonyReCnt%>]</font><br>
<%}if (!strLookMan.isEmpty()) {%>
<font color="#928279" size="3">- 瘤陛 焊绊锹 荤恩 : </font><a href="<%=strJSPLink%>&news=<%=strLookMan%>&colum_num=9"><%=strLookMan%></a><font color="<%=mainFontColor%>" size="3"> [<%=iLookManReCnt%>]</font><br>
<%}if (!strFault.isEmpty()) {%>
<font color="#928279" size="3">- 坷疵狼 角荐 : </font><a href="<%=strJSPLink%>&news=<%=strFault%>&colum_num=10"><%=strFault%></a><font color="<%=mainFontColor%>" size="3"> [<%=iFaultReCnt%>]</font><br>
<%} %>
</td>
<td width="3"></td>
</tr>
<tr height="8">
<td colspan="3"></td>
</tr>
</table>
</td>
</tr>
<!-- 滚瓢 矫累 -->
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr height="16">
<td></td>
<%if (mphone.equals(gphone)) {
if (boolState == false){
%>
<td align="center" width="60" bgcolor="#efebd5"><a href="<%=url_path%>/news/ProfileInput.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>"><font color="#716e63" size="3">货臂殿废</font></a></td>
<%}
else{
%> <td align="center" width="60" bgcolor="#efebd5"><a href="<%=url_path%>/news/ProfileModify.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>"><font color="#716e63" size="3">荐沥窍扁</font></a></td>
<%}%>
<%}
else {
%>
<td align="center" width="60" bgcolor="#efebd5"><a href="<%=url_path%>/mypage/my_black_confirm.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>&hostf=N&code=5"><font color="#716e63" size="3">规疙废静扁</font></a></td>
<%
}
sql = "SELECT COUNT(*) FROM GT_NsProfile WITH (READUNCOMMITTED) WHERE PHONENUM="+ Long.parseLong(gphone);
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if (rs.next())
{
count = rs.getInt(1);
}
rs.close();
pstmt.close();
//if (mphone.equals(gphone) || count > 0)
//{
%>
<td width="2"></td>
<td align="center" width="60" bgcolor="#efebd5"><a href="<%=url_path%>/news/Calendar.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>&nickname=<%=nickName%>"><font color="#716e63" size="3">橇肺鞘崔仿</font></a></td>
<%//}
sql = "SELECT COUNT(*) FROM GT_Ns30question WITH (READUNCOMMITTED) WHERE PHONENUM="+ Long.parseLong(gphone);
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if (rs.next())
{
count = rs.getInt(1);
}
rs.close();
pstmt.close();
if (count > 0)
if (mphone.equals(gphone))
strJSPLink = "answerList_I.jsp";
else
strJSPLink = "answerList_You.jsp";
else
strJSPLink = "30q&a_Popup.jsp";
%>
<td width="2"></td>
<td align="center" width="70" bgcolor="#efebd5"><a href="<%=url_path%>/news/<%=strJSPLink%>?mphone=<%=mphone%>&gphone=<%=gphone%>"><font color="#716e63" size="3">30巩30翠焊扁</font></a></td>
<%%>
<td></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<!-- 滚瓢 场 -->
<!-- 春胶 牧刨明 场 -->
<!-- 咯归 矫累 -->
<tr>
<td height="11"></td>
</tr>
<!-- 咯归 场 -->
<!-- 春胶 府胶飘 矫累 -->
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<!-- 弥辟春胶 鸥捞撇 矫累 -->
<tr height="17">
<td width="6" bgcolor="<%=mainBgColor%>"></td>
<td bgcolor="<%=mainBgColor%>"><font color="#ffffff">::: <%=nickName%>丛狼 弥辟 春胶</font></td>
</tr>
<tr height="4">
<td width="6"></td>
<td></td>
</tr>
<!-- 弥辟春胶 鸥捞撇 场 -->
<!-- 弥辟春胶 牧刨明 矫累 -->
<%
sql = "SELECT TOP 1 kind, title, reCnt, regdate FROM GT_NSNEWS WITH (READUNCOMMITTED) WHERE PHONENUM = " + Long.parseLong(gphone) + " ORDER BY regdate DESC";
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if (rs.next())
{
iNewsKind = rs.getInt("kind");
strNewsTitle = rs.getString("title");
iNewsReCnt = rs.getInt("reCnt");
strRegdate = rs.getString("regdate");
if (iNewsKind == 1)
strNewsKind = "[荤扒/荤绊]";
else if (iNewsKind == 2)
strNewsKind = "[瘤开]";
else if (iNewsKind == 3)
strNewsKind = "[楷抗/胶器明]";
else if (iNewsKind == 4)
strNewsKind = "[扁鸥]";
cStringTypeLength = 15 - strNewsKind.length();
strPrintNewsTitle = cStringTypeLength < strNewsTitle.length() ? strNewsTitle.substring(0,cStringTypeLength) + "..." : strNewsTitle;
strRegdate = strRegdate.replace("-", "/");
strRegdate = strRegdate.substring(5,16);
rs.close();
pstmt.close();
if (mphone.equals(gphone))
strJSPLink = "my_news_list_lhl.jsp";
else
strJSPLink = "other_news_list_lhl.jsp";
%>
<tr>
<td width="6"></td>
<td>
<font color="<%=mainFontColor%>"><%=strNewsKind%> </font><a href="<%=url_path%>/news/<%=strJSPLink%>?mphone=<%=mphone%>&gphone=<%=gphone%>"><%=strPrintNewsTitle%></a><font color="<%=mainFontColor%>"> [<%=iNewsReCnt%>]</font><br>
<font color="#928279" size="3"><%=strRegdate%></font>
</td>
</tr>
<%
}
else
{
%>
<tr>
<td width="6"></td>
<td>殿废等 弥脚 春胶啊 绝嚼聪促.</td>
</tr>
<%if (mphone.equals(gphone)) {%>
<tr>
<td width="6"></td>
<td align="right"><font color="#928279" size="3"><a href="<%=url_path%>/news/my_news_register_lhl.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>">货臂殿废⒑</a> </font></td>
</tr>
<%}
}%>
<tr height="4">
<td width="6"></td>
<td></td>
</tr>
<!-- 弥辟春胶 牧刨明 场 -->
<!-- 柠令硅萍 鸥捞撇 矫累 -->
<tr height="17">
<td width="6" bgcolor="<%=mainBgColor%>"></td>
<td bgcolor="<%=mainBgColor%>"><font color="#ffffff">::: 柠令!<%=nickName%> 捞具扁!</font></td>
</tr>
<tr height="4">
<td width="6"></td>
<td></td>
</tr>
<!-- 柠令硅萍 鸥捞撇 场 -->
<!-- 柠令硅萍 牧刨明 矫累 -->
<%
sql = "SELECT TOP 1 kind, title, reCnt, regdate FROM GT_NsQuiz WITH (READUNCOMMITTED) WHERE PHONENUM = " + Long.parseLong(gphone) + " ORDER BY regdate DESC";
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if (rs.next())
{
iNewsKind = rs.getInt("kind");
strNewsTitle = rs.getString("title");
iNewsReCnt = rs.getInt("reCnt");
strRegdate = rs.getString("regdate");
if (iNewsKind == 1)
strNewsKind = "[郴秒氢]";
else if (iNewsKind == 2)
strNewsKind = "[郴厚剐]";
else if (iNewsKind == 3)
strNewsKind = "[郴己氢]";
else if (iNewsKind == 4)
strNewsKind = "[扁鸥]";
cStringTypeLength = 15 - strNewsKind.length();
strPrintNewsTitle = cStringTypeLength < strNewsTitle.length() ? strNewsTitle.substring(0,cStringTypeLength) + "..." : strNewsTitle;
strRegdate = strRegdate.replace("-", "/");
strRegdate = strRegdate.substring(5,16);
rs.close();
pstmt.close();
strJSPLink = "myQuizList.jsp";
%>
<tr>
<td width="6"></td>
<td>
<font color="<%=mainFontColor%>"><%=strNewsKind%> </font><a href="<%=url_path%>/news/<%=strJSPLink%>?mphone=<%=mphone%>&gphone=<%=gphone%>"><%=strPrintNewsTitle%></a><font color="<%=mainFontColor%>"> [<%=iNewsReCnt%>]</font><br>
<font color="#928279" size="3"><%=strRegdate%></font>
</td>
</tr>
<%
}
else
{
%>
<tr>
<td width="6"></td>
<td>
殿废等 柠令啊 绝嚼聪促.
</td>
</tr>
<%if (mphone.equals(gphone)) {%>
<tr>
<td width="6"></td>
<td align="right"><font color="#928279" size="3"><a href="<%=url_path%>/news/myQuizAdd.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>&backLinkFlag=1">货臂殿废⒑</a> </font></td>
</tr>
<%}
}
%>
<tr height="4">
<td width="6"></td>
<td></td>
</tr>
<!-- 柠令硅萍 牧刨明 场 -->
<!-- 汲巩炼荤 鸥捞撇 矫累 -->
<tr height="17">
<td width="6" bgcolor="<%=mainBgColor%>"></td>
<td bgcolor="<%=mainBgColor%>"><font color="#ffffff">::: <%=nickName%>丛狼 汲巩炼荤</font></td>
</tr>
<tr height="4">
<td width="6"></td>
<td></td>
</tr>
<!-- 柠令硅萍 鸥捞撇 场 -->
<!-- 柠令硅萍 牧刨明 矫累 -->
<%
sql = "SELECT TOP 1 title, (Provision1Cnt + Provision2Cnt + Provision3Cnt + Provision4Cnt + Provision5Cnt) reCnt, regdate FROM GT_NsResearch WITH (READUNCOMMITTED) WHERE PHONENUM = " + Long.parseLong(gphone) + " ORDER BY regdate DESC";
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if (rs.next())
{
strNewsTitle = rs.getString("title");
iNewsReCnt = rs.getInt("reCnt");
strRegdate = rs.getString("regdate");
strNewsKind = "Q.";
cStringTypeLength = 15 - strNewsKind.length();
strPrintNewsTitle = cStringTypeLength < strNewsTitle.length() ? strNewsTitle.substring(0,cStringTypeLength) + "..." : strNewsTitle;
strRegdate = strRegdate.replace("-", "/");
strRegdate = strRegdate.substring(5,16);
rs.close();
pstmt.close();
strJSPLink = "ResearchList.jsp";
%>
<tr>
<td width="6"></td>
<td>
<a href="<%=url_path%>/news/<%=strJSPLink%>?mphone=<%=mphone%>&gphone=<%=gphone%>"><%=strNewsKind%> <%=strPrintNewsTitle%></a><font color="<%=mainFontColor%>"> [<%=iNewsReCnt%>]</font><br>
<font color="#928279" size="3"><%=strRegdate%></font>
</td>
</tr>
<%
}
else
{
%>
<tr>
<td width="6"></td>
<td>
殿废等 汲巩炼荤啊 绝嚼聪促.
</td>
</tr>
<%if (mphone.equals(gphone)) {%>
<tr>
<td width="6"></td>
<td align="right"><font color="#928279" size="3"><a href="<%=url_path%>/news/ResearchRegister.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>&backLinkFlag=1">货臂殿废⒑</a> </font></td>
</tr>
<%}
}
%>
<tr height="4">
<td width="6"></td>
<td></td>
</tr>
<!-- 柠令硅萍 牧刨明 场 -->
<!-- 模备春胶 鸥捞撇 矫累 -->
<tr height="17">
<td width="6" bgcolor="<%=mainBgColor%>"></td>
<td bgcolor="<%=mainBgColor%>"><font color="#ffffff">::: <%=nickName%>丛狼 模备春胶</font></td>
</tr>
<tr height="4">
<td width="6"></td>
<td></td>
</tr>
<!-- 模备春胶 鸥捞撇 场 -->
<!-- 模备春胶 牧刨明 矫累 -->
<tr>
<td width="6"></td>
<td><%
sql = "SELECT COUNT(a.title) FROM (SELECT title, kind, recnt, regdate, phonenum, 1 q FROM GT_NSNEWS WITH (READUNCOMMITTED) ";
sql = sql + " UNION ALL SELECT title, kind, recnt, regdate, phonenum, 2 q FROM GT_NsQuiz WITH (READUNCOMMITTED) ";
sql = sql + " UNION ALL SELECT title, 0, provision1cnt + provision2cnt + provision3cnt + provision4cnt + provision5cnt recnt, regdate, phonenum, 3 q FROM GT_NsResearch WITH (READUNCOMMITTED) ";
sql = sql + " ) a , GT_friend b WITH (READUNCOMMITTED) WHERE b.phonenum = '"+ gphone +"' AND b.friend_flag = 1 ";
sql = sql + " and convert(bigint,b.guest_phone) = a.phonenum ";
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if (rs.next())
{
count = rs.getInt(1);
rs.close();
pstmt.close();
}
if (count > 0)
{
sql = "SELECT TOP 5 a.* FROM (SELECT title, kind, recnt, regdate, phonenum, 1 q FROM GT_NSNEWS WITH (READUNCOMMITTED) ";
sql = sql + " UNION ALL SELECT title, kind, recnt, regdate, phonenum, 2 q FROM GT_NsQuiz WITH (READUNCOMMITTED) ";
sql = sql + " UNION ALL SELECT title, 0, provision1cnt + provision2cnt + provision3cnt + provision4cnt + provision5cnt recnt, regdate, phonenum, 3 q FROM GT_NsResearch WITH (READUNCOMMITTED) ";
sql = sql + " ) a , GT_friend b WITH (READUNCOMMITTED) WHERE b.phonenum = '"+ gphone +"' AND b.friend_flag = 1 ";
sql = sql + " and convert(bigint,b.guest_phone) = a.phonenum ORDER BY a. regdate DESC";
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
while (rs.next())
{
strNewsTitle = rs.getString("title");
iNewsReCnt = rs.getInt("reCnt");
strRegdate = rs.getString("regdate");
iNewsKind = rs.getInt("kind");
strFriendPhone = getStrPhone(getLong(rs.getString("phonenum")));
iQueryType = rs.getInt("q");
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.";
}
cStringTypeLength = 15 - strNewsKind.length();
strPrintNewsTitle = cStringTypeLength < strNewsTitle.length() ? strNewsTitle.substring(0,cStringTypeLength) + "..." : strNewsTitle;
if (iQueryType == 3){
strJSPLink = "ResearchList.jsp";%>
<a href="<%=url_path%>/news/<%=strJSPLink%>?mphone=<%=mphone%>&gphone=<%=strFriendPhone%>"><%=strNewsKind%> <%=strPrintNewsTitle%></a><font color="<%=mainFontColor%>"> [<%=iNewsReCnt%>]</font><br>
<% }
else {
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -