myqamatchmatelist.jsp

用手机浏览的一个类似于聊天室 博克 homepage 等 对这方面有 兴趣的朋友 有所帮助的

	  
	  starMatchemp = (match%4)/2;
	  
	  long phonenum = pageRs.getLong(6);
	  
	  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;

        %>
	<!--概莫 郴侩 冠胶1 矫累-->
	<tr>
		<td >
			<table width="240" border="0" cellspacing="0" cellpadding="0">
				<tr>
					<td colspan="3" height="3"></td>
				</tr>
				<tr>
					<td width="7"></td>
					<td width="226">
						<table width="226" border="0" cellspacing="0" cellpadding="0">
							<tr>
								<!--酒官鸥 矫累-->
								<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=<%=phonenum%>" width="48" height="54" border="0"></td>
											<td width="3"></td>
										</tr>
										<tr>
											<td colspan="3" height="3"></td>
										</tr>
									</table>
								</td>
								<!--酒官鸥 场-->

								<!--概莫 郴侩 矫累-->
								<td width="172">
									<table width="172" border="0" cellspacing="0" cellpadding="0">	
										<tr>
											<td width="5"></td>
											<td width="107" height="17"><b><%=name1 %></b></td>
											<td><font color="#909090"><%if(sex ==1) { %>咯己 <%}else{ %>巢己<%} %> (<%=nyear-year%>技)</font></td>
										</tr>
										<tr>
											<td width="5"></td>
											<td colspan="2"><font color="#909090">包缴档</font><font color="#ffa6d6"> 
											                <%for(int i=0;i<starAttentionfull;i++) {%>≮<%} %><%for(int i=0;i<starAttentionemp;i++) {%>≠<%} %></font><br>
																	 <font color="#909090">概莫档</font><font color="#ffa6d6">
										                    <%for(int i=0;i<starMatchfull;i++) {%>≮<%} %><%for(int i=0;i<starMatchemp;i++) {%>≠<%} %></font></td>
										</tr>
									</table>
								</td>
								<!--概莫 郴侩 场-->
							</tr>
							<tr>
								<td colspan="2" height="3"></td>
							</tr>
							<tr>
								<td colspan="2" align="center">酒捞叼咯几磊丛苞 唱客狼 <font color="#ff6c78">概莫档 <%=(int)percent%>%</font></td>
							</tr>
							<tr>
								<td colspan="2" align="center"><font color="#909090" size="3">(醚 <%=(int)answercount  %>俺 亲格 老摹)</font></td>
							</tr>
							<tr>
								<td colspan="2" height="3"></td>
							</tr>

							<!--概莫 备盒急 矫累-->
							<tr>
								<td colspan="2" height="1" bgcolor="#d5d1be"></td>
							</tr>
							<!--概莫 备盒急 场-->

						</table>
					</td>
					<td width="7"></td>
				</tr>
			</table>
		</td>
	</tr>
	<!--概莫 郴侩 冠胶1 场-->
	<%
	}
     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="240" height="21" bgcolor="#e8f2f2" border="0" cellspacing="0" cellpadding="0">
				<tr>
    <td height="19" 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>&nbsp;
   
   <%}
   //其捞瘤 锅龋 唱凯窍扁
  
   if(isNoPage == 0)
   
   {
	
	 for(int i=startPage ; i<(startPage+limit);i++)
    
     {
	  
	   if( i == pageNUM)
	   
	   {%>
			
			<font color="#DB1A00"><b><%=i%></b></font>&nbsp;
	<% }
	   
	   else
	 
	   { %>
			<a href="<%=pageurl%>&pageNUM=<%=i%>"><font color="#DB1A00"><%=i%></font></a>&nbsp;
    <% }
	   
	   if(i >= pagecount) break;
	 
	 }
   
   }
  
   else
	  
	  out.println("钎矫 且 郴侩捞 绝嚼聪促.");
   
   //[促澜] 傅农 眠啊
   
   if((startPage+limit)<=pagecount){ %>
	
	<a href="<%=pageurl%>&pageNUM=<%=(startPage+limit)%>"><font color="#DB1A00">促澜</font></a>&nbsp;
   
   <%}
   
%>	
	</td>
	
  </tr>
			</table>
			<!--其捞瘤 傅农 场-->

	<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%>/soulmate/MYQAmatchMate.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>&name=<%=java.net.URLEncoder.encode(name)%>"><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">&nbsp;<a href="<%=url_path+"/main.jsp?mphone="+mphone+"&gphone="+gphone%>">权</a>&gt;<a href="<%=url_path%>/mypage/my_confirm.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>"><%=name %>丛狼 迄乔包府</a>&gt;<a href="<%=url_path+"/soulmate/MySoulmate.jsp?mphone="+mphone+"&gphone="+gphone%>">家匡皋捞飘</a><br>&nbsp;&nbsp;&nbsp;&nbsp;&gt;龙巩措翠</td>
					<td width="10" bgcolor="#BBC7C8"></td>
				</tr>
			</table>
		</td>
	</tr>
<!--窍窜 版肺钎矫 场-->

</table>

<!--窍窜 版肺钎矫 矫累-->
	<%@ include file="../newbottom.jsp"%>
<!--窍窜 版肺钎矫 场-->

</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){}
	}
%>