member_first_list.jsp.svn-base

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

<%@ page import="java.lang.*,java.io.*, java.net.*, java.awt.*, java.util.Vector, javax.imageio.*,  java.sql.*, com.entaz.lib.db.*" contentType="text/html;charset=euc-kr"%>
<%@ include file="../imgpath.jsp"%>
<%@ include file="../definePath.jsp"%>
<%@ include file="../makeKOR.jsp"%>
<%@ include file="../common_func.jsp"%>
<%@ include file="define.jsp"%>
<%
   response.setHeader("cache-control","no-cache");
   response.setHeader("expires","0");
   response.setHeader("pragma","no-cache");
%><%	
	/**
	 *	
	 *
	 *	@ version			:	1.0.0
	 *	@ author			:	cui qiuyue ( [e-mail] )
	 *	@ last modified	:	2008-04-28
	 */
	/*------------------------------------------------------------------------------------------------------
	+		기본 파라미터
	-------------------------------------------------------------------------------------------------------*/
	String		mphone				=	request.getParameter("mphone");

	String		gphone				=	request.getParameter("gphone");
	
	String		szCount				=	null;
	
	int           nFriendCount         = 0;
	int           nPaperCount         = 0;
	int           nTodayCount          = 0;
	int           nTotalCount            = 0;
	int           nGuestBook           = 0;
	
	Connection					con		= null;
	PreparedStatement		pstmt	= null;
	Statement					stmt		= null;
	ResultSet					rs			= null;
	
	try
	{

	/*------------------------------------------------------------------------------------------------
	 *		DB 커넥션
	 -------------------------------------------------------------------------------------------------*/
	%><%@ include file="../getConnection.jsp"%><%
	
	/*------------------------------------------------------------------------------------------------
	 *		오늘 폰피방문수
	 -------------------------------------------------------------------------------------------------*/

	szCount = " SELECT  today_cnt AS todayC  from  GT_ranker  WHERE   phonenum=?";

	pstmt = con.prepareStatement(szCount);
	
	pstmt.setString(1, mphone);
	
	rs = pstmt.executeQuery();
		 
	if( rs.next() )
	{
		nTodayCount = rs.getInt("todayC");
	}
	rs.close();
	pstmt.close();

	/*------------------------------------------------------------------------------------------------
	 *		총 폰피방문수
	 -------------------------------------------------------------------------------------------------*/

	szCount = " SELECT  total_cnt AS totalC  from  GT_ranker  WHERE   phonenum=?";

	pstmt = con.prepareStatement(szCount);
	
	pstmt.setString(1, mphone);
	
	rs = pstmt.executeQuery();
		 
	if( rs.next() )
	{
		nTotalCount = rs.getInt("totalC");
	}
	rs.close();
	pstmt.close();
	
	
	/*------------------------------------------------------------------------------------------------
	 *		친구신청 건수
	 -------------------------------------------------------------------------------------------------*/

	szCount = " SELECT  COUNT(friend_idx) AS fCount  from  GT_friend WHERE  friend_flag=2  AND   phonenum=?";

	pstmt = con.prepareStatement(szCount);
	
	pstmt.setString(1, mphone);
	
	rs = pstmt.executeQuery();
		 
	if( rs.next() )
	{
		nFriendCount = rs.getInt("fCount");
	}
	rs.close();
	pstmt.close();
	
	/*------------------------------------------------------------------------------------------------
	 *		새쪽지  건수
	 -------------------------------------------------------------------------------------------------*/
	szCount = " SELECT  COUNT(paper_idx)  AS pCount  from  GT_paper_recv  WHERE  paper_flag=1 AND  paper_check_flag=2 and  phonenum_my =?";

	pstmt = con.prepareStatement(szCount);
	
	pstmt.setString(1, mphone);
	
	rs = pstmt.executeQuery();
		 
	if( rs.next() )
	{
		nPaperCount = rs.getInt("pCount");
	}
	rs.close();
	pstmt.close();
	
	/*------------------------------------------------------------------------------------------------
	 *		 방명록 새글 도착여부 
	 -------------------------------------------------------------------------------------------------*/
	szCount = " SELECT   ranker_guestbook AS guBook  FROM  GT_ranker  WHERE  phonenum = ?";

	pstmt = con.prepareStatement(szCount);
	
	pstmt.setString(1, mphone);
	
	rs = pstmt.executeQuery();
		 
	if( rs.next() )
	{
		nGuestBook = rs.getInt("guBook");
	}
	rs.close();
	pstmt.close();
	}
catch(Exception e)
{
	throw e;
}
finally
{ 
	if ( rs != null ) { try { rs.close(); } catch ( Exception e ) { } }
	if ( stmt != null ) { try { stmt.close(); } catch ( Exception e ) { } }
	if ( con != null ) { try { con.close(); } catch ( Exception e ) { } }
}
	
	%><%@include file="HTML/Member_first_list.jsp"%>