profilereple.jsp

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

<!--------------------------------------------------------------------------------------------------------------
*@橇肺鞘 瘩臂 
*@Author : 弥眠岿 (2008-6-23)
--------------------------------------------------------------------------------------------------------------->
<%@ 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"%>
<%
	/*------------------------------------------------------------------------------------------------------
	+	扁夯 颇扼固磐
	-------------------------------------------------------------------------------------------------------*/	
	String mphone= request.getParameter("mphone");

	String gphone= request.getParameter("gphone");
	
	mphone = getStrPhone(getLong(mphone));
    
    gphone = getStrPhone(getLong(gphone));
	
	String news = "";
	
	if(request.getParameter("news")!=null){news=java.net.URLDecoder.decode(makeKOR(request.getParameter("news")));};
	
	int ref_idx = 1;

	int colum_num =1;

	if(request.getParameter("ref_idx") != null)
	{
	    ref_idx = Integer.parseInt(request.getParameter("ref_idx"));
	}
	
	if(request.getParameter("colum_num") != null)
	{
		colum_num = Integer.parseInt(request.getParameter("colum_num"));
	}

	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 nickname="";
	
	String myname = "";
	
	String todayNews = "";
	
	String todayNewsCnt ="";
	
	String befornews = "";
	
	int beforcnt=0;
	
	String afternews = "";
	
	int aftercnt=0;
	
	long phonenum = 0;
	
	int idx = 0;
	
	int colum_last = colum_num;
	
	int colum_first = colum_num;
	/*------------------------------------------------------------------------------------------------------
	+	其捞瘤 备泅 眠啊 函荐
	-------------------------------------------------------------------------------------------------------*/
	String 	pageurl 			= null;

	int pagesize = 10;  // 茄其捞瘤寸 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"%><%@ 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(request.getParameter("idx")!=null)
	 {
	 	query1="DELETE FROM GT_NsProfileRe WHERE idx =?";
	 
	 	pstmt = con.prepareStatement(query1);
	 
	 	pstmt.setInt(1,Integer.parseInt(request.getParameter("idx")));
	 
	 	pstmt.executeUpdate();
	 
	 	pstmt.close();
	 
	 	switch (colum_num)
		{ 
	   		case 1: todayNewsCnt="ToDorReCnt"; break;
	   		case 2:  todayNewsCnt="mottoReCnt";  break;
	   		case 3:  todayNewsCnt="friendReCnt";  break;
	   		case 4: todayNewsCnt="wishReCnt";  break;
	   		case 5: todayNewsCnt="interestReCnt";  break;
	   		case 6:  todayNewsCnt="foodReCnt"; break;
	   		case 7: todayNewsCnt="musicReCnt";  break;
	   		case 8:  todayNewsCnt="agonyReCnt"; break;
	   		case 9: todayNewsCnt="lookManReCnt";  break;
	   		case 10: todayNewsCnt="faultReCnt"; break;
	}
	
	query1="UPDATE GT_NsProfile SET "+todayNewsCnt+"="+todayNewsCnt+"-1"+"WHERE idx =?";
	
	pstmt = con.prepareStatement(query1);
	
	pstmt.setInt(1,ref_idx);
	
	pstmt.executeUpdate();
		
	pstmt.close();
	
	 }
	/*------------------------------------------------------------------------------------------------
	 *		橇肺鞘 瘩臂 殿废
	 -------------------------------------------------------------------------------------------------*/
	 query1 = "SELECT nickname FROM gt_user_info WITH (READUNCOMMITTED) WHERE phonenum = ?";
	 
	 pstmt = con.prepareStatement(query1);
	
	 pstmt.setString(1,mphone);
	 
	 rs = pstmt.executeQuery();
	 
	 if(rs.next())
	 {
	    myname = rs.getString("nickname");
	 }
	 
	 rs.close();
		
	 pstmt.close();
	 
	 if(request.getParameter("addtext")!=null && request.getParameter("addtext")!="")
	 {
	  	query1= "INSERT INTO GT_NsProfileRe (phonenum,nickname,text,ref_idx,colum_num,regdate) VALUES(?,?,?,?,?,getdate())";
	  
	  	pstmt = con.prepareStatement(query1);
	
	 	pstmt.setString(1,mphone);
	
	 	pstmt.setString(2,myname);
	
	 	pstmt.setString(3,java.net.URLDecoder.decode(makeKOR(request.getParameter("addtext"))));
	 
		pstmt.setInt(4,ref_idx);
	 
	 	pstmt.setInt(5,colum_num);
	
	 	pstmt.executeUpdate();
	
	 	pstmt.close();
	
		switch (colum_num)
		{ 
	   		case 1: todayNewsCnt="ToDorReCnt"; break;
	   		case 2:  todayNewsCnt="mottoReCnt";  break;
	   		case 3:  todayNewsCnt="friendReCnt";  break;
	   		case 4: todayNewsCnt="wishReCnt";  break;
	   		case 5: todayNewsCnt="interestReCnt";  break;
	   		case 6:  todayNewsCnt="foodReCnt"; break;
	   		case 7: todayNewsCnt="musicReCnt";  break;
	   		case 8:  todayNewsCnt="agonyReCnt"; break;
	   		case 9: todayNewsCnt="lookManReCnt";  break;
	   		case 10: todayNewsCnt="faultReCnt"; break;
		}

		query1="UPDATE GT_NsProfile SET "+todayNewsCnt+"="+todayNewsCnt+"+1"+"WHERE idx =?";
	
		pstmt = con.prepareStatement(query1);
	
		pstmt.setInt(1,ref_idx);
	
		pstmt.executeUpdate();
		
		pstmt.close();
	 
	}
	  /*------------------------------------------------------------------------------------------------
	 *		橇肺鞘 瘩臂 捞傈臂 
	 -------------------------------------------------------------------------------------------------*/ 
	while(colum_first!=1 && befornews.equals(""))
	{
		switch (colum_first-1)
		{ 
	   		case 1: todayNews = "toDo"; todayNewsCnt="ToDorReCnt"; break;
	   		case 2: todayNews = "motto"; todayNewsCnt="mottoReCnt";  break;
	   		case 3: todayNews = "friend"; todayNewsCnt="friendReCnt";  break;
	   		case 4: todayNews = "wish"; todayNewsCnt="wishReCnt";  break;
	   		case 5: todayNews = "interest"; todayNewsCnt="interestReCnt";  break;
	   		case 6: todayNews = "food";  todayNewsCnt="foodReCnt"; break;
	   		case 7: todayNews = "music"; todayNewsCnt="musicReCnt";  break;
	   		case 8: todayNews = "agony";  todayNewsCnt="agonyReCnt"; break;
	   		case 9: todayNews = "lookMan"; todayNewsCnt="lookManReCnt";  break;
	   		case 10: todayNews = "fault";  todayNewsCnt="faultReCnt"; break;
	}
		query1= "SELECT"+" "+todayNews+","+todayNewsCnt+" FROM GT_NsProfile WITH (READUNCOMMITTED) WHERE phonenum = ? AND idx = ?";
	 
	 	pstmt = con.prepareStatement(query1);
	 
	 	pstmt.setLong(1,getLong(gphone));
	 
	 	pstmt.setInt(2,ref_idx);
	 
	 	rs = pstmt.executeQuery();
	 	
		if(rs.next())
	 	{
	  		befornews =rs.getString(1);
	   
	   		beforcnt = rs.getInt(2);
	 	}
	 
	  	rs.close();
		
	  	pstmt.close();
	  
	  	colum_first--;
	 }
	 /*------------------------------------------------------------------------------------------------
	 *		橇肺鞘 瘩臂 促澜臂  
	 -------------------------------------------------------------------------------------------------*/ 
	 while(colum_last!=10 && afternews.equals(""))
	{
	 	switch (colum_last+1)
		{ 
	   		case 1: todayNews = "toDo"; todayNewsCnt="ToDorReCnt"; break;
	   		case 2: todayNews = "motto"; todayNewsCnt="mottoReCnt";  break;
	   		case 3: todayNews = "friend"; todayNewsCnt="friendReCnt";  break;
	   		case 4: todayNews = "wish"; todayNewsCnt="wishReCnt";  break;
	   		case 5: todayNews = "interest"; todayNewsCnt="interestReCnt";  break;
	   		case 6: todayNews = "food";  todayNewsCnt="foodReCnt"; break;
	   		case 7: todayNews = "music"; todayNewsCnt="musicReCnt";  break;
	   		case 8: todayNews = "agony";  todayNewsCnt="agonyReCnt"; break;
	   		case 9: todayNews = "lookMan"; todayNewsCnt="lookManReCnt";  break;
	   		case 10: todayNews = "fault";  todayNewsCnt="faultReCnt"; break;
		}
	
		query1= "SELECT"+" "+todayNews+","+todayNewsCnt+" FROM GT_NsProfile WITH (READUNCOMMITTED) WHERE phonenum = ? AND idx = ?";
	
	 	pstmt = con.prepareStatement(query1);
	
	 	pstmt.setLong(1,getLong(gphone));
	 
	 	pstmt.setInt(2,ref_idx);
	 
		rs = pstmt.executeQuery();
	
	 	if(rs.next())
	 	{
	   		afternews =rs.getString(1);
	   
	   		aftercnt = rs.getInt(2);
	 	}
	 
	  	rs.close();
		
	  	pstmt.close();
	  
	   	colum_last++;
	 }
	 /*------------------------------------------------------------------------------------------------
	 *		橇肺鞘 瘩臂 list
	 -------------------------------------------------------------------------------------------------*/ 
	query1="SELECT COUNT(idx) num FROM GT_NsProfileRe WITH (READUNCOMMITTED) WHERE ref_idx=? AND colum_num=?";
	
	pstmt = con.prepareStatement(query1);
	
	pstmt.setInt(1,ref_idx);
	
	pstmt.setInt(2,colum_num);	
	
	rs = pstmt.executeQuery();

	if(rs.next())
	{
		num=rs.getInt("num");

	}
    rs.close();
		
	pstmt.close();
        
    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;
	    }
     
		query1="SELECT nickname,text,idx  FROM GT_NsProfileRe WITH (READUNCOMMITTED) WHERE ref_idx=? AND colum_num=? ORDER BY idx DESC";
	
		pstmt = con.prepareStatement(query1);
	
		pstmt.setInt(1,ref_idx);
	
		pstmt.setInt(2,colum_num);	
	
		pageRs = pstmt.executeQuery();
	
	 	if(!pageRs.next()) // 蔼捞 绝阑锭
		{