📄 researchresult.jsp
字号:
<tr height="19">
<td width="8" bgcolor="<%=mainBgColor%>"></td>
<td bgcolor="<%=mainBgColor%>"><font color="#ffffff">汲巩炼荤柳青惑炔</font></td>
</tr>
</table>
</td>
</tr>
<!-- 鸥捞撇 场 -->
<!-- 咯归 矫累 -->
<tr height="8">
<td></td>
</tr>
<!-- 咯归 场 -->
<!-- 汲巩搬苞 矫累 -->
<tr>
<td>
<table width="240" border="0" cellspacing="0" cellpadding="0" bgcolor="<%=contentBgColor%>">
<tr height="8">
<td colspan="3"></td>
</tr>
<tr>
<td width="4"></td>
<td>
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td valign="top">
<font color="#928279"><%=strTitle%></font><br>
<font color="<%=btnFontColor%>" size="3">[<%=reCount%>]</font>
</td>
</tr>
</table>
</td>
<td width="4"></td>
</tr>
<tr height="4">
<td colspan="3"></td>
</tr>
<!--2008-08-21 搬苞 弊贰橇 捞固瘤 荐沥 矫累-->
<tr>
<td width="4"></td>
<td>
<table border="0" cellspacing="0" cellpadding="0" bgcolor="#ffffff">
<tr height="4">
<td colspan="3"></td>
</tr>
<%if (!"".equals(strProvision1)){%>
<tr>
<td width="4"></td>
<td valign="middle">
<table border="0" cellspacing="0" cellpadding="0" bgcolor="#ffffff">
<tr>
<td><font color=<%=levelBoardColor1%>>1. <%=strProvision1%>(<%=provision1Cnt%>) </font>
<%for(int i = 0;i<provision1Cnt;i++){ %>
<img src=<%=levelImgPath1%> width="5" height="11">
<% }%>
</td>
</tr>
</table>
</td>
<td width="4"></td>
</tr>
<%}
if (!"".equals(strProvision2)){
%>
<tr>
<td width="4"></td>
<td>
<table border="0" cellspacing="0" cellpadding="0" bgcolor="#ffffff">
<tr>
<td><font color=<%=levelBoardColor2%>>2. <%=strProvision2%>(<%=provision2Cnt%>) </font>
<%for(int i = 0;i<provision2Cnt;i++){ %>
<img src=<%=levelImgPath2%> width="5" height="11">
<% }%>
</td>
</tr>
</table>
</td>
<td width="4"></td>
</tr>
<% }if (!"".equals(strProvision3)){
%>
<tr>
<td width="4"></td>
<td>
<table border="0" cellspacing="0" cellpadding="0" bgcolor="#ffffff">
<tr>
<td><font color=<%=levelBoardColor3%>>3. <%=strProvision3%>(<%=provision3Cnt%>) </font>
<%for(int i = 0;i<provision3Cnt;i++){ %>
<img src=<%=levelImgPath3%> width="5" height="11">
<% }%>
</td>
</tr>
</table>
</td>
<td width="4"></td>
</tr>
<% }if(!"".equals(strProvision4)){
%>
<tr>
<td width="4"></td>
<td>
<table border="0" cellspacing="0" cellpadding="0" bgcolor="#ffffff">
<tr>
<td><font color=<%=levelBoardColor4%>>4. <%=strProvision4%>(<%=provision4Cnt%>) </font>
<%for(int i = 0;i<provision4Cnt;i++){ %>
<img src=<%=levelImgPath4%> width="5" height="11">
<% }%>
</td>
</tr>
</table>
</td>
<td width="4"></td>
</tr>
<% }if (!"".equals(strProvision5)){
%>
<tr>
<td width="4"></td>
<td>
<table border="0" cellspacing="0" cellpadding="0" bgcolor="#ffffff">
<tr>
<td><font color=<%=levelBoardColor5%>>5. <%=strProvision5%>(<%=provision5Cnt%>)</font>
<%for(int i = 0;i<provision5Cnt;i++){ %>
<img src=<%=levelImgPath5%> width="5" height="11">
<% }%>
</td>
</tr>
</table>
</td>
<td width="4"></td>
</tr>
<% }%>
<!--2008-08-21 搬苞 弊贰橇 捞固瘤 荐沥 场-->
<!--2008-08-21 痢急 荐沥 矫累-->
<!--痢急 矫累-->
<tr>
<td align="center" colspan="3">
<font color="#ffcbb9" size="3" align="center"><b>··························································</b></font>
</td>
</tr>
<!--痢急 场-->
<!--2008-08-21 痢急 荐沥 场-->
<tr>
<td width="4"></td>
<td>
<font color="<%=btnFontColor%>"><b> ⒑ 泅犁 1困 : </b></font><b><%=maxProvisionCntNum%>. <%=maxProvisionCntName%>(<%=maxProvisionCnt%>)</b>
</td>
<td width="4"></td>
</tr>
<tr height="4">
<td align="center" colspan="3"></td>
</tr>
</table>
</td>
<td width="4"></td>
</tr>
<tr height="4">
<td colspan="3"></td>
</tr>
<tr>
<td width="4"></td>
<td>
<font color="#7c8889" size="3"><%=strNickname%>丛狼 急琶 : <%=provisionNum%>.<%=strProvision%></font><br>
<font color="#7c8889" size="3">捞蜡 : <%=researchText%></font><br>
</td>
<td width="4"></td>
</tr>
<tr height="8">
<td colspan="3"></td>
</tr>
</table>
</td>
</tr>
<!-- 汲巩搬苞 矫累 -->
<%if(mphone.equals(gphone)) {
if(upFlag == 0){ %>
<tr height="6">
<td></td>
</tr>
<!-- 咯归 场 -->
<!-- 滚瓢 矫累 -->
<tr>
<td>
<table width="240" border="0" cellspacing="0" cellpadding="0">
<tr height="17">
<td></td>
<td width="60" bgcolor="<%=mainBgColor%>" align="center" ><a href="<%=url_path%>/news/researchDelete.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>&titleIdx=<%=titleIdx%>&actionName=deleteResearchTitle"><font color="#ffffff">昏力窍扁</font></a></td>
<td></td>
</tr>
</table>
</td>
</tr>
<!-- 滚瓢 场 -->
<%} else {%>
<tr height="6">
<td></td>
</tr>
<tr>
<td></td>
</tr>
<%}
}else {%>
<tr height="6">
<td></td>
</tr>
<tr>
<td></td>
</tr>
<%} %>
<!-- 咯归 矫累 -->
<tr height="8">
<td></td>
</tr>
<!-- 咯归 场 -->
<tr>
<td>
<table width="240" border="0" cellspacing="0" cellpadding="0" bgcolor="<%=titleColor%>">
<tr height="19">
<td width="48" align="center"><a href="<%=url_path%>/news/ResearchPlayerList.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>&titleIdx=<%=titleIdx%>&strProvision=<%=strProvision1%>&provisionNum=1&upFlag=<%=upFlag%>"><font color="<%=linkBoardColor1%>" size="3"><b>1锅</b></font></a></td>
<td width="48" align="center"><a href="<%=url_path%>/news/ResearchPlayerList.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>&titleIdx=<%=titleIdx%>&strProvision=<%=strProvision2%>&provisionNum=2&upFlag=<%=upFlag%>"><font color="<%=linkBoardColor2%>" size="3"><b>2锅</b></font></a></td>
<td width="48" align="center"><a href="<%=url_path%>/news/ResearchPlayerList.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>&titleIdx=<%=titleIdx%>&strProvision=<%=strProvision3%>&provisionNum=3&upFlag=<%=upFlag%>"><font color="<%=linkBoardColor3%>" size="3"><b>3锅</b></font></a></td>
<td width="48" align="center"><a href="<%=url_path%>/news/ResearchPlayerList.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>&titleIdx=<%=titleIdx%>&strProvision=<%=strProvision4%>&provisionNum=4&upFlag=<%=upFlag%>"><font color="<%=linkBoardColor4%>" size="3"><b>4锅</b></font></a></td>
<td width="48" align="center"><a href="<%=url_path%>/news/ResearchPlayerList.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>&titleIdx=<%=titleIdx%>&strProvision=<%=strProvision5%>&provisionNum=5&upFlag=<%=upFlag%>"><font color="<%=linkBoardColor5%>" size="3"><b>5锅</b></font></a></td>
</tr>
</table>
</td>
</tr>
<!--捞傈/促澜 傅农 冠胶 矫累-->
<%
/*------------------------------------------------------------------------------------------------
* pageCount
-------------------------------------------------------------------------------------------------*/
sql = "SELECT count(NRR.idx) FROM gt_NsResearch NR WITH (READUNCOMMITTED) LEFT JOIN gt_NsResearchRe NRR WITH (READUNCOMMITTED) ON NR.idx = NRR.ref_idx WHERE NRR.ref_idx="+titleIdx+" AND NRR.anser=";
if( returnBack == 1){
sql= sql + maxProvisionCntNum ;
}else {
sql= sql + provisionNum ;
}
pstmt = con.prepareStatement(sql);
pageset = pstmt.executeQuery();
if(pageset.next()){
dbcount = pageset.getInt(1); // 臂 醚 肮荐
pageset.close();
}
if(dbcount%pagesize == 0)
pagecount = dbcount/(pagesize); // 醚 其捞瘤荐 备窍扁
else
pagecount = dbcount/(pagesize)+1; // 醚 其捞瘤荐 备窍扁
if(request.getParameter("pageNUM")!=null)
{
pageNUM=Integer.parseInt(request.getParameter("pageNUM"));//瘤沥等 其捞瘤 焊咯林扁
absolutepage=(pageNUM-1)*pagesize+1;
}
/*------------------------------------------------------------------------------------------------
* Research Title List
-------------------------------------------------------------------------------------------------*/
sql = "SELECT NRR.idx,NRR.phonenum,NRR.nickname,NRR.text,substring(replace(CONVERT(varchar,NRR.regdate, 120 ),'-','/'),6,11) regdate ,NRR.takeFlag ";
sql = sql + " FROM gt_NsResearch NR WITH (READUNCOMMITTED) LEFT JOIN gt_NsResearchRe NRR WITH (READUNCOMMITTED) ON NR.idx = NRR.ref_idx WHERE NRR.ref_idx="+titleIdx+" AND NRR.anser=";
if(returnBack == 1){
sql= sql + maxProvisionCntNum ;
}else {
sql= sql + provisionNum ;
}
if(upFlag == 0 ){
sql = sql + " ORDER BY NRR.regdate desc ";
}else {
sql = sql + " ORDER BY NRR.takeFlag desc , NRR.regdate desc ";
}
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if(!rs.next()) // 蔼捞 绝阑锭
{
isNoPage = 1;
pagesize=0;
}
else // 蔼捞 乐阑锭 //rs.absolute(absolutepage);
{
for(int s=0; s<absolutepage-1; s++)
rs.next();
}
%>
<!--捞傈/促澜 傅农 冠胶 矫累-->
<%
pageurl=url_path+"/news/ResearchResult.jsp?mphone="+mphone+"&gphone="+gphone+"&titleIdx="+titleIdx+"&upFlag="+upFlag;
String [] szSplit = pagePathTop(pageurl, dbcount, pageNUM, pagecount);
%>
<tr>
<td>
<table width="240" border="0" cellspacing="0" cellpadding="0" bgcolor="<%=pageBgColor %>">
<tr>
<td width="25"></td>
<td width="60" height="19" align="left"><font color="#676767" size="3">⒏ </font><font color="<%=pageFNFontColor %>" size="3">(7)</font><%=szSplit[0]%><b><font color="<%=pageFNFontColor %>" size="3">捞傈</font></b><%=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="25"></td>
</tr>
</table>
</td>
</tr>
<!--捞傈/促澜 傅农 冠胶 场-->
<!--咯归 矫累-->
<tr>
<td height="3"></td>
</tr>
<!--咯归 场-->
<%
int cnt = dbcount;
if(pageNUM == 1){
cnt = dbcount;
}else{
cnt=dbcount-(pageNUM-1)*pagesize;
}
int count = 0 ; //其捞瘤 墨款磐 函荐
while(count<pagesize)
{
count++;
re_titleIdx = rs.getInt("idx");
strGuestPhoneNum = rs.getString("phonenum");
strGuestNickName = rs.getString("nickname");
strText = rs.getString("text");
regdate = rs.getString("regdate");
takeFlag = rs.getInt("takeFlag");
if(upFlag != 0 ){
if (takeFlag == 1){
placeTopColor = "#fefad2";
}else{
placeTopColor = "#e1eef1";
}
}else{
placeTopColor = "#e1eef1";
}
%>
<!-- 汲巩搬苞 府胶飘 矫累 -->
<!-- 馆汗 1 矫累 -->
<tr>
<td>
<table width="240" border="0" cellspacing="0" cellpadding="0" bgcolor="<%=placeTopColor%>">
<tr>
<!--酒官鸥 矫累-->
<td width="54" align="top">
<table width="54" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="3" height="3"></td>
</tr>
<tr>
<td width="3"></td>
<td align="top"><img src="<%=ava_path%>display_thumb.jsp?mphone=<%=mphone%>&gphone=0<%=strGuestPhoneNum%>" width="48" height="54"></td>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -