mysoulmate.jsp.svn-base

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

<!--------------------------------------------------------------------------------------------------------------
*@目敲霸烙 娄茫扁 
*@Author : 弥眠岿 (2008-6-04)
*@Images : 其捞瘤 救俊 甸绢啊绰 捞固瘤
	1) bg_01.png - 抛捞喉 弥惑窜 硅版捞固瘤(仟弗祸)
--------------------------------------------------------------------------------------------------------------->
<%@ 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"%>
<%@ include file="../makeKOR.jsp"%>
<%
 
	/***********************************************************************
	
	@ Page Description
	 	霸烙 皋牢 其捞瘤
	
	@ Parameter

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

	/*------------------------------------------------------------------------------------------------------
	+	扁夯 颇扼固磐
	-------------------------------------------------------------------------------------------------------*/	
	String mphone= request.getParameter("mphone");
	
	String gphone= request.getParameter("gphone");
	if(gphone == null)
	{
	  gphone = mphone;
	}
	
	/*------------------------------------------------------------------------------------------------------
	+	傈开 函荐
	-------------------------------------------------------------------------------------------------------*/
	
	String rgstrNickName[] = new String[4];
	String guestphone[] = new String[10000];
	
	String rgTitle[] = new String[2];
	String rgTableName[] = new String[2];
	
	String nickname = "";
	
	int nflag = 0;
	int xnflag = 0;
	
	int n=0;
	
	String title = "";
	
	int randomtitle = -1;
	
	int randomtitleTwo = -1;
	
	int year = 0;
	
	int month = 0;
	
	int day = 0;
	
	int   iDay=0;  //朝楼 荐
	
	int intellect = 0;  //瘤己 
	
	int body = 0;     //脚眉
	
	int sensitivity =0;//皑己
	
	int yintellect = 0; // 绢力狼 扁废 瘤己
	
	int ybody = 0; // 绢力狼 扁废 脚眉
	
	int ysensitivity =0;// 绢力狼 扁废 皑己

	int ifullstar = 0;  //喊荐
	
	int iemptystar = 0; //后喊荐
	
	int bfullstar = 0;
	
	int bemptystar = 0;
	
	int sfullstar = 0;
	
	int semptystar = 0;
	
	int toNextIdx = 0;
	/*------------------------------------------------------------------------------------------------------
	+	DB 包访 函荐
	-------------------------------------------------------------------------------------------------------*/
	PreparedStatement pstmt = null;
	
	Connection con = null;
	
	Statement stmt = null;
	
	ResultSet rs = null;
	
	String query1 = null;
	
	int newIdxO = 0;
	int newIdxT = 0;
	int newIdxS = 0;
	int newIdx = 0;
	
	String newContents = "";
	
	try
	{

	/*------------------------------------------------------------------------------------------------
	 *		DB 目池记
	 -------------------------------------------------------------------------------------------------*/
	%><%@ include file="../getConnection.jsp"%><%
	
	/*------------------------------------------------------------------------------------------------
	 *	郴 巩力 炼福扁 荤恩.
	 -------------------------------------------------------------------------------------------------*/
	 
	 
	 
	 query1 = "select guest_phone from GT_LUCKY_REQUEST WITH (READUNCOMMITTED) where phonenum = ?"+" order by guest_phone desc";
     
     pstmt = con.prepareStatement(query1);
     
     pstmt.setLong(1,Long.parseLong(mphone));
     
     rs = pstmt.executeQuery();
     
     for(int i=0;rs.next();i++)
     {
       guestphone[i]=rs.getString("guest_phone");
       
       xnflag = i+1;
     }
     
     rs.close();
     
     pstmt.close();
	 
	 for(int qq =0;qq<xnflag;qq++){
	 
		 query1 = "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(query1);
		 pstmt.setLong(1,Long.parseLong(mphone));
		 pstmt.setLong(2,Long.parseLong(mphone));
		 pstmt.setLong(3,Long.parseLong(mphone));
		 pstmt.setLong(4,Long.parseLong(guestphone[qq]));
		 rs=pstmt.executeQuery();
		 if(rs.next()){
		 	title = rs.getString("title");
		 }
		 rs.close();
		 pstmt.close();
	 	if(title != null && title !=""){
	 	query1 = "DELETE GT_LUCKY_REQUEST WHERE  guest_phone = "+guestphone[qq];
	 	pstmt = con.prepareStatement(query1);
	 	int b  = pstmt.executeUpdate();
	 	pstmt.close();
	 	}
	 
	 }
	 

	 
	 
     query1 = "select  distinct Top 4 nickname from GT_LUCKY_REQUEST WITH (READUNCOMMITTED) where phonenum = ?"+" order by nickname desc";
     
     pstmt = con.prepareStatement(query1);
     
     pstmt.setLong(1,Long.parseLong(mphone));
     
     rs = pstmt.executeQuery();
     
    for(int i=0;rs.next();i++)
     {
       rgstrNickName[i]=rs.getString("nickname");
       
       nflag = i+1;
     }
     
     rs.close();
     
     pstmt.close();
     
     /*------------------------------------------------------------------------------------------------
	 *	钱绢杭 龙巩捞 乐阑 版快 茄 俺父 免仿钦聪促. 
	 -------------------------------------------------------------------------------------------------*/
	 
	 query1 = "select distinct top 1 title,idx from GT_LUCKY_QUIZ WITH (READUNCOMMITTED) where flag = 1 and 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(query1);
	 
	 pstmt.setLong(1,Long.parseLong(mphone));
	 pstmt.setLong(2,Long.parseLong(mphone));

	 rs = pstmt.executeQuery();
	 
	 if(rs.next())
	 {
	    title = rs.getString("title");
	    toNextIdx = rs.getInt("idx");
	 }
	 
	 rs.close();
	 
	 pstmt.close();
	 
	 /*------------------------------------------------------------------------------------------------
	 *	官捞坷 府惦篮 促澜厘狼 官捞坷 府惦 傍侥俊 嘎苗 技何 郴侩阑 免仿钦聪促.
	 -------------------------------------------------------------------------------------------------*/
	 query1 = "select year, month, day,nickname  from GT_user_info WITH (READUNCOMMITTED) where phonenum = '"+mphone+"'";
	 
	 pstmt = con.prepareStatement(query1);
	 
	 rs = pstmt.executeQuery();
	 
	 if(rs.next())
	 {
	    year = rs.getInt("year");
	    
	    month = rs.getInt("month");
	 
	    day = rs.getInt("day");
	    
	    nickname = rs.getString("nickname");
	 }

	 rs.close();
	 
	 pstmt.close();
	 //款技评 id 备窍绰 傍侥  矫累 
	 Date todayDate1 = new Date();
	 
	 randomtitle = todayDate1.getDate()+day;
	 
	 randomtitle = Integer.parseInt(String.valueOf(randomtitle).substring(String.valueOf(randomtitle).length()-1));
	 
	 randomtitleTwo = randomtitle+3;
	 
	 if(randomtitle == 0){
	 	randomtitle =10;
	 }
	 
	 if(randomtitleTwo > 10){
	 	randomtitleTwo = 10;
	 }
	 
	 //款技评 id 备窍绰 傍侥 场 
	 if(year!=0 && month !=0 && day !=0)
	 
	 {
	 
	 Calendar calendar1=Calendar.getInstance();
	 
	 calendar1.set(year,month,day);
 
	 //坷疵 狼 朝楼 
	 Calendar calendar2=Calendar.getInstance();
	 
	 year=calendar2.get(Calendar.YEAR);
    
     month=calendar2.get(Calendar.MONTH)+1;
    
     day=calendar2.get(Calendar.DATE);
     
     calendar2.set(year,month,day);
     
     
	 if(!calendar2.equals(calendar1))
	 {  
         while(!calendar2.equals(calendar1))
                      {  
                              calendar1.add(calendar1.DATE,1);  
                              iDay++;
                      }
     }
      
     intellect =33/2-iDay%33;
     
     if(intellect<0)
     {
       intellect = Math.abs(intellect);
     }
     
     body =  23/2-iDay%23;
     
     if(body<0)
     {
       body =Math.abs(body);
     }
     
     sensitivity =  28/2-iDay%28;
     
      if(sensitivity<0)
     {
       sensitivity =Math.abs(sensitivity);
     }
     
     iDay = iDay-1;
     
     yintellect = 33/2-iDay%33;
     
      if(yintellect<0)
     {
       yintellect =Math.abs(yintellect);
     }
     
     ybody = 23/2-iDay%23;
     
     if(ybody<0)
     {
       ybody =Math.abs(ybody);
     }
     
     ysensitivity = 28/2-iDay%28;
     
     if(ysensitivity<0)
     {
       ysensitivity =Math.abs(ysensitivity);
     }

     ifullstar = intellect/4;
     
     iemptystar = (intellect%4)/2;
     
     bfullstar = body/4;
     
     bemptystar = (body%4)/2;
     
     sfullstar = sensitivity/4;
     
     semptystar = (sensitivity%4)/2;

     }


	 /*------------------------------------------------------------------------------------------------
	 *	款技屏.
	 -------------------------------------------------------------------------------------------------*/
	 
	 query1 = "select title,tablest from gt_luck_title WITH (READUNCOMMITTED) where idx = "+randomtitle+" or idx = "+randomtitleTwo;
	 
	 pstmt = con.prepareStatement(query1);
	 
	 rs = pstmt.executeQuery();
	 
	 for(int i=0;rs.next();i++)
	 {
	    rgTitle[i]=rs.getString("title");
	    rgTableName[i]=rs.getString("tablest");
	    n=i+1;
	 }
	 rs.close();
	 
	 pstmt.close();
	 
	 
	 
	 
	 
	 if(intellect<12){
	 newIdxO = 100;
	 }else if(11<intellect && intellect<23){
	 newIdxO = 200;
	 }else if(22<intellect){
	 newIdxO = 300;
	 }
	 
	 if(body<9){
	 newIdxT = 10;
	 }else if(8<body && body<17){
	 newIdxT = 20;
	 }else if(16<body){
	 newIdxT = 30;
	 }
	 
	 if(sensitivity<10){
	 newIdxS = 1;
	 }else if(9<sensitivity && sensitivity<19){
	 newIdxS = 2;
	 }else if(18<sensitivity){
	 newIdxS = 3;
	 }
	 
	 newIdx = newIdxO + newIdxT + newIdxS ;
	 
	 
	 query1 = "select * from gt_taday_One WITH (READUNCOMMITTED) where idx = ?";
	 
	 pstmt = con.prepareStatement(query1);
	 
	 pstmt.setLong(1,newIdx);
	 
	 rs = pstmt.executeQuery();
	 
	 for(int i=0;rs.next();i++)
	 {
	    newContents = rs.getString("contents");
	 }
	 rs.close();
	 
	 pstmt.close();
	 
	 
	 
	 
%>

<html>
<head>
	<link href="../mobile.css" rel="stylesheet" type="text/css">
	<title>权> 家匡皋捞飘</title>
</head>
<body>

<table width="176" border="0" cellspacing="0" cellpadding="0">
	<!--鸥捞撇 矫累-->
	<tr>