📄 soulmate_zp.jsp.svn-base
字号:
<!--公霸鸥 局沥 包府 郴侩 场-->
<%
} else if (oppCount == 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/LoveMng_zp.jsp?mphone=<%=mphone%>&gphone=<%=mphone%>">歹焊扁(醚<%=oppCount%>疙) ⒑</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>
<!--鸥捞撇 场-->
<%
/*------------------------------------------------------------------------------------------------
* Taro opponent's count
-------------------------------------------------------------------------------------------------*/
sql = " select count(idx) taroCount from gt_lucky_taro WITH (READUNCOMMITTED) where phonenum="
+ Long.parseLong(mphone);
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if (rs.next()) {
taroCount = rs.getInt("taroCount");
} else {
taroCount = 0;
}
rs.close();
pstmt.close();
if (taroCount != 0) {
/*------------------------------------------------------------------------------------------------
* Taro List
-------------------------------------------------------------------------------------------------*/
sql = " select idx,taro_card_idx,taro_idx,nickname,sex,age,phonenum,max(regdate) regdate ,max(text) text from (";
sql = sql
+ " select ta.idx,co.taro_card_idx,co.taro_idx,us.nickname,us.sex,(substring(convert(varchar(8),getDate(),112),0,5)-us.year+1) age,co.phonenum,convert(char(10),co.regdate,102) regdate,ta.text ";
sql = sql
+ " from gt_lucky_taro ta WITH (READUNCOMMITTED),gt_lucky_taro_comment co WITH (READUNCOMMITTED),GT_User_Info us WITH (READUNCOMMITTED) where ta.idx=co.taro_idx and us.phonenum=co.phonenum and ta.phonenum="
+ Long.parseLong(mphone);
sql = sql
+ " ) viewInvoke group by idx,taro_card_idx,taro_idx,nickname,sex,age,phonenum,regdate,text order by regdate desc ";
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
%>
<!--鸥肺痢阑 毫林技夸! 郴侩 矫累-->
<tr>
<td colspan="3">
<table width="176" bgcolor="#eeeeee" border="0" cellspacing="0" cellpadding="0">
<%
int count = 0; //其捞瘤 墨款磐 函荐
while (rs.next()) {
count++;
strGuestNickName = rs.getString("nickname");
text = rs.getString("text");
regDate = rs.getString("regdate");
sex = rs.getInt("sex");
age = rs.getInt("age");
taroId = rs.getString("idx");
taro_idx = rs.getString("taro_idx");
taro_card_idx = rs.getString("taro_card_idx");
taro_phonenum = rs.getString("phonenum");
if (count == 1) {
%>
<tr>
<td colspan="2" height="3"></td>
</tr>
<%if(text == null || text == ""){ %>
<tr>
<td colspan="2">
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="35" valign="top"><font color="#9819e9"></font></td>
<td><font color="#9819e9"></font></td>
</tr>
</table>
</td>
</tr>
<%}else{ %>
<tr>
<td colspan="2">
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="35" valign="top"><font color="#9819e9">⒑龙巩:</font></td>
<td><font color="#9819e9"><%=text%></font></td>
</tr>
</table>
</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="answerDetail.jsp?gphone=<%=taro_phonenum%>&mphone=<%=taro_phonenum%>&idx=<%=taroId%>"><%=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>
<%
} else if (count <= 5) {
%>
<!--概莫 郴侩 矫累-->
<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="#7b7b7b"><a href="answerDetail.jsp?gphone=<%=taro_phonenum%>&mphone=<%=taro_phonenum%>&idx=<%=taroId%>">
<%=strGuestNickName%>丛狼 搬苞 </a></font><font color="#ababab" size="2">(<%=regDate%>)</font><br>
</td>
</tr>
<%
}
}
rs.close();
pstmt.close();
%>
<tr>
<td colspan="2" height="5"></td>
</tr>
</table>
</td>
</tr>
<!--概莫 郴侩 场-->
<%
} else if (taroCount == 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/questionList.jsp?mphone=<%=mphone%>&gphone=<%=mphone%>">鸥肺痢龙巩 殿废⒑</a></font>
<font color="#c789ff"><a href="<%=url_path%>/soulmate/questionself.jsp?mphone=<%=mphone%>&gphone=<%=mphone%>">傈眉焊扁 ⒑</a></font>
</td>
<td width="3"></td>
</tr>
</table>
</td>
</tr>
<!--鸥肺痢阑 毫林技夸! 郴侩 场-->
<tr>
<td height="10"></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%>/mypage/my_main_sub.jsp?mphone=<%=mphone%>&gphone=<%=mphone%>&hostf=Y"><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=" + mphone%>">权</a>>
<a href="<%=url_path%>/mypage/my_confirm.jsp?mphone=<%=mphone%>&gphone=<%=mphone%>"><%=strNickname%>葱匙烙丛狼 迄乔</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 + -