📄 myqamatchmatelist.jsp.svn-base
字号:
starAttentionfull = Attention/4;
if(starAttentionfull > 6){
starAttentionfull = 6;
}
starAttentionemp = (Attention%4)/2;
int match = pageRs.getInt("Match_point");
if(match>100){
match = 100;
}
starMatchfull = ((match*24)/4)/100;
starMatchemp = (((match*24)%4)/2)/100;
long phonenum = pageRs.getLong("phonenum");
try{
/*------------------------------------------------------------------------------------------------
* 唱客 嘎绰 荤恩 沥翠 荐
-------------------------------------------------------------------------------------------------*/
query1 = " select count(a.idx) answercount from gt_lucky_quiz_mylog a,gt_lucky_quiz_mylog c"+
" where a.quiz_idx=c.quiz_idx and a.answer = c.answer"+
" and a.phonenum =? and a.guest_phone =?"+
" and c.phonenum =?"+" and c.guest_phone =?";
pstmt = con.prepareStatement(query1);
pstmt.setLong(1,Long.parseLong(mphone));
pstmt.setLong(2,phonenum);
pstmt.setLong(3,Long.parseLong(mphone));
pstmt.setLong(4,Long.parseLong(mphone));
rs = pstmt.executeQuery();
if(rs.next())
{
answercount = rs.getInt("answercount");
}
rs.close();
pstmt.close();
/*------------------------------------------------------------------------------------------------
* 唱客 嘎绰 荤恩 翠函 荐
-------------------------------------------------------------------------------------------------*/
query1="select count(idx) as allcont from GT_LUCKY_QUIZ_MYLOG where phonenum =? and Guest_phone =? ";
pstmt = con.prepareStatement(query1);
pstmt.setLong(1,Long.parseLong(mphone));
pstmt.setLong(2,phonenum);
rs = pstmt.executeQuery();
if(rs.next())
{
allcont = rs.getInt("allcont");
}
percent = (answercount/allcont) * 100;
%>
<tr>
<td>
<table width="176" bgcolor="#eeeeee" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="2" height="2"></td>
</tr>
<tr>
<td width="15" height="15">
<%if(sex ==1) { %>
<img src="<%=img_path%>images/soulmate/icon_01.png">
<%}else{ %>
<img src="<%=img_path%>images/soulmate/m.png">
<%}%>
</td>
<td><font color="#545454"><b><a href="<%=url_path%>/mypage/my_confirm.jsp?mphone=<%=mphone%>&gphone=<%=dianhua%>"><%=name1 %></a></b></font>
<font color="#c085ed">(<%if(sex ==1) { %>咯己 <%}else{ %>巢己 <%} %> <%=nyear-year%>技)</font></td>
</tr>
<tr>
<td width="15"></td>
<td><font color="#909090"></font></td>
</tr>
<tr>
<td colspan="2" height="3"></td>
</tr>
<!--概莫 郴侩 矫累-->
<tr>
<td colspan="2">
<table width="176" bgcolor="#ffffff" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="3" height="3"></td>
</tr>
<tr>
<td width="13"></td>
<td><font color="#ff6b94">包缴档</font> <font color="#ff6b94" size="5"><%for(int i=0;i<starAttentionfull;i++) {%>≮<%} %><%for(int i=0;i<starAttentionemp;i++) {%>≠<%} %></font><br>
<font color="#ff6b94">概莫档</font> <font color="#ff6b94" size="5"><%for(int i=0;i<starMatchfull;i++) {%>≮<%} %><%for(int i=0;i<starMatchemp;i++) {%>≠<%} %></font><br>
<font color="#7b7b7b"><%=name1%>丛苞 唱客狼</font><br>
<font color="#9819e9">概莫档
<%int ggg;if((int)percent > 100){ggg = 100;}else{ggg = (int)percent;} %>
<%=ggg%>%</font><br><font color="#ababab">(醚 <%=(int)answercount %>俺 亲格 老摹)</font>
</td>
<td width="11"></td>
</tr>
<tr>
<td colspan="3" height="9"></td>
</tr>
</table>
</td>
</tr>
<!--概莫 郴侩 场-->
</table>
</td>
</tr>
<%
}
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){}
}
if(pageRs.isLast())
{ //盖 付瘤阜 饭内靛 老版快
break;
}
else
{
pageRs.next();
}
}
pageRs.close();
pstmt.close();
%>
<!--咯归 矫累-->
<tr>
<td height="3"></td>
</tr>
<!--咯归 场-->
<tr>
<td>
<!--其捞瘤 傅农 矫累-->
<table width="176" height="16" bgcolor="#e8f2f2" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="16" colspan="6" bgcolor="#e8f2f2" valign="bottom" align="center">
<%//其捞瘤 备泅何
int limit = 5 ; //其捞瘤 府胶飘 俺荐 瘤沥
int temp =(pageNUM-1) % limit ; //矫累 其捞瘤 备窍扁
int startPage = pageNUM - temp;
%>
<%// [捞傈] 傅农 眠啊窍扁
if ((startPage-limit)>0){ %>
<a href="<%=pageurl%>&pageNUM=<%=startPage-1%>"><font color="#DB1A00">捞傈</font></a>
<%}
//其捞瘤 锅龋 唱凯窍扁
if(isNoPage == 0)
{
for(int i=startPage ; i<(startPage+limit);i++)
{
if( i == pageNUM)
{%>
<font color="#DB1A00"><b><%=i%></b></font>
<% }
else
{ %>
<a href="<%=pageurl%>&pageNUM=<%=i%>"><font color="#DB1A00"><%=i%></font></a>
<% }
if(i >= pagecount) break;
}
}
else
out.println("钎矫 且 郴侩捞 绝嚼聪促.");
//[促澜] 傅农 眠啊
if((startPage+limit)<=pagecount){ %>
<a href="<%=pageurl%>&pageNUM=<%=(startPage+limit)%>"><font color="#DB1A00">促澜</font></a>
<%}
%>
</td>
</tr>
</table>
<!--其捞瘤 傅农 场-->
</td>
</tr>
<tr>
<td height="5"></td>
</tr>
<!--倒酒啊扁 滚瓢 矫累-->
<tr>
<td>
<table width="176" height="16" border="0" cellspacing="0" cellpadding="0">
<tr>
<td></td>
<td width="55" height="16" bgcolor="#c789ff" align="center"><a href="<%=url_path%>/soulmate/MYQAmatchMate.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>&name=<%=name%>&panduan=<%=panduan%>"><font color="#ffffff">倒酒啊扁</font></a></td>
<td></td>
</tr>
</table>
</td>
</tr>
<!--倒酒啊扁 滚瓢 场-->
<!--咯归 矫累-->
<tr>
<td height="11"></td>
</tr>
<!--咯归 场-->
<!--窍窜 版肺钎矫 矫累-->
<tr>
<td>
<table width="176" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="10" bgcolor="#BBC7C8"></td>
<td width="156" bgcolor="#DAE6E8" height="15"> <a href="<%=url_path+"/main.jsp?mphone="+mphone+"&gphone="+gphone%>">权</a>><a href="<%=url_path%>/mypage/my_confirm.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>"><%=name %>丛狼 迄乔</a></td>
<td width="10" bgcolor="#BBC7C8"></td>
</tr>
<tr>
<td width="10" bgcolor="#BBC7C8"></td>
<td width="156" bgcolor="#DAE6E8" height="15"> ><a href="<%=url_path+"/soulmate/MySoulmate.jsp?mphone="+mphone+"&gphone="+gphone%>">家匡皋捞飘</a>>龙巩措翠</td>
<td width="10" bgcolor="#BBC7C8"></td>
</tr>
</table>
</td>
</tr>
<!--窍窜 版肺钎矫 场-->
</table>
<!--窍窜 版肺钎矫 矫累-->
<%@ include file="../newbottom.jsp"%>
<!--窍窜 版肺钎矫 场-->
</form>
</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){}
}
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -