soulmate_g.jsp

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

<!-- 
* @ name: soulmate_g.jsp
* @ Author : ranxu 
* @ date :2008-06-04
-->
<%@ page import='java.io.*,java.text.*,java.util.Date,java.util.Vector, 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"%>
<%! 
	int SEX_MALE = 1;
	int SEX_FEMALE = 2;
	
	public String getSex(int key) 
	{
		String ret = "";
		if(key==SEX_FEMALE){
			ret = "巢己";
		}else if(key==SEX_MALE){
			ret = "咯己"; 
		}
		return ret;
	}	
%>
<%	
    /*------------------------------------------------------------------------------------------------------
	 parameter from last page:knowmate_s.jap or knowmate_k.jap
	 -------------------------------------------------------------------------------------------------------*/
	String mphone		= request.getParameter("mphone");
	String gphone		= request.getParameter("gphone");
	String picid 		= request.getParameter("picid");
	String picnumidx 	= request.getParameter("picnum");	
	boolean str_Flag 	= true;	
	if(picid == null){
		picid = "";
	}
	if(picnumidx == null){
		picnumidx = "";
	}	
	/*------------------------------------------------------------------------------------------------------
	+	DB 
	-------------------------------------------------------------------------------------------------------*/
	PreparedStatement 	pstmt 	= null;
	Connection 			con 	= null;
	Statement 			stmt 	= null;
	ResultSet 			rs 		= null;
	String 				sql 	= null;
	int 				ret 	= -1;
	/*------------------------------------------------------------------------------------------------------
	 +	init parameter of current page
	 -------------------------------------------------------------------------------------------------------*/
	String 	nickname 			= "";
	String 	nicknameface 		= "";
	String 	nicknamefaceTwo 	= "";
	int 	age 				= 0;
	int 	sex 				= 0;
	int 	attentionPoint 		= 0;
	String 	title 				= "";
	String 	title_taro 			= "";
	int 	idx_taro 			= 0;	
	boolean hasTaroTitle		= false;	
	boolean taroTitleAnswered 	= false;
	
	try
	{	
	/*------------------------------------------------------------------------------------------------
	 *		DB 目池记
	 -------------------------------------------------------------------------------------------------*/
	%><%@ include file="../getConnection.jsp"%><%
	/*------------------------------------------------------------------------------------------------
	 *		All Quiz answerCount
	 -------------------------------------------------------------------------------------------------*/
	sql = " select nickname from Gt_user_info WITH (READUNCOMMITTED) where phonenum=?";
	pstmt = con.prepareStatement(sql); 
	pstmt.setString(1,gphone);
	rs=pstmt.executeQuery();	
	if(rs.next()){
		nicknameface = rs.getString("nickname");
	}
	rs.close();
	pstmt.close();	
	sql = " select nickname from Gt_user_info WITH (READUNCOMMITTED) where phonenum=?";
	pstmt = con.prepareStatement(sql); 
	pstmt.setString(1,mphone);
	rs=pstmt.executeQuery();	
	if(rs.next()){
		nicknamefaceTwo = rs.getString("nickname");
	}
	rs.close();
	pstmt.close();	
	sql = " select nickname,sex,(substring(convert(varchar(8),getDate(),112),0,5)-year+1) age,attention_point "
		+" from Gt_user_info a WITH (READUNCOMMITTED), gt_lucky_attention_point b WITH (READUNCOMMITTED) where a.phonenum=b.phonenum and a.phonenum=?";//'"+gphone+"'";	
	pstmt = con.prepareStatement(sql); 
	pstmt.setString(1,gphone);
	rs=pstmt.executeQuery();	
	if(rs.next()){
		nickname = rs.getString("nickname");
		sex = rs.getInt("sex");
		age = rs.getInt("age");
		attentionPoint = rs.getInt("attention_point");
	}
	rs.close();
	pstmt.close();	
	/*-------------------------------------------------------------------------------------------------------
	+	unanswered title
	-------------------------------------------------------------------------------------------------------*/	
	sql = " select top 1 * from GT_LUCKY_QUIZ_MYLOG WITH (READUNCOMMITTED) where phonenum = ? and Guest_phone = ? and quiz_idx not in(select quiz_idx from GT_LUCKY_QUIZ_MYLOG WITH (READUNCOMMITTED) where phonenum = ? and Guest_phone =?) order by idx desc ";		
	pstmt = con.prepareStatement(sql);
	pstmt.setLong(1,Long.parseLong(gphone));
	pstmt.setLong(2,Long.parseLong(gphone));
	pstmt.setLong(3,Long.parseLong(gphone));
	pstmt.setLong(4,Long.parseLong(mphone));
	rs=pstmt.executeQuery();
	if(rs.next()){
		title = rs.getString("title");		
	}
	rs.close();
	pstmt.close();	
	/*-------------------------------------------------------------------------------------------------------
	+	unanwered taro title
	-------------------------------------------------------------------------------------------------------*/			 
	sql = " select top 1 * from gt_lucky_taro WITH (READUNCOMMITTED)"+
		  " where  phonenum= ? "+//gphone
		  " order by idx desc ";
	pstmt = con.prepareStatement(sql);
	pstmt.setLong(1,Long.parseLong(gphone));
	rs=pstmt.executeQuery();
	if(rs.next()){
		hasTaroTitle = true;
	}else{
		hasTaroTitle = false;

	}	
	rs.close();
	pstmt.close();	
	if(hasTaroTitle == true){
		sql = " select top 1 * from gt_lucky_taro WITH (READUNCOMMITTED)"+
		  " where  phonenum= ? and comment = 0"+//gphone
		  " order by idx desc ";
		pstmt = con.prepareStatement(sql);
		pstmt.setLong(1,Long.parseLong(gphone));
		rs=pstmt.executeQuery();
		if(rs.next()){
			idx_taro = rs.getInt("idx");
			title_taro = rs.getString("text");	
		}else{
			sql = " select top 1 * from gt_lucky_taro WITH (READUNCOMMITTED)"+
		  	" where  phonenum= ? and comment = 1"+//gphone
		  	" order by idx desc ";
		  	pstmt = con.prepareStatement(sql);
			pstmt.setLong(1,Long.parseLong(gphone));
			rs=pstmt.executeQuery();
			if(rs.next()){
				idx_taro = rs.getInt("idx");
				title_taro = rs.getString("text");	
			}
		}
		rs.close();
		pstmt.close();		
	}
	
	sql = "SELECT * FROM GT_LUCKY_LOVE WITH (READUNCOMMITTED) WHERE Guest_phone = ? and phonenum = ? and left(regdate,10) = left(getdate(),10)";
	pstmt = con.prepareStatement(sql);
	pstmt.setLong(1,Long.parseLong(mphone));
	pstmt.setLong(2,Long.parseLong(gphone));
	rs=pstmt.executeQuery();
	if(rs.next()){
		str_Flag = false;
	}
	rs.close();
	pstmt.close();	
 %>	
<html>
<head>
	<link href="http://entaz.mugeta.com/client/mugeta_v2_test/web/user/mobile.css" rel="stylesheet" type="text/css">
	<title>权> 促尔绢丛狼 迄乔 > 家匡皋捞飘</title>
</head>
<body>
<!--剧侥
  <tr>
     <td>
          <table width="176" border="0" cellspacing="0" cellpadding="0">
             <tr>  
  	    <td></td>
      	   </tr>
          </table>
     </td>
  </tr>
-->
<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="8"></td>
	</tr>
	<!--咯归 场-->
	<!--家匡皋捞飘 冠胶1 矫累-->
	<tr>
		<td >
			<table width="176" border="0" cellspacing="0" cellpadding="0">
				<tr>
					<td width="5"></td>
					<td width="166">
						<table width="166" 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=<%=gphone%>" width="48" height="54"></td>
											<td width="3"></td>
										</tr>
										<tr>
											<td colspan="3" height="3"></td>
										</tr>
									</table>
								</td>
								<!--酒官鸥 场-->
								<!--郴侩 矫累-->
								<td width="112">
									<table width="112" border="0" cellspacing="0" cellpadding="0">	
										<tr>
											<td width="2"></td>
											<td width="110" valign="top"><b><%=nicknameface%></b><br><font color="#909090"><%=getSex(sex) %> (<%=age %>)</font></td>
											<td></td>
										</tr>
										<tr>
											<td width="5"></td>
											<td colspan="2"><font color="#909090"><%=nicknameface%>丛俊 措茄<br>包缴档 </font>
													<font color="#ffa6d6"><%
											if(attentionPoint>=24){
											%>
												<%=nicknameface %>丛阑 亮酒窍绊 乐绢夸~
											<%												
											}else if(attentionPoint>=20 && attentionPoint<=23){
											%>
												<%=nicknameface %>丛俊霸 包缴捞 乐绢夸~
											<%