📄 researchresult.jsp
字号:
<td width="3"></td>
</tr>
<tr>
<td colspan="3" height="3"></td>
</tr>
</table>
</td>
<!--酒官鸥 场-->
<!-- 闰祸 咯归 矫累 -->
<td bgcolor="#ffffff" width="3"></td>
<!-- 闰祸 咯归 场 -->
<!-- 郴侩 矫累 -->
<td valign="top">
<table border="0" cellspacing="0" cellpadding="0">
<tr height="20">
<td width="4"></td>
<td>
<font color="#7c8889"><a href="<%=url_path%>/mypage/my_confirm.jsp?mphone=<%=mphone%>&gphone=0<%=strGuestPhoneNum%>"><%=strGuestNickName%></a></font>
<font color="#a2a2a2" size="3">(<%=regdate%>)</font>
</td>
</tr>
<tr>
<td width="4"></td>
<td>
<%=strText%>
</td>
</tr>
</table>
</td>
<!-- 郴侩 场 -->
<td width="8"></td>
</tr>
<tr height="3">
<td width="54" bgcolor="#ffffff"></td>
<td width="3" bgcolor="#ffffff"></td>
<td></td>
<td width="8"></td>
</tr>
<tr height="2">
<td colspan="4"></td>
</tr>
<tr>
<td width="54" align="center"><font color="#a2a2a2">9</font></td>
<td width="3"></td>
<%if (mphone.equals(gphone)&&upFlag == 0&&!mphone.equals("0"+strGuestPhoneNum)){
%>
<td>
<table border="0" cellspacing="0" cellpadding="0">
<tr height="15">
<td></td>
<td width="30" align="center" bgcolor="#ffffff"><font color="#7c8889"><a href="<%=url_path%>/news/ResearchResult.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>&titleIdx=<%=titleIdx%>&re_titleIdx=<%=re_titleIdx%>&re_phonenum=<%=strGuestPhoneNum%>&re_name=<%=strGuestNickName%>&actionName=placeTop">盲琶</a></font></td>
</tr>
</table>
</td>
<%
}else{%>
<td></td>
<%}
%>
<td width="8"></td>
</tr>
<tr height="2">
<td colspan="4"></td>
</tr>
</table>
</td>
</tr>
<!--咯归 矫累-->
<tr>
<td height="3"></td>
</tr>
<%
cnt --;
if(rs.isLast())
{ //盖 付瘤阜 饭内靛 老版快
break;
}
else
{
rs.next();
}
}
%>
<!--咯归 场-->
<!-- 馆汗 1 场 -->
<!-- 汲巩搬苞 府胶飘 场 -->
<!--2008-08-21 傅农埃拜 荐沥 矫累-->
<!--其捞瘤 傅农 矫累-->
<%
String [] szSplit2 = pagePathBottom(pageurl, dbcount, pageNUM, pagecount);
%>
<tr>
<td>
<table width="240" border="0" cellspacing="0" cellpadding="0" bgcolor="<%=pageBgColor %>">
<tr>
<td height="19">
<table width="240" 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>
<!--其捞瘤 傅农 场-->
<!--2008-08-21 傅农埃拜 荐沥 场-->
<!--2008-08-21 痢急 荐沥 矫累-->
<!--痢急 矫累-->
<tr>
<td align="center">
<font color="#cccccc" size="3" align="center"><b>··························································</b></font>
</td>
</tr>
<!--痢急 场-->
<!--2008-08-21 痢急 荐沥 场-->
<!--咯归 矫累-->
<tr>
<td height="4"></td>
</tr>
<!--咯归 场-->
<%
/*--------------------------------------------------------------------------------------------------------------------------------------
* last titleIdx
---------------------------------------------------------------------------------------------------------------------------------------*/
sql = " SELECT max(a.idx) lastTitleIdx FROM gt_NsResearch a WITH (READUNCOMMITTED) ,gt_NsResearchRe b WITH (READUNCOMMITTED) WHERE a.idx=b.ref_idx AND a.phonenum="+Long.parseLong(gphone)+" AND a.idx <"+titleIdx;
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if( rs.next() )
{
lastTitleIdx = rs.getInt("lastTitleIdx");
}
rs.close();
pstmt.close();
/*--------------------------------------------------------------------------------------------------------------------------------------
* next titleIdx
---------------------------------------------------------------------------------------------------------------------------------------*/
sql = " SELECT min(a.idx) nextTitleIdx FROM gt_NsResearch a WITH (READUNCOMMITTED) ,gt_NsResearchRe b WITH (READUNCOMMITTED) WHERE a.idx=b.ref_idx AND a.phonenum="+Long.parseLong(gphone)+" AND a.idx >"+titleIdx;
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if( rs.next() )
{
nextTitleIdx = rs.getInt("nextTitleIdx");
}
rs.close();
pstmt.close();
/*--------------------------------------------------------------------------------------------------------------------------------------
* My last titleIdx
---------------------------------------------------------------------------------------------------------------------------------------*/
sql = " SELECT max(a.idx) myLastTitleIdx FROM gt_NsResearch a WITH (READUNCOMMITTED) ,gt_NsResearchRe b WITH (READUNCOMMITTED) WHERE a.idx=b.ref_idx AND a.phonenum="+Long.parseLong(gphone)+" AND b.phonenum="+Long.parseLong(mphone)+" AND a.idx <"+titleIdx;
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if( rs.next() )
{
myLastTitleIdx = rs.getInt("myLastTitleIdx");
}
rs.close();
pstmt.close();
/*--------------------------------------------------------------------------------------------------------------------------------------
* My next titleIdx
---------------------------------------------------------------------------------------------------------------------------------------*/
sql = " SELECT min(a.idx) myNextTitleIdx FROM gt_NsResearch a WITH (READUNCOMMITTED) ,gt_NsResearchRe b WITH (READUNCOMMITTED) WHERE a.idx=b.ref_idx AND a.phonenum="+Long.parseLong(gphone)+" AND b.phonenum="+Long.parseLong(mphone)+" AND a.idx >"+titleIdx;
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if( rs.next() )
{
myNextTitleIdx = rs.getInt("myNextTitleIdx");
}
rs.close();
pstmt.close();
if ( 0 != lastTitleIdx){
if ( lastTitleIdx != myLastTitleIdx){
lastTitleIdx = myLastTitleIdx;
}
/*--------------------------------------------------------------------------------------------------------------------------------------
* Last Tilte
---------------------------------------------------------------------------------------------------------------------------------------*/
sql = " SELECT idx,title ,(Provision1Cnt+Provision2Cnt+Provision3Cnt+Provision4Cnt+Provision5Cnt) reCount " ;
sql = sql +" FROM gt_NsResearch WITH (READUNCOMMITTED) WHERE idx="+lastTitleIdx+" AND phonenum="+Long.parseLong(gphone);
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if( rs.next() )
{
lastTitleIdx = rs.getInt("idx");
lastTitle = rs.getString("title");
lastTitleCnt = rs.getInt("reCount");
}
rs.close();
pstmt.close();
}
nextTitleIdx = nextTitleIdx != myNextTitleIdx ? myNextTitleIdx : nextTitleIdx;
/*--------------------------------------------------------------------------------------------------------------------------------------
* Next Tilte
---------------------------------------------------------------------------------------------------------------------------------------*/
sql = " SELECT idx,title ,(Provision1Cnt+Provision2Cnt+Provision3Cnt+Provision4Cnt+Provision5Cnt) reCount " ;
sql = sql +" FROM gt_NsResearch WITH (READUNCOMMITTED) WHERE idx="+nextTitleIdx+" and phonenum="+Long.parseLong(gphone);
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if( rs.next() )
{
nextTitleIdx = rs.getInt("idx");
nextTitle = rs.getString("title");
nextTitleCnt = rs.getInt("reCount");
}else{
nextTitle = "";
}
rs.close();
pstmt.close();
%>
<tr>
<td>
<%if ( 0 != lastTitleIdx){
if (lastTitleIdx == myLastTitleIdx){ %>
<font color="#8c8c8c" size="3"> ° </font><font color="<%=pageFNFontColor %>" size="3">捞傈 : </font><a href="<%=url_path%>/news/ResearchResult.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>&titleIdx=<%=lastTitleIdx%>"><font color="#8c8c8c" size="3"><%=lastTitle%>.</font><font color="#ff4d72" size="3">[<%=lastTitleCnt%>]</font></a><br>
<%}else { %>
<font color="#8c8c8c" size="3"> ° </font><font color="<%=pageFNFontColor %>" size="3">捞傈 : </font><a href="<%=url_path%>/news/ResearchStart.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>&titleIdx=<%=myLastTitleIdx%>"><font color="#8c8c8c" size="3"><%=lastTitle%>.</font><font color="#ff4d72" size="3">[<%=lastTitleCnt%>]</font></a><br>
<% }
}
if( !"".equals(nextTitle)){
if (nextTitleIdx == myNextTitleIdx){
%>
<font color="#8c8c8c" size="3"> ″ </font><font color="<%=pageFNFontColor %>" size="3">促澜 : <a href="<%=url_path%>/news/ResearchResult.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>&titleIdx=<%=nextTitleIdx%>"><%=nextTitle%></a></font><font color="#ff4d72" size="3">[<%=nextTitleCnt%>]</font><br>
<%} else {%>
<font color="#8c8c8c" size="3"> ″ </font><font color="<%=pageFNFontColor %>" size="3">促澜 : <a href="<%=url_path%>/news/ResearchResult.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>&titleIdx=<%=myNextTitleIdx%>"><%=nextTitle%></a></font><font color="#ff4d72" size="3">[<%=nextTitleCnt%>]</font><br>
<% }
}%>
</td>
</tr>
<!--咯归 矫累-->
<tr>
<td height="4"></td>
</tr>
<!--咯归 场-->
<!--2008-08-21 痢急 荐沥 矫累-->
<!--痢急 矫累-->
<tr>
<td align="center">
<font color="#cccccc" size="3" align="center"><b>··························································</b></font>
</td>
</tr>
<!--痢急 场-->
<!--2008-08-21 痢急 荐沥 场-->
<!-- 滚瓢 矫累 -->
<tr>
<td>
<table width="240" border="0" cellspacing="0" cellpadding="0">
<tr height="17">
<td></td>
<td width="80" bgcolor="<%=mainBgColor%>" align="center" ><a href="<%=url_path%>/news/ResearchList.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>"><font color="#ffffff">汲巩格废</font></a></td>
<td width="2"></td>
<td width="80" bgcolor="<%=mainBgColor%>" align="center" ><a href="<%=url_path%>/news/NewsMain.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>"><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="240" border="0" cellspacing="0" cellpadding="0">
<tr height="19">
<td width="10" bgcolor="#BBC7C8"></td>
<td bgcolor="#DAE6E8">
<a href="<%=step1%>">权</a>><a href="<%=step2%>"><%=strNickname%>丛狼迄乔</a>><a href="<%=step3%>">春胶</a>>汲巩搬苞
</td>
<td width="10" bgcolor="#BBC7C8"></td>
</tr>
</table>
</td>
</tr>
<!--版肺钎矫 场-->
</table>
<!--窍窜 版肺钎矫 矫累-->
<%@ include file="../newbottom.jsp"%>
<!--窍窜 版肺钎矫 场-->
</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 ) { } }
}
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -