📄 soulmate_zp.jsp
字号:
<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="2" height="2"></td>
</tr>
<tr>
<td width="15"></td>
<td>
<font color="#ff6b94"><%=strOppNickname%>丛俊 措茄</font>
<br>
<font color="#ff6b94">包缴档 </font><font size="5">
<%
if (attentionPoint >= 24) {
%> <%=strNickname%>丛阑 亮酒窍绊 乐绢夸~ <%
} else if (attentionPoint >= 20 && attentionPoint <= 23) {
%> <%=strNickname%>丛俊霸 包缴捞 乐绢夸~ <%
} else {
for (int i = 0; i < attentionPoint / 4; i++) {
%> ≮ <%
}
if (attentionPoint % 4 >= 2) {
%> ≠ <%
}
}
%>
</font>
<br>
<font color="#7b7b7b"><%=strOppNickname%>丛俊 措茄</font>
<br>
<font color="#9819e9">捞秦档
<%int kkk;if((int)(((float)oppRightCount/(float)questionCount)*100)>100){kkk = 100;}else{kkk = (int)(((float)oppRightCount/(float)questionCount)*100);} %>
<%=kkk%>%
</font>
<br>
<font color="#ababab">(<%=oppRightCount%>俺 巩力 沥翠 /
醚 <%=questionCount%>俺 巩力 钱捞)</font>
<br>
<font color="#7b7b7b"><%=strOppNickname%>丛苞 唱客狼</font>
<br>
<font color="#9819e9">概莫档
<%int jjj; if((int)(((float)oppRightCount/(float)oppCount)*100)>100){jjj=100;}else{jjj = (int)(((float)oppRightCount/(float)oppCount)*100);} %>
<%=(int)(((float)oppRightCount/(float)oppCount)*100)%>%
</font>
<br>
<font color="#ababab">( <%=oppRightCount%>俺 老摹 / 醚
<%=oppCount%>俺 )</font>
</td>
</tr>
<tr>
<td colspan="2" height="5"></td>
</tr>
</table>
</td>
</tr>
<!--概莫 郴侩 场-->
<tr>
<td width="3"></td>
<td align="right">
<font color="#c789ff"><a href="<%=url_path%>/soulmate/QuizListView_zp.jsp?mphone=<%=mphone%>&gphone=<%=mphone%>">傈眉焊扁 (醚<%=answerCount%>疙) ⒑</a>
</font>
</td>
</tr>
<!--唱俊 措茄 巩力甫 钱绢夯 模备甸 郴侩 场-->
</table>
</td>
</tr>
<%
} else if (answerCount == 0) {
%>
<tr>
<td colspan="3">
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="7"></td>
<td align="left">
<font color="#909090">弥辟俊 巩力甫 钱绢夯 模备甸捞 绝绢夸.</font>
</td>
<td width="7"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="3" height="5"></td>
</tr>
<tr>
<td width="3"></td>
<td align="right">
<font color="#c789ff"><a href="<%=url_path%>/soulmate/QuizListView_zp.jsp?mphone=<%=mphone%>&gphone=<%=mphone%>">傈眉焊扁
(醚<%=answerCount%>疙) ⒑</a>
</font>
</td>
<td width="3"></td>
</tr>
<%
}
%>
</table>
</td>
</tr>
<!--唱俊 措茄 巩力甫 钱绢夯 模备甸 冠胶 场-->
<tr>
<td height="7"></td>
</tr>
<!--公霸鸥 局沥 包府 冠胶 矫累-->
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<!--鸥捞撇 矫累-->
<tr>
<td width="3"></td>
<td height="17">
<font color="#c789ff"><b>♂</b>
</font><font color="#7c7c7c"><b> 公霸鸥 局沥 包府!</b>
</font>
</td>
<td width="3"></td>
</tr>
<!--备盒急 矫累-->
<tr>
<td width="3"></td>
<td height="2" bgcolor="#ecaaff"></td>
<td width="3"></td>
</tr>
<!--备盒急 场-->
<tr>
<td colspan="3" height="3"></td>
</tr>
<!--鸥捞撇 场-->
<%
/*------------------------------------------------------------------------------------------------
* Love opponent's count
-------------------------------------------------------------------------------------------------*/
sql = "select count(*) oppCount from ( ";
sql = sql +" select a.sex , a.phonenum , a.nickname , (substring(convert(varchar(8),getDate(),112),0,5)-a.year+1) age , max(b.text) text , max(b.regdate) regdate from gt_lucky_love b WITH (READUNCOMMITTED), GT_User_Info a WITH (READUNCOMMITTED)";
sql = sql + "where (a.phonenum in (select phonenum from gt_lucky_love WITH (READUNCOMMITTED) where phonenum!="+Long.parseLong(mphone)+" and guest_phone="+Long.parseLong(mphone)+") or a.phonenum in (select guest_phone from gt_lucky_love WITH (READUNCOMMITTED) where phonenum="+Long.parseLong(mphone)+" and guest_phone!="+Long.parseLong(mphone)+"))";
sql = sql +" group by a.phonenum , a.nickname ,a.year , a.sex) m left join gt_lucky_attention_point n on m.phonenum = n.guest_phone where n.phonenum ="+Long.parseLong(mphone);
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if (rs.next()) {
oppCount = rs.getInt("oppCount");
} else {
oppCount = 0;
}
rs.close();
pstmt.close();
if (oppCount != 0) {
/*------------------------------------------------------------------------------------------------
* Love List
-------------------------------------------------------------------------------------------------*/
sql = " select a.guest_phone,a.guest_nickname ,convert(char(10),a.regdate,102) regdate ,a.phonenum, a.nickname from (select guest_phone,guest_nickname ,max(regdate) as regdate ,phonenum,nickname from GT_LUCKY_LOVE WITH (READUNCOMMITTED) where phonenum!=guest_phone and (phonenum!="
+ Long.parseLong(mphone)
+ " and guest_phone = "
+ Long.parseLong(mphone)
+ ") or (phonenum="
+ Long.parseLong(mphone)
+ " and guest_phone != "
+ Long.parseLong(mphone)
+ ") group by guest_phone ,guest_nickname,phonenum,nickname) a order by regdate desc";
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
%>
<!--公霸鸥 局沥 包府 郴侩 矫累-->
<tr>
<td width="3"></td>
<td width="170">
<table width="170" border="0" cellspacing="0" cellpadding="0">
<%
int count = 0; //其捞瘤 墨款磐 函荐
while (rs.next()) {
count++;
strGuestNickNameOne = rs.getString("guest_nickname");
strGuestNickNameTwo = rs.getString("nickname");
regDate = rs.getString("regdate");
loveGuestPhoneOne = rs.getString("guest_phone");
loveGuestPhoneTwo = rs.getString("phonenum");
if (Long.parseLong(mphone) == Long
.parseLong(loveGuestPhoneOne)) {
loveGuestPhone = loveGuestPhoneTwo;
strGuestNickName = strGuestNickNameTwo;
} else {
loveGuestPhone = loveGuestPhoneOne;
strGuestNickName = strGuestNickNameOne;
}
sql = "SELECT sex,(substring(convert(varchar(8),getDate(),112),0,5)-year+1) age FROM GT_USER_INFO WITH (READUNCOMMITTED) WHERE phonenum = '0"
+ loveGuestPhone + "'";
pstmt = con.prepareStatement(sql);
rsrs1 = pstmt.executeQuery();
if (rsrs1.next()) {
sex = rsrs1.getInt("sex");
age = rsrs1.getInt("age");
} else {
sex = 1;
age = 0;
}
rsrs1.close();
pstmt.close();
if (count == 1) {
%>
<tr>
<td colspan="3">
<table width="176" bgcolor="#eeeeee" border="0"
cellspacing="0" cellpadding="0">
<tr>
<td colspan="2" height="3"></td>
</tr>
<tr>
<td colspan="2">
<font color="#9819e9">⒑唱俊霸 啊厘腹篮 包缴阑 焊捞绰模备</font>
</td>
</tr>
<!--咯归 矫累-->
<tr>
<td colspan="2" height="3"></td>
</tr>
<!--咯归 场-->
<tr>
<td width="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+ "/soulmate/LoveMatch_zp.jsp?mphone="+ mphone + "&gphone=0" + loveGuestPhone%>"><%=strGuestNickName%></a></b></font>
<font color="#c085ed"><%
if (sex == 1) {
%> 咯己 (<%=age%>技) <%
} else {
%> 巢己 (<%=age%>技) <%
}
%></font>
</td>
</tr>
<tr>
<td width="15"></td>
<td>
<font color="#909090"><%=regDate%></font>
</td>
</tr>
<tr>
<td colspan="2" height="3"></td>
</tr>
</table>
</td>
</tr>
<%
} else if (count <= 5) {
%>
<!--概莫 郴侩 矫累-->
<tr>
<td colspan="2">
<table width="176" bgcolor="#ffffff" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="3" height="2"></td>
</tr>
<tr>
<td width="15"></td>
<td>
<font color="#7b7b7b"><a href="<%=url_path+ "/soulmate/LoveMatch_zp.jsp?mphone="+ mphone + "&gphone=0" + loveGuestPhone%>"><%=strGuestNickName%>丛狼局沥 搬苞</a></font>
<font color="#ababab">(<%=regDate%>)</font>
<br>
</td>
<td width="3"></td>
</tr>
<tr>
<td colspan="3" height="5"></td>
</tr>
</table>
</td>
</tr>
<%
}
}
rs.close();
pstmt.close();
%>
<!--概莫 郴侩 场-->
</table>
</td>
<td width="3"></td>
</tr>
<tr>
<td width="3"></td>
<td align="right">
<a href="<%=url_path%>/soulmate/LoveMng_zp.jsp?mphone=<%=mphone%>&gphone=<%=mphone%>"><font color="#c789ff">歹焊扁(醚<%=oppCount%>疙) ⒑</font></a>
</td>
<td width="3"></td>
</tr>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -