myqamatchmatelist.jsp.svn-base

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

<!--------------------------------------------------------------------------------------------------------------
*@目敲霸烙 娄茫扁 
*@Author : 弥眠岿 (2008-6-06)
*@Images : 其捞瘤 救俊 甸绢啊绰 捞固瘤
	1) bg_01.png - 抛捞喉 弥惑窜 硅版捞固瘤(仟弗祸)
--------------------------------------------------------------------------------------------------------------->
<%@ page import='java.io.*,java.text.*,java.util.Date,java.util.Vector, javax.servlet.http.HttpSession,java.sql.*, com.entaz.lib.db.*, com.entaz.relay.net.*' contentType='text/html;charset=euc-kr'%>
<%@ include file="../imgpath.jsp"%>
<%@ include file="../common_func.jsp"%>
<%@ include file="../makeKOR.jsp"%>
<%

	/***********************************************************************
	
	@ Page Description
	 	霸烙 皋牢 其捞瘤
	
	@ Parameter

	***********************************************************************/

	/*------------------------------------------------------------------------------------------------------
	+	扁夯 颇扼固磐
	-------------------------------------------------------------------------------------------------------*/	
	String mphone= request.getParameter("mphone");
	
	String gphone= request.getParameter("gphone");
	
	String panduan = request.getParameter("panduan");
	
	int selectbox = 0;
	if(request.getParameter("selectbox")!=null)
	{
	 selectbox = Integer.parseInt(request.getParameter("selectbox"));
	}
	else
	{
	 selectbox =1;
	}
	
	String name= java.net.URLDecoder.decode(makeKOR(request.getParameter("name")));
	/*------------------------------------------------------------------------------------------------------
	+	傈开 函荐
	-------------------------------------------------------------------------------------------------------*/
    int nyear =0;
    
    int starAttentionfull =0;
    
    int starAttentionemp =0;
    
    int starMatchfull =0;
    
    int starMatchemp =0;
    
    double answercount =0;
    
    double allcont =0;
    
    double percent =0;
    
    String 	pageurl 			= null;
	
	// 其捞瘤 备泅 眠啊 函荐 
	int pagesize = 5;  // 茄其捞瘤寸 10俺 免仿拱

	// 傈开 函荐肺 急攫.. 其捞瘤 备泅 何盒俊 犁荤侩
	int pageNUM=1;    // 其捞瘤 锅龋
	int pagecount=1 ; // 其捞瘤 肮荐 瘤沥 函荐

	int absolutepage=1;  // 例措 困摹 其捞瘤 锅龋
    int num = 0;   //  DB 救俊 臂 肮荐 历厘 函荐
	int isNoPage = 0;	//茄俺档 绝蠢衬.. 绝栏搁0, 乐栏搁1
	
	/*------------------------------------------------------------------------------------------------------
	+	DB 包访 函荐
	-------------------------------------------------------------------------------------------------------*/
	PreparedStatement pstmt = null;
	
	Connection con = null;
	
	Statement stmt = null;
	
	ResultSet rs = null;
	
	String query1 = null;
	
	ResultSet pageRs =null;

	
	
	try
	{

	/*------------------------------------------------------------------------------------------------
	 *		DB 目池记
	 -------------------------------------------------------------------------------------------------*/
	%><%@ include file="../getConnection.jsp"%><%
	
	/*------------------------------------------------------------------------------------------------
	 *	唱客 嘎绰 荤恩狼 扁夯 沥焊 
	 -------------------------------------------------------------------------------------------------*/
	 query1="select count(distinct Guest_phone)as num  from gt_lucky_quiz_mylog WITH (READUNCOMMITTED) where phonenum =?";

	 pstmt = con.prepareStatement(query1);
     
     pstmt.setLong(1,Long.parseLong(mphone));
     
     rs= pstmt.executeQuery();
     
     if(rs.next())
     {
       num = rs.getInt("num");
     }

	  if(num%pagesize == 0)
		
		pagecount = num/(pagesize); // 醚 其捞瘤荐 备窍扁
	
	    else
		
		pagecount = num/(pagesize)+1; // 醚 其捞瘤荐 备窍扁

	    if(request.getParameter("pageNUM")!=null)
	    {
		pageNUM=Integer.parseInt(request.getParameter("pageNUM"));//瘤沥等 其捞瘤 焊咯林扁
		
		absolutepage=(pageNUM-1)*pagesize+1;
	    }

	 rs.close();
	 
	 pstmt.close();
	 
	 query1="select name,sex,year,phonenum,isNull(Attention_point,0) Attention_point ,isNull(Match_point,0) Match_point from ((select nickname name,sex sex ,year year,phonenum from gt_user_info WITH (READUNCOMMITTED) where convert(bigint,phonenum) "+
	 		"in(select distinct Guest_phone  from gt_lucky_quiz_mylog WITH (READUNCOMMITTED) where phonenum =?  and guest_phone != ?) ) a left join  "+
	 		"(select Attention_point,guest_phone bphone from GT_LUCKY_ATTENTION_POINT WITH (READUNCOMMITTED) where convert(bigint,Guest_phone) "+
	 		"in(select distinct Guest_phone  from gt_lucky_quiz_mylog WITH (READUNCOMMITTED) where phonenum =?  and guest_phone != ?) and phonenum = ? ) b on a.phonenum = b.bphone left join "+
	 		"(select Match_point ,guest_phone cphone from GT_LUCKY_MATCH_POINT WITH (READUNCOMMITTED) where convert(bigint,Guest_phone) "+
	 		"in (select distinct Guest_phone  from gt_lucky_quiz_mylog WITH (READUNCOMMITTED) where phonenum =?  and guest_phone != ?) and  phonenum = ? ) c  on a.phonenum = c.cphone ) ";
     //            +" and b.phonenum =? and c.phonenum = ?";
     if(selectbox ==2)
     {
     query1 =query1+" order by c.Match_point desc";
     }
     else
     {
     query1 =query1+" order by b.Attention_point desc";
     }
                 
     pstmt = con.prepareStatement(query1);
     
     pstmt.setLong(1,Long.parseLong(mphone));
     
     pstmt.setLong(2,Long.parseLong(mphone));
     
     pstmt.setLong(3,Long.parseLong(mphone));
     
     pstmt.setLong(4,Long.parseLong(mphone));
     
     pstmt.setLong(5,Long.parseLong(mphone));
     
     pstmt.setLong(6,Long.parseLong(mphone));
     
     pstmt.setLong(7,Long.parseLong(mphone));
     
     pstmt.setLong(8,Long.parseLong(mphone));
     
     
     pageRs= pstmt.executeQuery();
     if(!pageRs.next())
     {
           isNoPage = 1;
			pagesize=0;
     }
	else         // 蔼捞 乐阑锭	//rs.absolute(absolutepage);
		{				
			for(int s=0; s<absolutepage-1; s++)
			
			    
				pageRs.next();
				
				
		}
	%>
	<html>
<head>
	<link href="../mobile.css" rel="stylesheet" type="text/css">
	<title>权 > <%=name %>丛狼 迄乔包府 > 家匡皋捞飘 > 龙巩措翠</title>
</head>
<body>
<form name="form1" action="<%=url_path%>/soulmate/MyQAmatchmateList.jsp" method ="post">
<table width="176" border="0" cellspacing="0" cellpadding="0">
	<!--鸥捞撇 矫累-->
	<tr>
		<td>
			<table width="176" border="0" cellspacing="0" cellpadding="0">
				<tr>
					<td colspan="2" height="2" bgcolor="#c789ff"></td>
				</tr>
				<tr>
					<td width="6" height="14" bgcolor="#9819e9"></td>
					<td height="14" bgcolor="#9819e9"><font color="#ffffff">龙巩措翠 钱绢焊扁</font></td>
				</tr>
				<tr>
					<td colspan="2" height="2" bgcolor="#c789ff"></td>
				</tr>
				<tr>
					<td colspan="2" height="1" bgcolor="#9819e9"></td>
				</tr>
			</table>
		</td>
	</tr>
	<!--鸥捞撇 场-->

	<!--咯归 矫累-->
	<tr>
		<td height="4"></td>
	</tr>
	<!--咯归 场-->

	<!--沥纺 急琶 矫累-->
	<tr>
		<td>
			<table width="176" border="0" cellspacing="0" cellpadding="0">
				<tr>
					<td></td>
					<td colspan="2" align="center"><font color="9819e9"><b>唱客 嘎绰 荤恩甸</b></font></td>
					<td></td>
				</tr>
				<tr>
					<td colspan="4" height="5"></td>
				</tr>
				<tr>
					<td></td>
					<td width="75" align="center">
						<input type="hidden" name="mphone" value="<%=mphone%>">
						<input type="hidden" name="gphone" value="<%=gphone%>">
						<input type="hidden" name="name" value="<%=name%>">
						<select name="selectbox" size="1">
							<option value="1" <%=selectbox==1?"selected":""%>>包缴档 鉴</option>
							<option value="2" <%=selectbox==2?"selected":""%>>概莫档 鉴</option>
						</select>
					</td>
					<td width="40" align="center" bgcolor="#c789ff"><font color="#ffffff"><a href="javascript:document.form1.submit()">沥 纺</a></font></td>
					<td></td>
				</tr>
			</table>
		</td>
	</tr>
	<!--沥纺 急琶  场-->
	
	<!--咯归 矫累-->
	<tr>
		<td height="5"></td>
	</tr>
	<!--咯归 场--> 

	<tr>
		<td>
		
   <!--捞傈/促澜 傅农 冠胶 矫累-->
   <table width="176" bgcolor="#c789ff" border="0" cellspacing="0" cellpadding="0">
    <tr height="16">
      <td bgcolor="#e8f2f2" align="center">
       <%
        pageurl=url_path+"/soulmate/MyQAmatchmateList.jsp?mphone="+mphone;
        out.println(pagePath(pageurl, num, pageNUM, pagecount));
       %>
      </td>
     </tr>
   </table>
   <!--捞傈/促澜 傅农 冠胶 场-->

		</td>
	</tr>
<%
    
    int count = 0 ; //其捞瘤 墨款磐 函荐
    
    Calendar calendar=Calendar.getInstance();
	 
	 nyear=calendar.get(Calendar.YEAR);
	 
	 
    while(count<pagesize)
	{	
		count++;
					
       String name1=pageRs.getString("name");
       
       int sex = pageRs.getInt("sex");
       
       int year = pageRs.getInt("year");
       
       int Attention = pageRs.getInt("Attention_point");
       
       String dianhua = pageRs.getString("phonenum");