trace.jsp.svn-base

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

<!--------------------------------------------------------------------------------------------------------------
*@磊扁 橇肺鞘 焊扁 
*@Author : 弥眠岿 (2008-6-26)
--------------------------------------------------------------------------------------------------------------->
<%@ 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"%>
<%@ include file="appConstants.jsp"%>
<%@ include file="formatUtil.jsp"%>

<style   type="text/css">  
A:hover {
 COLOR: #000000; TEXT-DECORATION: underline
}
A:link {
 COLOR: #000000; TEXT-DECORATION: underline
}
A:visited {
 COLOR: #000000; TEXT-DECORATION: underline
}
</style>  
<%
	/*------------------------------------------------------------------------------------------------------
	+	扁夯 颇扼固磐
	-------------------------------------------------------------------------------------------------------*/	
	String mphone= request.getParameter("mphone");

	String gphone= request.getParameter("gphone");
	
	mphone = getStrPhone(getLong(mphone));
    
    gphone = getStrPhone(getLong(gphone));
	
	String year = "";
	
	if(request.getParameter("year")!=null){year=request.getParameter("year");};
	
	String month = "";
	
	if(request.getParameter("month")!=null){month=request.getParameter("month");};
	
	String day = "";
	
	if(request.getParameter("day")!=null){day=request.getParameter("day");};
	
	String type="";
	
	if(request.getParameter("type")!=null){type=request.getParameter("type");};
	
	String yy = "";
	
	if(request.getParameter("yy")!=null){yy=request.getParameter("yy");};
	
	String mm = "";
	
	if(request.getParameter("mm")!=null){mm=request.getParameter("mm");};
	
	String dd = "";
	
	if(request.getParameter("dd")!=null){dd=request.getParameter("dd");};
	
	/*------------------------------------------------------------------------------------------------------
	+	傈开 函荐
	-------------------------------------------------------------------------------------------------------*/	
	String nickname = "";
	
	String imgFile = "";
	
	long  fLevel = 0;
	
	int state =0;
	
	int idx =0;
	
	String toolTip = "";
	
	String toDo = "";
	
	String motto = "";
	
	String friend = "";
	
	String wish = "";
	
	String interest = "";
	
	String food = "";
	
	String music = "";
	
	String agony= "";
	
	String lookMan = "";

    String fault = "";
    
    int 	iFace = 0;
    
    int ToDorReCnt = 0;

    int  mottoReCnt = 0;
     
    int  friendReCnt = 0;
     
    int  wishReCnt = 0;
     
    int interestReCnt = 0;
     
    int foodReCnt = 0;
     
    int musicReCnt = 0;
     
    int agonyReCnt = 0;
     
    int lookManReCnt = 0;
     
    int faultReCnt = 0;
    
    String regdatelast = "";
    
    String regdatenext = "";
    
    String lastYear = "";
    
    String lastMonth = "";
    
    String lastDay = "";
    
    String nextYear = "";
    
    String nextMonth = "";
    
    String nextDay = "";
	/*------------------------------------------------------------------------------------------------------
	+	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"%><%@ include file="bgColor.jsp"%><%
	/*------------------------------------------------------------------------------------------------
	 *		橇肺鞘 nickname
	 -------------------------------------------------------------------------------------------------*/
	 query1 = "SELECT nickname FROM gt_user_info WITH (READUNCOMMITTED) WHERE phonenum = ?";
	 
	 pstmt = con.prepareStatement(query1);
	
	 pstmt.setString(1,gphone);
	 
	 rs = pstmt.executeQuery();
	 
	 if(rs.next())
	 {
	    nickname = rs.getString("nickname");
	 }
	 rs.close();
		
	 pstmt.close();
	 
	 if (neededExp == 0)
	 {
		fLevel = 1;
	 }else
	 {
		fLevel = (long)(((float)(cumulatedExpNow - cumulatedExp)) / (float)neededExp * 10) + 1;
	  }

     imgFile = img_path + "images/news/010_"+ fLevel +".png";
	
	/*------------------------------------------------------------------------------------------------------
	+	扁夯 惑怕
	-------------------------------------------------------------------------------------------------------*/
	query1="SELECT state FROM GT_NsMood WITH (READUNCOMMITTED)WHERE phonenum=? AND CONVERT(char(10),regdate,120)=CONVERT(char(10), '"+year+"-"+month+"-"+day+"',120) ";
	
	pstmt=con.prepareStatement(query1);
	
	pstmt.setLong(1,getLong(gphone));
	
	rs=pstmt.executeQuery();
	
	if(rs.next())
	{
	  state = rs.getInt("state");
	}
	
	pstmt.close();
	
	rs.close();

	/*------------------------------------------------------------------------------------------------------
	+	橇肺鞘
	-------------------------------------------------------------------------------------------------------*/
	query1="SELECT idx,toolTip,toDo,motto,friend,wish,interest,food,music,agony,lookMan,fault,face,ToDorReCnt,mottoReCnt,friendReCnt"
	           +",wishReCnt,interestReCnt,foodReCnt,musicReCnt,agonyReCnt,lookManReCnt,faultReCnt FROM GT_NsProfile WITH (READUNCOMMITTED)"
	           +" WHERE phonenum=? AND CONVERT(char(10),regdate,120)=CONVERT(char(10), '"+year+"-"+month+"-"+day+"',120) ";
	
	pstmt=con.prepareStatement(query1);
	
	pstmt.setLong(1,getLong(gphone));
	
	rs=pstmt.executeQuery();
	
	if(rs.next())
	{
		idx=rs.getInt("idx");
	
        toolTip = rs.getString("toolTip");
 
        toDo = rs.getString("toDo");
         
        motto = rs.getString("motto");
     
        friend = rs.getString("friend");
     
       wish = rs.getString("wish");
      
        interest = rs.getString("interest");
     
        food = rs.getString("food");
      
        music = rs.getString("music");
      
        agony = rs.getString("agony");
      
        lookMan = rs.getString("lookMan");
      
        fault = rs.getString("fault");
      
       ToDorReCnt = rs.getInt("ToDorReCnt");

       mottoReCnt = rs.getInt("mottoReCnt");
     
       friendReCnt = rs.getInt("friendReCnt");
     
       wishReCnt = rs.getInt("wishReCnt");
     
       interestReCnt = rs.getInt("interestReCnt");
     
       foodReCnt = rs.getInt("foodReCnt");
     
       musicReCnt = rs.getInt("musicReCnt");
     
       agonyReCnt = rs.getInt("agonyReCnt");
     
       lookManReCnt = rs.getInt("lookManReCnt");
     
       faultReCnt = rs.getInt("faultReCnt");
       
       iFace 			= rs.getInt("face") == 0 ? 1 : rs.getInt("face");
      
	}
	
	pstmt.close();
	
	rs.close();
	
	/*------------------------------------------------------------------------------------------------------
	+	橇肺鞘 捞傈
	-------------------------------------------------------------------------------------------------------*/
	query1="SELECT TOP 1 regdate FROM GT_NsProfile WITH (READUNCOMMITTED) WHERE phonenum=? "
	          +"AND CONVERT(char(10),regdate,120)<CONVERT(char(10), '"+year+"-"+month+"-"+day+"',120) ORDER BY regdate DESC";
	 
	pstmt =con.prepareStatement(query1);
	
	pstmt.setLong(1,getLong(gphone));
	
	rs=pstmt.executeQuery();
	
	if(rs.next())
	{
		regdatelast = rs.getString("regdate");
	   
	    lastYear = regdatelast.substring(0,4);
	
	    lastMonth = regdatelast.substring(5,7);
	 
	    lastDay = regdatelast.substring(8,10);
	}
	
	pstmt.close();
	
	rs.close();

	/*------------------------------------------------------------------------------------------------------
	+	橇肺鞘 促澜
	-------------------------------------------------------------------------------------------------------*/
	query1="SELECT top 1 regdate FROM GT_NsProfile WITH (READUNCOMMITTED) WHERE phonenum=? "
	          +"AND CONVERT(char(10),regdate,120)>CONVERT(char(10), '"+year+"-"+month+"-"+day+"',120) ORDER BY regdate";