📄 researchplayerlist.jsp.svn-base
字号:
sql = "SELECT title,Provision1,Provision2,Provision3,Provision4,Provision5 ,(Provision1Cnt+Provision2Cnt+Provision3Cnt+Provision4Cnt+Provision5Cnt) reCount ,";
sql = sql + " Provision1Cnt,Provision2Cnt,Provision3Cnt,Provision4Cnt,Provision5Cnt ,maxProvisionCnt=(SELECT max(Provision1Cnt) FROM ( ";
sql = sql + "SELECT Provision1Cnt ";
sql = sql + "union all ";
sql = sql + "SELECT Provision2Cnt ";
sql = sql + "union all ";
sql = sql + "SELECT Provision3Cnt ";
sql = sql + "union all ";
sql = sql + "SELECT Provision4Cnt ";
sql = sql + "union all ";
sql = sql + "SELECT Provision5Cnt ";
sql = sql + ") tmp )FROM gt_NsResearch WITH (READUNCOMMITTED) WHERE idx="+titleIdx+" AND phonenum="+Long.parseLong(gphone);
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if( rs.next() )
{
strTitle = rs.getString("title");
reCount = rs.getInt("reCount");
maxProvisionCnt = rs.getInt("maxProvisionCnt");
if(null != strProvision1 || !"".equals(strProvision1)) strProvision1 = rs.getString("Provision1"); else strProvision1 = "";
if(null != strProvision2 || !"".equals(strProvision2)) strProvision2 = rs.getString("Provision2"); else strProvision2 = "";
if(null != strProvision3 || !"".equals(strProvision3)) strProvision3 = rs.getString("Provision3"); else strProvision3 = "";
if(null != strProvision4 || !"".equals(strProvision4)) strProvision4 = rs.getString("Provision4"); else strProvision4 = "";
if(null != strProvision5 || !"".equals(strProvision5)) strProvision5 = rs.getString("Provision5"); else strProvision5 = "";
provision1Cnt = rs.getInt("Provision1Cnt");
provision2Cnt = rs.getInt("Provision2Cnt");
provision3Cnt = rs.getInt("Provision3Cnt");
provision4Cnt = rs.getInt("Provision4Cnt");
provision5Cnt = rs.getInt("Provision5Cnt");
}
rs.close();
pstmt.close();
/*--------------------------------------------------------------------------------------------------------------------------------------
* Board Color Check
---------------------------------------------------------------------------------------------------------------------------------------*/
levelImgPath1 = img_path+"images/news/013.png";
levelImgPath2 = img_path+"images/news/013.png";
levelImgPath3 = img_path+"images/news/013.png";
levelImgPath4 = img_path+"images/news/013.png";
levelImgPath5 = img_path+"images/news/013.png";
linkBoardColor1 = titleFontColorY;
linkBoardColor2 = titleFontColorY;
linkBoardColor3 = titleFontColorY;
linkBoardColor4 = titleFontColorY;
linkBoardColor5 = titleFontColorY;
if ( provisionNum ==1){
strProvision = strProvision1;
linkBoardColor1 = "ffffff";
levelBoardColor1 = btnFontColor;
levelImgPath1 = img_path+"images/news/014.png";
}else if (provisionNum ==2){
strProvision = strProvision2;
linkBoardColor2 = "ffffff";
levelBoardColor2 = btnFontColor;
levelImgPath2 = img_path+"images/news/014.png";
}else if (provisionNum ==3){
strProvision = strProvision3;
linkBoardColor3 = "ffffff";
levelBoardColor3 = btnFontColor;
levelImgPath3 = img_path+"images/news/014.png";
}else if (provisionNum ==4){
strProvision = strProvision4;
linkBoardColor4 = "ffffff";
levelBoardColor4 = btnFontColor;
levelImgPath4 = img_path+"images/news/014.png";
}else if (provisionNum ==5){
strProvision = strProvision5;
linkBoardColor5 = "ffffff";
levelBoardColor5 = btnFontColor;
levelImgPath5 = img_path+"images/news/014.png";
}else if (provisionNum ==0){
strProvision = "";
linkBoardColor1 = titleFontColorY;
linkBoardColor2 = titleFontColorY;
linkBoardColor3 = titleFontColorY;
linkBoardColor4 = titleFontColorY;
linkBoardColor5 = titleFontColorY;
levelImgPath5 = img_path+"images/news/014.png";
}
%>
<html>
<head>
<title></title>
<link href="http://entaz.mugeta.com/client/mugeta_v2_test/web/user/mobile.css" rel="stylesheet" type="text/css">
</head>
<body>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<!-- 鸥捞撇 矫累 -->
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr height="19">
<td width="8" bgcolor="<%=mainBgColor%>"></td>
<td bgcolor="<%=mainBgColor%>"><font color="#ffffff">汲巩炼荤柳青惑炔</font></td>
</tr>
</table>
</td>
</tr>
<!-- 鸥捞撇 场 -->
<!-- 咯归 矫累 -->
<tr height="4">
<td></td>
</tr>
<!-- 咯归 场 -->
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0" bgcolor="<%=titleColor%>">
<tr height="16">
<td 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 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 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 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 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="+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="+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/ResearchPlayerList.jsp?mphone="+mphone+"&gphone="+gphone+"&titleIdx="+titleIdx+"&upFlag="+upFlag;
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="16" 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" 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="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="176" 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>
<td width="3"></td>
</tr>
<tr>
<td colspan="3" height="3"></td>
</tr>
</table>
</td>
<!--酒官鸥 场-->
<!-- 闰祸 咯归 矫累 -->
<td bgcolor="#ffffff" width="3"></td>
<!-- 闰祸 咯归 场 -->
<!-- 郴侩 矫累 -->
<td width="100%" valign="top">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="2" height="3"></td>
</tr>
<tr>
<td width="4"></td>
<td>
<font color="#7c8889"><a href="<%=url_path%>/mypage/my_confirm.jsp?mphone=<%=mphone%>&gphone=0<%=strGuestPhoneNum%>"><%=strGuestNickName%></a></font><br>
<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"><%=cnt%></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="14">
<td></td>
<td width="31" align="center" bgcolor="#ffffff"><font color="#7c8889"><a href="<%=url_path%>/news/ResearchPlayerList.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>&titleIdx=<%=titleIdx%>&re_titleIdx=<%=re_titleIdx%>&re_phonenum=<%=strGuestPhoneNum%>&re_name=<%=strGuestNickName%>&actionName=placeTop">盲琶</a></font></td>
</tr>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -