📄 soulmate_zp.jsp
字号:
<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(distinct(guest_nickname)) oppCount from GT_LUCKY_LOVE where 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 opponent's Info
-------------------------------------------------------------------------------------------------*/
sql = " select nickname,sex,(substring(convert(varchar(8),getDate(),112),0,5)-year) age ,phonenum from GT_User_Info WHERE phonenum=" ;
sql = sql + "(select top 1 guest_phone from GT_LUCKY_LOVE where phonenum="+Long.parseLong(mphone)+" order by regdate desc)" ;
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if( rs.next() )
{
strOppNickname = rs.getString("nickname");
sex = rs.getInt("sex");
age = rs.getInt("age");
strGuestphone = rs.getString("phonenum");
}else{
strNickname = "绝澜";
sex = 1;
age = 0;
strGuestphone = "";
}
rs.close();
pstmt.close();
/*------------------------------------------------------------------------------------------------
* Love List
-------------------------------------------------------------------------------------------------*/
sql = " select a.guest_phone,a.guest_nickname ,convert(char(10),a.regdate,102) regdate from (select guest_phone,guest_nickname ,max(regdate) as regdate from GT_LUCKY_LOVE where phonenum!=guest_phone and phonenum="+Long.parseLong(mphone)+" group by guest_phone ,guest_nickname) a order by regdate desc" ;
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
%>
<!--公霸鸥 局沥 包府 郴侩 矫累-->
<tr>
<td width="3"></td>
<td width="234">
<table width="234" border="0" cellspacing="0" cellpadding="0">
<%
int count = 0 ; //其捞瘤 墨款磐 函荐
while(rs.next())
{
count++;
strGuestNickName = rs.getString("guest_nickname");
regDate = rs.getString("regdate");
if(count == 1){
%>
<tr>
<td width="3"></td>
<!--酒官鸥 矫累-->
<td width="54">
<table width="54" bgcolor="#e8f2f2" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="3" height="3"></td>
</tr>
<tr>
<td width="3"></td>
<td valign="top"><img src="<%=ava_path%>display_thumb.jsp?mphone=<%=mphone%>&gphone=<%=strGuestphone%>" width="48" height="54"></td>
<td width="3"></td>
</tr>
<tr>
<td colspan="3" height="3"></td>
</tr>
</table>
</td>
<!--酒官鸥 场-->
<!--郴侩 矫累-->
<td width="174">
<table width="174" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="5"></td>
<td colspan="2"><font color="#464646">唱俊霸 啊厘 腹篮 包缴阑</font><br>
<font color="#464646">焊捞绰 模备</font></td>
</tr>
<tr>
<td width="5"></td>
<td width="107" height="20" valign="bottom"><b><%=strOppNickname%></b></td>
<%if(sex == 1){ %>
<td valign="bottom"><font color="#909090">咯己 (<%=age%>技)</font></td>
<%}else{ %>
<td valign="bottom"><font color="#909090">巢己 (<%=age%>技)</font></td>
<%} %>
</tr>
</table>
</td>
<td width="3"></td>
<!--郴侩 场-->
</tr>
<tr>
<td colspan="4" height="3"></td>
</tr>
<%}else if(count<=5){ %>
<!--局沥 搬苞 郴侩 矫累-->
<tr>
<td width="3"></td>
<td colspan="2"><font color="#464646"><%=strGuestNickName%>丛狼 局沥 搬苞</font>
<font color="#909090" size="3"> (<%=regDate%>)</font></td>
<td width="3"></td>
</tr>
<%}
}
rs.close();
pstmt.close();
%>
<!--局沥 搬苞 郴侩 矫累-->
<tr>
<td colspan="4" height="5"></td>
</tr>
</table>
</td>
<td width="3"></td>
</tr>
<tr>
<td width="3"></td>
<td align="right"><font color="#c789ff" size="3"><a href="<%=url_path%>/soulmate/LoveMng_zp.jsp?mphone=<%=mphone%>&gphone=<%=mphone %>">歹焊扁 (醚<%=oppCount%>疙) ⒑</a></font></td>
<td width="3"></td>
</tr>
<!--公霸鸥 局沥 包府 郴侩 场-->
<%}else if(oppCount ==0 ){ %>
<!--公霸鸥 局沥 包府 郴侩 矫累-->
<tr>
<td colspan="3">
<table width="240" 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="7"></td>
</tr>
<tr>
<td width="3"></td>
<td align="right"><font color="#c789ff" size="3"><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="3"></td>
</tr>
<!--鸥肺痢阑 毫林技夸! 冠胶 矫累-->
<tr>
<td >
<table width="240" border="0" cellspacing="0" cellpadding="0">
<!--鸥捞撇 矫累-->
<tr>
<td width="3"></td>
<td height="19"><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 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 nickname,sex,age,phonenum,max(regdate) regdate ,max(text) text from (";
sql = sql +" select us.nickname,us.sex,(substring(convert(varchar(8),getDate(),112),0,5)-us.year) age,co.phonenum,convert(char(10),co.regdate,102) regdate,ta.text ";
sql = sql +" from gt_lucky_taro ta,gt_lucky_taro_comment co,GT_User_Info us where ta.idx=co.taro_idx and us.phonenum=co.phonenum and ta.phonenum="+Long.parseLong(mphone) ;
sql = sql +" ) viewInvoke group by nickname,sex,age,phonenum,regdate,text order by regdate desc ";
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
%>
<!--鸥肺痢阑 毫林技夸! 郴侩 矫累-->
<tr>
<td width="3"></td>
<td width="234">
<table width="234" border="0" cellspacing="0" cellpadding="0">
<%
int count = 0 ; //其捞瘤 墨款磐 函荐
while(rs.next())
{
count++;
if(count == 1){
strGuestNickName = rs.getString("nickname");
text = rs.getString("text");
regDate = rs.getString("regdate");
sex = rs.getInt("sex");
age = rs.getInt("age");
%>
<tr>
<td width="3"></td>
<!--酒官鸥 矫累-->
<td width="54">
<table width="54" bgcolor="#e8f2f2" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="3" height="3"></td>
</tr>
<tr>
<td width="3"></td>
<td valign="top"><img src="<%=ava_path%>display_thumb.jsp?mphone=<%=mphone%>&gphone=<%=strGuestphone%>" width="48" height="54"></td>
<td width="3"></td>
</tr>
<tr>
<td colspan="3" height="3"></td>
</tr>
</table>
</td>
<!--酒官鸥 场-->
<!--郴侩 矫累-->
<td width="174">
<table width="174" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="5"></td>
<td width="107" height="20" valign="top"><b><%=strGuestNickName %></b></td>
<%if(sex == 1){ %>
<td valign="top"><font color="#909090">咯己 (<%=age%>技)</font></td>
<%}else{ %>
<td valign="top"><font color="#909090">巢己 (<%=age%>技)</font></td>
<%} %>
</tr>
<tr>
<td width="5"></td>
<td colspan="2"><font color="#909090"><%=text %></font><br>
</td>
</tr>
</table>
</td>
<td width="3"></td>
<!--郴侩 场-->
</tr>
<tr>
<td colspan="4" height="3"></td>
</tr>
<!--鸥肺痢阑 毫林技夸! 搬苞 郴侩 矫累-->
<%}else if(count<=5){ %>
<tr>
<td width="3"></td>
<td colspan="2"><font color="#464646"><%=strGuestNickName%>丛狼 搬苞</font>
<font color="#909090" size="3"> (<%=regDate %>)</font></td>
<td width="3"></td>
</tr>
<% }
}
rs.close();
pstmt.close();
%>
<!--鸥肺痢阑 毫林技夸! 搬苞 郴侩 矫累-->
<tr>
<td colspan="4" height="5"></td>
</tr>
</table>
</td>
<td width="3"></td>
</tr>
<tr>
<td width="3"></td>
<td ><font color="#c789ff" size="3"><a href="<%=url_path%>/soulmate/questionList.jsp?mphone=<%=mphone%>&gphone=<%=mphone %>">鸥肺痢 龙巩 殿废⒑</a></font> 
<font color="#c789ff" size="3"><a href="<%=url_path%>/soulmate/questionself.jsp?mphone=<%=mphone%>&gphone=<%=mphone %>">傈眉焊扁 ⒑</a></font></td>
<td width="3"></td>
</tr>
<!--鸥肺痢阑 毫林技夸! 郴侩 场-->
<%}else if (taroCount == 0){ %>
<!--鸥肺痢阑 毫林技夸! 郴侩 矫累-->
<tr>
<td colspan="3">
<table width="240" 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="7"></td>
</tr>
<tr>
<td width="3"></td>
<td><font color="#c789ff" size="3"><a href="<%=url_path%>/soulmate/questionList.jsp?mphone=<%=mphone%>&gphone=<%=mphone %>">鸥肺痢 龙巩 殿废⒑</a></font> 
<font color="#c789ff" size="3"><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="7"></td>
</tr>
<!--滚瓢 矫累-->
<tr>
<td>
<table width="240" height="17" border="0" cellspacing="0" cellpadding="0">
<tr>
<td></td>
<td width="60" height="17" bgcolor="#c789ff" align="center"><a href="<%=url_path%>/mypage/my_confirm.jsp?mphone=<%=mphone%>&gphone=<%=mphone%>"><font color="#ffffff">倒酒啊扁</font></a></td>
<td></td>
</tr>
</table>
</td>
</tr>
<!--滚瓢 场-->
<!--咯归 矫累-->
<tr>
<td height="11"></td>
</tr>
<!--咯归 场-->
<!--窍窜 版肺钎矫 矫累-->
<tr>
<td>
<table width="240" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="10" bgcolor="#BBC7C8"></td>
<td width="220" bgcolor="#DAE6E8" height="19"> <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 + -